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.