HH_EVV_DATA
Description:
Will contain Electronic Visit Verification data and documentation for each visit.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 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).
2 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 CM_CT_OWNER_ID VARCHAR No
The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
6 EVV_METHOD_C_NAME VARCHAR No
The EVV trigger, such as the start of end of the visit, for the corresponding line in the related item.
May contain organization-specific values: No
Category Entries:
NFC Scan In
NFC Scan Out
Start Visit
End Visit
Other NFC Scan
7 EVV_FAIL_TYPE_C_NAME VARCHAR No
Describes how EVV failed on the client.
May contain organization-specific values: No
Category Entries:
Location Services Failed
Location Outside Allowed Radius
Visit Time Later Than Scheduled Time
Visit Time Manually Entered (Mobile)
Visit Time Manually Entered (Remote Client)
Aggregator Rejected Submission (Needs Addendum)
Visit Duration Does Not Match Scheduled Visit Duration
Visit Time Earlier Than Scheduled Time
8 EVV_RSN_CODE_C_NAME VARCHAR No
The reason code to justify the change made to override the EVV failure.
May contain organization-specific values: Yes
Category Entries:
Mobile Device Issues
Mobile Device Captured Incorrect Location
Mobile Device Not Charged
Mobile Device Missing
Mobile Device Requested
Mobile App Issues/Inoperable
No Cell Coverage
Other
Provider Error
Provider Failed to Document Start Visit - Services Delivered
Provider Failed to Document End Visit - Services Delivered
Provider Failed to Document Start or End Visit - Services Delivered
Provider Failed to Document Start and End Visit - Services Delivered
Provider Documented Visit Start/End too Late/Early
Data Entry Error
Scheduling Error
Duplicate Entry
Service Provided Outside Home
Service Provided at an Alternate Location - Services Delivered
Wrong Type of Service Selected
Wrong Patient Selected
Unsafe Environment
Emergency
Natural/Public Health Disaster
Visit Extended by Patient Request
Visit Shortened by Patient Request
Patient Refused Service
No One Answered Locked Door
Patient Discharged
Legal Designee Refused Service
Patient Unavailable
Patient Not Home
Patient Removed From Home By Family
Patient in Hospital
Patient Expired
Unscheduled Visit (Confirmed)
Provider Service Not Per Patient
Provider No Show
Provider Change
Provider Unable to Use Mobile Device
Administrative Delay
Retroactive Coverage Addition
Retroactive Payor Change
Manual Entry of EVV
Verification Attempt Failed
Group Visit
Split Visit - Overtime
Split Visit - Multiple Programs
Split Visit - Home Care Attendant
No Orders - Not Billable
Provider ID Not Entered
Invalid Provider ID
EVV System Failure
Type of Service Not Selected
Patient Requested Visit Change/Cancellation
Visit Cancelled - Patient's Services Suspended
9 EVV_RSN_CODE_TYPE_C_NAME VARCHAR No
The type of reason code, and whether the code was entered on mobile or through the Remote Client.
May contain organization-specific values: No
Category Entries:
General
Location
Scheduled Time
Administrative
Duration
10 EVV_RSN_CODE_CMT VARCHAR No
Comments accompanying the reason code.
11 EVV_RES_CODE_C_NAME VARCHAR No
The resolution code corresponding to the actions taken to override the EVV failure.
May contain organization-specific values: Yes
Category Entries:
Changed verification collection method and documented
Written documentation maintained
Visit Rescheduled within 2 hours
Visit Rescheduled within 24 hours
Visit Rescheduled within 48 hours
Next Scheduled Visit
Non-Paid Caregiver
New attendant assigned to Patient
Visit has been rescheduled
Services canceled or suspended until further notice
Updated patient's address and documented
Change in schedule
Other
12 EVV_EXC_CODE_C_NAME VARCHAR No
The exception code to be acknowledged corresponding to the EVV failure.
May contain organization-specific values: Yes
Category Entries:
Unknown Client
Unknown Employee
Visit Without Any Calls
Visit Without In-Calls
Visit Without Out-Calls
Unscheduled Visit
Unmatched Client ID/Phone
GPS Distance Exception
Service Verification Exception
Visit Verification Exception
Client Signature Exception
Late In Call
Early Out Call
Short Visit
No Show
Missing Service
Employee Speaker Verification
Invalid Service
Location Required
13 EVV_FAIL_SOURCE_C_NAME VARCHAR No
Indicates the source of the EVV failure for the corresponding line in the related group.
May contain organization-specific values: No
Category Entries:
Calculated
User Input