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 patients 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 a new tmp entry for 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.
Use tmp fields:
- Project: CCU_Service
- Item: CCU or MICU
- start_dt: date of service change
- start_tm: time of 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_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