ACCU borrow: Difference between revisions

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


== Data Collection Instructions ==
== 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:
In TMP: for any patient that occupy's an STB MICU or CICU bed while under Acute Care Cardiology Service (ACCU) at any time.
* Project: '''ACCU borrow'''
*Use tmp fields:
* Item: '''CICU''' or '''MICU''' or '''ACCU'''
** Project: '''ACCU borrow'''
* start_dt: '''date on unit'''
** Item: '''CICU''' or '''MICU''' or '''ACCU'''
* start_tm: '''time on unit'''
** start_dt: '''date on unit'''
** start_tm: '''time on unit'''


*Dispo Tab
**[[Service/Location field]]: STB_CCU


If changes physician service from ACCU to MICU or CICU while still  in MICU or CICU, NEW PROFILE.


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

Revision as of 12:30, 7 July 2016

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

See also

see also STB Cardiac Care patients