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