Bed Census Data Processing Instructions: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 16: Line 16:
#*FROM:  http:\\forms.manitoba-ehealth.ca/ccwhiteboard/secure/admin.php, (only the scanner computer has access this site our office. Site is password protected).  
#*FROM:  http:\\forms.manitoba-ehealth.ca/ccwhiteboard/secure/admin.php, (only the scanner computer has access this site our office. Site is password protected).  
#*TO:  x\\med_ccmed\Pagasa\whiteboard\'''ICUBedsCensusHistory.xls'''
#*TO:  x\\med_ccmed\Pagasa\whiteboard\'''ICUBedsCensusHistory.xls'''
#'''Opens SAS 9.4''' (program written by [[User: JMojica | Jmojica]] to sort 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:\MED\MED_CCMED\PAGASA\Whiteboard\'''whiteboard_version2020.sas'''
#*go to: S:\MED\MED_CCMED\PAGASA\Whiteboard\'''whiteboard_version2020.sas'''
Line 27: Line 27:
#Go to: S:\MED\MED_CCMED\PAGASA\Whiteboard\'''whiteboard.xlsx'''
#Go to: S:\MED\MED_CCMED\PAGASA\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.xlss'''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.  
#*go to folder S:\Critical_Care\Patient_DB_Reports\Bed_Census
#*go to folder S:\Critical_Care\Patient_DB_Reports\Bed_Census
#*OPEN '''WRHA Critical Care Daily Bed Census-Ver2020.mdb'''
#*OPEN '''WRHA Critical Care Daily Bed Census-Ver2020.mdb'''
Line 35: Line 35:
#*IMPORT
#*IMPORT
#*SAVE
#*SAVE
#*check if the last date in the mdb is correct.
...
...
* [[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.

Revision as of 10:32, 2021 July 5

Also know as whiteboard

Program

Critical Care in WRHA

  • Person Responsible: The [Statistician] of the Critical Care Database

Start Date

May 3, 2012

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.

Data Processing -New Instructions

  1. Goes to the HSC_MICU and picks up the bed census faxed sheets minimally every Tuesday and Friday. (clerk leaves it in a slot by fax machine). Due to COVID, the HSC_MICU clerk bring the forms to JJ387 inbox.
  2. Exports (downloads) all entered data once per week;
    • FROM: http:\\forms.manitoba-ehealth.ca/ccwhiteboard/secure/admin.php, (only the scanner computer has access this site our office. Site is password protected).
    • TO: x\\med_ccmed\Pagasa\whiteboard\ICUBedsCensusHistory.xls
  3. Opens SAS 9.4 (program written by the Statistician 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
    • go to: S:\MED\MED_CCMED\PAGASA\Whiteboard\whiteboard_version2020.sas
    • OPEN
    • change the earliest and inclusive dates in the SAS script to date you last exported and up to the day you did export
    • RUN
    • SAVE
    • CLOSE
    • The SAs program will export an excel file labeled whiteboard.xlsx
  4. Go to: S:\MED\MED_CCMED\PAGASA\Whiteboard\whiteboard.xlsx
  5. Manually checks whiteboard.xlsx if the dates specified for each unit are complete.
  6. 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.
    • go to folder S:\Critical_Care\Patient_DB_Reports\Bed_Census
    • OPEN WRHA Critical Care Daily Bed Census-Ver2020.mdb
    • Check to ensure last date of import where you left off
    • FILE
    • GET EXTERNAL Data S:\MED\MED_CCMED\PAGASA\Whiteboard\Whiteboard.xlsx
    • IMPORT
    • SAVE
    • check if the last date in the mdb is correct.

...

Bed census.mdb Queries

  • most of the Queries in this mdb are made by p:Randy Martens, who is not longer with Program effective July 16, 2020

Legacy Processing Instructions Bed census.mdb