ACCU borrow

From CCMDB Wiki
Jump to navigation Jump to search
Projects
Active?: active
Program: CC
Requestor: unknown
Collection start:
Collection end:

ACCU Borrow is used to track duration that a STB_ACCU patient spends in a STB_CICU, or STB_MICU bed. This is a special case of Bed borrow.

Data Collection Instructions

For any STB_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.

  • Discussed this process with Julie first week of August, 2016. Just to clarify: When an A_CCU patient is in MICU or CICU from the start, the date and time in the borrow tmp field will be the same as the admit date and time to that unit. If the patient is later discharged to the ward, no other action is needed because it will be understood that the pt remained in the borrowed location the entire time. If, however, the pt is transferred to the A_CCU location, then, another entry must be made in the borrow tmp section to indicate the date and time for this move. For example, the first entry will have A_CCU borrow then "MICU" with the date and time. The second entry for A_CCU borrow will be A_CCU and then the date and time when moved there. A patient could also start out in A_CCU and then move to MICU or CICU so then the entries would be made to reflect these moves. --LKolesar 11:47, 2016 August 11 (CDT)
  • 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.

Different Scenario of ACCU Borrow

  • The whole stay has been borrowed bed in MICU or CICU.
  • Only partial stay has been borrowed bed in MICU or CICU.
    • Usually the order of stay is MICU or CICU first and then move to ACCU.
    • Rare case that ACCU is first and then borrowing bed in MICU or CICU at the end of stay.
    • Rare case that ACCU is first and then borrowing bed in MICU or CICU And then back to ACCU.
    • Rare case that ACCU borrowed beds are in both MICU and CICU in consecutive orders.

Start/End Dates

  • Start: July 7, 2016
  • End: there is no planned end date

Data Use

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
    • this query should be replaced by this:
      • Single record D_ID should have Item equal to 'MICU' or 'CICU' and should not have an item='ACCU'
      • if an item is 'ACCU', there should be another entry of same D_ID having an item of either 'MICU' or 'CICU')
        • I need to understand more about this before I can implement... Ttenbergen 21:57, 2017 July 29 (CDT)

Template:Discussion

  • query s_tmp_CCU_Service_twins - can't have two entries that are the same (ie same service and time)
    • Need to change the query name. JMojica 12:14, 2017 March 16 (CDT)
      • why is that? Ttenbergen 21:57, 2017 July 29 (CDT)

Template:Discussion

  • added code to check that same service in consecutive sequence is not allowed
    • This is OK. JMojica 12:14, 2017 March 16 (CDT)
      • "next record" comparisons are not supported natively by Access. Is this check vital? It's possible but would be somewhat messy to implement. Ttenbergen 21:57, 2017 July 29 (CDT)

SAS Program

  • To be filled up by Julie