HH_PAT_INFO

Description: |
Contains Home Health noadd single items in the Patient (EPT) master file.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ID | VARCHAR | No |
Unique identifier for the patient.
2 | CAREGIVER_1_NAME | VARCHAR | No |
Caregiver 1 name.
3 | CAREGIVER_1_CITY | VARCHAR | No |
Caregiver 1 city.
4 | CAREGIVER_1_ZIP | VARCHAR | No |
Caregiver 1 ZIP code.
5 | CAREGIVER_1_HPHONE | VARCHAR | No |
Caregiver 1 home phone number.
6 | CAREGIVER_1_WPHONE | VARCHAR | No |
Caregiver 1 work phone number.
7 | CAREGIVER_1_EMAIL | VARCHAR | No |
Caregiver 1 email address.
8 | CAREGIVER_2_NAME | VARCHAR | No |
Caregiver 2 name.
9 | CAREGIVER_2_CITY | VARCHAR | No |
Caregiver 2 city.
10 | CAREGIVER_2_ZIP | VARCHAR | No |
Caregiver 2 ZIP code.
11 | CAREGIVER_2_HPHONE | VARCHAR | No |
Caregiver 2 home phone number.
12 | CAREGIVER_2_WPHONE | VARCHAR | No |
Caregiver 2 work phone number.
13 | CAREGIVER_2_EMAIL | VARCHAR | No |
Caregiver 2 email address.
14 | CAREGIVER_1_REL_C_NAME | VARCHAR | No |
Primary caregiver's relationship to the patient
May contain organization-specific values: Yes
15 | CAREGIVER_2_REL_C_NAME | VARCHAR | No |
Secondary caregiver's relationship to the patient
The category values for this column were already listed for column: CAREGIVER_1_REL_C_NAME
16 | CAREGIVER_1_MPHONE | VARCHAR | No |
The primary caregiver's mobile phone number.
17 | CAREGIVER_1_PRIM_PHONE_C_NAME | VARCHAR | No |
Tracks which of the caregiver 1 phone numbers is the primary number.
May contain organization-specific values: No
Category Entries:
Home phone
Work phone
Mobile phone
18 | CAREGIVER_1_LANG_C_NAME | VARCHAR | No |
Tracks the preferred language of the primary caregiver.
May contain organization-specific values: Yes
19 | CAREGIVER_2_MPHONE | VARCHAR | No |
Mobile phone number for the secondary caregiver.
20 | CAREGIVER_2_PRIM_PHONE_C_NAME | VARCHAR | No |
Which of the caregiver 1's phone numbers is the primary number.
The category values for this column were already listed for column: CAREGIVER_1_PRIM_PHONE_C_NAME
21 | CAREGIVER_2_LANG_C_NAME | VARCHAR | No |
Tracks the secondary caregiver's preferred language.
The category values for this column were already listed for column: CAREGIVER_1_LANG_C_NAME
22 | CAREGIVER_2_CNTY_C_NAME | VARCHAR | No |
The county portion of the secondary caregiver's address.
May contain organization-specific values: Yes
23 | CAREGIVER_2_CNTRY_C_NAME | VARCHAR | No |
The country portion of the secondary caregiver's address.
May contain organization-specific values: Yes
24 | CAREGIVER_2_HOU_NUM | VARCHAR | No |
The house number portion of the secondary caregiver's address.
25 | CAREGIVER_2_DIST_C_NAME | VARCHAR | No |
The district portion of the secondary caregiver's address.
May contain organization-specific values: Yes