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 Interpreter Emergency Contact