Questions

From CCMDB Wiki
Jump to navigation Jump to search

Lists all pages in. For those that were added with Template:Discuss it also lists the question.

Questions

edit wiki page who question Last modified
edit wiki page who question Last modified
edit "cannot open any more tables" in Access Pagasa
  • After 24 rows, open and closed assigning Pseudo Phin an error message pop up then I cannot assign Phin anymore. I closed CFE then open then I am good to go again. The second time the error message pop up not 24 rows it less than 24 like 15 rows then it will show again the error message. PTorres 16:09, 2022 June 14 (CDT)
    • Is it the "cannot open..." error or the "enter parameter..." error you get at this point? Emailed Pagasa... Ttenbergen 10:49, 2022 November 16 (CST)
      • Still shows "cannot open "so I clicked ok then it says run time error 3014 cannot open any more tables. Closed the CFE then log back in.
      • After I continue assigning Pseudo Phin after 25 rows "cannot open" showed up again I clicked ok then error message shows again. Closed CFE then log back in.PTorres 14:42, 2022 November 30 (CST)
        • Are you following the steps in Generating PseudoPHINs when this goes wrong? Which step in those instructions are you at when it stops responding and you need to restart the program? Ttenbergen 13:48, 2022 November 29 (CST)
      • Yes, I am. I am clicking and assigning the new Pseudo Phin and not moving. PTorres 14:47, 2022 November 30 (CST)
 2022-12-07 6:15:25 PM
edit "cannot open any more tables" in Access Pagasa
  • Assigning Pseudo Phin or working on the queries if I worked long enough opened closed it then the error message pop up "Enter Parameter Value". PTorres 17:01, 2022 April 14 (CDT)
    • What is the specific action or button press after which this happens? I.e. which step in Generating PseudoPHINs? Ttenbergen 10:49, 2022 November 16 (CST)
      • When I click the pseudo button to the left of the PHIN field label, nothing is moving.PTorres 15:23, 2022 November 30 (CST)
        • I don't understand what you mean by that. What is the last thing you do before the "Enter Parameter Value" error happens? As in, what is the last button you click or last field you enter? Ttenbergen 12:15, 2022 December 7 (CST)
    		•  2022-12-07 6:15:25 PM
    edit ABG Data Allan
  • Identified as something we should do to streamline data collection. I have made this page to document progress toward this import. Blood gas data is in DSM listing; need to compare to see if we can use it
    		• 2023-05-17 7:00:40 PM
    edit APACHE Acute Dxs in ICD10 codes Allan You asked for a spot for this info 2023-04-27 3:39:34 PM
    edit APACHE Comorbidities in ICD10 codes Allan You asked for a spot for this info 2023-04-27 3:37:59 PM
    edit Boarding Loc Lisa are there circumstances where the unit time is changed from the Cognos one? These might come from Definition of a Critical Care Laptop Admission / Definition of a Medicine Laptop Admission or should in any case be consistent with that.
  • yes for SICU often COGNOS has the date and tm the same for first service and first boarding loc and second boarding loc, so we will change the boarding loc to be off by 1 minute until we confirm in the chart the correct date and times. We then exclude the boarding loc so that it doesn't keep popping up on the CUS, leave a note in note section to confirm date and times Lisa Kaita 13:55, 2023 February 1 (CST)
    • I am not sure how best to update this instruction so it's both clear how to collect, how to interpret incomplete data, and how to interpret complete data.... thoughts? Ttenbergen 15:10, 2023 February 1 (CST)
    		•  2023-02-01 9:10:53 PM
    edit Boarding Loc Lisa if two show up with same dttm how should this be resolved?
  • see above example. Lisa Kaita 13:59, 2023 February 1 (CST)
    		•  2023-02-01 9:10:53 PM
    edit Change of GRA location names from "our" names to EPR/Cognos names Tina
  • Do we need to change old ITEM values for consistencies? --JMojica 12:11, 2022 March 8 (CST)
    • It might be nice to have, and you would know better how important this is. If we want to do it, we would need to ask Pagasa to run the update queries for each item. The query would be like
    • UPDATE L_TmpV2 SET L_TmpV2.Item = "GH-Emergency"
WHERE (((L_TmpV2.Project)="Boarding Loc") AND ((L_TmpV2.Item)="GRA_ER"));
        • Was updated for all except GRA Boarding... Tina needs to fix wiki page. Ttenbergen 16:11, 2022 March 23 (CDT)
    		 2022-03-23 9:11:36 PM
    edit ClientGUID field Lisa
  • 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)
    		• 2023-05-24 5:18:08 PM
    edit Critical Care Program Quality Indicator Report Julie We don't have a page for STB_ICMS - what do we call that location? Ttenbergen 09:53, 2023 May 18 (CDT) 2023-05-18 2:53:09 PM
    edit DC Treatment Tina _dev_CFE_Data
  • The field has a length of 50 and should be reduced to 2 now that that's the longest content.
    		•  2022-09-01 10:01:08 PM
    edit ECIP all
  • As per email discussion with Lisa: "We could also have a safety net where by the other ICU collectors could email the collectors at HSC when they receive an admission from HSC ER?"
    • If others receiving an admission from HSC ER would be a filter, we might actually have that info in Cognos, it just would not be showing up in your (ie HSC’s) data at this time. But that would mean collectors would always need to review patients who went to another ICU from the HSC ER (and likely the same for the STB ER, possibly even the GRA one...), so that seems like a lot of overhead. Are we OK to just identify SICU ECIPs as a population we likely usually don't capture? Ttenbergen 15:36, 2020 October 6 (CDT)
  • On the online Bed Board (https://whiteboard.manitoba-ehealth.ca/whiteboard/icu), there is a column OFF_service Patients which means any patient overflowing to either Resuscitation room in ED, PACU/PARR, ICCS, etc. and entry is real time. For HSC SICU, the common overflow location is PACU (haven’t seen any at ER). Only GRA ICU shows overflows in ER. This may give us a clue for possible ECIP but not sure how DC will crosscheck the online bed board if the timing won't synchronized. maybe we just have to ignore SICU ECIP if there is such a thing. --JMojica 16:27, 2020 October 6 (CDT)
    		•  2023-05-04 5:15:58 PM
    edit ER Delay Tina
  • 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)
    		•  2023-04-19 8:52:09 PM
    edit Error "Invalid SQL statment..." when sending all
  • 2023-03-22 S9 first send started 07:12:41 stopped at checking for duplicates at 7:13:06, showed up on laptop at 0716, news & backup then second send went through
    • But did it give this error? Ttenbergen 09:24, 2023 March 22 (CDT)
    		•  2023-05-15 1:29:14 PM
    edit Error: There isn't enough free memory to update the display. Close unneeded programs and try again. all
  • Are collectors still getting this error? Under what circumstances? Will need more input if we want to fix this. Ttenbergen 15:34, 2022 June 1 (CDT)
  • I just had this happen on the H6 laptop, but I have about 250 records on it and I had forgotten to delete the sent profiles (about 50) so once I did this the error went away Lisa Kaita 08:11, 2022 June 3 (CDT)
    		•  2022-06-03 1:11:54 PM
    edit High-Obs Wards Tina Tina to add. 2022-10-20 9:32:54 PM
    edit HSC MICU all
  • Does this belong somewhere else as well? Cognos2 Service Starter?Lisa Kaita 09:09, 2022 September 1 (CDT)
    		• 2022-11-03 10:29:22 PM
    edit JALT Meeting - Rolling Agenda and Minutes 2023 all JALT
  • For CC Reports, ER Delay for LE 30 minutes, ignore (treat as zero) and GT 30 minutes, use actual ER Delay. N is number of cases where previous location is from own ER, CC reports Mean ER Delay as Total ER delays/N and Median ER based on N. Prior to Oct 2020, we calculate ER delay as Arrive Dttm - Accept Dttm. But there are cases where Accept Dttm is missing, therefore ER Delay is missing and these missing are not included in N. Are all these correct? --JMojica 17:36, 2023 February 13 (CST)
  • For Medicine Reports, I am reporting LOS (mean, std, total, min, max) per Boarding LOC which includes ER . Should the GT 30 mins threshold be applied for ER boarding loc or use actual ER LOS? do we need to follow the same rule for both CC and Med? --JMojica 17:36, 2023 February 13 (CST)
    		•  2023-04-19 5:21:33 PM
    edit Lung, metastatic malignancy to it (also code primary site) Allan
  • This had been question "If someone has a primary lung cancer, and they have metastases to the other lung, do we combine this code with Lung and/or bronchus, primary malignancy?"
    		• 2023-05-17 6:56:57 PM
    edit Non-standard ICD10 Diagnoses Tina Dx grouping
  • With our addition of codes, collectors may use one of our codes rather than the closest standard ICD10 code. In that case, the dx would not show up in the range. How should we address this? The most likely candidates above seem Bronchiolitis obliterans organizing pneumonia (BOOP, cryptogenic organizing pneumonia (COP)) and SARS (severe acute respiratory syndrome)
    • AG REPLY -- for this nonstd BOOP code, there are no existing issues regarding any of the comorbid groups (e.g. Charlson)
      • Allan, could you confirm that that this is what we found when we looked into BOOP.
  • AG REPLY --- so far Tina the only 2 U-codes that would ever be a primary dx are U04 and U14.68 -- which belong respectively to ICD10 chapters J and E. But whenever we add a new U-code we need to remember to decide which chapter (if any) it needs to be included under. Tina to add to template.
    • I can't add this to the template, this is not how templates work, they won't warn me as I start a new dx page. We'd need to remember this some other way. And I just saw other dxs that might fit in here: Diabetes mellitus acute complication: Non-ketotic hyperosmolar state, Asystole, Pulseless Electrical Activity (PEA)
    • Actually, neither BOOP nor SARS would currently be captured by our APACHE Acute Dxs in ICD10 codes filter - they likely should be. So this is still an issue and we would miss them if we did something similar. How do we fix it for the Apache codes and prevent this problem going fwd? Ttenbergen 15:22, 2022 June 30 (CDT)
      • Discussed at JALT, Allan will review. Ttenbergen 10:32, 2022 August 24 (CDT)
        • Allan sent an email 2022-10-02 that provides a new inclusion list for some of these. Nothing for APACHE or Charlson Comos, but additions for APACHE Acute Dxs in ICD10 codes. Tina needs to process the additions into S ICD10 APACHE Dx patterns table. Ttenbergen 16:54, 2022 October 27 (CDT)
        • Additionally, Tina will provide Allan the filter info as it's stored in Access so that future updates aren't confusing. Ttenbergen 17:00, 2022 October 27 (CDT)
        • Additionally we need some way to make sure we consider this when we add dxs. Ttenbergen 17:00, 2022 October 27 (CDT)
  • figured out that the structure of APACHE Acute Dxs in ICD10 codes is way different than I had thought and that my current implementation can't accommodate it, reviewing with Julie. Ttenbergen 23:09, 2022 October 27 (CDT)
    		•  2022-10-28 4:09:28 AM
    edit Outreach efforts Task
  • We have talked about doing more outreach so people are aware of and use our DB. I saw the Wound Day notice, and it made me wonder if we can have any meaningful presence there. But that’s STILL reactive. If we wanted to be more proactive in getting out the word about our data, what should we do in 2023 to accomplish that? Ttenbergen 09:43, 2022 December 29 (CST)
    		•  2022-12-29 3:44:51 PM
    edit Query check CCI CXR vs LOS Julie
  • Just came across this... the started query includes additional dxs now, as per #CCI collect count each. Does the proposed accepted count make sense for all the dxs? Your validation table was for CXR. Ttenbergen 11:50, 2023 May 3 (CDT)
    		•  2023-05-03 8:58:14 PM
    edit Query Mgmt StartDelays Lisa
  • Not currently used since Trish retired. If we want to use these we will need to update this to using Admit DtTm instead. But this may not be the right query anyway. Emailed Lisa to have conversation if she wants to use this. Ttenbergen 15:08, 2022 April 27 (CDT)
    		•  2022-04-27 8:08:40 PM
    edit Query NDC Bad Postal Code Tina
  • I think this is the process where you said you are having problems with copy/pasting. Copy pasting isn't even mentioned here, so maybe update the process to show how you actually do this, so that someone like Sheila Rusnak would be able to follow the instructions. Ttenbergen 15:45, 2022 March 17 (CDT)
    • Do you create that query each time? Would we be able to update the NDC query that finds these in the first place to include the info you need? We can discuss at our next meeting. Ttenbergen 16:23, 2022 March 17 (CDT)
      • Taking this off Pagasa's list for now, since if we can get this data from DSS we won't need to do this any more. Ttenbergen 15:36, 2022 March 24 (CDT)
    		•  2023-05-04 5:03:24 PM
    edit R Filter Field Pagasa
  • Emailed Pagasa to please run the following queries to clear out this field. Ttenbergen 09:52, 2022 August 4 (CDT)
    		•  2022-09-01 10:19:07 PM
    edit R Filter Field Tina 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)
    		•  2022-09-01 10:19:07 PM
    edit Repeat clicks being needed when entering CCI PX Type all
  • I can't replicate this. Pulled test data, deleted all CCIs Picklist entries from one profile, closed profile, re-opened, clicked type dropdown and it worked. Can someone provide a series of steps to recreate the above error? The report is old and I must have pasted it from somewhere else, so I don't even have a collector to go back to. The problem may be the step just before clicking in the dropdown, so if you get this problem, please include that step. Ttenbergen 16:59, 2022 February 10 (CST)
    		•  2022-02-10 10:59:34 PM
    edit SBGH Swing Beds all
  • to be sure, if I remember right STB ICU does that for ALL Boarding Loc entries, not just swing beds, right? Just trying to confirm, because if that's true then it's not a swing bed instruction but instead a STB Critical Care Collection Guide instruction (or possibly a Boarding Loc one). Ttenbergen 11:33, 2022 January 27 (CST)
    		• 2023-05-24 8:57:55 PM
    edit SBGH Swing Beds Lisa Are there actually differences in how CC, Med or different laptops do this? Or is the following correct for all?
    • Since any CUS entry at STB may be either a swing bed or a real bed, service locations and times need review.
    • For Medicine, the swing bed entries will often be obvious as the unit stays will be a matter of minutes
    • If a CUS entry is for a swing bed, manually exclude using the "exclude" button
    • Any ICU pt. may be placed into a swing bed, but the majority of swing beds are used for the ICCS pt's. The pt. is placed in a swing bed while in the OR, and then moved into a real bed post op when they arrive in the CICU. Their stay in a swing bed may be any length of time. The true arrive Dt/Tm is taken from the ICU flow sheets.
    • if a pt. was placed into an ICU swing bed but was never admitted to the ICU, the pt. entries are manually excluded from Cognos when reviewed.
    • I would feel more comfortable if a collector from SBGH reviewed this, as I haven't been there for some time and I am not 100% certain how they are dealing with swing beds Lisa Kaita 13:06, 2022 August 24 (CDT)
    • Pam tweaked the above, just waiting for Val to weigh in Lisa Kaita 13:30, 2022 August 24 (CDT)
      • Are we still waiting for feedback on this one? Ttenbergen 15:57, 2023 May 24 (CDT)
    		 2023-05-24 8:57:55 PM
    edit Template:ICD10 Guideline MRSA Allan z "It was decided that Allan with contact Dr. Embil after COVID is over and see if we can obtain this data from Infection Control. If so, we could import it into the database, and have our data collectors cease obtaining it." - did anything come of that? 2021-01-12 8:59:00 PM
    edit Visit Admit DtTm differences within same admission Task
  • Do we still see occasional mismatches? Ttenbergen 13:40, 2022 December 8 (CST)
    		•  2022-12-08 7:41:18 PM
    Retrieved from "https://ccmdb.kuality.ca/index.php?title=Questions&oldid=154839"