CL_QANSWER_FAMILY_MEMBERS

Description: |
This table stores information about the patient's family members that they entered when filling out their family history.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ANSWER_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ANSWER_ID | VARCHAR | No |
The unique identifier (.1 item) for the answer record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | FAM_MEM | VARCHAR | No |
The unique identifier of the patient's family member with regards to their family history.
4 | MSG_CALLER_REL_C_NAME | VARCHAR | No |
The family status relationship category ID for the patient.
May contain organization-specific values: Yes
5 | FAM_MEM_NAME_OR_ALIAS | VARCHAR | No |
Patient-created identifier to help the patient differentiate between their family members when filling out their family history.
6 | FAM_MEM_REMOVE_YN | VARCHAR | No |
Tracks if the associated family member (HQA related group 600) has been requested to be removed from the patient's family history by the user.
May contain organization-specific values: No
Category Entries:
No
Yes
7 | FAM_STAT_STATUS_C_NAME | VARCHAR | No |
Stores family member status.
May contain organization-specific values: No
Category Entries:
Other
Alive
Deceased
Unknown
Fetus - In Utero
Fetus - Stillbirth
Fetus - Ectopic Pregnancy
Fetus - Termination of Pregnancy
Fetus - Spontaneous Abortion
Fetus - Other
Fetus - Molar
Fetus - Abortion
8 | FAM_MEM_FATHER_IDENT | VARCHAR | No |
stores id of family member's father
9 | FAM_MEM_MOTHER_IDENT | VARCHAR | No |
stores id of family member's mother
10 | FAM_STAT_SEX_C_NAME | VARCHAR | No |
Stores family member sex
May contain organization-specific values: No
Category Entries:
Female
Male
Unknown
Unassigned
11 | FAM_STAT_GENDER_IDENTITY_C_NAME | VARCHAR | No |
The gender identity of a relative in the patient's family history.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Transgender Female
Transgender Male
Not Listed
Choose not to disclose
Nonbinary
Genderqueer
12 | FAM_MEM_DOB_DATE | DATETIME | No |
The date of birth of a relative in the patient's family history.
13 | FAM_MEM_DOB_END_DATE | DATETIME | No |
If the relative's date of birth is a "fuzzy" range, holds the end date of the range.
14 | FAM_MEM_DEATH_AGE | VARCHAR | No |
The age at death of a relative in the patient's family history.