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.