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 gender 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