Visit Verification Activity Log

Description

This report produces an Excel spreadsheet that includes details for changed visits that occurred within the selected date range. This includes details about the visit including call in/call out times, client information, employee and details about changes made to the visit. If specific data items are not collected by the program, that field will be blank on the report output. This report can be run for a maximum of 7 days.

Use

Use this export to create an easily sortable list of all changed visits that occurred within the selected date range including any updates that were made. When you select Run Export, you will be asked to save the Excel file.

Fields and Columns

Parameters

Use the following fields to limit the report output to:

Field	Description
Account	visits associated with the selected account(s)
Payers	visits with the selected payer(s)
Programs	visits with the selected program(s)
Services	the selected service(s) related to the visits
Client	client by name (last name, first name) or Sandata client ID When a partial name is entered the report displays results that begin with the entered characters.
Client Medicaid ID	visits with the entered Client Medicaid ID The entered value must be an exact match to a client's Medicaid ID.
Employee	visits with the employee by name (last name, first name) or Santrax ID When a partial name is entered, the report displays results that begin with the entered characters.

Report Output

Each column of the report displays:

Column	Description
Visit Key	the unique ID of the visit
Account	the provider agency's Sandata EVV account number
Account Name	the account name
Client ID	the Sandata client ID
Client Medicaid ID	the client's Medicaid ID
Alternate Medicaid ID	the client's Medicaid and/or Alternate Medicaid ID If not available, Payer ID. If newborn support is enabled and the client is flagged as a newborn, is shown as "N".
Client Last Name	the client's last name
Client First Name	the client's first name
Client Middle Initial	the client's middle initial (if available)
Employee Santrax ID	the employee's Santrax ID
Employee Last Name	the last name of the employee
Employee First Name	the first name of the employee
Payer	the payer for the visit
Program	the program for the visit
Service	the service for the visit
Scheduled In Date	the scheduled start date of the visit
Scheduled In Time	the scheduled start time of the visit
Scheduled Out Date	the scheduled end date of the visit
Scheduled Out Time	the scheduled end time of the visit
Call In Date	the call-in date of the visit
Call In Time	the call-in time of the visit
Call Out Date	the call-out date of the visit
Call Out Time	the call-out time of the visit
Adjusted In Date	the manually entered start date of the visit
Adjusted In Time	the manually entered end time of the visit
Adjusted Out Date	the manually entered end date of the visit
Adjusted Out Time	the manually entered end time of the visit
Bill Time	the total billable time for the visit
Pay Time	the total payable time for the visit
Group Code	the group code, if applicable, for the visit
Tasks	the tasks performed for the visit
Memo	the content of the memo, if entered
Change User	the user that made the visit change
Change Date	the date of the change
Change Time	the time of the change
Change Privilege	the description of the visit change
Reason Code	the reason code applied to the visit

Sample Report

Visit Verification Activity Log Export - Sample