ACCU borrow: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
TOstryzniuk (talk | contribs)
Line 16: Line 16:


*Dispo Tab
*Dispo Tab
**[[Service/Location field]]: STB_CCU  
**[[Service/Location field]] enter: STB_CCU  
***See: [[STB Cardiac Care patients]]
***See: [[STB Cardiac Care patients]]



Revision as of 12:39, 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