PAT_REL_ROLE_LIST

Description:

This table contains patient contacts' role(s) in relation to the patient. It includes the patient contact's role, the date the role started, and the date the role ended. The records included in this table are Patient Relationships (RLA) records.

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	ROLE_C_NAME	VARCHAR	No
	The role category ID of the patient contact at the patient-level. May contain organization-specific values: Yes
4	ROLE_START_DATE	DATETIME	No
	The date when the patient contact's role starts.
5	ROLE_END_DATE	DATETIME	No
	The date when the patient contact's role ends.