ACCU borrow: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (minor)
Line 17: Line 17:
*Dispo Tab
*Dispo Tab
**[[Service/Location field]]: STB_CCU  
**[[Service/Location field]]: STB_CCU  
***See: [[STB Cardiac Care patients]]


If changes physician service from ACCU to MICU or CICU while still  in MICU or CICU, NEW PROFILE.
If changes physician service from ACCU to MICU or CICU while still  in MICU or CICU, NEW PROFILE.
Line 30: Line 31:
* To be filled up by Julie
* To be filled up by Julie


== See also ==
 
see also [[STB Cardiac Care patients]]





Revision as of 13:32, 2016 July 7

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

If changes physician service from ACCU to MICU or CICU while still in MICU or CICU, NEW PROFILE.

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