ACCU borrow: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) m minor |
TOstryzniuk (talk | contribs) m →{{CCMDB Data Integrity Checks}}: minor |
||
| Line 23: | Line 23: | ||
=={{CCMDB Data Integrity Checks}}== | =={{CCMDB Data Integrity Checks}}== | ||
{{Discussion}} | {{Discussion}} | ||
needs review from Tina and Julie. | needs review from ''Tina'' and ''Julie''. | ||
* query ''s_tmp_CCU_Service_shouldntve'' - no pt not STB_MICU can have any | * query ''s_tmp_CCU_Service_shouldntve'' - no pt not STB_MICU can have any | ||
* query ''s_tmp_CCU_Service_twins'' - can't have two entries that are the same (ie same service and time) | * query ''s_tmp_CCU_Service_twins'' - can't have two entries that are the same (ie same service and time) | ||
Revision as of 12:35, 2016 July 7
Purpose
Purpose is to track duration that an ACCU patient spends in a STB_CICU, or STB_MICU bed
Start/End Dates
- Start: July 7, 2016
- End: there is no planned end date
Data Collection Instructions
In TMP: for any patient that occupy's an STB MICU or CICU bed while under Acute Care Cardiology Service (ACCU) at any time.
- Use tmp fields:
- Project: ACCU borrow
- Item: CICU or MICU or ACCU
- start_dt: date on unit
- start_tm: time on unit
- Dispo Tab
- Service/Location field: STB_CCU
If changes physician service from ACCU to MICU or CICU while still in MICU or CICU, NEW PROFILE.
Template:CCMDB Data Integrity Checks
Template:Discussion needs review from Tina and Julie.
- query s_tmp_CCU_Service_shouldntve - no pt not STB_MICU can have any
- query s_tmp_CCU_Service_twins - can't have two entries that are the same (ie same service and time)
- added code to check that same service in consecutive sequence is not allowed
SAS Program
- To be filled up by Julie