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