PAT_RELATIONSHIP_LIST
Description:
This table includes the majority of patient contact demographic info, general relationship info, and patient-level relationship info. The records included in this table are Patient Relationships (RLA) records.

Primary Key
Column Name Ordinal Position
PAT_RELATIONSHIP_ID 1

Column Information
Name Type Discontinued?
1 PAT_RELATIONSHIP_ID NUMERIC No
The unique identifier for the patient contact record.
2 RECORD_STATUS_C_NAME VARCHAR No
The record status category ID for the patient contact
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
3 PAT_ID VARCHAR No
The unique ID of the patient this patient contact is added to.
4 PAT_LEVEL_RELATIONSHIP_YN VARCHAR No
Indicates whether the patient contact should be displayed at the patient level.
May contain organization-specific values: No
Category Entries:
No
Yes
5 NAME VARCHAR No
Patient contact's name. This column only displays names that are stored directly on patient contact records and will be blank for patient contact records that are linked to different patient records. Use the PAT_RELATIONSHIP_RECORD_NAME column instead if you want a single column that will display the names of both linked and unlinked patient contact records.
6 GENDER_C_NAME VARCHAR No
The gender category ID for the patient contact.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Transgender Female
Transgender Male
Other
Choose not to disclose
Nonbinary
Genderqueer
7 BIRTH_DATE DATETIME No
Patient contact's date of birth.
8 HOUSE_NUM VARCHAR No
Patient contact's house number.
9 CITY VARCHAR No
Patient contact's city of residence.
10 STATE_C_NAME VARCHAR No
The state category ID for the patient contact's residence.
May contain organization-specific values: Yes
11 ZIP_CODE VARCHAR No
Patient contact's postal code.
12 DISTRICT_C_NAME VARCHAR No
The district category ID for the patient contact's residence.
May contain organization-specific values: Yes
13 COUNTY_C_NAME VARCHAR No
The county category ID for the patient contact.
May contain organization-specific values: Yes
14 COUNTRY_C_NAME VARCHAR No
The country category ID for the patient contact.
May contain organization-specific values: Yes
15 OCCUPATION VARCHAR No
Patient contact's occupation.
16 INTERP_NEEDED_YN VARCHAR No
Indicates whether the patient contact requires a language interpreter.
The category values for this column were already listed for column: PAT_LEVEL_RELATIONSHIP_YN
17 HEARING_IMPAIRED_YN VARCHAR No
Indicates whether the patient contact is hard of hearing.
The category values for this column were already listed for column: PAT_LEVEL_RELATIONSHIP_YN
18 VISUALLY_IMPAIRED_YN VARCHAR No
Indicates whether the patient contact has low vision.
The category values for this column were already listed for column: PAT_LEVEL_RELATIONSHIP_YN
19 SPEC_NEED_IMPAIR_C_NAME VARCHAR No
The hearing and vision special needs category ID for the patient contact.
May contain organization-specific values: Yes
20 RECORD_CREATION_DATE DATETIME No
The date when the patient contact was created.
21 PREFERRED_LANGUAGE_C_NAME VARCHAR No
The preferred language category ID for the patient contact.
May contain organization-specific values: Yes
22 DISPLAY_SEQUENCE INTEGER No
Stores the order in which patient-level contacts display.
23 SOCIAL_CLOSENESS_C_NAME VARCHAR No
The social closeness category ID for the patient contact.
May contain organization-specific values: Yes
24 SAME_HOUSEHOLD_YN VARCHAR No
Indicates whether the patient contact lives in the same household as the patient.
The category values for this column were already listed for column: PAT_LEVEL_RELATIONSHIP_YN
25 SUPPORT_NETWORK_YN VARCHAR No
Indicates whether the patient contact is part of the patient's support network.
The category values for this column were already listed for column: PAT_LEVEL_RELATIONSHIP_YN
26 CUSTODY_C_NAME VARCHAR No
The custody category ID for the patient contact
May contain organization-specific values: Yes
27 GUARDIAN_YN VARCHAR No
Indicates whether the patient contact is the patient's legal guardian.
The category values for this column were already listed for column: PAT_LEVEL_RELATIONSHIP_YN
28 PROTECTION_ORDER_YN VARCHAR No
Indicates whether a protection order has been filed against the patient contact.
The category values for this column were already listed for column: PAT_LEVEL_RELATIONSHIP_YN
29 LAST_REV_DTTM DATETIME (Attached) No
Indicates the last instant that this record's relationship information was reviewed or updated from a patient-level encounter.
30 LAST_REV_USER_ID VARCHAR No
The unique ID of the user who most recently reviewed or updated this patient contact's information from a patient-level encounter.
31 LAST_REV_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
32 NOTIFY_ON_ADMSN_YN VARCHAR No
Indicates whether the patient contact should be notified when the patient is admitted.
The category values for this column were already listed for column: PAT_LEVEL_RELATIONSHIP_YN
33 LEGAL_RELATION_C_NAME VARCHAR No
The legal relationship category ID for the patient contact.
May contain organization-specific values: Yes
Category Entries:
Health Care Agent
First Alternate Health Care Agent
Second Alternate Health Care Agent
34 ACTV_HLTHCR_AGENT_YN VARCHAR No
Indicates whether the patient contact is an active health care agent for the patient.
The category values for this column were already listed for column: PAT_LEVEL_RELATIONSHIP_YN
35 GENERIC_CAT_1_C_NAME VARCHAR No
Customer-labeled category item.
May contain organization-specific values: Yes
36 GENERIC_CAT_2_C_NAME VARCHAR No
Customer-labeled category item.
May contain organization-specific values: Yes
37 GENERIC_CAT_3_C_NAME VARCHAR No
Customer-labeled category item.
May contain organization-specific values: Yes
38 GENERIC_CAT_4_C_NAME VARCHAR No
Customer-labeled category item.
May contain organization-specific values: Yes
39 GENERIC_STRING_1 VARCHAR No
Customer-labeled string item.
40 GENERIC_STRING_2 VARCHAR No
Customer-labeled string item.
41 GENERIC_STRING_3 VARCHAR No
Customer-labeled string item.
42 GENERIC_STRING_4 VARCHAR No
Customer-labeled string item.
43 AUTH_LETTER_RECIPIENT_YN VARCHAR No
Indicates whether the patient contact is authorized to receive appointment letters.
The category values for this column were already listed for column: PAT_LEVEL_RELATIONSHIP_YN
44 SEND_LETTERS_BY_DEFAULT_YN VARCHAR No
Indicate whether the patient contact should receive appointment letters about the patient by default.
The category values for this column were already listed for column: PAT_LEVEL_RELATIONSHIP_YN
45 LIMITATION_CODE_C_NAME VARCHAR No
The limitation code category ID for a supervisory patient contact.
May contain organization-specific values: Yes
46 RESPONSIBILITY_CODE_C_NAME VARCHAR No
The responsibility code category ID for a supervisory patient contact.
May contain organization-specific values: Yes
47 AUTHORITY_CODE_C_NAME VARCHAR No
The authority code category ID for a supervisory patient contact.
May contain organization-specific values: Yes
No Entries Defined
48 BUSINESS_IDENT VARCHAR No
The unique ID of the business for a supervisory patient contact.
49 PENDING_PAT_LEGAL_RELATION_C_NAME VARCHAR No
The pending Healthcare Agent (HCA) relationship category ID for the patient contact.
The category values for this column were already listed for column: LEGAL_RELATION_C_NAME
50 ACP_UPD_REJECTION_REASON_C_NAME VARCHAR No
The rejection reason category ID for the advance care plan (ACP).
May contain organization-specific values: Yes
Category Entries:
Invalid signature
Missing documentation
Inconsistent documentation
Illegible
Invalid form
Missing signature
Relationship doesn't match document
Relationship not supported by current documentation
Contact name and document do not match
51 ACP_UPD_REJECTION_REASON_TEXT VARCHAR No
The patient-facing rejection reason for an update to the advance care plan (ACP).
52 ACP_UPD_MYCHART_USER_ID VARCHAR No
The unique ID of the MyChart user who updated the advance care plan (ACP).
53 PAT_RELATIONSHIP_RECORD_NAME VARCHAR No
The name of the patient contact record. If the patient contact record is linked to a different patient's record, the name will come from the patient record. Otherwise, it will come from the name stored directly on the patient contact record. If your organization does not allow users to link patient contacts to other patient records, this column will act the same as the NAME column in this table.
54 ORDER_ISSUED_TASK_C_NAME VARCHAR No
The issued order category ID for the patient contact with regard to the division of tasks amongst patient guardians.
May contain organization-specific values: Yes
No Entries Defined
55 LIVING_STATUS_C_NAME VARCHAR No
The living status category ID for the patient contact. Epic releases statuses of Alive and Deceased. Missing statuses are treated as Alive.
May contain organization-specific values: Yes
Category Entries:
Alive
Deceased
56 PAT_CONTACT_ROW_TYPE_C_NAME VARCHAR No
The patient contact type category ID for a patient contact. This column uses 0 for Person and 1 for Organization.
May contain organization-specific values: No
Category Entries:
Person
Organization
57 ORG_FACILITY_ID_LOC_NAME VARCHAR No
The name of the revenue location.
58 ORG_RELIG_AFFL_ID VARCHAR No
The unique ID of the religious affiliation linked to an organization patient contact.
59 ORG_RELIG_AFFL_ID_RELIG_AFFIL_NAME VARCHAR No
The name of the religious affiliation organization.
60 ORG_WEBSITE VARCHAR No
A website URL for the organization patient contact.
61 ORG_FAX_NUMBER VARCHAR No
The fax number for an organization patient contact.
62 ORG_PRIMARY_CONTACT VARCHAR No
The representative or point person for an organization contact.
63 ORG_PRIMARY_CONTACT_PHONE VARCHAR No
The phone number for the organization primary contact.
64 ORG_DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
65 MYPT_ID VARCHAR No
The unique id of the MyChart account associated with the patient contact, primarily for the purpose of granting the contact proxy access to the patient.
66 FREETEXT_COMMENT VARCHAR No
A free text comment on the contact
67 PRIMARY_OR_FIRST_PHONE VARCHAR No
The phone number of a patient contact. This is the primary phone number if one is marked primary, otherwise this is the first phone number listed for the patient contact. If the patient contact is linked to another record, this phone number is from the linked record, otherwise this phone number is from the patient contact record.
68 EMERG_CONTACT_YN VARCHAR No
Indicates whether a patient contact is an emergency contact.
The category values for this column were already listed for column: PAT_LEVEL_RELATIONSHIP_YN