The Pharmacy Data Query report can be used to create a report that might not otherwise be available in the platform. The full data set can be viewed online for downloaded to a spreadsheet or imported to other applications for further data manipulation.
All pharmacy claim detail records are available with both pharmacy data submitted and a number of enriched fields that are created during the load process.
Page filters are used to filter to the desired subset of data. The filters can be used to build a report with the needed parameters. The default screen is shown with no data available. All records can be displayed by not selecting any filters and clicking the “Apply” button.
The data can be viewed in a paged method by using the page controls at the bottom of the report.
Once the desired subset of records is identified, the table can be exported selecting “Export” button. The file will be placed in your “Downloads” folder on your PC. Once the table has been exported (e.g. into Excel) columns can be deleted, and secondary or tertiary sorts, sub totals and grand totals can be applied as desired.