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.