Data dictionary › Patient identity & demographics

RELATIONSHIPS

Single Population

File
data/RELATIONSHIPS.csv
Category
patient
Primary key
RELATIONSHIP_ID
Columns
10

01Relates to the patient

ACCOUNT_1 is the patient's ACCOUNT; or ACCOUNT_2 is the patient's ACCOUNT

Single-patient export: the patient's rows.

02References

03Columns

#ColumnTypeSource typeNullNotes
1RELATIONSHIP_ID PKintegerintno
2FAMILY_IDintegerintno
3ACCOUNT_1stringvarchar(12)no
4ACCOUNT_2stringvarchar(12)no
5ROLE_TYPE_CODE_1integerintno
6ROLE_TYPE_CODE_2integerintno
7START_DATEdatetimedatetimeyes
8END_DATEdatetimedatetimeyes
9RELATIONSHIP_PLACEstringvarchar(100)yes
10OTHER_RELATIONSHIP_DETAILSstringvarchar(100)yes