Extracting claim data

Menu location: Reports menu, Create Reports, Miscellaneous type

Assurance can create data files for use with other systems, including customer-written programs that post data back into HIS systems. The system creates an xml file that includes all claim data, even the status history and payment data. Follow these steps to create a data extract file:

  1. Go to the Reports menu, Create Reports option.
  2. Select the Miscellaneous report type.
  3. Click the DEP format checkbox for the desired data extraction file version.
  4. The system opens the claim filter. Set up the criteria for the claims you want to target.
  5. Click OK to generate the xml file.
  6. Download the finished file from either the home page or View Reports.
Tips
  • If you need data from deleted claims, you must undelete them before you extract the claim data.
  • Use the Status: Local Code or Status: Payer Code options in Claim Filter with range fields to select claims for extraction based on the availability of payer or local status codes.
  • Creating an extract file can be automated. Set up and save a filter to use when generating the report. Set up an auto module that uses the related extract process from the Reports - Miscellaneous list.
  • To locate claims that have been included in an extract file, use Claim Filter. Select Status Codes: Local from the user drop down field, and enter 167 for the code.