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.