Bed Census Data Processing Instructions: Difference between revisions
TOstryzniuk (talk | contribs) |
TOstryzniuk (talk | contribs) |
||
| Line 7: | Line 7: | ||
#*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 bed 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 bed count from the previous day closest to before 1500 hrs. | ||
#*in SAS - OPEN PROGAM | #*in SAS - OPEN PROGAM | ||
#*go to: x\\med_ccmed\Pagasa\whiteboard\'''whitboard.sas''' | #*go to: x\\med_ccmed\Pagasa\whiteboard\'''whitboard.sas''' | ||
| Line 17: | Line 17: | ||
#Go to: x\\med_ccmed\Pagasa\whiteboard\'''whitboard.xls''' | #Go to: x\\med_ccmed\Pagasa\whiteboard\'''whitboard.xls''' | ||
#*OPEN & PRINTS out XLS spreadsheet | #*OPEN & PRINTS out XLS spreadsheet | ||
# | #'''Manually checks''' whiteboard.xls for entry errors against the faxed bed census forms. | ||
#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]]. | #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]]. | ||
#'''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. | #'''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. | ||