Extracting claim data for Aii
Menu location: Reports menu, Create Reports, Miscellaneous type, Extract Data for Aii
Advanced Inquiry Interface (Aii) is the program that queries Medicare for early adjudication results. Largely replaced by Medicare Direct Entry (MDE).
The Aii data extraction report copies all data from each claim in your working group into an XML file. When the file is downloaded to your local system, local applications use the data to complete their processing. Two major local applications that use DEP data are Custom Extraction and Posting and Advanced Inquiry Interface (Aii). The data extractor creates the XML, but unless you have one of the local applications installed, none of the data is used. If you are interested in using either application, contact Support for more information.
Aii Extract Data works like a report. The result is an XML that contains all the data. Aii Extract Data also adds a status history code (166) to the History tab of each claim. All Data Extraction files display in view reports as extract data.
Follow these steps to create and download the data file:
- From Create Reports on the Reports menu, select the Miscellaneous type.
- Click Aii Extract Data.
- When the success message displays on the Home page, use View Reports on the Reports menu to download the data file to the folder on your system in which Aii expects to find it
- Run a Claim Status Summary report to show a count and amount summary for all the claims in the working group from which data has been extracted.
- You can automate the production of the XML and the summary report by creating auto modules and adding them to an auto list.
- If your site uses the Agent, you can use auto print to automatically download the XML to your local system.
- An XML file that contains a large number of claims is a big file. If downloading these data files takes too long, extract data more frequently on smaller groups of claims or create an auto list to do the extraction and download during off hours.
- You can limit the claims in any working group to claims from which data was extracted. When setting up the filter, select Status: Local Code from the user-selected fields, and enter 166.
- If you use both Custom Extraction and Posting and Aii, then create auto modules for the two kinds of DEP reports. Send them to different folders on your local system as they are created.