Bed Census Data Processing Instructions

May 3, 2012 - Data Processor- 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;
   • 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 date in 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 & PRINT
5. Checks Bed census Whiteboard for entry errors from forms.
6. makes correction to the electronic bed census white board. If not clear, checks with Statistician.
7. exports data from white board location twice week to share point on W as a census.mdb
   • Steps for export