- 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)
- 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 |
- 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
Renamedbirth_date→birthdatedata_source→meta_source