| 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 | 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 | APACHE Acute Dxs in ICD10 codes | Allan | You asked for a spot for this info | 2022-12-08 4:03:36 PM |
| edit | APACHE Comorbidities in ICD10 codes | Allan | You asked for a spot for this info | 2022-12-08 3:54:44 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 | Cardiac arrest | Allan | Allan how do you want the ICD 10 diagnosis Sudden cardiac death used, keeping this code Cardiac arrest in mind Lisa Kaita 08:30, 2022 December 10 (CST) | 2022-12-10 2:30:50 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 | Cognos2 Service Starter | all |
Tina, not sure what is meant by the above sentence to open resp? Lisa Kaita 08:29, 2023 January 27 (CST)
- meant "respectively", since the "O" opens rather than adds. If I wasn't such a nerd I would just say "or" instead of "resp.". Then no one would be confused and what fun would that be. ;-) Should probably change it...Ttenbergen 14:52, 2023 February 1 (CST)
| 2023-02-01 8:52:49 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 | Julie | This is really one of the Indicators, right? If so we should add that template... That would also include which reports use it, and what the n is, etc. Ttenbergen 10:27, 2023 February 2 (CST) | 2023-02-15 10:39:34 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-02-15 10:39:34 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-03-22 2:24:53 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 | 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 | 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-03-22 4:46:37 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 | Lung, metastatic malignancy to it (also code primary site) | Allan | 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? | 2022-12-13 3:42:50 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 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 BedHeld | all | JALT
Checked JALT_Meeting_-_Rolling_Agenda_and_Minutes_2023#JALT_Meeting_–_January_11/12,_2023 and there are no details there... did we decline this check? Ttenbergen 16:02, 2023 February 2 (CST) | 2023-02-02 10:02:53 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) | 2023-03-23 6:08:10 PM |
| edit | Transfer Delay (Medicine) | Tina |
this is now implemented in Created TransferReady query so we should just refer there and explain there. | 2023-03-23 4:45:26 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 |
| edit | Visual disturbance/impairment, NOS | Allan | how to code {sc:blindness, congenital}, which was still left in here from original setup
Would Eye, congenital malformation cover this? | 2023-01-04 4:01:33 PM |