HH_PAT_ENC
Description:
This table contains Home Care overtime single items that are stored in the Patient (EPT) master file.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1

Column Information
Name Type Discontinued?
1 CONTACT_DATE_REAL FLOAT No
Unique identifier for this contact for this patient.
2 CHIEF_COMPLAINT_ID NUMERIC No
Identifier for chief complaint for the encounter.
3 HH_TYPE_OF_SVC_C_NAME VARCHAR No
Home Health type of service category list selections for the encounter. Links to category table ZC_HH_TYPE_OF_SVC.
May contain organization-specific values: Yes
4 HH_CONTACT_TYPE_ID VARCHAR No
Identifier for the Home Health contact type for the encounter.
5 HH_ENC_CREAT_INST DATETIME (Local) No
Instant of creation for the encounter.
6 HH_VST_CHRG_UCLID VARCHAR No
The Universal Charge Line record ID for the visit change for this encounter.
7 HH_ASMT_CHRG_UCLID VARCHAR No
The Universal Charge Line record ID for the assessment change for this encounter.
8 INPAT_DISCHRG_DT DATETIME No
Inpatient discharge date.
9 PRIMARY_DX_ID NUMERIC No
Identifier for the ICD-9 primary diagnosis. Links to table CLARITY_EDG.
10 PRIM_DX_START_DATE DATETIME No
Primary diagnosis start date.
11 PRIM_DX_SEVERITY INTEGER No
Primary diagnosis severity.
12 PROGNOSIS_C_NAME VARCHAR No
Prognosis category list selections. Links to category table ZC_PROGNOSIS.
May contain organization-specific values: No
Category Entries:
Poor
Guarded
Fair
Good
Excellent
13 REHAB_POTENTIAL_C_NAME VARCHAR No
Rehab potential category list selections. Links to category table ZC_REHAB_POTENTIAL.
May contain organization-specific values: No
Category Entries:
Good
Fair
Poor
14 POC_FLAG_YN VARCHAR No
Is there a plan of care? Yes or no.
May contain organization-specific values: No
Category Entries:
No
Yes
15 POC_HDR_ID VARCHAR No
Text entered for plan of care header.
16 CERT_PER_STRT_DT DATETIME No
Cert period start date.
17 CERT_PERIOD_END_DT DATETIME No
Cert period end date.
18 POC_VERBAL_ORD_ID VARCHAR No
Identifier for the plan of care verbal order. Links to table HH_VO_INFO.
19 POC_GOALS_ID VARCHAR No
Identifier for the plan of care goals.
20 POC_ORDERS_ID VARCHAR No
Identifier for the plan of care orders.
21 IS_BILLABLE_YN VARCHAR No
Whether the encounter is billable.
May contain organization-specific values: No
Category Entries:
Yes
No
22 EOW_LINK_CT_ID VARCHAR No
The record ID of a message in the In Basket task and messaging system. Links to table IB_MESSAGES.
23 SCHED_TM_TBD VARCHAR No
Schedule time to be determined.
24 OASIS_DATA_LINK_ID NUMERIC No
Numeric link to an OASIS data set.
25 ROC_DATE DATETIME No
Resumption of care assessment date.
26 DISCHARGE_REASON_C_NAME VARCHAR No
Discharge reason category list selection. Links to category table ZC_REASON_DISCH.
May contain organization-specific values: Yes
27 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
28 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
29 CM_CT_OWNER_ID VARCHAR No
The Community ID (CID) of the instance that owns this contact. This is populated only if you use IntraConnect.
30 STATED_WEIGHT NUMERIC No
The stated weight entered for a patient during an encounter.
31 HC_ADM_DECISION_YN VARCHAR No
This item contains the home care admission decision.
May contain organization-specific values: Yes
Category Entries:
No
Yes
On Hold
32 IP_PROC_NA_YN VARCHAR No
This item stores whether the "NA - Not Applicable" check box is checked for Home Health OASIS question M1012.
The category values for this column were already listed for column: POC_FLAG_YN
33 IP_PROC_UKNWN_YN VARCHAR No
This item stores whether the "UK - Unknown" check box is checked for Home Health OASIS question M1012 - Inpatient Procedures.
The category values for this column were already listed for column: POC_FLAG_YN
34 REGIMEN_CHG_NA_YN VARCHAR No
This item stores whether the "NA - Not Applicable" check box is checked for Home Health OASIS question M1016.
The category values for this column were already listed for column: POC_FLAG_YN
35 POC_PHYS_ID VARCHAR No
This item stores responses to question M0018 on Home Health OASIS assessments. M0018 holds the NPI of the physician who is expected to sign the home health patient's plan of care. This item stores the record ID of the physician, not the NPI.
36 POC_PHYS_NA_YN VARCHAR No
This item stores whether the Unknown checkbox is checked on Home Health OASIS question M0018.
The category values for this column were already listed for column: POC_FLAG_YN
37 POC_VERBAL_SOC VARCHAR No
This field holds the clinician who received the verbal start of care order and the date the order was received.
38 POC_F2F_HNO_ID VARCHAR No
HH Face to Face attestation note for the plan of care
39 PRIM_DX_FLAG_C_NAME VARCHAR No
The Primary DX - Flag item is a customer defined category list that can be used to further describe a diagnosis entry. An example of the use of this item would be for flagging a diagnosis as an exacerbation or onset. The flag will be carried over to the plan of care
May contain organization-specific values: Yes
No Entries Defined
40 VISIT_START_DTTM DATETIME (Local) No
The start time and date of a home visit.
41 VISIT_END_DTTM DATETIME (Local) No
The end time and date of a home visit.
42 HH_EPS_CHRG_UCL_ID VARCHAR No
The Universal Charge Line record ID for the EPS Assessment charge for NY Medicaid.
43 POC_PHYS_EST_HNO_ID VARCHAR No
This stores a link to the note that stores Home Health's physician recertification estimate attestation statement for the Plan of Care verbal order.
44 SOC_DATE DATETIME No
If this is a start of care contact, this is the M0030 date.
45 VOL_DRIVING_ST_TM DATETIME (Local) No
The driving start time for a home health or hospice volunteer visit.
46 VOL_DRIVING_END_TM DATETIME (Local) No
The driving end time for a home health or hospice volunteer visit.
47 VOL_MILEAGE FLOAT No
The mileage for driving to a home health or hospice volunteer visit.
48 VOL_NAME VARCHAR No
The volunteer's name for a home health or hospice volunteer visit.
49 TRANSCRIBE_USER_ID VARCHAR No
The transcribing user for a home health or hospice volunteer visit.
50 TRANSCRIBE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
51 HH_POC_PHYS_ADDR_ID VARCHAR No
This item stores the unique address ID corresponding to M0018 provider (attending physician) who is expected to sign the Home Health patient's Plan of Care.
52 POC_SUBMIT_UTC_DTTM DATETIME (UTC) No
This item stores the POC submission instant in UTC when the POC was submitted.
53 DECEASED_BEFORE_YN VARCHAR No
This item determines if the patient was deceased before the visit. If this is set to Yes, the whole visit will be considered as post-mortem visit.
The category values for this column were already listed for column: POC_FLAG_YN
54 NO_SECONDARY_DX_C_NAME VARCHAR No
Whether the patient has a secondary diagnoses.
May contain organization-specific values: No
Category Entries:
Checked
Unchecked
55 ENC_CLOSE_METHOD_C_NAME VARCHAR No
The encounter close method category ID for the encounter.
May contain organization-specific values: No
Category Entries:
Remote Client
Batch Job
Utilities
Mobile
Hyperspace
Third Party
Automatically closed due to incorrect time zone
56 REPORTING_DISC_C_NAME VARCHAR No
This item stores the reporting discipline of the provider who completed the encounter.
May contain organization-specific values: No
Category Entries:
Registered Nurse
Licensed Practical Nurse
Physical Therapist
Physical Therapy Assistant
Occupational Therapist
Occupational Therapy Assistant
Speech-Language Pathologist
Medical Social Worker
Home Health Aide
Chaplain
Homemaker
Other
57 POC_MENTAL_NOTE_ID VARCHAR No
This stores a link to the note that stores the mental, psychosocial, and cognitive observations for the Plan of Care verbal order.
58 HH_HSPC_EPISODE_ID NUMERIC No
The ID of the first home health/hospice episode to which the encounter is linked.
59 DISCH_W_DECLN_RSN_C_NAME VARCHAR No
Reason for discharging a patient who has declined or not improved outcomes
May contain organization-specific values: Yes
No Entries Defined
60 DISCH_W_DECLN_CMT VARCHAR No
Additional optional comments for explaining why the patient was discharged with declined outcomes