ACCU borrow

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

• Dispo Tab
  • 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.

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