CCU Service Tracking
Purpose
We want to know how much of the load of the STB MICU is due to which service.
Data Collection Instructions
For each patient occupying a STB MICU bed, that during their stay in MICU have been under Cardiology Service at any time, enter the service they are admitted under. If the service changes during the stay, enter the new service as well.
- If a patient occupying a STB MICU bed remains under MICU coverage their entire stay, there is no need to make a tmp entry for CCU Service at all.
- Project: CCU_Service
- Item: CCU or MICU
- start_dt: date of admission/service change
- start_tm: time of admission/service change
Start/End Dates
- Start: 2015-Jun-01
- End: there is no planned end date
Template:CCMDB Data Integrity Checks
- query s_tmp_CCU_Service_missing - each STB_MICU pt has to have at least one
- 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
See also
see also STB Cardiac Care patients