ACCU borrow: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(ACCU bed borrow in STB CICU or MICU)
 
Line 25: Line 25:


== SAS Program ==
== SAS Program ==
* The data is saved in table L_TmpV2 under project 'CCU Service' of the centralized_data.mdb
* To be filled up by Julie
* The SAS program that reads the data is in X:\Julie\SAS_CFE\CFE_macros\CFE_CCUServiceTracking.sas


== See also ==
== See also ==

Revision as of 13:08, 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


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