ACCU borrow: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m m |
Ttenbergen (talk | contribs) m m |
||
| Line 1: | Line 1: | ||
== Purpose == | == Purpose == | ||
Purpose is to track duration that a [[STB_ACCU]] patient spends in a [[STB_CICU]], or [[STB_MICU]] bed | Purpose is to track duration that a [[STB_ACCU]] patient spends in a [[STB_CICU]], or [[STB_MICU]] bed | ||
== Data Collection Instructions == | == Data Collection Instructions == | ||
| Line 20: | Line 16: | ||
If physician service changes from ACCU to [[STB_MICU]] or [[STB_CICU]] while still in MICU or CICU, '''create a new profile'''. | If physician service changes from ACCU to [[STB_MICU]] or [[STB_CICU]] while still in MICU or CICU, '''create a new profile'''. | ||
== Start/End Dates == | |||
*Start: July 7, 2016 | |||
*End: there is no planned end date | |||
=={{CCMDB Data Integrity Checks}}== | =={{CCMDB Data Integrity Checks}}== | ||
Revision as of 09:25, 2016 August 4
Purpose
Purpose is to track duration that a STB_ACCU patient spends in a STB_CICU, or STB_MICU bed
Data Collection Instructions
For any ACCU patient who occupies an STB MICU or CICU bed while under Acute Care Cardiology Service (ACCU) at any time, enter all moves between borrowed beds.
- 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 enter: STB_CCU
If physician service changes from ACCU to STB_MICU or STB_CICU while still in MICU or CICU, create a new profile.
Start/End Dates
- Start: July 7, 2016
- End: there is no planned end date
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