Bed Census Data Processing Instructions: Difference between revisions

Line 16:

#*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\'''ICUBedsCensusHistory.xls'''

#'''Opens SAS 9.4''' (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.4''' (program written by the Statistician [[User: JMojica | Jmojica]] to sort and 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

#*go to: S:\MED\MED_CCMED\PAGASA\Whiteboard\'''whiteboard_version2020.sas'''

Line 27:

#Go to: S:\MED\MED_CCMED\PAGASA\Whiteboard\'''whiteboard.xlsx'''

#'''Manually checks''' whiteboard.xlsx if the dates specified for each unit are complete.

#'''uploads (imports)''' the '''whiteboard.~~xlss~~'''from "S:\MED\MED_CCMED\PAGASA\Whiteboard" to S:\Critical_Care\Patient_DB_Reports\Bed_Census into an access database. This is also known as Randy Martens Daily bed census database.

#'''uploads (imports)''' the '''whiteboard.xlsx''' from "S:\MED\MED_CCMED\PAGASA\Whiteboard" to S:\Critical_Care\Patient_DB_Reports\Bed_Census into an access database. This is also known as Randy Martens Daily bed census database.

#*go to folder S:\Critical_Care\Patient_DB_Reports\Bed_Census

#*OPEN '''WRHA Critical Care Daily Bed Census-Ver2020.mdb'''

Line 35:

#*IMPORT

#*SAVE

#*check if the last date in the mdb is correct.

...

* [[p:Pagasa Torres]] or [[p:Julie Mojica]], do a compact and repair. Must pull it to desktop, do compact repair then copy it back up.

@@ Line 16: / Line 16: @@
 #*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\'''ICUBedsCensusHistory.xls'''
-#'''Opens SAS 9.4''' (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.4''' (program written by the Statistician [[User: JMojica | Jmojica]] to sort and 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
 #*go to: S:\MED\MED_CCMED\PAGASA\Whiteboard\'''whiteboard_version2020.sas'''
@@ Line 27: / Line 27: @@
 #Go to: S:\MED\MED_CCMED\PAGASA\Whiteboard\'''whiteboard.xlsx'''
 #'''Manually checks''' whiteboard.xlsx if the dates specified for each unit are complete.
-#'''uploads (imports)''' the '''whiteboard.xlss'''from "S:\MED\MED_CCMED\PAGASA\Whiteboard" to S:\Critical_Care\Patient_DB_Reports\Bed_Census into an access database.  This is also known as Randy Martens  Daily bed census  database.
+#'''uploads (imports)''' the '''whiteboard.xlsx'''  from "S:\MED\MED_CCMED\PAGASA\Whiteboard" to S:\Critical_Care\Patient_DB_Reports\Bed_Census into an access database.  This is also known as Randy Martens  Daily bed census  database.
 #*go to folder S:\Critical_Care\Patient_DB_Reports\Bed_Census
 #*OPEN '''WRHA Critical Care Daily Bed Census-Ver2020.mdb'''
@@ Line 35: / Line 35: @@
 #*IMPORT
 #*SAVE
+#*check if the last date in the mdb is correct.
 ...
 * [[p:Pagasa Torres]] or [[p:Julie Mojica]], do a compact and repair.  Must pull it to desktop, do compact repair then copy it back up.