Aggregators, Clearinghouses, and State Portal Guides›Sandata Data Delivery & Visit Management

Sandata Data Delivery & Visit Management

Overview

Per state requirements, Ankota directly feeds required data to Sandata, a data aggregator serving numerous states, based on complex technical specs. This data becomes part of a library of data made available to the state for internal monitoring. (The content and format of this data is determined by the state in accordance with federal law.)

After reviewing the data, Sandata sends Ankota responses confirming the acceptance or rejection of those visits. If the visits are rejected, Sandata will usually provide a brief explanation as to why. Ankota logs those responses in the Visit Approval Dashboard for review. Rejections are also highlighted on the Ankota Landing Dashboard.

Most "Accepted" visits will then be "Verified." Verified means the visit is billable. Some visits, however, will say "Processed." In some payer set-ups, Processed may remain the final EVV status within Sandata, even after billing continues elsewhere.

Billing is sometimes completed through Sandata, and sometimes through 837s, depending on the state and payer.

Critical Workflow

  • Use the Landing Dashboard to identify and complete needed actions

  • Use the Approval Assistant to review Needs Action visits

  • Following this process results in very few rejections

  • Ankota will automatically export Passed Screening and Approved visits as appropriate

  • Check for Responses

    • Ensure a status of Accepted for all exported visits during the first export

    • Most "Accepted" visits will then be "Verified" in Sandata. Verified means the visit is billable. Some visits, however, will say "Processed." In some payer set-ups, Processed may remain the final EVV status within Sandata, even after billing continues elsewhere.

  • Check for exceptions in Sandata prior to billing

    • Checking for exceptions prior to billing is critical in states where exceptions can cause visits to be unbillable, such as Missouri

    • In most cases:

      • Omit the visit with exceptions/in status Incomplete (either in Sandata or, if the Omit option is unavailable, contact Ankota Support)

      • Make the correction to the visit

      • Change the Visit ID in Ankota using the Add to Visit ID button (which adds a character to the end of the visit ID, making it a "new" visit ID)

      • Export the updated visit

    • NOTE: if the wrong client was scheduled, this is a fatal error; the visit must be canceled and a new billable visit created

  • Make sure new clients and caregivers are checked after their first visits to ensure data is exporting successfully

  • Manage Rejected visits on the Visit Approval Dashboard by reviewing the rejection, correcting, and manually re-exporting

    • If the Approval Assistant wasn't used to review the visits before sending, double check the rejected visits in the AA

    • If there was incorrect data entered by an admin resulting in billing the wrong visit type or duration:

      • Errors can usually be corrected by making changes, then marking with a new Reason code prior to re-exporting the visit
    • If Sandata will not accept the update:

      • Send BillVisit as false or mark as Omit/False in Sandata

      • Make the correction to the visit

      • Change the Visit ID in Ankota using the Add to Visit ID button

      • Export the updated visit

    • NOTE: if the wrong client was scheduled, this is a fatal error; cancel the visit and create a new billable visit

  • Bill via Sandata or 837 as appropriate when visits are accepted

Index

  • Data Preparation

    • The Approval Assistant

    • Individual Visit Review

  • Data Lifecycle

  • Data Management Best Practices

  • Data Responses & Rejections

    • Integrated Responses

    • Rejections

    • Rejection Corrections

  • Other

    • Essential Transportation / Essential Errand / Shopping

Data Preparation

Data preparation typically covers the following:

  • Adding missing data entry

  • Adding missing (reason, bypass, or exception) codes

  • Unexpected duration requiring approval or change

  • Individual review of some visits with unique issues

Visit Approval

To speed up this process, Ankota usually recommends using the Approval Assistant in the Visit Approval Dashboard to rapidly identify missing data, missing codes, and duration issues prior to approval. Any remaining unapproved visits can be individually reviewed, and then data is delivered.

A process flow diagram showing three sequential steps for handling "Needs Action" visits: using the VAD Approval Assistant for mass review (blue box), reviewing remaining visits individually in the VAD (green box), and exporting data automatically with Sandata, Therap, and Netsmart or upon billing with Authenticare and HHAX (green box).

The Approval Assistant

The Approval Assistant is used for mass review of Needs Action visits. It has four key sections:

  • The Data Entry section catches missing data. It will link to the profiles of clients or caregivers missing information along with indicating what is missing.

  • The Codes section will make coding suggestions as appropriate for the state and aggregator and resolves the related red warnings. This section particularly speeds up the review process.

  • The Durations section will help make duration changes if necessary. This is a powerful section primarily intended for private pay and CDS.

  • The Approval section allows approval of visits with no red warnings left. (Visits which still have red warnings will not be approved.)

The Approval Assistant resolves the majority of all issues that require attention or changes in order to be accepted by Sandata. The most complex step is typically coding. Coding requires the admin to recognize the errors that occurred and apply a code to reflect the error, which will result in the state accepting the visit. Most errors which would cause a rejection can be prevented with a code. The most common codes will automatically be suggested by the Approval Assistant. Missed coding is the most common reason for visit rejection, so it is always beneficial to use the Approval Assistant.

The "Approve Selected Visits" dialog displays four sections for processing visit approvals: Data Entry Issues listing validation errors for specific visits, Reason Codes to Apply showing three selectable reason codes with visit counts, Adjust Durations Of Visits That Exceeded Scheduled Duration indicating 4 visits needing duration adjustment, and Approve Visits with radio button options for approval status (Needs Approval, Approved for Billing and Payroll, Approved for Payroll, Approved for Billing, Pay But Don't Bill, Bill But Don't Pay, Unapproved Bill Never Pay).

Individual Visit Review

After completing a review of Needs Action visits with the Approval Assistant, wait a few minutes before refreshing the Visit Approval Dashboard to pull up all remaining Needs Action visits. There should be significantly fewer visits remaining.

Next, walk through each visit individually by clicking the paper-and-pencil "Edit" icon (

) and reviewing the red warnings which could not be resolved by the Approval Assistant. Typically these are unusual warnings. Resolve them, make other adjustments as needed (see additional notes below), then approve the visit, and the visit will be exported.

A process flow diagram showing three sequential steps for handling "Needs Action" visits: using the VAD Approval Assistant for mass review (blue box), reviewing remaining visits individually in the VAD (green box), and exporting data automatically with Sandata, Therap, and Netsmart or upon billing with Authenticare and HHAX (green box).

Other visit adjustments will vary based on the visit. Actions may include:

  • Reviewing unresolved red warnings

  • Fixing the issues the red warnings flagged

  • Marking the red warnings as reviewed/completed (turning them green)

  • Correcting times if needed

    • Always click Save Visit Details to recalculate billable/payable after adjusting times
  • Reporting care plan items if needed

  • Checking the Close Visit box if needed

  • Adding coding if needed

  • Approving the visit (even if it is approving it to be Never Bill/Never Pay)

Data Lifecycle

The Ankota/Sandata data life cycle is initiated by visits passing screening or being approved in Ankota. Appropriate, state-required visits are then sent to Sandata, who reviews them and sends feedback to Ankota.

During the start of data delivery, data should be checked to ensure it is exporting successfully. This should be repeated with any new clients or caregivers.

Any rejected visits are then reviewed by the Ankota user in the Visit Approval Dashboard, corrected, and re-sent to Sandata. (Rejected visits are much rarer when customers use the Approval Assistant on Needs Action visits.)

This diagram illustrates a workflow process with five circular nodes connected by arrows, showing the steps involved in managing visit screening and approval: profiles are sent or re-sent by aggregator/state, visits pass screening and are approved for billing, needs are reviewed and visits are corrected and re-sent, aggregators process data and send responses, and Ankota customers review and make corrections to visits.

Data Management Best Practices

Prepare Appropriately

  • Fill out all the necessary fields prior to scheduling visits for clients or caregivers

  • Regularly work through the Visit Approval Dashboard so issues don't pile up

Use Dashboards

  • Check the Landing Dashboard regularly

  • Complete the action items visible there (manage visits)

Use the Approval Assistant Wisely

  • Work through Needs Action visits one category at a time

The Visit Approval Dashboard filter screen displays multiple search and filter options organized in three columns, including Client, Caregiver, Review Status (set to "Needs Action"), date range fields (2/5/2024 to 4/5/2024), Approval Type, Visit Type, Payer Descriptor, and Visit ID, with action buttons for "Run Rules," "View Report," and "Tag Filters" at the bottom right.

  • For Missouri Errands, review visits with Errands first

  • The Approval Assistant works best for groups of Needs Action Medicaid visits which must be delivered to an aggregator

  • The Approval Assistant can be used with non-Medicaid visits for cleaning and visit management, but it was not designed for those visits

  • The Approval Assistant can be used to review Rejected visits if it was not used to begin with and key steps were missed

    • Filter appropriately when reviewing Rejected visits

The Visit Approval Dashboard filter panel displays multiple search and filter options including Date From (02/04/2024) and Date To (04/04/2024) fields highlighted in red, along with dropdowns for Client, Caregiver, Review Status, Export Status (set to "Rejected"), Approval Type, Visit Type, and other criteria, with action buttons for Run Rules, View Report, and Tag Filters at the bottom right showing "23 visits" found.

  • Work top to bottom in the Approval Assistant

  • Give each section time to process

  • Manage visits first, then approve

Data Responses & Rejections

Integrated Responses

Aggregator responses (rejections and acceptances) are automatically integrated into the Ankota Visit Approval Dashboard. Depending on the size of the data delivery and the timing of the export, responses may appear anywhere from a few hours later to a day later.

The exported data statuses will be shown as the data progresses:

  • No Response means the data was not sent or not successfully sent

  • Sent to Export indicates the file was created and queued for delivery

  • Sent means the formatted file has been transmitted

  • In Process means the data was confirmed as received by the aggregator/clearinghouse and is now under review

  • Rejected or Accepted is the final status of all successfully exported and processed visits

  • N/A is a special selected status where Ankota users can erase the export status history and set to N/A

    • This is typically used when a visit is accidentally sent over with an override, such as accidentally sending a private pay visit over

Hidden responses:

  • Sandata may accept a visit, but silently make it unbillable; see below

The main concern will be to check for rejections, view the errors, make corrections, and export them. The Visit Approval Dashboard can be filtered by Date and Export Status to view rejected response files (make sure the Ankota Visit Status is Status: All):

The Visit Approval Dashboard filter panel displays multiple filter options including Date From (4/1/2023) and Date To (5/25/2023) fields highlighted in red, along with dropdowns for Client, Caregiver, Visit Status, Approval Type, Visit Type, Export Status (set to "Rejected"), and other criteria, with action buttons for Run Rules, View Report, and Tag Filters at the bottom.

The errors will show specifically in the visit details under Status.

The Visit Detail Report page displays comprehensive information for a client visit, including client name (Harry), care plan, referring program (CDS), and visit type (Personal Care CDS). The form shows scheduled and actual arrival/departure times, visit duration fields, and a Status section currently highlighted in red showing "Rejected" with an error message indicating an incorrect VisitCancelledIndicator format that needs to be corrected.

Rejections

Rejection Reasons

Visits can be rejected for a number of reasons, but typically it is one of the following:

  • Client or caregiver data is wrong or missing

    • The Approval Assistant's Data Entry section helps prevent missing data errors
  • The client is not authorized to bill this payer or visit type for the service date

  • The visit has a basic EVV error and requires coding to allow acceptance by the aggregator

    • The Approval Assistant's Coding section helps prevent missed codes

The errors will show specifically in the visit details under Status. Corrections can be made as needed and re-exported. For more guidance on rejection reasons and how to proceed, see the Corrections section below.

The Visit Detail Report page displays comprehensive information for a client visit, including client name (Harry), care plan, referring program (CDS), and visit type (Personal Care CDS). The form shows scheduled and actual arrival/departure times, visit duration fields, and a Status section currently highlighted in red showing "Rejected" with an error message indicating an incorrect VisitCancelledIndicator format that needs to be corrected.

Accepted with Exceptions

Sometimes visits will be accepted by Sandata, but with exceptions. Exceptions do not show in Ankota, only in Sandata. In some states, visits with exceptions are still billable; in others, they are not.

Missouri Exceptions:

As of 4/1/2026 in the state of Missouri, most exceptions cause visits to be Incomplete and therefore unbillable.

  • The most common exception causing unbillable status is missing care plan items on visits requiring care plan items

  • Ankota has added a safety net to help prevent these unbillable visits:

    • If a visit type requires care plan items

    • And the visit is missing care plan items

    • Ankota will not deliver until at least one care plan item is completed

To locate exceptions, log in to Sandata on Demand and navigate to Visit Review. Enter the date range and select All Exceptions. This will display any exceptions returned by Sandata. Click into each exception to view the specific details for that visit.

The Visit Review search form displays filter options for querying visit records, including Agency (set to "All"), Client ("Test Client"), Medicaid ID# (1122112), Employee, Date Range (01/01/2026 to 02/17/2026), Visit Status (All), and a "Filter Visits By" dropdown (currently set to "All Exceptions"). Search and Clear buttons are available at the bottom to execute or reset the query.

After the criteria for the search is made, the report will show below. Scroll to the right and click on the eye icon.

A service visit record table displaying DSDS - CDS Personal Care entries with columns for visit date, scheduled times, actual call in/out times, adjusted hours, billing status, and action buttons; the table shows 1 to 8 of 8 entries with two visible rows dated 12/09/2025 and 12/08/2025, both marked as "Incomplete" status.

Because Ankota typically flags visits that are missing care plans—and caregivers cannot close visits without completing care plan items—these types of exceptions should be uncommon.

The screenshot shows a vertical navigation menu with six sections: GENERAL (currently selected with blue outline), CLIENT, EMPLOYEE, CALL LOG, TASKS, and EXCEPTIONS. A red circle indicator labeled "Missing Tasks" appears in the upper right, alerting users to incomplete tasks.

To correct this, there are two options: coding the visit as missing tasks (accepting the error and moving on), or adding the care plan items and doing a special export of the visit.

Coding And Re-Exporting Visits without Care Plan Items/Tasks

Coding and then re-exporting visits without care plan items is the best path if it is unclear what tasks were completed on a visit.

By coding the visit and approving the visit, Ankota will allow re-exporting the accepted visit.

To make the correction:

  • Do NOT add care plan items

  • Mark the visits in Ankota with reason code Sandata 250 – Does not Contain Task Information

  • Approve the visit

  • Export the visit

Correcting, Re-setting, and Exporting Visits with Care Plan Items

In the case where the care plan completion information is available and care plan corrections are desired, the process is as follows:

  • Correct the missing care plan items on visits (typically through the Visit Approval Dashboard, inside the visit details, Care Plan Items button)

  • Re-set the visit status

    • This can be done either through a Support ticket request, or, in the case of repeated corrections, a re-set override can be provided
  • Re-export the visit

Contact Support for assistance with this process.

Rejection Corrections

Once the error is known (visible in the visit's rejection details), correct the errors as needed and then re-export the visit(s). This may involve adjusting reason codes in the Visit Approval Dashboard before re-exporting a single visit, or completely backing out billing and payroll in order to correct a fundamentally wrong visit (with wrong visit dates, time, visit type, client, or caregiver) before re-exporting the visit.

Some common errors and the actions to take are outlined below.

ErrorMeaningWhat to Do
Request Failed With An ExceptionThis visit was coded (most commonly a reason code, such as 160 - Caregiver Failed to Call Out), but the visit did NOT need the reason codeRemove the unnecessary code and re-export
A visit row exists in stx.visits table (by account/visit_id) and no changes are specifiedThis visit was sent a second (or third, fourth...) time, but there is no reason provided as to why it was changed, so it was rejected.If you sent the visit by accident a second time and you do not need to update the visit, do not change anything. If you did want to re-send the visit, reason code the visit and then re-send the visit.
Reason code errorThe reason code was wrong/missing.Update the reason code and re-send the visit.
Employee not foundThe employee's file did not successfully transfer.Update your employee profile so that it includes all the required data for your state, then export the caregiver again. If needed, re-export any billed visits the caregiver had completed either by moving invoices to draft and then back to completed, OR by exporting from the Visit Approval Dashboard manually. (Filtering for the employee on the Visit Approval Dashboard, selecting all visits, and then clicking Export is usually the fastest way to export for employees.)
The VisitChanges segment cannot be empty when Call Type is Manual. The record is being rejected.A visit was completed manually but was not managed as a manual visit. (This visit was not reason coded even though it had an issue with EVV. In states where action codes are also needed, you need to add an action code as well.)Code the visit appropriately and re-send the visit. This will ensure that the changemadeby, changedatetime, reasoncode, and changereasonmemo (visitchanges segment) fields are supplied to Sandata.
Client not foundThe client's file did not successfully transfer.Update your client profile so that it includes all the required data for your state, then re-export the client. If needed, re-export any invoiced visits the client had completed by moving invoices to draft and then back to completed, OR by exporting from the Visit Approval Dashboard manually.
The EmployeeIdentifier format is incorrect.The FCSR ID is missing/wrong.Correct the missing/wrong FCSR ID (the most common error is entering the longer confirmation code, as opposed to the 8-digit actual FCSR ID), then export the caregiver again. If needed, re-export any billed visits the caregiver had completed by moving invoices to draft and then back to completed, OR by exporting from the Visit Approval Dashboard manually.
The ClientCity format is incorrect.The client's city is incorrectly formatted.Correct the client's city, then re-export the client. If needed, re-export any invoiced visits the client had completed by moving invoices to draft and then back to completed, OR by exporting from the Visit Approval Dashboard manually.
Client Not Found. Clients must have been previously received from Payer to be updated via Alt-EVV.The client profile is not found in the database for this payer, such as Medicaid.In most states, the client's name, Medicaid ID, and DOB are used to match clients against a database. First, check to make sure all of that data is correct and exactly matches the client's authorization. Second, make sure the client truly is assigned to this payer, and not accidentally a private pay client scheduled to Medicaid visit types, for example. If the data for the client is correct and the payer is also correct, then you should check in with the payer to see why this client is not on file with the payer.
The ChangeMadeBy value is incorrectMissing email addressCheck company email address in Organization Detail and staff/admin email address in profile and confirm they are valid. Please re-export once resolved, either by moving invoices to draft and then back to completed, OR by exporting from the Visit Approval Dashboard manually.
Error during retrieving service_id enteredWrong HCPCS code (wrong visit type)Confirm the correct visit type was scheduled for the client. If it appears correct, double check the authorization. Adjust as needed and re-send the visit. (NOTE: in 2025, Massachusetts retracted requirements for data delivery of many visit types depending on program/payer/visit type combination. If you previously sent visit types that are now being rejected with this warning, contact Support.)
The ClientIdentifierOnCall cannot be nullWrong/missing Medicaid IDConfirm the Medicaid ID is not wrong/missing. Correct if needed; re-export the client and then export the visits from the Visit Approval Dashboard.
Cannot handle import due to \u0027Fail to save data due to \u0027comThere was an error in data being sentRe-export the visit to resolve this issue. This should not occur often. Reach out to Ankota Support if this continues to happen.
Account InactiveThe account was suspended due to inactivityReach out to Sandata support to get the account activated. Once activated, export the caregiver/client and visits.
The request was cancelled due to the configured HttpClientThe connection between Ankota and Sandata timed out before Sandata returned a response. Common causes include: Sandata was responding slowly or experiencing heavy traffic. A temporary network or internet connectivity issue occurred. The request contained a large amount of data and exceeded the allowed timeout period. A temporary outage or performance issue on either the sender's side or Sandata's side.Re-export the visit to resolve this issue. This should not occur often. Reach out to Sandata Support if this continues to happen.

If a rejection reason not on this list is received, reach out to an Ankota specialist for more information.

Other

Essential Transportation / Essential Errand / Shopping

For transport care plan items, Ankota users have the option to turn on an Ankota warning, "Visit with Essential Transportation or Errands at Arrival or Departure not at Client Location." This feature requires configuration and is typically used only with Missouri Sandata visits. Generally, filter for visits with the Errands warning and manage them BEFORE using the Approval Assistant. This is the only exception to the general "Use the Approval Assistant first" guideline.

This warning works as follows:

  • Request the function be turned on

  • Define a maximum distance allowed for transport care plan items

  • This warning will only be applied to visits where Essential Transportation, Essential Errand, or Shopping is a care plan item on the visit

  • The visit will be flagged in Ankota when it is outside the geofence (typically 0.1 miles) but under the maximum for transportation (typically 25 miles) — COMING SOON

  • After the visit is flagged in Ankota, users can quickly use the Approval Assistant to code the visit appropriately so that visits outside the visit location can be reason coded and exported

  • Alternately, users can filter for the warning and then review the visits individually for coding and approval

The Visit Approval Dashboard page displays filtering options for clients, caregivers, review status, and approval type, with date range selectors and a dropdown menu showing visit arrival method options including "Visit with Essential Transportation or Errands at Arrival or Departure Not at Client Location." Action buttons for "Run Rules," "View Report," and "Tag Filters" are visible at the bottom right.

Was this article helpful?
On this page