location

Details and position information for a physical place where services are provided and resources and participants may be stored, found, contained, or accommodated. See the HL7 FHIR R4 spec for full details.

Previous version: location

Note: 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)

Primary Keys:

• 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

Related Tables:

Parent:

• organization

Child:

• location_extension
• location_telecom
• location_type
• location_type_coding

Version diff

Renamed

• address_line → address
• physical_type_display → physicaltype_text
• type_display → type_hl7_display
• data_source → meta_source

Deprecated

• managing_organization_id → query location_references w/ reference_type = 'managingorganization'