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.
16 FAM_MEMPROB_LINKED_DX INTEGER No
Stores the diagnosis ID linked to a family history problem.