FAMILY_HX_STATUS
Description:
Family status relationship table. Contains the relationship to the patient and the name of the family member, as well as the source of this information.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI).
2 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
4 FAM_STAT_REL_C_NAME VARCHAR No
The family status relationship category number for the relationship between the patient and their family member.
May contain organization-specific values: Yes
5 FAM_STAT_STATUS_C_NAME VARCHAR No
The family status category number for the family member, such as 1 for "alive" and 2 for "deceased".
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
6 FAM_STAT_DEATH_AGE VARCHAR No
Age of family member at their death.
7 FAM_STAT_COMMENT VARCHAR No
This item contains the free text comments associated with a patient's family member status in medical history.
8 FAM_STAT_NAME VARCHAR No
The name of family member.
9 FAM_STAT_SRC_C_NAME VARCHAR No
The family status source category number for the source of corresponding family status information.
May contain organization-specific values: Yes
Category Entries:
Provider
Patient
Parent
Legal Guardian
Proxy User
Automatically reconciled from patient
Automatically reconciled from proxy
10 HX_LNK_ENC_CSN NUMERIC No
The Contact Serial Number of the encounter in which the history was created/edited. If the history was created/edited outside of the context of an encounter, then this column will be blank.
11 FAM_STAT_DOB_DT DATETIME No
This is used to calculate the age of a relative. This is either the date of birth (approximate or exact) or part of a range. If it is a range, then this column will be the beginning date and FAM_STAT_DOB_END_DT will store the end date. This range of dates is used to define an age range.
12 FAM_STAT_ID INTEGER No
The Unique ID for the family member.
13 FAM_STAT_FATHER_ID INTEGER No
Unique ID for the Father
14 FAM_STAT_MOTHER_ID INTEGER No
Unique ID for the mother.
15 FAM_STAT_DOB_END_DT DATETIME No
If an age range is entered for a family member, then the range is stored as two dates. This column holds the end date and FAM_STAT_DOB_DT holds the beginning date.
16 FAM_STAT_TWIN INTEGER No
This item tracks twin relationships among members of the patient's family. Two family members who are twins (or three who are triplets, etc.) will have the same value on their lines of this item. A value of 0 indicates that the family member is a twin of the patient.
17 FAM_STAT_IDENT_TWIN INTEGER No
This item tracks identical twin relationships among members of the patient's family. Two family members who are identical twins (or three who are identical triplets, etc.) will have the same value on their lines of this item. A value of 0 indicates that the family member is an identical twin of the patient.
18 FAM_STAT_COD_C_NAME VARCHAR No
The cause of death of a family member of the patient.
May contain organization-specific values: Yes
19 FAM_STAT_SEX_C_NAME VARCHAR No
This item stores the sex of a family member of the patient.
May contain organization-specific values: No
Category Entries:
Female
Male
Unknown
Unassigned
20 FAM_STAT_GENDER_IDENTITY_C_NAME VARCHAR No
Gender identity for a family member.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Transgender Female
Transgender Male
Other
Choose not to disclose
Nonbinary
Genderqueer
21 FAM_STAT_REL_ID NUMERIC No
This item stores the unique ID of the patient relationship record. The patient relationship record contains information about how the person is related to the patient.
22 FAM_STAT_ADOPT_C_NAME VARCHAR No
Adoption status of a particular family member.
May contain organization-specific values: No
Category Entries:
Adopted In
Adopted Out
Adopted
23 FAM_STAT_ADPT_PAR_1 INTEGER No
The ID of a relative's adoptive parent. We allow two adoptive parents. The other adoptive parent ID is stored in I EPT 20359.
24 FAM_STAT_ADPT_PAR_2 INTEGER No
The ID of a relative's adoptive parent. We allow two adoptive parents. The other adoptive parent ID is stored in I EPT 20358.
25 FAM_STAT_PREG_EPISODE_ID NUMERIC No
This item stores a link to the patient's pregnancy information in Obstetric history.
26 FAM_STAT_DELIV_EPISODE_ID NUMERIC No
This item stores a link to the patient's delivery information for Obstetric History.
27 FAM_HX_FERT_STAT_C_NAME VARCHAR No
This field contains the category value representing a patient's relative's fertility status.
May contain organization-specific values: No
Category Entries:
Fertile
No Children By Choice
Infertile
Unknown
28 FAM_HX_FERT_NOTE VARCHAR No
This field is a free text item holding notes pertaining to a particular relative's fertility status.