ACCU borrow: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m m
Line 1: Line 1:
== Purpose ==
== Purpose ==
Purpose is to track duration that an ACCU patient spends in a STB_CICU, or STB_MICU bed
Purpose is to track duration that a [[STB_ACCU]] patient spends in a [[STB_CICU]], or [[STB_MICU]] bed


== Start/End Dates ==
== Start/End Dates ==

Revision as of 09:24, 2016 August 4

Purpose

Purpose is to track duration that a STB_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

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.

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