JALT Meeting - Rolling Agenda and Minutes 2025

From CCMDB Wiki
Jump to navigation Jump to search

__NOCACHE__

List of items to bring to JALT meeting

Add to this by adding the following to the article where the problem is documented:

{{DiscussTask | JALT
* <question details>}}

(this will bring it to Task if not addressed at JALT)

or

{{Discuss | JALT
* <question details>}}

(this will not bring it to Task) Toggle columns: Last modified

wiki page question Last modified
wiki page question Last modified
Chronic Health Facility 2025-08-06 5:02:14 AM
Chronic Health Facility
  • This issue raised a problem with medicine data recently, and we will review again if this needs to be coded more granular after all,
  • dicussed at JALT June 25, 2025 while Bojan would like this it is not possible to keep track of unit changes and not always easy to tell which unit they arrive from so leave a Riverview and Deer Lodge (DLC), with the exception of the PCH units in each facility.Lisa Kaita 14:52, 25 June 2025 (CDT)
  • 2025-08-06 5:02:14 AM
    Chronic Health Facility We have discussed lately that we might want to become more nuanced about some chronic care locations (Deer Lodge (DLC) and Riverview). I have removed the details from the above linked fields and consolidated here. Once this page is cleaned up this discussion entry can be removed.
  • Discussed at
  • 2025-08-06 5:02:14 AM
    Dispo field JALT

    I thought we had decided at JALT to collect this as presented by EPR... do I remember this wrong? I had already added it in CCMDB.accdb Change Log 2025#2025-03-11-1. Ttenbergen 22:52, 11 March 2025 (CDT)

    • Yes, I saw that, come to think of it I don't think we decided, not in my notes, but we can use it and I will change the wiki instructions Lisa Kaita 11:25, 13 March 2025 (CDT)
    • If we are going to collect this detail for dispo, should we consider whether or not to also look at SH in preadmit living situation?, currently lumped with community facility with support. Lisa Kaita 14:45, 16 April 2025 (CDT)
    • The entry name includes "TRSF" - is the entry for the previous location equivalent in EPR? Ttenbergen 23:30, 16 April 2025 (CDT)
    • no because the previous location would usually be <site>_ER Lisa Kaita 09:53, 28 May 2025 (CDT)
      • Sorry, I should have asked about "pre-hospital location in ADT". Ttenbergen 16:21, 28 May 2025 (CDT)
    2025-09-08 3:31:26 PM
    Intended1stSrvc 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)
    2025-10-09 5:35:08 PM
    Patients residing in Manitoba with ambiguous MH Health coverage JALT
  • The page name isn't quite right, this concept is still evolving in documentation.
  • Some of these may be better off broken out as their own pages or templates and only indexed from here.
  • 2025-08-14 5:06:29 PM
    Pre acute living situation field JALT should we be including Misericordia TCU here? Lisa Kaita 11:57, 5 June 2025 (CDT) 2025-10-03 3:28:45 PM
    Service/Location field
  • is this section still current? Ttenbergen 11:13, 6 March 2025 (CST)
  • It up for discussion tomorrow at JALT Meeting - Rolling Agenda and Minutes 2025 Lisa Kaita 21:04, 10 March 2025 (CDT)
  • Allan spoke with Bojan, to be discussed at next JALT Lisa Kaita 14:48, 16 April 2025 (CDT)
  • still being discussed at JALT Lisa Kaita 21:45, 9 September 2025 (CDT)
  • OK, discussion seems to be complete, we will change ICUotherService to Intended1stSrvc. I have cleaned up most peripheral links, but Lisa, could you make sure that this page reflects post-ICUotherService collection instructions? Any info about the change should really only be in 2025-05 Revision of concept around ICUotherService, which I have already linked from the legacy section of this page. We need to make sure that the info to make sense of the continuity of the data lives in that page. Ttenbergen
  • What will be the turn-over for this? New admissions starting Oct 1? Ttenbergen 14:54, 26 September 2025 (CDT)
  • 2025-09-26 7:54:49 PM
    Service/Location field
    • SMW


    • Cargo


    • Categories
    2025-09-26 7:54:49 PM
    Standard data cleaning process 2025-03-12 2:51:43 AM

    _

    _

    • New Item Collector Coding- Patient and laptop profiles- ADL and Charlson discrepancy, See Tina's email forwarded to JALT members May 29, 2025
    • ICD10 categories, see Tina's email Nov 6, 2024, forwarded to JALT members

    JALT 2025-10-8

    • Present: Tina, Julie, Jen, Lisa, Allan
    • Minutes by: Allan

    1. In followup of the first item from the prior JALT meeting, Allan, Julie and Jen arranged to meet to discuss how exactly to program identifying the various types of boarding and double-boarding.

    2. Regarding identifying the "subsets" of location types within Riverview and Deer Lodge

    • It was related that this issue dovetails with a meeting yesterday with Dan discussing types of discharge locations that are "in between" and home and PCH. The plan from that meeting was to do a 2-3 month temp project where the collectors record (in a free text field) the specific identity of such in-between locations --> after which we can assess their frequency and types.

    3. Regarding Dispo field disparate options for Previous Location and Dispo.

    • Lisa will (again) send around the full lists of "admit from" and "disposition" locations currently in use in the ADT system. We will look at these to decide on additional possible changes

    4. We had a long discussion about the ICU services

    • Currently, we have a cumbersome system with multiple variables that sometimes overlap considerably: Service tmp entry, Service/Location and now Intended1stSrvc
    • It's important to note that currently we generate a new record whenever a patient changes ICU services
    • The current status is that
      • There are just 7 actual ICU services: MICU, SICU, IICU, ICMS, CICU, ACCU and Grace ICU. However, downloaded (via Cognos) from the ADT system are >20 different ICU-related services, e.g. HSC Critical Care/Plastics. But per his meeting a few weeks ago with the ICU leadership, they only use information based on the 7 services. Tina brought up the regional
      • Service Location is a single entry per ICU record, which is chosen manually from a dropdown list of the 7 services by the data collectors
      • Service tmp entry is populated from Cognos/ADT. It can have multiple entries, which can get confusing, e.g. if an SICU patient starts on plastics and then the vascular surgery team gets involved instead it will include listings of: HSC Critical Care/Plastics and HSC Critical Care/Vascular
    • After considerable discussion, we agreed that a reasonable way of simplifying all of this is:
      • Maintain Service Location as the actual service the patient is on -- coded as one of the 7 true ICU services
      • Delete the Service tmp entry altogether -- as we currently create a new record when a patient changes service, and it's first entry is always the same as Service Location, this will cause no problems

    JALT 2025-09-25

    • Present: Tina, Julie, Jen, Lisa, Allan
    • Minutes by: Allan

    1. Continued discussion related to 2025-05 Revision of concept around ICUotherService

    • This entire meeting was taken up with discussing the 1st bullet point of the prior JALT meeting (see below), i.e. related to creating new variable Intended1stSrvc and retiring its predecessor ICUotherService
    • After this is implemented Allan and Julie must meet to discuss exactly how to code the 4 categories of ICU-specific patient bed-days desired by the ICU director group, i.e.:
      • bed-days of patients on that ICU's service but boarding in a different physical location -- this uses Service tmp entry and Boarding Loc
      • bed-days of patients physically in that service's ICU location but under the care of a different ICU service -- this uses Service tmp entry and Boarding Loc
      • bed-days of of patients whose ICUotherService indicates they should be on that ICU service, but per Service tmp entry and Boarding Loc are on a different ICU service and in a different physical ICU -- these are that services's "double boarders"
      • bed-days of of patients on that ICU service and physically in that service's physical ICU location, but whose ICUotherService indicates they should be on a different ICU service -- these are "double boarders" of other ICU services
    • We scheduled another JALT meeting in 2 weeks to discuss the other items from the prior JJALT meeting

    JALT 2025-07-25

    • Present: Tina, Julie, Jen, Lisa, Allan
    • Minutes by: Allan

    1. Continued discussion related to 2025-05 Revision of concept around ICUotherService

    • See June 25, 2025 minutes
    • Allan raised the idea of having all ICU-to-ICU transfers remain part of the original ICU database record, both for ICU-to-ICU transfers within a site (e.g. MICU to SICU) and between sites (e.g. GH ICU to MICU).
      • By use of the 3 variables: Boarding Loc, Service tmp entry and modified ICUotherService --- we would be able to slice and dice ICU days any way desired for reporting.
      • This would include NOT re-calculating the APAPCHE scoring -- which makes sense not to do as the APACHE system is entirely based on scoring at the very first admission to any ICU.
      • But 1 thing we might have to re-visit is identifying the reason for ICU transfer, i.e. the "new admit diagnosis". This is quite complicated, as some ICU-to-ICU transfers are NOT because of a new problem mandating different care, while others are for new problems. Of course, given that we track acquired diagnoses with their dates of onset, along with CCI-coded procedures (e.g. surgical procedures), it's likely we could do a good job of inferring the reason for both physical location changes and service changes.
    • On July 28 Allan spoke with Bojan about these issues:
      • He is open to the idea of NOT starting a new record upon ICU-to-ICU transfer (even between hospitals), and thus with NOT recalculating APACHE scores upon such transfers. One idea from this conversation was to create a 4th category of diagnoses, i.e. a single, "most responsible" Transfer Diagnosis, with date.
      • He will talk with the ICU Directors group about this, including revisiting all aspects of the ICU quarterly reporting, to include whether they desire reporting by physical ICU or by ICU service.

    2. Regarding identifying the "subsets" of location types within Riverview and Deer Lodge (DLC).

    • It always has been, and remains virtually impossible to accurately know which segment of those locations sent a patient to hospital. While Allan previously queried Bojan, who indicated that the ICU program has no deep need to know that, Tina has identified that other efforts she and Dan are involved with DO have such a need. This is made even more complicated because, as in other sites, a given ward/floor at Riverview or Deer Lodge (DLC) can change its "type" over time. However, to date she has not been able to identify/locate anyone who can help us with this. Tina will continue to seek this information

    3. Regarding Dispo field -- there are disparate options for Previous Location and Dispo.

    • We went through those, and made some (minor) alterations.
    • Lisa will find, and send around, the full lists of "admit from" and "disposition" locations currently in use in the ADT system. We will look at these to decide on additional possible changes

    JALT 2025-06-25

    • Present: Tina, Julie, Jen, Lisa, Allan
    • Minutes by: Allan

    1. 2025-05 Revision of concept around ICUotherService - We spent most of this meeting continuing discussion about tracking services and locations.

    • BACKGROUND:
      • There are 3 basic variables to track: Service the patient should be on; Service the patient is on; Actual physical location of the patient. From the POV of any given ICU (e.g. MICU) there are then 5 relevant patient categories:
    Group Service should be on Actual service Actual location Meaning
    A mine mine my ICU my natural patients
    B mine mine different ICU my boarders elsewhere
    C different different my ICU somebody else's boarders in my ICU
    D mine different different my "double boarders" elsewhere
    E different different my ICU somebody else's "double boarders" in my ICU


    Group E should be different - mine - my ICU. Example - SICU patient taken care by MICU service at MICU bed. in contrast with Group C: SICU patient taken care by SICU service at MICU bed. - --JMojica 15:09, 14 August 2025 (CDT)

    • SMW


    • Cargo


    • Categories
    • B+D means insufficient beds in my ICU; C+E means insufficient beds in other unit(s)
      • The current quarterly reporting "by unit" is currently (per Julie) actually by service (i.e. A+B+E), but in discussion with Bojan, he told Allan that he has always wanted and assumed he was getting by physical unit (i.e. A+C+E).
      • We currently have 4 variables that have been, or are, used to identify services and locations:
        • Boarding Loc -- tracks the patient's actual physical location; can change
        • Service tmp entry -- tracks the service taking care of the patient; can change
        • Service Location -- is the INITIAL service that cared for the patient at hospital admission; does not change. Of note, this field is used to create the unique record identifier and for other purposes unrelated to the service caring for the patient. Thus, not only would it be problematic to delete it, but even renaming it would cause problems.
        • ICUotherService -- this is a temp entry that can change over time, and is currently only used at St. B. It contains 2 bits of information, e.g. "ACCU under MICU" means that the patient should be in ACCU on ACCU service but is in MICU on MICU service.
      • We recognize that this data infrastructure is confusing and contains some duplication. Here is a suggestion of being able to accurately track all of A, B, C, D and E in the simplest way and with the smallest amount of modifications to existing data infrastructure:
        • Keep the current meaning of Service/Location but make very clear in the Wiki that it is a legacy-type field we still use but not to consider it part of the clarification of actual service or location
        • Keep Boarding Loc and Service tmp entry with their current meanings
      • Alter the meaning of ICUotherService to be the service the patient SHOULD be on. With this simplifying change to the coding of this field, we can unambiguously use these 3 variables to partition care into A, B, C, D and E. We then must re-decide on the criterion that leads us to create a new ICU record. Currently it is when the actual service changes.
    just came across Proposed future changes to Location and Transfer Ready and related fields about a previous consideration to changing related fields. Ttenbergen 13:28, 27 June 2025 (CDT) 
    
    • SMW


    • Cargo


    • Categories

    JALT 2025-05-29

    • 2025-05 Revision of concept around ICUotherService - This entire 2.5 hour meeting was about the very complicated issues that relate to patient's: physical location (Boarding Loc), actual care service (Service tmp entry), and where the patient "should be" (which is currently coded in "Other ICU", and Service Location).
      • This is made even more complicated in that Service Location also serves functions related to "grouping" for reporting.
      • Other issues that relate include: what alterations in locations and/or service should result in starting a new record; how to code Dispo field and Previous Location in the case of ICU-to-ICU transfers with creation of a new record.
    • After discussion we agreed that the next step will be to clarify precisely what kinds of reports are desired by our users. In this regard, Allan has worked out a schema for classifying patients based on 3 binary characteristics, and will discuss it with Bojan
      • Physical location of patient
      • Current care service of patient
      • Which service the patient "should be on"

    JALT 2025-03-11

    1. Visit Admit dttm discrepancies, see Visit_Admit_DtTm_differences_within_same_admission
    2. New disposition options- barriers to discharge and how best to capture this, Dispo_field
    3. Chronic_Health_Facility
    4. Alternative_Integrated_Accommodation_(AIA)
    5. 2025-05 Revision of concept around ICUotherService: Service/Location field Revisit MICU overflow in SICU
      • in context also of ICUotherService, Service tmp entry and Boarding Loc and STB CC
      • Allan spoke on March 14 with Bojan about the wishes/needs of Critical Care regarding this:
        • The "basic" information provided by Boarding Loc and Service tmp entry enable tracking patient-days boarding (defined as a patient cared for by Service A but in location B) -- but they do NOT need to know which location B (e.g. an MICU patient boarding in SICU vs. JK)
        • They do want to be able to track the number of patient-days in which a patient who would normally go to ICU A, instead is in ICU B where they are cared for by Service B. This is something that is now tracked by the complicated Service Location field. A simpler alternative to track this could be to have for each ICU record an optional field that identifies it (perhaps called "ICU other service") which has options such as "ICU other service-MICU", "ICU other service-SICU", etc, indicating the ICU service the patient "should have been on"
          • Example: A patient that would normally be cared for in ICCS, but ICCS is full. So the patient goes to ICMS on the ICMS service. Here loc=ICMS, Service=ICMS and this database record has a flag for "ICU other service-ICCS".
    • Could you summarize what we would need to change from ICUotherService to get to this? It sounds similar. Ttenbergen 13:25, 17 March 2025 (CDT)
      • in the example mentioned, the service is STB ICMS and flag in the tmp ICUotherService with item entry CICU under MICU service which is ICCS under ICMS service. the current list we have is clearer and less confusing than ICU other service- MICU. And when this patient is accepted to the STB ICMS as an ICMS patient, we continue the profile and the tmp ICUotherService will have a new line with entry MICU under MICU service. Such profile then will have part of ICMS service as an ICCS patient and as an ICMS patient. In the qtr report, this profile is included in the ICMS unit. However, a separate report if requested can be done if wanted to know the LOS of overflowed patients on borrowed service. --JMojica 17:30, 7 April 2025 (CDT)
    • SMW


    • Cargo


    • Categories

    Previous

    For earlier minutes see JALT Meeting - Rolling Agenda and Minutes 2024