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.
ClientGUID fieldLisa
  • 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)
  • I would need a specific example of Client GUID and the patient to look in EPR Lisa Kaita 12:26, 2022 August 24 (CDT)
    • The second field in your L_Log table is now being populated with these, so sort it z-to-a and you should see examples of ClientGUIDs. Ttenbergen 15:01, 2022 August 24 (CDT)
  • I looked at a few and the ClientGUID does not appear to be on the EPR, the only long # in EPR other than MRN is the Visit ID # Lisa Kaita 14:04, 2022 August 25 (CDT)
9 September 2022 15:31:55
DC TreatmentTina_dev_CFE_Data
  • The field has a length of 50 and should be reduced to 2 now that that's the longest content.
1 September 2022 22:01:08
ER DelayTina
  • I have re-updated Created_Variables_Common_maker_2021 query, for some reason the change I had made was not reflected in the master version. Ready to test. Ttenbergen 13:25, 2022 June 28 (CDT)
    • emailed Tina some inconsistencies found in ER Delays Aug 15,2022. --JMojica 13:21, 2022 August 29 (CDT)
  • 29 August 2022 18:21:34
    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. Based on the D_ID, the physical location-service involves, CCU, MICU,SICU.
      • looks like similar with ICUOtherService with a twist (i.e. with intub/non ventilated procedures). I think better as a separate tmp project.
      • in the booklet it says - This codes applies to coronary care patients who are deemed too sick for the Coronary Care Unit and are managed or co-managed in the Medical ICU because they required either ventilation, inotropes, central lines or IABP.
      • if this is the definition, I wander when filtered from L_LOG, the D_ID label have CCU, SICU in addition to HSC MICU or STB MICU (showed HSC_CCU--*, HSC_MICU--*, HSC_SICU--*,STB_CCU-*, STB_MICU-*, VIC_MICU-*) . Not sure if VIC_MICU is an entry error but this has acquired dx Debridement-cardiovascular entry, maybe correct. Also maybe the physical location does not matter? --JMojica 14:53, 2022 August 29 (CDT)
    • H/B/HB/BH (HSC CCU at H7, B3 or both) – 1100 records from 2003 – 2006 at HSC CCU
      • looks like this is similar with tmp boarding concept except without start dates but only location. I think better to make a separate project than add to current tmp Boarding since these had older data (maybe name the project as HSC CCU Location) --JMojica 14:55, 2022 August 29 (CDT)
    1 September 2022 22:19:07
    Transfer Delay (Critical Care)Tina
  • There were problems with the query I provided to Pagasa, this one doesn't seem to play nice if pasted as SQL. Waiting for reply from Julie on above before providing update since it might change. Ttenbergen 11:04, 2022 September 21 (CDT)
  • 19 October 2022 13:54:24
    Transfer Delay (Medicine)Tina 12 October 2022 17:04:10


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

    Related articles

    Related articles: