PAT_REL_NOTES_EPSD

Description:

This table contains the IDs of notes about 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 notes associated with the patient contact and episode from the PAT_REL_INFO_EPSD table.
4	EPSD_NOTE_ID	VARCHAR	No
	The unique ID of episode-level note for a patient contact.