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 | #*Copy the '''WRHA Critical Care Daily Bed Census-Ver2020.mdb''' from folder S:\Critical_Care\Patient_DB_Reports\Bed_Census to your '''desktop''' | ||
#*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''' from your desktop to folder S:\Critical_Care\Patient_DB_Reports\Bed_Census | #* Copy back the updated '''WRHA Critical Care Daily Bed Census-Ver2020.mdb''' from your '''desktop''' to folder S:\Critical_Care\Patient_DB_Reports\Bed_Census | ||
#* The Master database is on folder S:\Critical_Care\Patient_DB_Reports\Bed_Census | |||
... | ... | ||