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
Automatically estimated from flowsheet responses
Care Everywhere
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
Not Listed
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.