Michael Sainlaire, MS
Department of Medicine
Division of General Internal Medicine and Primary Care
Poster Overview

The number of hip and Knee replacement surgeries is growing every year. Hospitals must follow opioids use after THA/TKA to reduce opioid addiction. With the inputs of surgeons, we developed a report. It reviewed the length of opioid prescriptions. Any surgeon can run the report. It will be in Epic. It will allow surgeons to compare their performance to that of the hospital. Patients’ information will be at hand in the report to act on. Any healthcare system using Epic can run the report. We will continue to refine the report. It will help promote the safe use of opioid after hip or knee replacement. Thus, it will help check the conduct of physicians prescribing opioid.

Scientific Abstract

We queried our Epic Clarity database for patients with primary THR and TKR. We reviewed their chart for opioid prescription from discharge through 90 days. We probed the data for patients with total opioid prescriptions for greater than or equal to 15 days . We flagged those with prescriptions for greater than 42 days. In the process, we created a stored procedure that can be run in any healthcare system that uses an Epic EHR. The data is grouped by hospital and by surgeon to calculate their respective opioid prescription rate for a given period.


We developed a Crystal Report to present the data coming from the stored procedure. The report will be inserted into Epic Hyperspace. It will be available to any surgeon to run anytime to see his or her opioid prescribing rate compared to that of his or her peers. The report will be continually refined to ensure that it can be used to monitor patients opioid use. It can be used to check physicians prescribing patterns. It will offer important clinical information that physicians can act upon to improve the care of their patients

Clinical Implications
Managing postoperative pain following Total Hip Replacement and Total Knee Replacement using opioid can be prolonged and often underreported. To facilitate local quality improvement, we developed a crystal report.
Research Areas
Michael Sainlaire
Principal Investigator
David W. Bates, MD

Explore Other Posters

One reply on “Michael Sainlaire, MS”

Is the data generated for your crystal report specifically tied to Epic Clarity database for query info? aka, is your query engine, search algorithm works with database from other EMRs?
Do you have a published paper on your finding for the content of this poster session? If you have, can I have a pdf version of it?
Thanks in advance

Comments are closed.