PAT_REL_ROLES_EPSD

Description:

This table contains patient contact roles towards the patient for episode-level relationships. The records included in this table are Patient Relationships (RLA) records.

Primary Key

Column Name	Ordinal Position
PAT_RELATIONSHIP_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	PAT_RELATIONSHIP_ID	NUMERIC	No
	The unique identifier for the patient contact record.
2	GROUP_LINE	INTEGER	No
	The line number of the episode information in the patient contact. Together with PAT_RELATIONSHIP_ID, this forms the foreign key to the PAT_REL_INFO_EPSD and the PAT_REL_NOTES_EPSD tables.
3	VALUE_LINE	INTEGER	No
	The line number of one of multiple roles associated with the patient contact and episode from the PAT_REL_INFO_EPSD table.
4	EPSD_ROLE_TO_PAT_C_NAME	VARCHAR	No
	The role category ID of the patient contact at the episode-level. May contain organization-specific values: Yes