Skip to main content

Controlled Substance Report

Controlled substance compliance report

Written by Brian Stone

Controlled substances are recorded when a treatment containing a flagged medication is completed either on the Tx sheet or as a one-off. These medications will also be recorded when added directly to the invoice or are prescribed using the RX mode (in EMR only).

Adding a Product to Controlled Substance Reports

To include a product in Controlled Substance Reports going forward:

  1. Navigate to the product settings in the Admin area of Instinct.

  2. Search for the product you want to include.

  3. Open the product’s edit form.

  4. Toggle on the "Controlled Substance" setting.

  5. Save your changes.

Once marked as a controlled substance, the product will appear in future Controlled Drug Analytics reports.

Note: Changes to the Controlled Substance setting affect only future Controlled Substance Reports and do not update historical data.


Removing a Product from Controlled Substance Reports

To exclude a product from Controlled Substance Reports going forward:

  1. Go to the product settings in the Admin area of Instinct.

  2. Locate the product you want to remove.

  3. Open the product’s edit form.

  4. Toggle off the "Controlled Substance" setting.

  5. Save your changes.

This action will remove the product from future Controlled Drug Analytics reports. Note that this change is managed within Instinct and does not require adjustments in Stockroom.


Instinct Treatment Plan (ITP) Hospitals

Our Controlled Substance Reports can be emailed to your hospital distribution list based on your preferred frequency (daily, weekly, or monthly). Please contact us at [email protected] if you would like to start receiving this report or if you have any questions accessing, adding medications, or removing medications from your report. A few things to keep in mind:

  • If a treatment is completed on the Treatment Sheet and the corresponding invoice line item’s date/time is edited, the report will show the time the treatment was completed from the Tx Sheet.

  • If a controlled substance is added directly to an invoice and the date/time is edited, the report will show the current date/time displaying on the invoice.

  • If a controlled substance is added to the invoice via a prescription and the corresponding invoice line item’s date/time is edited, the report displays the date/time updated on the invoice and not the date it was prescribed.

Note: To learn more about how to access and schedule this report, check out our Analytics Guide.


Report Information Tab

The Report Info tab is the cover page for the report and consists of the Hospital Name and Hospital Location. It will also show what date/time range the report is for, when the report was created, and the time zone for the report.


Glossary Tab

The Glossary tab contains terms and definitions for column headings located throughout the report for clarity.

Terms Listed:

  • Product ID

    Product ID of the controlled substance.

  • Product

    Label name for the controlled substance.

  • Quantity

    Amount of the controlled substance administered or prescribed.

  • Formulation Unit

    Unit of measurement for the controlled substance.

  • Strength

    Strength of the controlled substance administered or prescribed.

  • Strength Unit

    Unit of strength for the controlled substance.

  • Measurement

    Amount of controlled substance recorded from a vitals measurement example: CRI. This will be bland for substances not set up as vitals.

  • Measurement Unit

    Unit of measurement for a controlled substance recorded from a vitals measurement. This will be blank for substances not set up as vitals.

  • Treatment Note

    Note associated with the treatment.

  • Rx Number

    Serial number assigned to the prescription by the pharmacy or dispenser.

  • Refill Number

    Number of the fill of the prescription. 0 indicates a New Rx, 1-99 is the fill number.

  • Refills Authorized

    The number of refills authorized b the prescriber.

  • Days’ Supply

    Estimated number of days the medication will last.

  • Ordered By

    Staff member who ordered the treatment.

  • Ordered At

    The time at which the treatment was ordered.

  • Ordered Note

    Note associated with the order.

  • Edited By

    Staff member who last edited the order.

  • Edited At

    The time at which the order was last edited.

  • Completed By

    Staff member who marked the treatment as complete or added the item to the invoice.

  • Completed At

    Date and time the item was marked as completed or entered directly onto the invoice.

  • Assigned Doctor

    Clinician assigned to the patient at the time the treatment was completed.

  • Patient ID.

    Patient ID who was associated to the controlled substance.

  • Patient Name

    Name of the patient associated with the controlled substance.

  • Patient Sex

    Sex of the patient.

  • Patient Species

    Species of the patient.

  • Account Name

    Name of the primary client animal owner.

  • Account Address

    Address for the primary client animal owner.

  • Account Phone

    Phone for the primary client animal owner.

  • Primary Contact Birth Date

    Where the controlled substance was entered into the software Invoice, Rx, or Tx Sheet.

  • Entered On

    Where the controlled substance was entered into the software Tx Sheet or Invoice.

Note: Controlled substances entered on the anesthesia sheet will be displayed as Tx Sheet.


Controlled Substance List Tab

The Controlled Substance List Tab consists of the following information:

  • Product ID

  • Product

  • Quantity

  • Formulation Unit

  • Strength

  • Strength Unit

  • Measurement

  • Measurement Unit

  • Treatment Note

  • Rx Number

  • Refill Number

  • Refills Authorized

  • Days’ Supply

  • Ordered By

  • Ordered At

  • Order Note

  • Edited By

  • Edited At

  • Completed By

  • Completed At

  • Invoice Closing Date

  • Assigned Doctor

  • Patient ID

  • Patient Name

  • Patient Sex

  • Patient Species

  • Account Name

  • Account Address

  • Account Phone

  • Primary Contact Birth Date

  • Entered On


Frequently asked questions

Can I update historical reports after toggling the "Controlled Substance" setting? No, changes to the "Controlled Substance" setting apply only to future reports and do not affect historical data.

Where do I manage the "Controlled Substance" setting? This setting is managed in the Admin area of Instinct under product settings.


Still need help?

Contact support via live chat or email [email protected].

Did this answer your question?