Patient

Schema documentation for the Patient table in the Metriport data model

The patient table contains information on patients, including demographic information such as birth date and gender.

Note: The name, address, and telecom fields in this table are from the first indices of the corresponding Patient resource FHIR arrays. To see the full set of demographics, see the patient name, patient address, and patient telecom tables.

Primary Keys:

• patient_id

Column	Data Type	Description
patient_id	varchar	Unique identifier for the patient
first_name	varchar	First given name
last_name	varchar	Family name (last name)
gender	varchar	Gender at birth
birth_date	date	Date of birth
address	varchar	First and second address lines concatenated
city	varchar	City name
state	varchar	State or province code
zip_code	varchar	ZIP or postal code
email	varchar	Email address
phone	varchar	Phone number
meta_source	varchar	Source document filename from FHIR meta.source
data_source	varchar	Deprecated. Use meta_source instead.
data_source_ext	varchar	Integration source of the data, derived from FHIR extension