Intended1stSrvc: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Agarland (talk | contribs)
No edit summary
Line 13: Line 13:
{{DJ | is that the right report? I have added this new data to that report's dependencies. If it's the wrong one it will need to be taken out of there. If other reports also use this, it will need to be added to them. If only that report you can remove this comment. [[User:Ttenbergen|Ttenbergen]] 15:20, 26 September 2025 (CDT)
{{DJ | is that the right report? I have added this new data to that report's dependencies. If it's the wrong one it will need to be taken out of there. If other reports also use this, it will need to be added to them. If only that report you can remove this comment. [[User:Ttenbergen|Ttenbergen]] 15:20, 26 September 2025 (CDT)
}}
}}
*This variable essentially replaces [[ICUotherService]]
*It is to be used when the ICU service a patients is actually on (MICU, SICU, IICU, ICMS, CICU, Grace ICU) is different from the service the patients '''should be on'''.  This most common reason for this to happen is bed capacity issues.
**e.g. patient admitted from ED ventilated with severe pneumonia, should go to MICU but it is full, so goes to SICU and is taken care of by the SICU service.  Here [[Service/Location]] is SICU and [[Intended1stSrvc]] is MICU
**e.g. patient in ED at Grace and should go to Grace ICU but it's full, so goes to HSC MICU.  Here [[Service/Location]] is MICU and [[Intended1stSrvc]] is Grace ICU.  This example shows that the [[Intended1stSrvc]] can be at a different hospital altogether.
*This variable should be left BLANK when the ICU service the patient is on is the one they should be on -- i.e. only fill it in when there is an [[Intended1stSrvc]] that is different from the first service they are actually on (i.e. what's in [[Service/Location]]
*Along with [[Boarding Loc]], [[Service Location]]
*As part of this alteration in collection, we will no longer collect [[Service tmp entry]]
**as [[Service tmp entry]] is downloaded from Cognos, this will no longer occur
contains information about patients who are '''taken care of by a critical care service other then the one that normally would have taken care of them''', generally due to capacity limitations. The actual service taking care of the patient is encoded in [[Service tmp entry]], this variable encodes which service should have taken care of a patient initially upon admission, but did not. Along with [[Boarding Loc]] and [[Service tmp entry]], this data allows keeping track of every type of boarding (also called bed borrowing) and "double-boarding" bed-days reported.
contains information about patients who are '''taken care of by a critical care service other then the one that normally would have taken care of them''', generally due to capacity limitations. The actual service taking care of the patient is encoded in [[Service tmp entry]], this variable encodes which service should have taken care of a patient initially upon admission, but did not. Along with [[Boarding Loc]] and [[Service tmp entry]], this data allows keeping track of every type of boarding (also called bed borrowing) and "double-boarding" bed-days reported.



Revision as of 11:10, 9 October 2025

Projects
Active?: proposed"proposed" is not in the list (active, planned, legacy, aborted in planning) of allowed values for the "ProjectActive" property.
Program: CC
Requestor:
Collection start:
Collection end:

This project is not live yet, do not follow the instructions to stop the old collection yet. I hope to have this set up to start collecting with the new instructions Oct 1. For now, continue to use the instructions in ICUotherService. Ttenbergen 14:27, 26 September 2025 (CDT)

  • SMW


  • Cargo


  • Categories

Background

The Critical Care Program Quality Indicator Report

is that the right report? I have added this new data to that report's dependencies. If it's the wrong one it will need to be taken out of there. If other reports also use this, it will need to be added to them. If only that report you can remove this comment. Ttenbergen 15:20, 26 September 2025 (CDT)

  • SMW


  • Cargo


  • Categories
  • This variable essentially replaces ICUotherService
  • It is to be used when the ICU service a patients is actually on (MICU, SICU, IICU, ICMS, CICU, Grace ICU) is different from the service the patients should be on. This most common reason for this to happen is bed capacity issues.
    • e.g. patient admitted from ED ventilated with severe pneumonia, should go to MICU but it is full, so goes to SICU and is taken care of by the SICU service. Here Service/Location is SICU and Intended1stSrvc is MICU
    • e.g. patient in ED at Grace and should go to Grace ICU but it's full, so goes to HSC MICU. Here Service/Location is MICU and Intended1stSrvc is Grace ICU. This example shows that the Intended1stSrvc can be at a different hospital altogether.
  • This variable should be left BLANK when the ICU service the patient is on is the one they should be on -- i.e. only fill it in when there is an Intended1stSrvc that is different from the first service they are actually on (i.e. what's in Service/Location
  • Along with Boarding Loc, Service Location
  • As part of this alteration in collection, we will no longer collect Service tmp entry


contains information about patients who are taken care of by a critical care service other then the one that normally would have taken care of them, generally due to capacity limitations. The actual service taking care of the patient is encoded in Service tmp entry, this variable encodes which service should have taken care of a patient initially upon admission, but did not. Along with Boarding Loc and Service tmp entry, this data allows keeping track of every type of boarding (also called bed borrowing) and "double-boarding" bed-days reported.

Data Collection Instructions

  • Code it as the ICU service that the patient SHOULD HAVE BEEN under upon initial admission to the ICU Service in this hospital, i.e. at the start of this record
    • Leave it blank if the very first day in ICU in that hospital, the patient was, in fact under the "correct" ICU service, i.e. the service that should have been taking care of the patient -- and as this is the majority of all ICU records, this variable will usually be left blank.
Example:   
  • Patient with acute MI admitted via ED. He should have been under the ACCU service in ACCU but ACCU was full. So he was admitted to ICMS instead under the ICMS Service. Thus here Intended1stSrvc = ACCU.

Transfer to Another ICU Service

Instructions relating to coding this variable when a patient transfers from one ICU service to another

  • For ICU-to-ICU transfers between hospitals (inter-facility), code this variable anew at the receiving hospital
  • For ICU-to-ICU transfers within a single hospital (intra-facility), carry over the value of this variable from the prior ICU record
      • continuation of above example: While he was in ICMS under the ICMS service he developed cardiogenic shock and emergently went for bypass surgery, after which he went to CICU under the CICU service. As he stayed in the same hospital and went ICU-to-ICU within it, the new CICU profile would begin when he went to the CICU service, the Intended1stSrvc = ACCU, as carried over from his first ICU profile at SBGH.

JALT

  • If this patient then moves to ACCU, do you still code Intended1stSrvc = ACCU, so they would be in ACCU with this tag?
  • What if they move to a Medicine service and then back to CC? This is only for continuous CC admission, right?
  • SMW


  • Cargo


  • Categories
  • We note that the ICU service that a patient should be under can change, and so simply carrying over the Intended1stSrvc from the first day in any ICU can misrepresent where the patient "should be". But we discussed and are OK with that, as such changes represent only a fraction of a fraction of patients, and trying to keep better track of what service should be on throughout their episode of ICU care is difficult and very confusing.
  • Use tmp fields:
  • Project: Intended1stSrvc
  • Item:

JALT

  • How do we want to do this, we could use the currently active entries for CC in s_dispo table:
  • HSC_IICU
  • HSC_MICU
  • HSC_SICU
  • STB_ACCU
  • STB_CICU
  • STB_MICU

or the full possible names under the CC services in S Cognos Services table that we actually use (in the last 2 months we had): Item

  • GH Critical Care / ACSS
  • GH Critical Care / General
  • GH Critical Care / General ICU
  • HSC Critical Care - MICU
  • HSC Critical Care / A Medicine
  • HSC Critical Care / A Non Teaching Med
  • HSC Critical Care / D Medicine
  • HSC Critical Care / D Non Teaching Med
  • HSC Critical Care / General
  • HSC Critical Care / H Medicine
  • HSC Critical Care / H Non Teaching Med
  • HSC Critical Care / Intermediate
  • HSC Critical Care / Medicine
  • HSC Critical Care / Neurosurgery
  • HSC Critical Care / Obstetrics
  • HSC Critical Care / Orthopedics
  • HSC Critical Care / Otolaryngology
  • HSC Critical Care / Plastics
  • HSC Critical Care / Respiratory
  • HSC Critical Care / Trauma
  • HSC Critical Care / Vascular
  • HSC Surgery / Neurosurgery
  • SBGH Cardiac / Cardiac Surgery
  • SBGH Cardiac / Crit Care Cardiology
  • SBGH Critical Care / Acute Care Surgery
  • SBGH Critical Care / B Service
  • SBGH Critical Care / C Service
  • SBGH Critical Care / Cardiac Surgery
  • SBGH Critical Care / Crit Care Cardiology
  • SBGH Critical Care / General
  • SBGH Critical Care / Medicine

or we could use only the part before the "/" for the CC services in S Cognos Services table:

  • GH Critical Care
  • HSC Critical Care / Intermediate (this wouldn't be captured without the post-/ part)
  • HSC Critical Care
  • (but what would actually signify SICU, or would we again still need Service/Location for that?
  • SBGH Cardiac
  • SBGH Critical Care
  • SBGH Cardiac / Cardiac Surgery (this wouldn't be captured without the post-/ part)
  • SBGH Cardiac / Crit Care Cardiology (this wouldn't be captured without the post-/ part)
  • SMW


  • Cargo


  • Categories

Things to resolve

Things we need to resolve:

  • We need to review anything that links to ICUotherService, and anything that page lists to. The "anything that links there" can be accessed by expanding the "related articles (expand)" at the bottom of ICUotherService. Ttenbergen 10:59, 25 September 2025 (CDT)
  • SMW


  • Cargo


  • Categories

Log

Data Integrity Checks (automatic list)

none found

  • I don't think any checks are possible for this, or can someone think of one?
  • SMW


  • Cargo


  • Categories

Related articles

Related articles: