- familymemberhistory – Main family member history record (this page)
- familymemberhistory_condition – Conditions per family member
- familymemberhistory_condition_code_coding
- familymemberhistory_relationship_coding
- familymemberhistory_sex_coding
- familymemberhistory_extension
- familymemberhistory_extension_vcc_coding
- familymemberhistory_references – Normalized references; see Reference Tables
familymemberhistory_references table contains normalized references from the family member history to other entities. For structure and indexing, see the Reference Tables documentation.
Primary Keys:
- familymemberhistory_id
- patient_id - links to the patient table
† Metriport Platform added
| Column | Data Type | Description |
|---|---|---|
| familymemberhistory_id | varchar | Unique identifier for the family member history record |
| patient_id | varchar | Unique identifier for the patient |
| status | varchar | Status of the record |
| date | datetime | When the history was recorded or last updated |
| bornstring | varchar | Birth date or age text for the family member |
| relationship_text | varchar | Free-text relationship to patient |
| sex_text | varchar | Free-text sex of the family member |
| sex_hl7_code† | varchar | HL7 sex code (administrative-gender) |
| sex_hl7_display† | varchar | Human-readable description of HL7 sex |
| meta_source | varchar | Source document filename from FHIR meta.source |
| data_source_ext† | varchar | Integration source of the data, derived from FHIR extension |