ACCU borrow

From CCMDB Wiki
Revision as of 10:29, 2016 August 4 by Ttenbergen (talk | contribs) (link)
Jump to navigation Jump to search

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 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

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

See also

SAS Program

  • To be filled up by Julie