Bed Census Data Processing Instructions: Difference between revisions
| Line 28: | Line 28: | ||
#'''Manually checks''' whiteboard.xlsx if the dates specified for each unit are complete. | #'''Manually checks''' whiteboard.xlsx if the dates specified for each unit are complete. | ||
#'''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. | #'''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. | ||
#* | #*Copy the '''WRHA Critical Care Daily Bed Census-Ver2020.mdb''' from folder S:\Critical_Care\Patient_DB_Reports\Bed_Census to your destop | ||
#*OPEN '''WRHA Critical Care Daily Bed Census-Ver2020.mdb''' | #*OPEN '''WRHA Critical Care Daily Bed Census-Ver2020.mdb''' | ||
#*Check to ensure last date of import where you left off | #*Check to ensure last date of import where you left off | ||
| Line 36: | Line 36: | ||
#*SAVE | #*SAVE | ||
#*check if the last date in the mdb is correct. | #*check if the last date in the mdb is correct. | ||
#* Copy back the updated '''WRHA Critical Care Daily Bed Census-Ver2020.mdb''' to folder S:\Critical_Care\Patient_DB_Reports\Bed_Census | |||
... | ... | ||
* [[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. | * [[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. | ||