PAT_REL_ADDL_REL

Description: |
This table contains information about patient relationships beyond the primary relationship. 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.

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 relationship 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 | ADDL_REL_C_NAME | VARCHAR | No |
Describe the patient contact's relation to the patient. This is if a patient contact would have more than one value for their Relationship to Patient (I RLA 1000).
May contain organization-specific values: Yes
4 | ADDL_REL_START_DATE | DATETIME | No |
Indicates the start date of the patient contact's "Additional Relation to Patient" (I RLA 360) item.
5 | ADDL_REL_END_DATE | DATETIME | No |
Indicates the end date of the patient contact's "Additional Relation to Patient" (I RLA 360) item.