phone and email are the first matching Location.telecom entries (system phone / email) and stay on this table for convenience. They are not deprecated. Use location_telecom for every telecom row.
Tables in this resource:
- location – Location record (this page)
- location_type – Backbone for location type
- location_type_coding
- location_telecom – Contact details per location
- location_extension
- location_extension_vcc_coding
- location_references – Reference Tables (managingOrganization, partOf)
- location_id
† Metriport Platform added
| Column | Data Type | Description |
|---|---|---|
| location_id | varchar | Unique identifier for the location |
| name | varchar | Name of the location |
| type_hl7_code† | varchar | HL7 location type code (v3-RoleCode) |
| type_hl7_display† | varchar | Human-readable description of HL7 type |
| physicaltype_text | varchar | Physical type free-text description of the facility |
| address† | varchar | First, second, and third address lines concatenated |
| city† | varchar | City (from Location.address) |
| state† | varchar | State or province (from Location.address) |
| country† | varchar | Country (from Location.address) |
| zip_code† | varchar | ZIP or postal code (from Location.address) |
| phone† | varchar | First phone from telecom |
| email† | varchar | First email from telecom |
| meta_source | varchar | Source document filename from FHIR meta.source |
| data_source_ext† | varchar | Integration source of the data, derived from FHIR extension |
Version diff
Renamedaddress_line→addressphysical_type_display→physicaltype_texttype_display→type_hl7_displaydata_source→meta_source
managing_organization_id→ querylocation_referencesw/reference_type = 'managingorganization'