CCU Service Tracking: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) →Data Collection Instructions: got rid of duplicate information about entering time to avoid something becoming inconsistent if anything changes. highlighted the entry where it already was. |
|||
| Line 3: | Line 3: | ||
== Data Collection Instructions == | == 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 the new service as well. | 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. | 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. | ||
| Line 10: | Line 10: | ||
* Project: '''CCU_Service''' | * Project: '''CCU_Service''' | ||
* Item: '''CCU''' or '''MICU''' | * Item: '''CCU''' or '''MICU''' | ||
* start_dt: date of | * start_dt: '''date of '''service change''' | ||
* start_tm: time of | * start_tm: '''time of '''service change''' | ||
== Start/End Dates == | == Start/End Dates == | ||
Revision as of 09:53, 24 June 2015
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