Portal related pages with questions

From CCMDB Wiki

Data User Portal for the Manitoba Critical Care and Medicine Databases has a audience outside of our organization, so we should attempt to keep on top of Category:Questions on pages that are linked from there. There is no easy way to do this for pages that are linked from there, specifically, but most pages linked from there are in one of the following categories: Category:Data structure, Category:Project or Category:Indicators. Here is a list of pages that are in one of those categories and that have questions:

 WhoDiscussQuestionModDtTm"Modification date" is a predefined property that corresponds to the date of the last modification of a subject and is provided by Semantic MediaWiki.
APACHE Acute DiagnosesallJALT
  • The list of admit CCI procedures used in combination with the admit ICD10 codes is shown in
    • There are many questions about that list, I have emailed Julie and Allan for more info. Ttenbergen 16:38, 2022 June 15 (CDT)
      • Allan has provided newest list, but there were version control issues. Allan to sent the current master version to Tina and Julie as of today's JALT. Ttenbergen 10:11, 2022 July 27 (CDT)
27 July 2022 15:11:10
ClientGUID fieldLisa
  • Do collectors add all HSC IICU admissions via Cognos now that each IICU service admission is included on all HSC CC laptops? Or are there still exceptions. Ttenbergen 11:41, 2022 June 16 (CDT)

    • Aside from the odd correction entries, are there scenarios where records are routinely added other than via Cognos? Ttenbergen 11:41, 2022 June 16 (CDT)

    • Do you know if the ClientGUID is visible in EPR anywhere? It is usually a long number, like 4000012345678912 at HSC. There are shorter ones and some start with a different number. If these were actually visible in EPR then the question of whether we ever enter a record otherwise would go away, as we would be ale to just enter them explicitly as neededTtenbergen 15:32, 2022 August 4 (CDT)
    10 August 2022 18:52:07
    DC TreatmentJulie
    • Three of these contain weird values; do we care?
    D_ID	SentDtTm	R_dc_treat
    STB_ACCU-30009	2016-Sep-16 06:35	c
    HSC_SICa-767	2016-Aug-03 07:51	s
    STB_CCU-29365	2015-Nov-04 10:14	Leslie
    • Do we want to keep this field in CFE or transfer the "DC" values into the new spot, and what would that be?
      • delete the weird values. maybe make a new table L_DC and another for L_FILTER and move to TMS legacy. --JMojica 17:20, 2022 August 12 (CDT)
    12 August 2022 22:20:15
    ER DelayJulie 28 June 2022 18:25:06
    Off ward fieldJulie
    • Any reason we would want to keep the data in this field? Ttenbergen 13:48, 2022 August 10 (CDT)
      • Allan suggested this OFFWARD field for some reasons related to outcome. you are right the tmp Boarding will indicate patients staying in offward locations. Offward started July 2016. CC started tmp Boarding July 2018 while Med on Sept2019. since offward start date was before any of these BL dates, we need to keep those data in prior dates. --JMojica 16:18, 2022 August 12 (CDT)
    12 August 2022 21:26:27
    Previous Service fieldTask
    • To clarify the first point above is this applicable to admissions from nursing stations direct to collection units?
      • What makes you wonder, why would it not be applicable? Ttenbergen 11:42, 2022 March 24 (CDT)
      • I added text to the first point, is this clearer now?
    • To clarify the second point above is "Emergency Medicine" entered for direct admits to a collection service from nursing stations via ER? Thanks!
      • What makes you wonder, why would it not be applicable? Ttenbergen 11:42, 2022 March 24 (CDT)
        • The questions were asked with new collectors in mind for clarification tweaking purposes in regards to phrasing such as "dropped by ER" if the patient is a direct admit to service via ER from a nursing station should the previous service entry also be "other (known, but not on list)"?.
          • What does "dropped by ER" mean in this context? Is it "dropped by" as in visited, or as in someone dropped the ball? Ttenbergen 10:47, 2022 April 7 (CDT)
    • valid question thanks Pam, makes me wonder why we differentiate between the two situations, in my opinion they should be consistent and we should put Emergency Medicine for both situations. The previous location will identify that they were from a nursing station, which in my mind functions like an urgent care/ER triage. We (HSC) rarely get direct admits to the ward from a nursing station, but we get lot of direct admits via the ER from a nursing station. Pull in Julie to see if/how she reports on this. Lisa Kaita 12:41, 2022 April 13 (CDT)
      • emailed Julie Ttenbergen 10:25, 2022 April 21 (CDT)
        • this is a case of direct admits from nursing station parked at ER, correct? we have the list of specific MB nursing stations and generic outside MB nursing stations. why put unknown? In terms of previous service, this is seldom requested so I have not quality checked this field. Just did a quick browse on the database and filter previous location having '(parked)' - found 1269 entries and the previous service is not consistent. There are 940 already in-patients and 82 entered Emergency Medicine as previous service ( 67 out of 82 from HSC) while the 858 entered the actual service or unknown. With regards to the new process starting Oct2020, we won't know if direct admits even if already an inpatient. Example from Oct 2020, I found 134 already an inpatient from other facilities with previous location own ER and previous service Emergency Med while 49 enter the actual service. If known as direct admit parked at ER waiting for available bed then enter the prior inpatient service. Otherwise enter Emergency Medicine. --JMojica 11:29, 2022 April 21 (CDT)
          • I thought Previous Service was part of a standing report, and that that is the main or only reason we even capture it. If it's not used, should we still collect it? I will flag this for task. Ttenbergen 15:22, 2022 April 28 (CDT)
    28 April 2022 20:22:25
    Query check tmp ER Boarding Loc should exist if from ERTaskJALT
    • how about the cases who did not wait at all at ER but immediately went to the Ward or ICU ? - do they still need the first boarding loc be ER? Some DCs entered at least 1 minute difference between first boarding loc ER and second boarding loc - if this is being done, what does the LOS per Location mean when there is 1 minute or 5 minutes or 30 minutes at ER. Are the ICU or Med service really taking care of them at ER in such short stay? --JMojica 14:16, 2022 March 21 (CDT)
      • Good questions. I think this needs to go to Task to get input from Collectors and Allan. Ttenbergen 11:52, 2022 March 24 (CDT)
      • This was discussed at TASK and the decision was create a soft check for collectors to check this, as we know that stays in ER less than 30 minutes are often errors, can this be removed? Lisa Kaita 08:32, 2022 April 28 (CDT)
        • The soft check would flag it for review, but Julie's question was what is the correct thing to actually enter in that scenario. The check can't address that. Ttenbergen 10:58, 2022 May 4 (CDT)
    14 June 2022 20:16:16
    R Filter FieldPagasa
  • Emailed Pagasa to please run the following queries to clear out this field. Ttenbergen 09:52, 2022 August 4 (CDT)

  • Don't understand where or how Julie wants these moved, I don't thin we have a tmp project for these; we can make one but then I'd need a clear definition of what these are. Emailed Julie Ttenbergen 09:52, 2022 August 4 (CDT)

    • CCN/CC (co managed CCU patients intubated/non ventilated) – 633 records from 1989-2004 at STB/HSC MICU
    • H/B/HB/BH (HSC CCU at H7, B3 or both) – 1100 records from 2003 – 2006 at HSC CCU
    10 August 2022 18:47:12
    Transfer Delay (Critical Care)TaskJALT one of the DC mentioned in the TASK meeting that GRA Med patient with transfer ready dttm and went to GRA ICU should be considered as bed wasted. In the current process, all with transfer ready dttm are included as bed wasted regardless where the patient went or died. but in this new way of reporting, this is not the case. can we discuss again which is the final way? --JMojica 13:28, 2022 June 24 (CDT)29 June 2022 14:46:56
    Transfer Delay (Medicine)Julie
    • This function is now ready to test. Ttenbergen 15:17, 2022 June 29 (CDT)
    29 June 2022 20:17:25


    This article is tagged to be reviewed periodically. The next scheduled review is on 1 Jan 1900.

    Related articles

    Related articles: