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