ACCU borrow
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 STB_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.
- Discussed this process with Julie first week of August, 2016. Just to clarify: When an A_CCU patient is in MICU or CICU from the start, the date and time in the borrow tmp field will be the same as the admit date and time to that unit. If the patient is later discharged to the ward, no other action is needed because it will be understood that the pt remained in the borrowed location the entire time. If, however, the pt is transferred to the A_CCU location, then, another entry must be made in the borrow tmp section to indicate the date and time for this move. For example, the first entry will have A_CCU borrow then "MICU" with the date and time. The second entry for A_CCU borrow will be A_CCU and then the date and time when moved there. A patient could also start out in A_CCU and then move to MICU or CICU so then the entries would be made to reflect these moves. --LKolesar 11:47, 2016 August 11 (CDT)
- 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_ACCU
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