PAT_RELATIONSHIP_LIST_HX

Description:

This table contains historical information about patient relationships. It includes information about relationship types and the dates that the relationships were valid. The records included in this table are Patient Relationships (RLA) records. Multiple lines in this table indicate the history of a relationship and are stored in chronological order (line 1 is the earliest).

Primary Key

Column Name	Ordinal Position
RELATIONSHIP_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	RELATIONSHIP_ID	NUMERIC	No
	The unique identifier for the patient contact record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	RELATION_TO_PAT_C_NAME	VARCHAR	No
	The relationship to patient category ID for the patient contact. May contain organization-specific values: Yes
4	RELATIONSHIP_START_DATE	DATETIME	No
	The date the patient contact's relation to the patient started.
5	RELATIONSHIP_END_DATE	DATETIME	No
	The date the patient contact's relation to the patient ended.