ACCU borrow: Difference between revisions

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


== Data Collection Instructions ==
== 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.


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:
*Use tmp fields:
** Project: '''ACCU borrow'''
** Project: '''ACCU borrow'''
Line 19: Line 19:
***See: [[STB Cardiac Care patients]]
***See: [[STB Cardiac Care patients]]


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


=={{CCMDB Data Integrity Checks}}==
=={{CCMDB Data Integrity Checks}}==

Revision as of 09:26, 2016 July 11

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

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