Patient.name[]).
Previous version: patient_name
Primary Keys:
- patient_name_id
- patient_id - links to the patient table
† Metriport Platform added
| Column | Data Type | Description |
|---|---|---|
| patient_name_id | varchar | Unique identifier for the name row |
| patient_id | varchar | Parent patient |
| last_name† | varchar | Family name (FHIR family) |
| first_name† | varchar | First given name |
| given_names† | array | All given names as array (nulls removed) |
| suffixes† | array | Name suffixes as array (nulls removed) |
| prefixes† | array | Name prefixes as array (nulls removed) |
| name_rank† | int | Order of this name within the patient (1-based) |
| data_source_ext† | varchar | Integration source of the data, derived from FHIR extension |