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
Not Listed
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