Bed census.mdb

WRHA Regional Daily ICU Bed census (White Board)

The ICU utilizes this process to collaboratively manage all ICU beds in the Region. The Critical Care Finance Director uses the bed census data for administrative purposes.

On May 3, 2012 this process became electronic. See: File:BedCensusAnnouncement Letter May 2012.pdf.

The task of coordinating with ehealth Staff on issues related with the Bed Census website, and maintaining of the Bed census database were assigned by the Critical Care Program Directors to the Statistician of the Critical Care Database.

Bed Census Data Collection Process

HSC MICU Clerk

1. Individual ICU’s in the city must fax forms to HSC MICU when there is a bed change in their unit.
2. The HSC MICU unit clerk manually enters the information directly into:Electronic ICU bed census
3. The HSC-MICU unit clerk updates the electronic "White Board" every time a change of beds form is faxed in from Winnipeg and Brandon ICU .
4. The ICU/Medicine Data Processor picks up the faxed in bed census forms twice a week from the main ICU and being used to confirm if any questionable data will arise.

ICU/Medicine Data Processor

1. The ICU/Medicine Data Processor downloads the data from the Electronic ICU bed census and prepare the data for import to the WRHA Critical Care Daily Bed Census-Version2020.mdb .
2. From the downloaded data, only the record before and closest to 3:00 pm for each date and unit will be selected and uploaded to the bed census database.
   • Go to: Bed Census Data Processing Instructions
3. When the downloaded data is getting bigger, a copy of the last downloaded data is relabeled with time periods and saved in the folder S:\Critical_Care\Patient_DB_Reports\Bed_Census\Legacy_BedCensusData. The Data Processor informs the Statistician who then gets in touch with the ehealth contact staff to tell about changing the start date of the downloaded data into a more recent date.

Location of Bed census data

1. Master: S:\Critical_Care\Patient_DB_Reports\Bed_Census/WRHA Critical Care Daily Bed Census-Version2020.mdb
2. Backup: of bed census.mbd also on Pagasa's C drive.

Who has access to Bed Census shared folder

The staff that have access to the share folder for Bed census.mdb are the Critical Care Directors (Nursing, Medical and Finance), the Critical Care Admin Assistant, p:Julie Mojica, p:Pagasa Torres

Legacy

p:Randy Martens

Bed Census Form

• Grace ICU Form
• HSC MICU.pdf
• HSC IICU.pdf
• HSC SICU.pdf
• Site Bed HSC SICU.pdf

Related articles

Related articles:

Bed occupancy ‎ (← links) White Board (redirect page) ‎ (← links) Changing settings in MS Access after first open ‎ (← links) File share HSC Critical Care ‎ (← links)