This report lets you see all claim statuses that took effect in a given date range you specify. Click here to see how claim status categories are defined.
A sample image of this SQL report run in the Database Viewer is shown below:
- The "amount" is the total amount of the claim. The HL7 category is the claim status -- A1 accepted, etc.
- You must be using a supported clearinghouse.
To highlight and copy the code below to your clipboard, simply click the Copy button.
select * from claim_status where asofdate between :from_date and cast(:to_date as date) + 1