ACCU borrow
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
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
- The data is saved in table L_TmpV2 under project 'CCU Service' of the centralized_data.mdb
- The SAS program that reads the data is in X:\Julie\SAS_CFE\CFE_macros\CFE_CCUServiceTracking.sas
See also
see also STB Cardiac Care patients