Practitioner.name[]).
Primary Keys:
- practitioner_name_id
- practitioner_id - links to the practitioner table
† Metriport Platform added
| Column | Data Type | Description |
|---|---|---|
| practitioner_name_id | varchar | Unique identifier for the name row |
| practitioner_id | varchar | Parent practitioner |
| 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 practitioner (1-based) |