CAL_COMM_HX_REF_PAT_REL

Description: |
Stores the history of source relationships to patients referenced by a communication (i.e. the history of CAL_REFERENCE_PAT.REF_PAT_REL_C). Each GROUP_LINE corresponds to a line in CAL_COMM_HX for a COMM_ID.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
COMM_ID | 1 |
GROUP_LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | COMM_ID | VARCHAR | No |
The unique identifier for the communication record.
2 | GROUP_LINE | INTEGER | No |
The line number for the information associated with this record.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple values associated with a specific group of data within this record.
4 | HX_REF_PAT_REL_C_NAME | VARCHAR | No |
Stores the category identifier of the relationship a source has to the patient referenced (CAL_COMM_HX_REF_PAT).
May contain organization-specific values: Yes
Category Entries:
Other
Self
Spouse
Significant Other
Child
Parent
Guardian
Grandparent
Grandchild
Niece/Nephew
Aunt/Uncle
Brother/Sister
Other Relative
Coworker/Associate
Friend
PCP
On Call Provider
Lab
Radiology
Guarantor
Carrier
Employer Group
Network
Provider
Mother
Father
Pharmacy
Payer
Vendor
Submitter
Interpreter
School Nurse
Case Worker
Caregiver
Patient Contact