DOCS_RCVD_FAM_HX_MEM

Description: |
This table stores discrete information about family members with a noted medical history. The information stored in this table was received from outside sources.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
DOCUMENT_ID | 1 |
CONTACT_DATE_REAL | 2 |
LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | DOCUMENT_ID | NUMERIC | No |
This item stores the Received Document record ID.
2 | CONTACT_DATE_REAL | FLOAT | No |
A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
5 | FAMILY_MEMBER_REL | VARCHAR | No |
The patient's relationship to the family member for this row.
6 | FAMMEMBER_REL_ID_C_NAME | VARCHAR | No |
The category ID of the patient's relationship for the family member for this row.
May contain organization-specific values: Yes
7 | FAMILY_MEMBER_NAME | VARCHAR | No |
The name of the family member for this row.
8 | FAMILY_MEMBER_RFRID | VARCHAR | No |
The unique ID of the relationship of the family member for this row.
9 | FAMILY_MMB_BIRTHTIM_DTTM | DATETIME (Attached) | No |
The birth date and time of the family member for this row.
10 | FAMILY_MMB_ISDEC_YN | VARCHAR | No |
The value that determines whether the family member for this row is deceased.
May contain organization-specific values: No
Category Entries:
No
Yes
11 | FAMILY_MMB_DEC_TIME_DTTM | DATETIME (Attached) | No |
The deceased date and time of the family member for this row.
12 | FAMILY_MMB_SRC_CSN | NUMERIC | No |
The Contact Serial Number of the received document record from which the family member for this row was sourced.
13 | FAM_MEM_GENDER_C_NAME | VARCHAR | No |
The sex assigned at birth of the family member for this row.
May contain organization-specific values: No
Category Entries:
Female
Male
Unknown
Unassigned
14 | FAM_MMB_LSTUPD_INST_DTTM | DATETIME (UTC) | No |
Stores the last update instant of the family member's relationship to the patient in UTC.
15 | FAMILY_MMB_REL_REM_YN | VARCHAR | No |
The value that determines if the family member in this row was marked to be removed by the patient.
The category values for this column were already listed for column: FAMILY_MMB_ISDEC_YN
16 | FAM_MMB_UNIQUEID | VARCHAR | No |
The unique identifier for the family relationship in this row that distinguishes this relationship from others made by the same patient.
17 | FAM_STAT_STATUS_C_NAME | VARCHAR | No |
Stores the status of the family member
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
18 | FAM_MMB_FATHER_IDENT | VARCHAR | No |
Holds the Unique ID of the relative who is biological father
19 | FAM_MMB_MOTHER_IDENT | VARCHAR | No |
Holds the Unique ID of the relative who is biological mother
20 | FAM_STAT_GENDER_IDENTITY_C_NAME | VARCHAR | No |
Family member gender identity
May contain organization-specific values: Yes
Category Entries:
Female
Male
Transgender Female
Transgender Male
Not Listed
Choose not to disclose
Nonbinary
Genderqueer
21 | FAM_MMB_DOB_DATE | DATETIME | No |
Family member date of birth Used to calculate Age
22 | FAM_MMB_DOB_END_DATE | DATETIME | No |
Family member date of birth range end. Used for calculating fuzzy age.
23 | FAM_MMB_DEATH_AGE | VARCHAR | No |
Family Member Death Age