| edit | "cannot open any more tables" in Access | Pagasa |
- After which action or button-press do you get the error "cannot open any more tables" in Access?
| 2022-11-23 10:56:02 PM |
| 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) Not showing any error but cannot click anymore so I go out and log back in. PTorres 16:56, 2022 November 23 (CST)
| 2022-11-23 10:56:02 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)
| 2022-11-23 10:56:02 PM |
| edit | ABG Data | Allan | z
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
- Allan will revisit with Lab people whether this is obtainable now Ttenbergen 11:34, 2022 February 9 (CST)
| 2022-04-21 10:25:05 PM |
| edit | Change for Apache Chronic to ICD10 from separate variable | Tina |
Created_Variables_CC_maker_2021 query now uses Created_APACHE_Chronic query with cut off Dispo_DtTm 2019-01-01. Please let me know if anything further is required about this. If all done, please take out this discussion and section. Ttenbergen 10:47, 2022 June 30 (CDT)
| 2022-11-15 4:41:30 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)
| 2022-09-09 3:31:55 PM |
| edit | Controlling Dx Type for ICD10 codes | Task |
Has Barret had a chance to complete the review of the list? Ttenbergen 17:10, 2022 August 9 (CDT)
- Allan and Barret will discuss if they know who could help Barret with this. Ttenbergen 11:49, 2022 September 28 (CDT)
| 2022-09-28 4:52:04 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) | 2022-06-14 8:50:14 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)
| 2022-08-29 6:21:34 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 | Gaps and overlaps | Pagasa |
Pagasa, we discussed this today, and you said you would put this into L_Problems and then delete the info from the excel sheet (or the whole excel sheet if all has been transitioned). Putting this here so it is on your list. Ttenbergen 15:34, 2022 March 31 (CDT)
when all has been moved to l_problem, the "current state" above can be deleted and we can just leave the "future state" portion as documentation. Ttenbergen 15:45, 2022 March 31 (CDT) | 2022-03-31 8:45:14 PM |
| edit | Gaps and overlaps | Pagasa |
Pulled this from Known data errors:
- The Data processor keeps an Excel workbook that includes: reason some profiles are missing data elements (APACHE - 8 ICU profiles), gaps in database because of deletions including reasons for deletions, overlaps, overs. Example missing all APACHE elements ... and reason why could never be obtained.
- It sounds like there might be other known error types in addition to lost, gap and overlap. Feel free to add them to L_Problems as well, just put here what any additional options mean. If needed I will pull the wiki pages apart. Ttenbergen 15:41, 2022 March 31 (CDT)
| 2022-03-31 8:45:14 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 | HSC-GA7S | all |
Is this a unit we currently collect on? What is it now? Ttenbergen 13:45, 2022 October 13 (CDT)
- It is currently empty, I think it is used as contingency beds Lisa Kaita 12:19, 2022 October 20 (CDT)
- Yes, it seems to be a wildcard place. So we need to document on this page when we find out a change in function, since it affects how we categorize admissions. EG at some point this was an ICU, at another a Med ward (possibly high obs). Ttenbergen 17:31, 2022 November 3 (CDT)
| 2022-11-03 10:31:16 PM |
| edit | HSC-GA7S | all | JALT
This same location has different levels of care over time. Currently the s_level_of_care table can only accommodate one, ie changes over time can't be included in it. My first thought was to include start and end times for this, but what if patients from both programs were boarding on a given unit at the same time? Can that happen? The very concept that these are boarding locations kind of means crazy things could go on. How do we best accommodate this? Would we always know as a physical location (especially a boarding one) changes LOC? Ttenbergen 13:53, 2022 October 13 (CDT)
| 2022-11-03 10:31:16 PM |
| edit | HSC-GA7S | Julie |
I came across this issue because Julie's data and mine had different Transfer Delay when this location was involved. This seems to mean that Julie's doesn't use the table to designate level of care. That could become a source of inconsistency. Should we do this the same way? What is the obstacle? Ttenbergen 13:45, 2022 October 13 (CDT)
- I do not use the s_level_of_care table for the reason that the same location can be assigned with more than one level of care either CC or HOBS or regular. I simplify the process in my program. For Critical Care, since each record is based by unit, if the patient stays in more than one boarding loc i.e. ER/PACU/Home unit/offservice unit, I consider them under the same level of care. Ex an IICU pt staying at SICU/GGA7/GA7S have same level of care, an ICMS patient staying at L2ME(IMCU)/L2HA(Recovery)/home unit/offunit(ACCU/ICCS) are under same level of care. For Medicine, in my program, for each record and boarding locations, I just need to distinguish the HOBS locations (e.g. HSC-GH7S,HSC_HOBS,HSC_H4H,HSC_B2 (only from dt 4/7/2020 to 8/7/2020) and STB_IMCU) and others not specified as HOBS are treated as regular wards (no need to spell out the individual names and no worry if new location comes up which are not yet added in the s_level_of_care table). --JMojica 16:33, 2022 October 14 (CDT)
| 2022-11-03 10:31:16 PM |
| edit | Level of care hierarchy | Julie |
Some CC records contain boarding locs with more than one level of care. Julie has always reported these delays based on service rather than boarding loc... need to find out if that's right. Emailing with Julie... Ttenbergen 11:22, 2022 September 22 (CDT) | 2022-09-22 4:22:43 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 | Query check long transfer delay | Julie |
At the meeting about cross checks (a long time ago) it was decided to change the cut-off to SD*3; if we want to proceed with this check, I will need values for that. Ttenbergen 23:08, 2020 October 15 (CDT)
- the MED above has to changed. I will do a calculation of recent data based on the new process using Mean+3SD. --JMojica 15:16, 2022 February 16 (CST)
| 2022-08-04 1:52:29 PM |
| edit | Query check tmp ER Boarding Loc should exist if from ER | Task | JALT
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)
| 2022-06-14 8:16:16 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)
| 2022-08-10 9:22:01 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 | Run-time error when closing CFE | Pagasa |
Pagasa, do you have more details about this? Ttenbergen 20:54, 2022 June 1 (CDT)
Right now I don't get this error message.PTorres 16:11, 2022 June 22 (CDT) | 2022-06-22 9:11:06 PM |
| edit | SBGH Swing Beds | Lisa |
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) | 2022-08-26 2:06: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)
| 2022-08-26 2:06: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 | 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) | 2022-10-19 1:54:24 PM |
| edit | Transfer Delay (Medicine) | Tina |
this is now implemented in Created TransferReady query so we should just refer there and explain there. | 2022-10-12 5:04:10 PM |