> ## Documentation Index
> Fetch the complete documentation index at: https://docs.metriport.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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](https://hl7.org/fhir/R4/location.html) for full details.

**Previous version:** [location](/medical-api/handling-data/schema-v000/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`](/medical-api/handling-data/schema-v100/location/telecom) for every telecom row.

**Tables in this resource:**

* **location** – Location record (this page)
* [location\_type](/medical-api/handling-data/schema-v100/location/type) – Backbone for location type
* [location\_type\_coding](/medical-api/handling-data/schema-v100/location/type_coding)
* [location\_telecom](/medical-api/handling-data/schema-v100/location/telecom) – Contact details per location
* [location\_extension](/medical-api/handling-data/schema-v100/location/extension)
* [location\_extension\_vcc\_coding](/medical-api/handling-data/schema-v100/location/extension_vcc_coding)
* **location\_references** – [Reference Tables](/medical-api/handling-data/schema-v100/reference_tables#location-references) (managingOrganization, partOf)

**Primary Keys:**

* location\_id

<div style={{textAlign: 'right'}}><sub>† Metriport Platform added</sub></div>

| 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](/medical-api/handling-data/schema-v100/organization/base)

**Child:**

* [location\_extension](/medical-api/handling-data/schema-v100/location/extension)
* [location\_telecom](/medical-api/handling-data/schema-v100/location/telecom)
* [location\_type](/medical-api/handling-data/schema-v100/location/type)
* [location\_type\_coding](/medical-api/handling-data/schema-v100/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`](/medical-api/handling-data/schema-v100/reference_tables) w/ `reference_type = 'managingorganization'`