Bed Census Data Processing Instructions: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 4: Line 4:
==Data Processing -New Instructions==
==Data Processing -New Instructions==
#Picks up bed census faxed sheets from the HSC-MICU each Tuesday and Friday. (clerk leave it in a slot by fax machine.
#Picks up bed census faxed sheets from the HSC-MICU each Tuesday and Friday. (clerk leave it in a slot by fax machine.
#Exports (downloads) all entered data;  
#Exports (downloads) all entered data twice per week;  
#*FROM:  http:\\forms.manitoba-ehealth.ca/ccwhiteboard/secure/admin.php, (only the scanner computer has access this site our office. Site is password protected).  
#*FROM:  http:\\forms.manitoba-ehealth.ca/ccwhiteboard/secure/admin.php, (only the scanner computer has access this site our office. Site is password protected).  
#*TO:  x\\med_ccmed\Pagasa\whiteboard\icuDSS.csv
#*TO:  x\\med_ccmed\Pagasa\whiteboard\'''icuDSS.csv'''
#Opens SAS 9.2 (program written by [[User: JMojica | Jmojica]] to sort export. Sorted to include bed count closes to before 1500 hrs each days and also for those dates where there was no bed change (IICU) reuse the be count from the previous day closest to before 1500 hrs.   
#Opens SAS 9.2 (program written by [[User: JMojica | Jmojica]] to sort export. Sorted to include bed count closes to before 1500 hrs each days and also for those dates where there was no bed change (IICU) reuse the be count from the previous day closest to before 1500 hrs.   
#*in SAS - open program
#*in SAS - open program
#*go to: x\\med_ccmed\Pagasa\whiteboard\whitboard.sas
#*go to: x\\med_ccmed\Pagasa\whiteboard\'''whitboard.sas'''
#*OPEN
#*OPEN
#*change date in SAS script to date you last exported and up to the day you did export
#*change the earliest and inclusive dates in the SAS script to date you last exported and up to the day you did export
#*RUN
#*RUN
#*SAVE
#*SAVE
#*CLOSE
#*CLOSE
#Go to: x\\med_ccmed\Pagasa\whiteboard\whitboard.xls
#Go to: x\\med_ccmed\Pagasa\whiteboard\'''whitboard.xls'''
#*OPEN & PRINT
#*OPEN & PRINTS out XLS spreadsheet
#Checks Bed census Whiteboard for entry errors from forms.  
#Checks whiteboard.xls for entry errors against the faxed bed census forms.  
#makes correction to the electronic bed census white board.  If not clear, checks with [[Statistician]].
#makes corrections in the whiteboard.xls and also marks changes in green pen on both on the printed out XLS spreadsheet and the faxed bed census form.  If not clear, checks with [[Statistician]].
#exports data from white board location twice week to share point on W as a census.mdb
#uploads (imports) the '''whitboard.xls'''from "X" to sharepoint on W:\\med_cc_admin3 on...... into an access database.  This is also known as Randy Martens bed census assess database.
#*Steps for export
#*go to Med_CC_admin3 on ....
 
#*go to folder\Bed_Census\WRHA Critical Care Daily Bed Census-Ver4.mdb
 
#*OPEN
#*Check to ensure last date of import where you left off
#*FILE
#*GET EXTERNAL Data x:\Pagasa\Whiteboard\Whitelboard.xls
#*Import


== [[Legacy Processing Instructions Bed census.mdb]] ==
== [[Legacy Processing Instructions Bed census.mdb]] ==

Revision as of 18:31, 2012 October 1

Start Date

May 3, 2012

Data Processing -New Instructions

  1. Picks up bed census faxed sheets from the HSC-MICU each Tuesday and Friday. (clerk leave it in a slot by fax machine.
  2. Exports (downloads) all entered data twice per week;
    • FROM: http:\\forms.manitoba-ehealth.ca/ccwhiteboard/secure/admin.php, (only the scanner computer has access this site our office. Site is password protected).
    • TO: x\\med_ccmed\Pagasa\whiteboard\icuDSS.csv
  3. Opens SAS 9.2 (program written by Jmojica to sort export. Sorted to include bed count closes to before 1500 hrs each days and also for those dates where there was no bed change (IICU) reuse the be count from the previous day closest to before 1500 hrs.
    • in SAS - open program
    • go to: x\\med_ccmed\Pagasa\whiteboard\whitboard.sas
    • OPEN
    • change the earliest and inclusive dates in the SAS script to date you last exported and up to the day you did export
    • RUN
    • SAVE
    • CLOSE
  4. Go to: x\\med_ccmed\Pagasa\whiteboard\whitboard.xls
    • OPEN & PRINTS out XLS spreadsheet
  5. Checks whiteboard.xls for entry errors against the faxed bed census forms.
  6. makes corrections in the whiteboard.xls and also marks changes in green pen on both on the printed out XLS spreadsheet and the faxed bed census form. If not clear, checks with Statistician.
  7. uploads (imports) the whitboard.xlsfrom "X" to sharepoint on W:\\med_cc_admin3 on...... into an access database. This is also known as Randy Martens bed census assess database.
    • go to Med_CC_admin3 on ....
    • go to folder\Bed_Census\WRHA Critical Care Daily Bed Census-Ver4.mdb
    • OPEN
    • Check to ensure last date of import where you left off
    • FILE
    • GET EXTERNAL Data x:\Pagasa\Whiteboard\Whitelboard.xls
    • Import

Legacy Processing Instructions Bed census.mdb

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Bed_Census_Data_Processing_Instructions&oldid=28780"