patient

Demographics and other administrative information about an individual or animal receiving care or other health-related services. See the HL7 FHIR R4 spec for full details.

Previous version: patient

Tables in this resource:

• patient – Main patient record (this page)
• patient_address – Address components
• patient_communication – Communication and language
• patient_communication_language_coding
• patient_identifier – External identifiers
• patient_identifier_type_coding – Type codings per identifier
• patient_mapping – External ID mapping
• patient_name – Name components
• patient_telecom – Telecom (phone, email)
• patient_extension
• patient_extension_vcc_coding
• patient_references – Reference Tables (managingOrganization)

Primary Keys:

• patient_id

_{† Metriport Platform added}

Column	Data Type	Description
patient_id	varchar	Unique identifier for the patient
first_name†	varchar	First given name (from first name row)
last_name†	varchar	Family name (from first name row)
gender	varchar	Gender
birthdate	date	Date of birth
maritalstatus_text	varchar	Marital status as text
address†	varchar	First and second address lines concatenated (from first address)
city†	varchar	City (from first address)
state†	varchar	State or province (from first address)
country†	varchar	Country (from first address)
zip_code†	varchar	ZIP or postal code (from first address)
email†	varchar	First email from telecom
phone†	varchar	First phone 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:

Child:

• allergyintolerance
• binary
• careplan
• communication
• composition
• condition
• consent
• coverage
• diagnosticreport
• documentreference
• encounter
• familymemberhistory
• goal
• immunization
• measure_report
• medicationadministration
• medicationdispense
• medicationrequest
• medicationstatement
• observation
• patient_address
• patient_communication
• patient_extension
• patient_identifier
• patient_mapping
• patient_name
• patient_telecom
• procedure
• servicerequest

Version diff

Renamed

• birth_date → birthdate
• data_source → meta_source