Bed Census Data Processing Instructions: Difference between revisions
No edit summary |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (10 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
Also know as '''whiteboard'''. | Also know as '''whiteboard'''. Data source from: https://whiteboard.manitoba-ehealth.ca/whiteboard/icu | ||
{{LegacyContent | |||
|explanation=discontinued 024-12-06 | |||
|successor=[https://app.powerbi.com/groups/me/reports/04765326-f623-4f95-a53c-9980d06915e3/ReportSectionaf3d8f1fd8def596e09a?experience=power-bi Provincial Capacity Management Dashboard] | |||
|content= | |||
==Program== | ==Program== | ||
| Line 7: | Line 12: | ||
==Start Date== | ==Start Date== | ||
May 3, 2012 | May 3, 2012 | ||
== End Date == | |||
*Jan 5, 2025 - HSC clerk last date of entry in the Whiteboard. | |||
*Jan 6, 2025 - the Provincial Dashboard start date | |||
*Dec 16, 2024 - last date of update in the '''WRHA Critical Care Daily Bed Census-Ver2020.mdb''' | |||
==What is the purpose of processing the bed census data?== | ==What is the purpose of processing the bed census data?== | ||
The downloaded data from the Bed census Website contain one or more data collection times in a day for each unit. Only one daily data is needed in the Bed census database and the time that was agreed upon is 2:00 p.m.. The individual site ICUs are asked to submit and fax their bed census data at 2:00 am and 2:00 pm and every time there is a change in bed census. However upon receipt of the faxed forms, it takes some time for the HSC clerk to enter the faxed information. So in order to capture the 2:00 pm data, the data before and closest to 3:00 pm is extracted from the downloaded data. | The downloaded data from the Bed census Website contain one or more data collection times in a day for each unit. Only one daily data is needed in the Bed census database and the time that was agreed upon is 2:00 p.m.. The individual site ICUs are asked to submit and fax their bed census data at 2:00 am and 2:00 pm and every time there is a change in bed census. However upon receipt of the faxed forms, it takes some time for the HSC clerk to enter the faxed information. So in order to capture the 2:00 pm data, the data before and closest to 3:00 pm is extracted from the downloaded data. | ||
*Data includes Total Open Staffed Bed, Ventilated and Non-ventilated patients, Empty beds, Off-unit and Off-service patients, Pending Admissions and Transferable Patients. | |||
*Open Beds data are being used by the [[Statistician]] in some indicators of the [[Critical_Care_Program_Quality_Indicator_Report]]. | |||
*Critical Care Directors also use some of these data for administrative purposes. | |||
==Data Processing -New Instructions== | ==Data Processing - New Instructions== | ||
# The HSC_MICU clerk disposed the forms as confidential waste. | # The HSC_MICU clerk disposed the forms as confidential waste. | ||
#'''Exports (downloads)''' all entered data once per week; | #'''Exports (downloads)''' all entered data once per week; | ||
#*FROM: http:\\forms.manitoba-ehealth.ca/ccwhiteboard/secure/admin.php, (Site is password protected). | #*FROM: http:\\forms.manitoba-ehealth.ca/ccwhiteboard/secure/admin.php, (Site is password protected). | ||
#*TO: | #*TO: S:\Critical_Care\Patient_DB_Reports\Bed_Census\Whiteboard\'''ICUBedsCensusHistory.xls''' | ||
#'''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. | #'''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 | #*in SAS - OPEN PROGAM | ||
#*go to: S:\ | #*go to: S:\Critical_Care\Patient_DB_Reports\Bed_Census\Whiteboard\'''whiteboard_version2020.sas''' | ||
#*OPEN | #*OPEN | ||
#*change the earliest and inclusive dates in the SAS script to date you last exported and up to the day you did export | #*change the earliest and inclusive dates in the SAS script to date you last exported and up to the day you did export | ||
| Line 25: | Line 38: | ||
#*CLOSE | #*CLOSE | ||
#*The SAS program will export an excel file labeled '''whiteboard.xlsx''' | #*The SAS program will export an excel file labeled '''whiteboard.xlsx''' | ||
#Go to: S:\ | #Go to: S:\Critical_Care\Patient_DB_Reports\Bed_Census\Whiteboard\'''whiteboard.xlsx''' | ||
#'''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:\ | #'''uploads (imports)''' the '''whiteboard.xlsx''' from "S:\Critical_Care\Patient_DB_Reports\Bed_Census\Whiteboard" to S:\Critical_Care\Patient_DB_Reports\Bed_Census into an access database. | ||
#*Copy the '''WRHA Critical Care Daily Bed Census-Ver2020.mdb''' from folder S:\Critical_Care\Patient_DB_Reports\Bed_Census to your '''desktop''' | #*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''' | ||
| Line 48: | Line 61: | ||
[[Category: Bed Census Project]] | [[Category:Bed Census Project]] | ||
}} | |||