HH_EPSD_INFO
Description:
This table contains Home Health/Hospice episode information. It contains the noadd single items for the Episode. These items are entered by a user as part of the Intake encounter.

Primary Key
Column Name Ordinal Position
SUMMARY_BLOCK_ID 1

Column Information
Name Type Discontinued?
1 SUMMARY_BLOCK_ID NUMERIC No
Unique identifier for the episode.
2 TEAM_ASSIGNMENT_C_NAME VARCHAR No
Team assignment category list selection for the episode. Links to category table ZC_TEAM_ASSIGNMENT.
May contain organization-specific values: Yes
3 DME_CO_ID NUMERIC No
This column contains the durable medical equipment supplier for the patient's episode. The column links to table RX_PHR.
4 DME_CO_ID_PHARMACY_NAME VARCHAR No
The name of the pharmacy.
5 LABORATORY_ID NUMERIC No
The unique id of the laboratory.
6 LABORATORY_ID_LLB_NAME VARCHAR No
Interface laboratory name.
7 HOME_INFUSN_CO_ID NUMERIC No
ID for the home infusion company for the episode. Links to table RX_PHR.
8 HOME_INFUSN_CO_ID_PHARMACY_NAME VARCHAR No
The name of the pharmacy.
9 HOME_CARE_CITY VARCHAR No
City in the home care address for the episode.
10 HOME_CARE_STATE_C_NAME VARCHAR No
Category list selection for home care state for the episode. Links to category table ZC_STATE.
May contain organization-specific values: Yes
11 HOME_CARE_ZIP VARCHAR No
ZIP code for the home care address for the episode.
12 HOME_CARE_PHONE VARCHAR No
Phone number for the home care address for the episode.
13 PAT_WEIGHT NUMERIC No
Patient weight entered for the episode.
14 PAT_HEIGHT VARCHAR No
Patient height entered for the episode.
15 CARE_PLAN_ID VARCHAR No
This item stores the careplan ID.
16 EPISODE_DELETED_C_NAME VARCHAR No
Depending on whether the episode is deleted, this item stores the category list selection for the episode. Links to category table ZC_EPISODE_DELETED.
May contain organization-specific values: Yes
Category Entries:
Deleted
Not Deleted
17 OUTPAT_ADMSN_C_NAME VARCHAR No
Is this an outpatient admission? Links to category table ZC_OUTPAT_ADMSN.
May contain organization-specific values: No
Category Entries:
Yes
No
18 INTERPRETER_NEED_C_NAME VARCHAR No
Is an interpreter needed for the episode? Links to category table ZC_OUTPAT_ADMSN.
The category values for this column were already listed for column: OUTPAT_ADMSN_C_NAME
19 TRIAGE_CODE_C_NAME VARCHAR No
Triage code category list selection for the episode. Links to category table ZC_TRIAGE_CODE.
May contain organization-specific values: Yes
20 REFERRAL_RECVD_TIM DATETIME (Local) No
Time the referral for this episode was received.
21 REFERRAL_AUTHOR VARCHAR No
Author of the referral for this episode.
22 RFL_AUTHOR_PHONE VARCHAR No
Referral author phone number.
23 REASON_DISCH_C_NAME VARCHAR No
Reason for discharge category list selection for the episode. Links to category table ZC_REASON_DISCH.
May contain organization-specific values: Yes
24 HH_EPISODE_TYPE_C_NAME VARCHAR No
Home Health episode type category list selection for the episode. Links to category table ZC_HH_EPS_TYPE.
May contain organization-specific values: Yes
25 HC_ADM_STAT_C_NAME VARCHAR No
This item tracks the status of the Home Care episode admission.
May contain organization-specific values: No
Category Entries:
Admitted
Discharged
Pending Admit
Non-Admit
Discarded
26 HOSPICE_ELEC_DT DATETIME No
Hospice Election Date
27 HOSPICE_REV_DT DATETIME No
Holds the Hospice Revocation Date
28 HC_ADM_SOURCE_C_NAME VARCHAR No
This item contains the source the patient was admitted from.
May contain organization-specific values: Yes
29 HC_DC_DISPOSITION_C_NAME VARCHAR No
This item stores the patient's discharge disposition.
May contain organization-specific values: Yes
30 NUM_PREV_EPSD_C_NAME VARCHAR No
Holds the Previous Number of Consecutive Home Health Episodes
May contain organization-specific values: No
Category Entries:
NONE
ONE EPISODE
Two or More Episodes
Unknown
31 RFL_SRC_RPT_C_NAME VARCHAR No
This item contains a customer defined list of referral sources.
May contain organization-specific values: Yes
No Entries Defined
32 HSPC_DC_REAS_C_NAME VARCHAR No
This item stores the reason for discharge for a hospice admission.
May contain organization-specific values: Yes
33 PRIM_DX_RPT_C_NAME VARCHAR No
Custom item for customers to fill in.
May contain organization-specific values: Yes
No Entries Defined
34 EPISODE_TYPE_ID NUMERIC No
This item stores the episode type.
35 COMP_ASMT_COMP_DTTM DATETIME (UTC) No
This item marks the instant at which the hospice comprehensive assessment was first completed. This happens automatically when all sections of the comprehensive assessment have been documented at least once.
36 COMP_ASMT_COMP_CSN NUMERIC No
This column stores the contact serial number (CSN) of the patient encounter in which the comprehensive assessment was first completed. That is, the first encounter closed in which all of the sections of the comprehensive assessment have been documented at least once.
37 HH_LINKED_UIC_ID NUMERIC No
In traveler mode each patient will have one episode per unit. This item allows an episode to be linked to a particular unit. Hence, facilitating retrieval of episode information of patients assigned to a specific unit.
38 HH_LINKED_UIC_ID_RECORD_NAME VARCHAR No
This column stores the name of the military unit's record.
39 HOSPICE_EFF_DT DATETIME No
The date the hospice agency began taking care of the patient.
40 PECOS_COMPLY_YN VARCHAR No
This column stores whether the episode is PECOS compliant. An episode is PECOS compliant if all necessary providers (referring provider, plan of care provider) are PECOS enrolled.
May contain organization-specific values: No
Category Entries:
No
Yes
41 HOME_CARE_COUNTY_C_NAME VARCHAR No
This item stores the county of the patient's home care address. The home care address is the address where the patient will be receiving home health or hospice care.
May contain organization-specific values: Yes
42 HSPC_PRIOR_DAYS_ON_SVC INTEGER No
Stores the number of CMS-qualified days the patient was in hospice care prior to this admission - This number persists between episodes, but resets to 0 after 60 days discharged.
43 HH_COVCHG_IND_DT DATETIME No
This item is used to flag a Home Health episode as needing a coverage change. When the coverage change workflow is completed, this date is removed.
44 HH_COVCHG_IND_COVERAGE_ID NUMERIC No
This item stores the new primary coverage for a coverage change. When the coverage change workflow is completed, this ID is removed.
45 DISCH_SOURCE_PAT_ENC_CSN_ID NUMERIC No
Stores the contact serial number (CSN) of the encounter from which this episode's Discharge Date, Disposition, and Reason for Discharge are populated.
46 HOME_CARE_COUNTRY_2_C_NAME VARCHAR No
This column stores the country of the patient's home care address. The home care address is the address where the patient will be receiving home health or hospice care.
May contain organization-specific values: Yes
47 HOME_CARE_HOUSE_NUMBER VARCHAR No
This column stores the house number of the patient's home care address. The home care address is the address where the patient will be receiving home health or hospice care.
48 HOME_CARE_DISTRICT_C_NAME VARCHAR No
This column stores the district of the patient's home care address. The home care address is the address where the patient will be receiving home health or hospice care.
May contain organization-specific values: Yes
49 HC_ADDR_LATITUDE VARCHAR No
The geocoded latitude for the home care address in numerical degrees with up to 6 decimals of accuracy.
50 HC_ADDR_LONGITUDE VARCHAR No
The geocoded longitude for the home care address in numerical degrees with up to 6 decimals of accuracy.
51 HC_ADDR_GEO_RATING VARCHAR No
The HC_ADDR_GEO_RATING rates the accuracy of latitude and longitude for the home care address. The rating is a calculated value determined by taking the lesser of the request-to-response granularity and vendor confidence scores. A is a perfect match to house number with perfect vendor confidence. B is equivalent to a street level specificity or a vendor confidence level in the 100-90 range. Ratings less than that are at best city or county specific and degrade in alphabetical order until E.
52 EPI_STATUS_C_NAME VARCHAR No
Current status of this episode.
May contain organization-specific values: No
Category Entries:
Active
Resolved
Deleted
53 COVCHG_IND_PAT_STATUS_C_NAME VARCHAR No
The discharge disposition recorded for a truncated hospital account following a coverage change.
The category values for this column were already listed for column: HC_DC_DISPOSITION_C_NAME
54 COVCHG_IND_HH_COVCHG_TYPE_C_NAME VARCHAR No
The type of coverage change needed on the Home Health episode.
May contain organization-specific values: No
Category Entries:
Create PPS
55 INBASKET_MSG VARCHAR No
InBasket Message IDs within this episode.
56 UNKNOWN_REF_PROV_YN VARCHAR No
Set if the referring provider is unidentified.
The category values for this column were already listed for column: OUTPAT_ADMSN_C_NAME
57 INTAKE_PAT_ENC_CSN_ID NUMERIC No
The unique patient contact serial number for the intake encounter for a home health/hospice episode. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
58 HC_COMP_ASMT_OVRD_C_NAME VARCHAR No
This item, when populated, may override the default comprehensive assessment configured for a patient's Hospice intake department. The department needs to map the value populated in this item with the new comprehensive assessment to use.
May contain organization-specific values: Yes
No Entries Defined