PAT_RELATIONSHIPS
Description:
Demographic information for patient contacts.

Primary Key
Column Name Ordinal Position
PAT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
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 PAT_REL_NAME VARCHAR No
The name of the patient's contact.
4 PAT_REL_CITY VARCHAR No
Contact's city of residence
5 PAT_REL_ZIP VARCHAR No
The ZIP code of the patient's contact.
6 PAT_REL_COUNTY_C_NAME VARCHAR No
Contact's county of residence
May contain organization-specific values: Yes
7 PAT_REL_COUNTRY_C_NAME VARCHAR No
Contact's country of residence
May contain organization-specific values: Yes
8 PAT_REL_HOME_PHONE VARCHAR No
Contact's home phone
9 PAT_REL_WORK_PHONE VARCHAR No
Contact's work phone
10 PAT_REL_MOBILE_PHNE VARCHAR No
Contact's mobile phone
11 PAT_REL_LGL_GUAR_YN VARCHAR No
Whether this contact is the patient's legal guardian
May contain organization-specific values: No
Category Entries:
Yes
No
12 PAT_REL_REC_LINK_ID VARCHAR No
Links this contact to a patient record
13 PAT_REL_RELATION_C_NAME VARCHAR No
Contact's relation to patient
May contain organization-specific values: Yes
14 PAT_REL_PRIM_PH_C_NAME VARCHAR No
Which of the contact's phone numbers should be considered primary
May contain organization-specific values: No
Category Entries:
Home phone
Work phone
Mobile phone
15 PAT_REL_GEN_STR_1 VARCHAR No
Customer labeled string item
16 PAT_REL_GEN_STR_2 VARCHAR No
Customer labeled string item
17 PAT_REL_GEN_STR_3 VARCHAR No
Customer labeled string item
18 PAT_REL_GEN_STR_4 VARCHAR No
Customer labeled string item
19 PAT_REL_GEN_CAT_1_C_NAME VARCHAR No
Customer labeled category item
May contain organization-specific values: Yes
20 PAT_REL_GEN_CAT_2_C_NAME VARCHAR No
Customer labeled category item
May contain organization-specific values: Yes
21 PAT_REL_GEN_CAT_3_C_NAME VARCHAR No
Customer labeled category item
May contain organization-specific values: Yes
22 PAT_REL_GEN_CAT_4_C_NAME VARCHAR No
Customer labeled category item
May contain organization-specific values: Yes
23 PAT_REL_HOUSE_NUM VARCHAR No
Contact's House Number
24 PAT_REL_DISTRICT_C_NAME VARCHAR No
The district category ID for the patient's contact.
May contain organization-specific values: Yes
25 PAT_REL_HEARING_YN VARCHAR No
Capture if patient's relative has hearing impairment
The category values for this column were already listed for column: PAT_REL_LGL_GUAR_YN
26 PAT_REL_VISUALLY_YN VARCHAR No
Capture if patient's relative has visual impairment
The category values for this column were already listed for column: PAT_REL_LGL_GUAR_YN
27 PAT_REL_IMP_NEEDS_C_NAME VARCHAR No
Capture the patient's emergency contact's special needs for hearing and visual impairment.
May contain organization-specific values: Yes
28 PAT_REL_SPOKEN_C_NAME VARCHAR No
Capture the patient's emergency contact's spoken language.
May contain organization-specific values: Yes
29 PAT_REL_WRITTEN_C_NAME VARCHAR No
Capture the patient's emergency contact's written language.
The category values for this column were already listed for column: PAT_REL_SPOKEN_C_NAME
30 PAT_REL_PREF_LANG_C_NAME VARCHAR No
Capture the patient's emergency contact's preferred language.
The category values for this column were already listed for column: PAT_REL_SPOKEN_C_NAME
31 PAT_REL_INTERPRET_YN VARCHAR No
Capture if the patient's emergency contact needs an interpreter.
May contain organization-specific values: No
Category Entries:
No
Yes
32 PAT_REL_SPL_NEEDS_C_NAME VARCHAR No
Capture the patient's emergency contact's special needs.
May contain organization-specific values: Yes
33 PAT_REL_NOTIFY_YN VARCHAR No
Capture if the patient's emergency contact should be notified on patient's admission.
The category values for this column were already listed for column: PAT_REL_INTERPRET_YN
34 PAT_LEGAL_REL_C_NAME VARCHAR No
Specifies the category for the legal relationship
May contain organization-specific values: Yes
Category Entries:
Health Care Agent
First Alternate Health Care Agent
Second Alternate Health Care Agent
35 PAT_REL_ACT_AGNT_YN VARCHAR No
Specifies if the health care agent is active or not
The category values for this column were already listed for column: PAT_REL_INTERPRET_YN
36 PAT_REL_EMAIL VARCHAR No
Primary email address of the patient's emergency contact.
37 PAT_REL_RLA_ID NUMERIC No
Links this patient contact to the associated Patient Relationships (RLA) patient relationship record.