Pharmacy collection

The Critical Care Database collects Drugs Collected for critical care patients. The Medicine Program does not collect any pharmacy information.

How to enter the data

In the Patient viewer, go to the Pharm_Flow tab. Enter the number of days for which a drug was given (not collecting doses any longer).

You don't need to list entries for a given day, the lines are there only allow you to break down your work if a patient stays for a long time. Values entered over multiple lines will be added up before sending; a listing for the sum wasn't included due to space restrictions.

Be sure to collect all intravenous and oral preparations for each drug unless otherwise noted. For example, if it only calls for intravenous infusion of opioids or lasix, etc. If a patient is on a combination of oral and intravenous for the same drug, only count the drug once per day regardless of administration route.

Only count the drugs specifically listed on the laptops (also listed on the wiki list). If 2 drugs are in the same category, only count one day for each category (don't double count).

Data Entry Hints

• double-click into a cell to up it by 1 (or in case of 0/1 drugs, to toggle between 0 and 1
• hover over a cell to get a popup with the drugs that are part of any of the groups we collect
• Today's date automatically is put into the line when you enter a new line. This also helps to keep track of when you last counted drugs.
• For the blue colored drugs you only need to put a "1" in the box (or double-click the box) if it ever was used during the patient stay. If it is left blank it means it was not used. We do not need the number of days for these specific drugs.

Data Collection Hints

• When reviewing the MAR for all drugs or flow sheets for infusions you may find it helpful to make a pencil mark after the drugs you have counted up to so that when you look at it again, the same drugs are not duplicate counted.

TISS / Pharm correlation

The following items on your pharmacy form should be confirmed against the corresponding items on the TISS:

• vasoactive drugs, heparin, antiarrythmic marked in your history notes and pharmacy form (Tiss items 67, 68& 69 )
• check that TISS # 76 or 77 is marked against the antibiotics on the MAR
• check that Tiss 71 is marked when pt had potassium via central line;
• check #70 is marked if patient is on Vasopressin.

Template:Data Integrity Rules

• each patient has to have at least one line of no entries
• maximum count for any drug must be < LOS+2 if calculated using admit date/time & discharge date/time
  • if excluding the admit & dischargetime in this intergrity check, then (discharge date - admit date) + 1 day.Trish Ostryzniuk 18:38, 2012 June 18 (CDT)

Go here for this discussion: [| update to integrity check]

Dates / Startup / Legacy Info

• for patients admitted started after midnight January 1, 2012 and
• Stop collecting pharmacy the old way at the same time.
• If a profile has some collected by the old method and some by the new method that is OK. Consolidation, if required, will happen behind the scenes.
• For HSC where no manual collection was done prior, the new admissions starting Jan 1, 2012 will have manual pharmacy collection with the new Pharm_Flow sheet.
• As of January 1, 2012 @ 0001 hrs, only the new Pharm Flow sheet for pharmacy will be used.