Bed Census Data Processing Instructions: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
PTorres (talk | contribs)
CCMDB_legit, approved
1,617 edits
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
Line 43: Line 43:


*{{Discussion}}
*{{Discussion}}
Where to find it?
which server?
* copy the database back up to the server
* copy the database back up to the server


Revision as of 15:37, 1 November 2018

Also know as whiteboard

Program

Critical Care in WRHA

Start Date

May 3, 2012

Data Processing -New Instructions

  • is this the current process, or is Bed_census.mdb? I think the process is better off here than in the .mdb article.
  • SMW


  • Cargo


  • Categories
  1. Goes to the HSC_MICU and picks up the bed census faxed sheets every Tuesday and Friday. (clerk leave it in a slot by fax machine.
  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\icuDSS.csv
  3. Opens SAS 9.2 (program written by 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
    • go to: x\\med_ccmed\Pagasa\whiteboard\whitboard.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
  4. Go to: x\\med_ccmed\Pagasa\whiteboard\whitboard.xls
  5. Manually checks whiteboard.xls.
  6. uploads (imports) the whitboard.xlsfrom "X" to sharepoint on W:\\med_cc_admin3 on...... into an access database. This is also known as Randy Martens bed census assess database.
    • go to Med_CC_admin3 on ....
    • go to folder\Bed_Census\WRHA Critical Care Daily Bed Census-Ver4.mdb
    • OPEN
    • Check to ensure last date of import where you left off
    • FILE
    • GET EXTERNAL Data x:\Pagasa\Whiteboard\Whitelboard.xls
    • IMPORT
    • SAVE
  • probably incomplete... Ttenbergen 18:17, 2016 April 14 (CDT) emailed Trish/PAgasa Ttenbergen 16:46, 2018 October 30 (CDT)
  • SMW


  • Cargo


  • Categories

...

Bed census.mdb Queries


which server?

  • copy the database back up to the server

Legacy Processing Instructions Bed census.mdb

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Bed_Census_Data_Processing_Instructions&oldid=123706"