DOCS_RCVD_FAM_HX_PROB

Description:

This table stores discrete family history problem information 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_PROB_REFID	VARCHAR	No
	The unique ID of the family member's problem for this row.
6	FAMILY_PROB_ID_C_NAME	VARCHAR	No
	The category ID of the family member's problem for this row. May contain organization-specific values: Yes
7	FAM_MMB_PROB_NAME	VARCHAR	No
	The display name of the family member's problem for this row.
8	FAM_MMB_PROB_ONSAGE	INTEGER	No
	The age of onset for the family member's problem for this row.
9	FAM_PROB_EFF_TIME_DTTM	DATETIME (Attached)	No
	The date and time at which the family member's problem for this row was observed.
10	FAMILY_MEMBER_REFID	VARCHAR	No
	The unique ID of the family member for this row. This column is frequently used to link to the DOCS_RCVD_FAM_HX_MEM table.
11	FAM_PRB_PERT_NEG_YN	VARCHAR	No
	The value that determines whether the problem for this row is a pertinent negative for the family member. May contain organization-specific values: No Category Entries: No Yes
12	FAM_MEMPROB_COD_YN	VARCHAR	No
	The value that determines whether the problem for this row was a cause of death for the family member. The category values for this column were already listed for column: FAM_PRB_PERT_NEG_YN
13	FAM_PROB_COMMENTS	VARCHAR	No
	Comments left for the problem in this row.
14	FAM_PROB_PAT_HX_RESP_C_NAME	VARCHAR	No
	The value that indicates the response the patient gave for a given family history problem. May contain organization-specific values: No Category Entries: Yes No No Response No (Not Pertinent)
15	FAM_MEMPROB_ONSET_AGE_END	INTEGER	No
	End of range for family member problem age of onset.