Reports and Metrics

In addition to inventory, pharmacy management and state required reports, vendors may require specialty reporting. These reports may need to be built specifically for the data being captured. System providers and other charity pharmacies using similar systems are two resources to check when developing a new report. Reports exported as excel spreadsheets can be adapted using excel formulas.

Example

Total number of 30-day prescriptions:

Create an excel report that looks at the day supply.

=IF(L6<31,1,IF(L6<61,2,IF(L6<91,3,IF(L6<121,4,IF(L6<151,5,(IF(6<181,6))))))

Number of Unique Patients:

Create an excel report that looks at patient name.

=IF(C6=C7,0,1)

Number of Patient Encounters:

Create an excel report that looks at the patient name and the date the prescription was filled.

=IF(C7=C6,IF(B7=B6,0,1),1)

Dispensary of Hope Link to WebinarsBest Practices in Technology and Pharmacy Software Webinar

Adapting fields within a pharmacy system is an option to create a specific report or a report with additional information. This can be done by adding the following:

  • A prescriber state license number to a pull-able, non-used prescriber field to be used in a report that requires state license but not DEA number. 
  • A pull-able blank patient field populated with the patient Federal Poverty Level (FPL). 

TIP: Good Shepherd Health uses Prosperworksto keep patients informed and expand the practice. Clinical Reporting

Systems such as Outcomes MTMand Mirixaare platforms for collecting and measuring the impact of clinical data and interventions. They allow disease specific medication management, track adherence, or if additional medication is needed for patient.

RxAssistPlusis a clinic-friendly system adaptable for collecting and reporting many types of clinical data. Patient enrollment criteria can be collected and is useful for demographic reporting, including language, referral source, income compared to FPL, and more.

These systems can track the clinical impact of services on patients served. Outcomes can be measured in severity, type, and number of interventions performed. As well as the total estimated cost avoidance to other healthcare systems (hospitalizations, ED visits, etc.) and total service worth if the services were billable to insurance.

See the chapter on Measurements,Evaluation and Outcomes and Appendices\Metrics for more reports and how they can be used. Implementation of performance metrics to assess pharmacists’ activities in ambulatory care clinicspresents measurable pharmacist functions that impact patient outcomes and mechanisms used to document these services.