Bed Census Data Processing Instructions: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 8: | Line 8: | ||
==What is the purpose of processing the bed census data?== | ==What is the purpose of processing the bed census data?== | ||
{{ | {{Discuss | who = Pagasa | what is the purpose of having clerk processing this data? | ||
*quality control? | *quality control? | ||
*preparing for reports? | *preparing for reports? | ||
*? | *?}} | ||
==Data Processing -New Instructions== | ==Data Processing -New Instructions== | ||
{{Discuss | who = | {{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 leave it in a slot by fax machine. | #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; | ||
| Line 38: | Line 38: | ||
#*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)}} | |||
{{Discuss | who = | |||
... | ... | ||
| Line 48: | Line 47: | ||
{{Discuss | who = Pagasa | | |||
* copy the database back up to the server | * copy the database back up to the server | ||
** which server?}} | |||
== [[Legacy Processing Instructions Bed census.mdb]] == | == [[Legacy Processing Instructions Bed census.mdb]] == | ||
Revision as of 17:59, 13 November 2019
Also know as whiteboard
Program
Critical Care in WRHA
Start Date
May 3, 2012
What is the purpose of processing the bed census data?
|
what is the purpose of having clerk processing this data?
|
Data Processing -New Instructions
|
|
|
- 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;
- 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
- 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
- Go to: x\\med_ccmed\Pagasa\whiteboard\whitboard.xls
- Manually checks whiteboard.xls.
- 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
|
|
|
...
- 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.
Bed census.mdb Queries
- most of the Queries in this mdb are made by p:Randy Martens
|
|
|