CCMDB Wiki

Bed Census Data Processing Instructions: Difference between revisions

← Older editNewer edit →
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,815 edits
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,815 edits
Line 12: Line 12:


==Data Processing -New Instructions==
==Data Processing -New Instructions==
{{Discuss | who = Pagasa |  question = *is this the current process, or is [[Bed_census.mdb]]? I think the process is better off here than in the .mdb article. }}
#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.  
#Goes to the HSC_MICU and picks up the bed census faxed sheets minimally every Tuesday and Friday. (clerk leave it in a slot by fax machine.
#'''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, (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\'''icuDSS.csv'''
#*TO:  x\\med_ccmed\Pagasa\whiteboard\'''ICUBedsCensusHistory.xls'''
#'''Opens SAS 9.2''' (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 [[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.   
#*in SAS - OPEN PROGAM
#*in SAS - OPEN PROGAM
#*go to: x\\med_ccmed\Pagasa\whiteboard\'''whitboard.sas'''
#*go to: S:\MED\MED_CCMED\PAGASA\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 24:
#*SAVE
#*SAVE
#*CLOSE
#*CLOSE
#Go to: x\\med_ccmed\Pagasa\whiteboard\'''whitboard.xls'''
#*The SAs program will export an excel file labeled '''whiteboard.xlsx'''
#'''Manually checks''' whiteboard.xls.  
#Go to: S:\MED\MED_CCMED\PAGASA\Whiteboard\'''whiteboard.xlsx'''
#'''uploads (imports)''' the '''whitboard.xls'''from "X" to sharepoint on W:\\med_cc_admin3 on...... into an access database.  This is also known as Randy Martens bed census assess database.  
#'''Manually checks''' whiteboard.xlsx if the dates specified for each unit are complete.  
#*go to Med_CC_admin3 on ....
#'''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.  
#*go to folder\Bed_Census\'''WRHA Critical Care Daily Bed Census-Ver4.mdb'''
#*go to folder S:\Critical_Care\Patient_DB_Reports\Bed_Census
#*OPEN
#*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
#*FILE
#*FILE
#*GET EXTERNAL Data x:\Pagasa\Whiteboard\Whitelboard.xls
#*GET EXTERNAL Data S:\MED\MED_CCMED\PAGASA\Whiteboard\Whiteboard.xlsx
#*IMPORT
#*IMPORT
#*SAVE
#*SAVE
{{Discuss | who = Pagasa |  question = * probably incomplete... Ttenbergen 18:17, 2016 April 14 (CDT) emailed Trish/PAgasa Ttenbergen 16:46, 2018 October 30 (CDT)}}
...
...
* [[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.
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Bed_Census_Data_Processing_Instructions"