|
|
| (69 intermediate revisions by 5 users not shown) |
| Line 1: |
Line 1: |
| At [[:Category:Offices |'''HSC''']], pharmacy data is manually collected by the '''ICU PHARMACY DEPARTMENT'''.
| | '' LEGACY only, see [[:Category:Pharmacy]]. Content deleted so it doesn't show in searches. See history for reference. '' |
|
| |
|
| Note: For information about pharmacy data collection in ALL OTHER ICU's ([[:Category:Offices | 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.
| | [[Category: Legacy Data_Processing]] |
| | | [[Category: Legacy Pharmacy]] |
| | |
| ==Processing of the Pharmacy Data==
| |
| The Pharmacy data from HSC ICU is manually entered '''irregularly''' into the [[TMSX |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===
| |
| #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 [http://ltc.umanitoba.ca/wikis/ccmdb/images/0/0e/2MASTER_PHARM_C_HSC_List_jan_29_07.pdf HSC Pharmacy Collection Form]s 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 TO JAN.bat]]
| |
| #Secondary PC enters paper pharmacy collection form into [[TMSX]] pharm.dat.
| |
| #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: ==
| |
| {| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
| |
| |- style="background-color:#FFFF99;font-size:11pt;font-weight:bold"
| |
| | width="54" height="23" valign="bottom" | HSC unit
| |
| | width="112" align="center" valign="bottom" | Date entered up to:
| |
| | |
| |- style="font-size:11pt"
| |
| |style="color:#800080" height="20" valign="bottom" | '''MICU'''
| |
| | align="right" valign="bottom" | 31-July-2010
| |
| | |
| |- style="font-size:11pt"
| |
| |style="color:#800080" height="20" valign="bottom" | '''SICU'''
| |
| | align="right" valign="bottom" | 31-July-2010
| |
| | |
| |- style="font-size:11pt"
| |
| |style="color:#800080" height="20" valign="bottom" | '''IICU'''
| |
| | align="right" valign="bottom" | 31-July-2010, Mar still has pt in IICU
| |
| | |
| |- style="font-size:11pt"
| |
| |style="color:#800080" height="20" valign="bottom" |''' CCU'''
| |
| | align="right" valign="bottom" | 31-July-2010
| |
| | |
| |}
| |
| | |
| --11:42:, 08 Nov 2010 (CDT)--[[User:Srusnak2|Srusnak2]]
| |
| | |
| ==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 Access[[CCMDB.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.--[[User:TOstryzniuk|TOstryzniuk]] 12:55, 15 October 2009 (CDT)
| |
| | |
| {| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
| |
| |- style="font-size:11pt;font-weight:bold"
| |
| | width="76" height="34" valign="bottom" | Site & Unit
| |
| | width="119" align="center" valign="bottom" | Date Pharmacy fixed
| |
| | width="124" align="center" valign="bottom" | # of hours to complete task
| |
| | width="68" align="center" valign="bottom" | Initials
| |
| | |
| |- style="font-size:11pt"
| |
| |style="color:#0000FF" height="34" valign="bottom" | STB_CICU
| |
| | align="center" valign="bottom" | '''21-Dec-2009'''
| |
| | align="center" valign="bottom" | '''4'''
| |
| |style="color:#800000" align="center" valign="bottom" | [[User:Srusnak|Srusnak]]
| |
| | |
| |- style="font-size:11pt"
| |
| |style="color:#0000FF" height="18" valign="bottom" | STB_MICU
| |
| | align="center" valign="bottom" | '''20_Jan-2010'''
| |
| | align="center" valign="bottom" |
| |
| |style="color:#800000" align="center" valign="bottom" |
| |
| | |
| |- style="font-size:11pt"
| |
| |style="color:#0000FF" height="18" valign="bottom" | STB_CCU
| |
| | align="center" valign="bottom" | "
| |
| | align="center" valign="bottom" |
| |
| |style="color:#800000" align="center" valign="bottom" |
| |
| | |
| |- style="font-size:11pt"
| |
| |style="color:#0000FF" height="18" valign="bottom" | CON_STB
| |
| | align="center" valign="bottom" | "
| |
| | align="center" valign="bottom" |
| |
| |style="color:#800000" align="center" valign="bottom" |
| |
| | |
| |- style="font-size:11pt"
| |
| |style="color:#0000FF" height="18" valign="bottom" | VIC_ICU
| |
| | align="center" valign="bottom" | "
| |
| | align="center" valign="bottom" |
| |
| |style="color:#800000" align="center" valign="bottom" |
| |
| | |
| |- style="font-size:11pt"
| |
| |style="color:#0000FF" height="18" valign="bottom" | OAK_ICU
| |
| | align="center" valign="bottom" | "
| |
| | align="center" valign="bottom" |
| |
| |style="color:#800000" align="center" valign="bottom" |
| |
| | |
| |- style="font-size:11pt"
| |
| |style="color:#0000FF" height="18" valign="bottom" | GRA_ICU
| |
| | align="center" valign="bottom" | "
| |
| | align="center" valign="bottom" |
| |
| |style="color:#800000" align="center" valign="bottom" |
| |
| | |
| |- style="font-size:11pt"
| |
| |style="color:#0000FF" height="18" valign="bottom" | TOTAL
| |
| | align="center" valign="bottom" | "
| |
| | align="center" valign="bottom" | 6
| |
| |style="color:#800000" align="center" valign="bottom" | [[User:Srusnak|Srusnak]]
| |
| '''
| |
| |}
| |
| | |
| | |
| | |
| | |
| | |
| [[Category:Data Sources]]
| |
| [[Category:Data_Processing]] | |
| [[Category: Pharmacy]] | |