Pharmacy Collection HSC
LEGACY only, see L_Pharm_Flowsheet and Category:Pharmacy
HSC pharmacy in HSC-H7 used to extract pharmacy data for admissions up to August 31.12.
The Data collector at HSC started collecting pharmacy on January 1, 2012. Go to Drugs Collected for list or to Pharmacy to find latest list.
At HSC, pharmacy data was 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 L Pharm Flowsheet.
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 (H7) have participated in this part of the collection process from mid 1988 to all admissions up to August 31, 2012. As of January 1, 2012, the data collection staff at HSC started collection drugs dispensed to patients. Go to: Drugs Collected for current list all sites collecting.
Requesting of HSC Pharmacy Data
- HSC pharmacy requests a patient TMSX Registry log (Logprnt.exe) Program list from Pagasa or Trish when ever they are ready to look up the pharmacy records.
- Registry Log (Logprnt.exe) Program 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.
- once their collection of pharmacy items is complete they drop the 2MASTER PHARM C HSC Lists off in the data processing office.
Entering of HSC Pharmacy Data
- Make the secondary PC Pharmacy.dat the Master.
- Run this batch file: CC Pharm from scanner.bat
- Secondary PC enters paper pharmacy collection form into TMSX pharm.dat.
- Make main data processing PC Pharmacy.dat Master again.
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:
LEGACY: Stop date: admission to August 31, 2012.-Trish Ostryzniuk 18:53, 2012 October 26 (EDT)
| HSC unit | Date entered up to: |
| MICU | 30-June-2012 |
| SICU | 30-June-2012 |
| IICU | 31-May-2012 |
| CCU | 30-June-2012 |
|
|
PTorres 11:41, 2012 September 13 (CDT)
Pharm Output Errors -Period July 7 to Sept 14.09-CCMDB.mdb output errors
- when new laptop (netbook) version of Access CCMDB.mdb was rolled out and first sending starting July 7.09, specified pharmacy items that should have been divided by base amount before output had not programmed into this version of AccessCCMDB.mdb. 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. This error occurred during period when collection staff were on short noticed, redeployed to bedside for H1N1 and coincided with the roll out of a new version of ccmdb.mdb. Every drug item that have been affected have been Id'd a fixed up as of Jan 20.10 as per Julie excellent worksheet that help us conquer the problem.--TOstryzniuk 12:55, 15 October 2009 (CDT)
| Site & Unit | Date Pharmacy fixed | # of hours to complete task | Initials |
| STB_CICU | 21-Dec-2009 | 4 | Srusnak |
| STB_MICU | 20_Jan-2010 | ||
| STB_CCU | " | ||
| CON_STB | " | ||
| VIC_ICU | " | ||
| OAK_ICU | " | ||
| GRA_ICU | " | ||
| TOTAL | " | 6 | Srusnak
|