ACCU borrow

Purpose

Purpose is to track duration that a STB_ACCU patient spends in a STB_CICU, or STB_MICU bed

Data Collection Instructions

For any STB_ACCU patient who occupies an STB MICU or CICU bed while under Acute Care Cardiology Service (ACCU) at any time, enter all moves between borrowed beds.

• Use tmp fields:
  • Project: ACCU borrow
  • Item: CICU or MICU or ACCU
  • start_dt: date on unit
  • start_tm: time on unit

• Dispo Tab
  • Service/Location field enter: STB_ACCU
    • See: STB Cardiac Care patients

If physician service changes from ACCU to STB_MICU or STB_CICU while still in MICU or CICU, create a new profile.

Start/End Dates

• Start: July 7, 2016
• End: there is no planned end date

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