Page Description

Use the Reimbursement Problem page to view, print, or export a report of each order choice that had an ABN generated for it that was not signed.

The report criteria allow you to show or restrict displayed results according to when the order was placed, collected, or approved; the lab that performed the testing; the ordering practice; the ordering location; the ordering provider; the patient.

Depending on the level of rights assigned to your role, Copia will limit the report to orders for your signed in location, for the locations associated with your practice, or for all locations for all practices within the system.

For more help, click one of the following links:

• Accessing this Page
• Setting the Report Criteria
• Reviewing and Printing the Reimbursement Problem Report
• Exporting the Report

Accessing this Page

• Click the Administration menu button, click the Reports button, and then click the Reimbursement Problem submenu link. You must have the necessary security permissions to access the Administration menu button. In addition, you must have the necessary rights at the practice level to access this report.

• When you click the Administration menu button, Copia opens the main Administration menu, which contains administrative menu buttons, including the Reports menu. To return to the main menu for Copia, click the Lab Tasks menu button.

[Return to Top]

Setting the Report Criteria

1. Enter the desired report criteria for the Reimbursement Problem Report.
   • Order/Collection/Approved Date: Select which type of date to use for the report.
   • Start/End: Enter a Start and End date. Select dates from the calendar view by clicking the calendar icons located next to the Start and End date fields. Copia will only search for orders with unsigned ABNs ordered, collected, or approved within this date span. By default, the date range is set to include only the current date.
   • Lab: Select the Lab that performed the testing from the drop-down list. Copia will only search for orders where the testing was performed at the selected lab. Select "All" to include orders from all lab testing locations.
   • Ordering Practice: Select the practice associated with the ordering location from the drop-down list. Copia will only search for orders that were placed at ordering locations associated with the selected practice. Select "All" to include orders from all practices. Click Search to select the Ordering Practice in the Practice Search page. See the Practice Search topic.
   • Ordering Location: Select the location where the order was collected from the drop-down list. Copia will only search for order choices that were collected from the selected location. Select "All" to include order choices from all collection locations. Click Search to select the collection location in the Location Search page. See the Location Search topic.
   • Ordering Provider: Select the ordering provider for the order from the drop-down list. Click Search to select the Ordering Provider in the User Search page. See the User Search topic.
   • Patient: Type 3 or more characters to search for and then select the patient from the list of users associated with the selected practice.
2. Select the Include Invalid Diagnoses where no diagnosis codes are selected option to include this type of order on the list.
3. Note that it is important to select the appropriate criteria to retrieve your desired orders. Use of multiple criteria could limit the number of possible matches, where use of a single criterion could result in multiple matches and draw an Out of Memory error. If either of these events occurs, reset your filters and click the Refresh button.
4. Enter a value in the Max Results Limit field to set the maximum number of rows of information Copia displays for the report. If it reaches the maximum, then it displays a message that it cannot display the report. By default, Copia displays up to 30,000 results.
5. Select an option from the Report Type drop-down list to determine whether Copia displays the report in HTML format or as a PDF.
6. Once you have the desired settings for the report criteria, click the Refresh button.
7. Copia updates the Report section of the page, and you may then review and print the report. See "Reviewing and Printing the Reimbursement Problem Report" below.

[Return to Top]

Reviewing and Printing the Reimbursement Problem Report

1. Once you have set the criteria and clicked the Refresh button, Copia updates the list in the Report section of the page. See "Setting the Report Criteria" above.
2. Use the scroll bar on the right side of the page to view the details for all of the order choices in the report.
3. To modify the report, adjust the report criteria and click Refresh. See "Setting the Report Criteria" above.
4. Once you have created a report, you may click the Export button to export the current report based on the delimiter chosen and save it to a file where you can open it with an external program (e.g., Notepad or Excel). See "Exporting the Report" below.
5. Click Print to open the standard print dialogs. Change the print settings as desired, and then click Print. Copia will print the report according to the settings you established in the print dialogs (number of copies, printer destination, etc.).

[Return to Top]

Exporting the Report

Note that in order to export data, you must select a delimiter (the default is blank), you must have already created a report (by clicking the Refresh button), and you must not have changed the filter since the last time the report was created. Copia will prompt you to correct any of these problems, if necessary, when you export the report.

1. Once you have created a report (see "Reviewing and Printing the Reimbursement Problem Report" above), you may choose to export the data based on the selected delimiter and save it to a file where you can open it with an external program (e.g., Notepad or Excel).
2. Select an option from the drop-down list of delimiters, located next to the Export button. You may select "Double quotes and comma," "Comma," "Tab," "Vertical bar," or "Semicolon." Copia uses the selected characters or spacing to separate each field of data when exporting the report.
3. Click the Export button to export the current report.
4. After you click Export, Copia displays a dialog that allows you to save the file or cancel the export. By default, Copia names the files "Reimbursement_Problems_," 2 digit year, 2 digit month, 2 digit day, 2 digit hour, 2 digit minute, 2 digit second, followed by the extension ".csv" for "Double quotes and comma" and "Comma" delimiters and ".txt" for "Tab," "Vertical bar," or "Semicolon" delimiters.
5. Note the following when using the export feature:
   • Some of the delimiter types aren't handled automatically by Excel, so, once loaded, select the first column and choose Data > Text to Columns to properly format the data.
   • When exporting to the delimiter type "Comma," Copia removes the commas from the following fields so the data shows up in the proper columns: patient name, ordering provider, order choice, ICD-9, and CPT codes.
   • If you don't change the filename extension ".orchard-csv" to ".csv" when using the "Double quotes and comma" delimiter, it will not open appropriately in Excel, so the column headers will not align properly with the data (in some cases it puts everything off by one column).

[Return to Top]

 © 2018 Orchard Software Corporation