Bed census.mdb: Difference between revisions

(6 intermediate revisions by 2 users not shown)

Line 1:

WRHA Regional Daily ICU Bed census (White Board)

{{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=

WRHA Regional Daily ICU Bed census (White Board) has '''stopped''' and has been replaced by the [https://app.powerbi.com/groups/me/reports/04765326-f623-4f95-a53c-9980d06915e3/ReportSectionaf3d8f1fd8def596e09a?experience=power-bi Provincial Capacity Management Dashboard] starting '''January 6, 2025'''

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.

Line 27:

Line 31:

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]]

== Request for Data Sharing with MCHP ==

In June 5, 2024, the first request for sharing the WRHA Critical Care Daily Bed Census with MCHP has been approved by the Critical Care Director, [[Dr. Boyan Paunovic]] to be used for a project titled “Post-Tracheostomy Outcomes in Mechanically Ventilated ICU Patients: A Retrospective Cohort Study” by the principal investigator, Dr. Kristen Gray of the Anesthesiology Residency program in the Max Rady College of Medicine at the University. The data will aid in assessing ICU structure-/process-level factors related to ICU capacity strain and outcomes.

=== Generating the access file ===

The [[Statistician]] made a copy of the Bed Census table by exporting it from the master database and importing it to another database labeled CCBedCensus.accdb. The new data table is labeled BedCensus_MCHP. Then it was zip and password protected (same password has been used as in the [[MCHP Export.accdb]] for consistency). Also copies of the [[Bed Census]] Forms containing the definitions of the data fields are also included in the zipped file. There is no patient identifier in the data file.

=== Sending ===

*The sending followed the same process as in the [[MCHP Export.accdb]]. The password protected CCBedCensus zipped file is sent via MCHP sFTP server. Julie has been given a temporary account by Rod McRae, IManager, Manitoba Centre for Health Policy.

**go to https://collab.mchp.ca/sites/sft. Enter the provided username and password by MCHP (see Passwords_MainOffice). Double click document CriticalCare_Medicine. Drag the zipped file to upload or choose the file to start uploading. logout.

*email the password to Dave Towns (Dave_Towns@cpe.umanitoba.ca).

===Legacy ===

[[p:Randy Martens]]

Line 47:

Line 60:

[[Category: Data Repository]]

[[Category:Data Repository]]

[[Category: Bed Census Project]]

[[Category:Bed Census Project]]

}}

@@ Line 1: / Line 1: @@
-WRHA Regional Daily ICU Bed census (White Board)
+{{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=
+WRHA Regional Daily ICU Bed census (White Board) has '''stopped'''  and has been replaced by the [https://app.powerbi.com/groups/me/reports/04765326-f623-4f95-a53c-9980d06915e3/ReportSectionaf3d8f1fd8def596e09a?experience=power-bi Provincial  Capacity Management Dashboard] starting '''January 6, 2025'''
 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.
@@ Line 27: / Line 31: @@
 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]]
+== Request for Data Sharing with MCHP ==
+In June 5, 2024, the first request for sharing the WRHA Critical Care Daily Bed Census with MCHP has been approved by the Critical Care Director, [[Dr. Boyan Paunovic]] to be used for a project titled “Post-Tracheostomy Outcomes in Mechanically Ventilated ICU Patients: A Retrospective Cohort Study” by the principal investigator, Dr. Kristen Gray of the Anesthesiology Residency program in the Max Rady College of Medicine at the University. The data will aid in assessing ICU structure-/process-level factors related to ICU capacity strain and outcomes.
+=== Generating the access file ===
+The [[Statistician]] made a copy of the Bed Census table by exporting it from the master database and importing it to another database   labeled CCBedCensus.accdb. The new data table is labeled BedCensus_MCHP.  Then it was zip and password protected (same password has been used as in the [[MCHP Export.accdb]] for consistency).  Also copies of the [[Bed Census]] Forms containing the definitions of the data fields are also included in the zipped file. There is no patient identifier in the data file.
+=== Sending ===
+*The sending followed the same process as in the [[MCHP Export.accdb]]. The password protected CCBedCensus zipped file is sent via MCHP sFTP server. Julie has been given a temporary account by Rod McRae, IManager, Manitoba Centre for Health Policy.
+**go to https://collab.mchp.ca/sites/sft. Enter the provided username and password by MCHP (see Passwords_MainOffice). Double click document CriticalCare_Medicine. Drag the zipped file to upload or choose the file to start uploading. logout.
+*email the password to Dave Towns (Dave_Towns@cpe.umanitoba.ca).
 ===Legacy ===
 [[p:Randy Martens]]
@@ Line 47: / Line 60: @@
-[[Category: Data Repository]]
+[[Category:Data Repository]]
-[[Category: Bed Census Project]]
+[[Category:Bed Census Project]]
+}}