Pharmacy Collection HSC

At HSC, pharmacy data is manually collected by the ICU PHARMACY DEPARTMENT.

Note: For information about pharmacy data collection in ALL OTHER ICU's ( STB,GRA,OAK,CON & VIC) in the Region, go to: Pharmacy Collection Other Sites or go directly to S_Drugs for list of drugs that are on the PDA for these sites.

Processing of the Pharmacy Data

The Pharmacy data from HSC ICU is manually entered irregularly into the Critical Care Database by the data processor. Data collectors at HSC do not collect any pharmacy data. The HSC Pharmacy department have participated in this part of the collection process since mid 1988.

Requesting of HSC Pharmacy Data

1. HSC pharmacy requests a patient TMSX registry log list from Pagasa or Trish when ever they are ready to look up the pharmacy records.
   • Registry Log list includes the following: Study, serial, LN, FN, DOB, Chart, Admit date, Admit Time, Discharge date, Discharge Time, unit, (enc) encounter, site, PHIN, Prov, Sex.
2. once their collection of pharmacy items is complete they drop the HSC Pharmacy Collection Forms off in the data processing office.

Entering of HSC Pharmacy Data

1. Make the secondary PC pharmacy.dat the Master.
   • Run this batch file: CC Pharm TO JAN.bat
2. Secondary PC enters paper pharmacy collection form into TMSX pharm.dat.
3. Make main data processing PC pharmacy.dat Master again.
   • CC Pharm FROM JAN.bat

Contact in HSC Pharmacy

• the key contact for HSC pharmacy collection is Russ Rosmus or Al Maronese.
• Historically ICU pharmacy was part of the HSC ICU QA Team when this database program first started at HSC in June 1988.

Pharmacy Manual Data Entry HSC-ICU's -Date completed to:

HSC unit	Date entered up to:
MICU	31-May-2009
SICU	31-May-2009
IICU	31-May-2009
CCU	31-May-2009

• NOTE: Nov IICU still being double checked-entries already done??

April IICU has no Registry Log print out and no study # (not entered yet)

• Srusnak 14:40, 14 Oct 2009 (CDT)

Template:Discussion

July 7 to Sept 14.09

• when new laptop (netbook) version of Access was rolled out and first sending stated July 7.09, specified pharmacy items that should have been divided by base amount before output had not programmed into this version of Access. For example Pharm item 90-Heparin, if given collected as 2 days of 7500 unit per day, this should be output as 3 doses of 5000 not 15000 units. The Heparin error was fixed in the database. The other drug item that have been affected have been Id'd. --TOstryzniuk 12:55, 15 October 2009 (CDT)