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