| 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
- Allan will revisit with Lab people whether this is obtainable now Ttenbergen 11:34, 2022 February 9 (CST)
| 2023-05-17 7:00:40 PM |
| edit | Adding a drug to pharmacy collection | all |
This needs cleanup, just putting it here instead of email | 2024-09-11 6:06:53 PM |
| edit | Alternative Integrated Accommodation (AIA) | Lisa |
This used to say "* Pre acute living situation would be not applicable" and I questioned what that means. But what is the pre-acute living situation for these? Home? Not really, one reason they go here is to continue some IV treatment. So closer to "PCH"? Or how do we want to code it? Ttenbergen | 2025-04-17 4:33:44 AM |
| edit | AMA | all |
I think this might be what is changing ti "Left Post Initial Treatment" after the email from 2025-02-20. Ttenbergen 11:00, 20 February 2025 (CST) | 2025-02-20 5:00:40 PM |
| edit | APACHE Acute Dxs in ICD10 codes | Allan | You asked for a spot for this info | 2025-04-09 9:50:09 PM |
| edit | Charlson Comorbidity Index | Julie |
Do we ever include the age in the Charlson score? Should we? If not, we need to clearly document that, since others looking at this score would expect us to use the original definition. Ttenbergen 11:03, 28 January 2025 (CST)
- No, the one I had provided with label =Charlson Score has no Age , just sum of all categories. The APACHE SCORE for sure has the AGE score and not Charlson Score. --JMojica 11:26, 28 January 2025 (CST)
Did we include age as part of the data used to generate the Overstay model? We need to use whatever we used for that in our score and generator.
- The problem is I did not see the final overstay model and I'm only relying on what was on the WIKI Overstay Predictor Project Algorithm showing the AGE and AgexADLmean. In Rodrigo's model, Age is included. I would presume Leigh Anne also included it.--JMojica 11:26, 28 January 2025 (CST)
- I just re-read your original answer, and it actually addressed my question: any Charlson Score you gave them did not include that age factor. I am pretty sure the official Charlson score does include an age factor, I implemented it in CCMDB (not CFE for some reason) "L_ICD10_Charlson_Agepts" query. We had this conversation before, but then I didn't document what was the reason to omit the age from the score. It makes a significant difference to the score, so whoever uses our data (eg is it included in our dump to MCHP) would expect it to include the age portion. Ttenbergen 18:08, 29 January 2025 (CST)
| 2025-03-18 10:18:15 PM |
| edit | Chronic Health Facility | all |
Do we need to consider 1010 Sinclair separately as well?
- Any others we might need to consider separately?
| 2025-05-20 3:58:12 AM |
| edit | Chronic Health Facility | all | We have discussed lately that we might want to become more nuanced about some chronic care locations (Deer Lodge and Riverview). I have removed the details from the above linked fields and consolidated here. Once this page is cleaned up this discussion entry can be removed.
Discussed at
| 2025-05-20 3:58:12 AM |
| edit | Chronic Health Facility | Lisa |
Discussed this at JALT Meeting - Rolling Agenda and Minutes 2025#JALT 2025-03-11 but I don't remember if we came to an answer or next step. Just found a note to add that we will also need to decide if any of these are in-patient locations. This would make them collectable as Pre-admit Inpatient Institution, and is relevant as per Pre-admit Inpatient Institution field#Data Use / Purpose. | 2025-05-20 3:58:12 AM |
| edit | Chronic Health Facility | Lisa |
These should be made consistent with Template:PCH Riverview Deer Lodge and should probably use that template to enforce consistent use. Ttenbergen 14:23, 2024 October 16 (CDT)
- and I have lost track of the details Ttenbergen 10:45, 2024 November 1 (CDT)
- There might be an easy way out of this question. We now only have one awaiting code; if waiting for any of them qualifies for this code then we may not need to know about the level of care. But then again, some of those sites also have acute/LAU type settings so we may need to figure this out after all...Ttenbergen 20:27, 2024 December 11 (CST)
| 2025-05-20 3:58:12 AM |
| edit | Chronic Health Facility | Lisa | Here is the breakdown
Riverview-
- PCH- C and D wings floors 1-4 42 beds
- PCH- Aand B wings -locked unit for alzheimer/dementia 30 beds
- 2E is LTV 30 beds
- 3E is palliative care 30 beds
- 4E is stroke rehab 30 beds
- 4W is Acute brain injury- 10 beds
- 3W is PCH- 29 beds
- 2W respiratory ward (no vents)- 30 beds
Deer Lodge
- Rehab wards are Lodge 2W, 4E and 4W
- TCU is Lodge 2E
- chronic care is Lodge 5E, 5W, 6E, 6W, 7E and 7W (clients with comples medical issues who can't be cared for in PCH ie. tracheostomy, ostomy, enteral and parenteral nutrition, complex wound care, blood transfusions and PIV and Central lines.
- PCH is Tower 3N, 3S, and 4,5,6,7 and also Lodge 3W, 3E
Lisa Kaita 13:03, 10 March 2025 (CDT) | 2025-05-20 3:58:12 AM |
| edit | Chronic Health Facility | Task | This issue raised a problem with medicine data recently, and we will review again if this needs to be coded more granular after all. Adding this to put it on the agenda. | 2025-05-20 3:58:12 AM |
| edit | Chronic Health Facility | Tina |
- review, that might need to be consolidated with this page as well.
| 2025-05-20 3:58:12 AM |
| edit | Chronic Health Facility | Tina | in s_dispo, Riverview has inpatient checked, Deer lodge does not. When all this is settled they should probably become consistent... but not sure which so not now. | 2025-05-20 3:58:12 AM |
| edit | ClientGUID field | all |
Lisa, any idea why this might be happening from a collection perspective? Is the problem in what we receive the right info from Cognos, or is there an issue in the collection process that makes this happen? Ttenbergen 09:52, 2024 December 5 (CST)
Julie, do we need to flag anywhere further that this data is suspect? Ttenbergen 09:52, 2024 December 5 (CST) | 2024-12-05 3:52:23 PM |
| edit | Colonized with organism (not infected) | Lisa |
Do we need similar instructions or mechanisms as for MRSA for this one? eg coding for Resistance to carbapenem antibiotics? Ttenbergen 11:18, 18 February 2025 (CST)
I'm not clear on what you are asking Lisa Kaita 20:57, 10 March 2025 (CDT)
Sorry, I meant the "set MRSA Colonized" button, and something like Template:ICD10 Guideline MRSA for how we code it when it's an actual infection rather than just a colonization. Ttenbergen 00:51, 11 March 2025 (CDT) | 2025-03-11 5:51:57 AM |
| edit | Coordination of data between collectors | all | Found this linked from PatientFollow Project - are these instructions still relevant after that project and Change to having each collector collect both programs on the same laptop? | 2025-03-12 4:30:57 AM |
| edit | Created TransferReady query | Tina | Still need to import this into master CFE, the version I have right now is messed up. Here it is: | 2024-11-22 6:08:24 AM |
| edit | Definition of a Critical Care Program Admission | all |
We need to extract a summary of the definition details from the page history.
We should set up a Record definition query in CFE to provide a clear way in CFE to treat historical, pre PatientFollow Project, records in a way that is consistent with our current definition. | 2025-03-18 7:22:14 PM |
| edit | Definition of a Medicine Program Admission | all |
We need to extract a summary of the definition details from the page history.
We should set up a Record definition query in CFE to provide a clear way in CFE to treat historical, pre PatientFollow Project, records in a way that is consistent with our current definition. | 2025-03-18 7:22:17 PM |
| edit | Discharged to community | all | Just a placeholder for now because the idea of how we define dispo to community (or for that matter, re-admit Previous Location) in data came up re. things like Readmission to MedWard and others. We have the obvious "Home" but if someone is discharged to something like Dialysis, would that also count? How do we define? Ideally by a column in s_dispo table such as s_dispo.loc_type, but that one uses "non-patient" which it also uses for Deceased patients (should we just split that out?). There is probably even more to this. Likely Julie has more than one approach in reporting. This came up because we were looking to define this for LAU collection readmission data.
- This is actually just as much regarding to admitted from community, so maybe this should just be renamed to "outpatient sites in s_dispo table"?
| 2025-03-20 2:52:15 AM |
| edit | Dispo field | all | If this is actually done then why don't we just make the nursing stations available? We already have s_dispo table entries for them. 35 entries since 2016, 6 in the last 12 months. Are there other things for which this entry is used? Checked for reasons for this decision but they don't appear documented Ttenbergen 19:42, 13 March 2025 (CDT) | 2025-05-02 3:36:38 AM |
| edit | Dispo field | Lisa | I thought we had decided at JALT to collect this as presented by EPR... do I remember this wrong? I had already added it in CCMDB.accdb Change Log 2025#2025-03-11-1. Ttenbergen 22:52, 11 March 2025 (CDT)
Yes, I saw that, come to think of it I don't think we decided, not in my notes, but we can use it and I will change the wiki instructions Lisa Kaita 11:25, 13 March 2025 (CDT)
If we are going to collect this detail for dispo, should we consider whether or not to also look at SH in preadmit living situation?, currently lumped with community facility with support. Lisa Kaita 14:45, 16 April 2025 (CDT)
The entry name includes "TRSF" - is the entry for the previous location equivalent in EPR? Ttenbergen 23:30, 16 April 2025 (CDT) | 2025-05-02 3:36:38 AM |
| edit | Dispo field | Lisa | That more detailed info included things like HSC Lennox Bell; we discussed whether or not we need to document the details of this. If so, the following is likely a starting point:
Home
Home with support
Institution NOS
TRSF Group/Supportive housing
TRSF to Correctional Facility
any Hospices
GH-Transitional care
HSC - Transitional care
Misericordia - Transitional care
STB - Transitional care
VIC - Transitional care
HSC Lennox Bell
Manitoba Adolescent Treatment Center - unknown/other | 2025-05-02 3:36:38 AM |
| edit | DSM Lab Extract | Tina |
A possibility to change the current Chart entry to be the same with SH format (see #DSM Inclusion Criteria/ Process for reason why in details). | 2023-07-05 5:36:20 PM |
| edit | DSM Labs data.accdb | Julie | Emailed Julie:
found overlap in old file, what does it mean
proposed using labDtTm for split threshold
Ttenbergen 16:51, 2024 May 2 (CDT) | 2025-03-18 10:17:54 PM |
| edit | ER Delay | all |
- 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)
- are these still an issue? Ttenbergen 11:15, 2024 May 1 (CDT)
- I will re-check again. Can't remember if have been resolved. --JMojica 14:40, 2024 October 2 (CDT)
| 2025-03-18 10:18:16 PM |
| edit | ER Delay | Julie |
I just had a look at that sas file (they open as text files) to see how you define transfer delay. If that file is still being used we may have a problem, it still defines tdelay different if a pt goes to a higher level of care, goes AMA or dies, and we changed that some time ago. So is this still the reference of how you calculate this? Ttenbergen 22:50, 2024 November 16 (CST) | 2025-03-18 10:18:16 PM |
| edit | ER Delay | Julie |
This data is problematic before 2011-Q2,the only reason there are any is because it derives them for EMIPs. Some data may be available in Moves for Medicine, but that would still leave a gap. Ttenbergen 23:09, 2024 November 16 (CST)
- OK, will be working on this getting data from Moves for Medicine from period Sept 2007 to June 3, 2011. will give to Pagasa for upload to Arrive DtTm field. I will update the WIKI as soon as done. Conclusion: for Medicine, prior Sept 2007, no ER delay while for Critical Care, no ER Delay prior July 1, 2016 -- these are treated as missing. --JMojica 16:35, 2024 December 11 (CST)
| 2025-03-18 10:18:16 PM |
| edit | Error "Invalid SQL statment..." when sending | all |
I have a hunch that this error may be related to a send failing for one collector and a second collector then also sending, leading to problems with the lock file.
So, when the error happens, please have a look at Regional Server\/output\\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\/output and see if there is a second centralized_data file there with an extension .lccdb. See Lccmdb and ldb files for details. Please log here about what you find. Ttenbergen 10:41, 2024 November 30 (CST) | 2025-04-12 12:46:30 PM |
| edit | Geri Rehab | Tina | this is one of the things we needed to discuss further, currently we capture RR5 as HSC_ward, but it is a combination of spinal cord rehab, NMSK rehab, amputation rehab, Riverview has stroke rehab, Deer Lodge has Geri rehab, If we are capturing these rehab wards for CGH, SOGH and VGH should we not be capturing this for all dispo locations that are rehab? Lisa Kaita 13:11, 8 April 2025 (CDT) | 2025-04-10 9:52:50 PM |
| edit | High-Obs Wards | Tina | Tina to add. | 2025-03-20 5:17:20 PM |
| edit | Hospital-acquired pneumonia (HAP) in ICD10 | Allan | A decision to change this was made at Task Team Meeting - Rolling Agenda and Minutes 2025#ICU Database Task Group Meeting – May 14, 2025. This template will need to be updated with the decision. | 2025-01-09 7:29:52 PM |
| edit | Hospital-acquired pneumonia (HAP) in ICD10 | Allan | that's supposed to say "on admission", not "on infection", right ? | 2025-01-09 7:29:52 PM |
| edit | Influenza pneumonia | Allan | A decision to change this was made at Task Team Meeting - Rolling Agenda and Minutes 2025#ICU Database Task Group Meeting – May 14, 2025. This template will need to be updated with the decision. | 2025-01-09 7:27:32 PM |
| edit | Influenza pneumonia | Allan | that's supposed to say "on admission", not "on infection", right ? | 2025-01-09 7:27:32 PM |
| edit | Instructions for importing a batch of DSM Data | Julie |
- Thanks for updating, but I don't understand... I thought the whole idea with having them in L_Problems_D_ID would be that that is the actual data used to do the translation from one ID to the other. Do you mean you actually hard-code it in SAS instead? I ask because you say you need to modify the SAS program to incorporate the change. Ttenbergen 21:47, 14 March 2025 (CDT)
- That is correct, I add a line in my SAS code to change the unmatched D_ID between the DSM dumped data versus the L_LOG D_IDs. Pagasa was instructed to list down in the L_Problems_D_ID those D_ID she had changed during her data processing task if these D_IDs had already been for DSM request. There will be no entry in the L_Problems_D_ID if any change in D_ID happens before sending a DSM request. So far, SAS finds zero of such case. If in case, SAS finds any record in the requestor not in L_LOG, that is only the time the SAS code assigns a new D_ID to the dumped DSM D_ID so as to be consistent with the L_Log D_ID. --JMojica 10:38, 17 March 2025 (CDT)
| 2025-03-17 3:38:11 PM |
| edit | JALT Meeting - Rolling Agenda and Minutes 2025 | Allan |
Could you summarize what we would need to change from ICUotherService to get to this? It sounds similar. Ttenbergen 13:25, 17 March 2025 (CDT)
- in the example mentioned, the service is STB ICMS and flag in the tmp ICUotherService with item entry CICU under MICU service which is ICCS under ICMS service. the current list we have is clearer and less confusing than ICU other service- MICU. And when this patient is accepted to the STB ICMS as an ICMS patient, we continue the profile and the tmp ICUotherService will have a new line with entry MICU under MICU service. Such profile then will have part of ICMS service as an ICCS patient and as an ICMS patient. In the qtr report, this profile is included in the ICMS unit. However, a separate report if requested can be done if wanted to know the LOS of overflowed patients on borrowed service. --JMojica 17:30, 7 April 2025 (CDT)
| 2025-05-20 3:53:33 AM |
| edit | L TmpV2 multi-entry clean-up | Julie | Did we ever resolve this? What was the outcome? If we didn't resolve it, do we still need to? If not, can we delete this page? | 2025-03-15 3:15:57 AM |
| edit | LAU Collection Project | Tina | Dan was right, this field is a mess trying to use our current definition with a population of patients that don't really fit an acute medicine profile. If the patient went to Rehab the Transfer Ready DtTm will reflect the time they are accepted, if they became palliative the Transfer Ready DtTm will reflect when they became so, otherwise much of this was a judgment call, as many would be deemed transfer ready on admission by our definition.Lisa Kaita 07:59, 11 April 2025 (CDT) | 2025-04-16 12:19:33 PM |
| edit | LAU collection readmission data | Lisa |
what if they spend time in an ED in between as part of re-admission, possibly pushing past the 7 day range? Due to the very long ER delays for LAU I think we would want to include those. Ttenbergen 00:06, 12 March 2025 (CDT
- These would be included because I am using the ADT/EPR readmits and the admit time reflects first time of presentation and an ensuing admission Lisa Kaita 12:13, 10 April 2025 (CDT))
- to be perfectly clear: if someone is discharged from LAU on Jan 1, and then presents to an ED at GRA, where they decide the person should go to LAU, but the patient is not transferred and made an inpatient again at an LAU for another 3 days (pushing their new admission past the 10 day window), would you tag them as a re-admission? Ttenbergen 12:42, 10 April 2025 (CDT)
Yes, I believe it would because in EPR for patient visits, the patient you describe would show them as an inpatient, beginning Jan 7, even though by our definition they are not an inpt til the LAU folks accept them. I would not be able to decipher the actual first service time without having the chart or running an EPR report. Lisa Kaita 12:49, 10 April 2025 (CDT) | 2025-05-03 5:39:16 AM |
| edit | LAU LTC consult | Tina | for this field the default entry for yes is the LTC Medical application, however I later realized that this is not a consult per se, as some have this completed without an actual consult to LTC (the learning process for this project was confusing, I should have spoken to someone from LTC before starting this) I continued to enter it this way, but also answered "yes" for those that had an actual LTC consult where the dttm were either earlier than the medical application or they did not have a medical application but had a LTC consult, I noted details in the Q column and the notes. I know this is an analysis nightmare but I think I can clean this up if before Julie does her analysis I go through these records Lisa Kaita 07:44, 11 April 2025 (CDT) | 2025-05-07 12:33:11 AM |
| edit | LAU OT/PT consults | Lisa |
Do we want an instruction if sign-off isn't found?
- Can I use the no consult entry?
- there is only one of those, so if more than one thing is missing we might not catch it. Aside from that, this would work. So, might be good enough.
So I interpreted this differently, not sure why or how but what I collected was the first date and time seen by OT/PT (not the consult dttm) and then the last time seen or sign off by OT/PT, For Geri rehab and pretty much all LAU patients the consults are done as part of the admission process. The exception is some of the patients will not be seen by one or the other or both if they are "too good" Lisa Kaita 07:06, 11 April 2025 (CDT) | 2025-05-03 5:39:53 AM |
| edit | LAU OT/PT consults | Lisa |
Do we want that cross-check entry? Do we need one for each or is a simple "no consult" if there is neither consult sufficient?
If the entry is missing then they were not seen, I don't think a cross check was set up for this, because it did not trigger any errors Lisa Kaita 07:06, 11 April 2025 (CDT) | 2025-05-03 5:39:53 AM |
| edit | LAU Public Trustee | Tina | I also used this field for FORM 21 but documented it in the Q column, should we take this out? I think there were a handful of these Lisa Kaita 07:27, 11 April 2025 (CDT) | 2025-05-03 5:39:57 AM |
| edit | Link suspect not same visitAdmitDtTm query | all |
Found a record from last Oct in this query so emailed Julie and Pagasa to see if we are still running this. Guess that raises the question if Correcting suspect links is still being followed, and Centralized data Vetting Process in general. Ttenbergen 22:49, 11 March 2025 (CDT) | 2025-03-12 3:49:40 AM |
| edit | Link suspect visitAdmitDtTm mult to-from-home query | Tina |
implement this
with L_Problems tie in?
tell Pagasa it exists | 2025-03-12 2:24:45 AM |
| edit | Overstay2 data processing and reporting in CFE | all |
Nothing yet, fill in as it becomes available. | 2025-02-23 10:13:18 PM |
| edit | Overstay2 data processing and reporting in CFE | Tina |
add functions/subs when I finalize this | 2025-02-23 10:13:18 PM |
| edit | Overstay2 processes on the units to reduce overstay | all |
We'll need to fill these in as they become available; that may well be as links to other documents, since the unit documentation would not be on this wiki. If files are generated we should link to them at their home location, but also maintain files on this wiki, since link rot is inevitable for this sort of thing. Ttenbergen 15:45, 23 February 2025 (CST) | 2025-02-23 10:22:38 PM |
| edit | Overstay2 scoring model | all |
add the content for the chosen model 8 here, with links | 2025-02-28 9:00:24 PM |
| edit | Pneumonia, bacterial | Allan | A decision to change this was made at Task Team Meeting - Rolling Agenda and Minutes 2025#ICU Database Task Group Meeting – May 14, 2025. This template will need to be updated with the decision. | 2025-01-09 7:28:47 PM |
| edit | Pneumonia, bacterial | Allan | that's supposed to say "on admission", not "on infection", right ? | 2025-01-09 7:28:47 PM |
| edit | Pneumonia, fungal/yeast | Allan | A decision to change this was made at Task Team Meeting - Rolling Agenda and Minutes 2025#ICU Database Task Group Meeting – May 14, 2025. This template will need to be updated with the decision. | 2025-01-09 7:29:08 PM |
| edit | Pneumonia, fungal/yeast | Allan | that's supposed to say "on admission", not "on infection", right ? | 2025-01-09 7:29:08 PM |
| edit | Pneumonia, NOS | Allan | A decision to change this was made at Task Team Meeting - Rolling Agenda and Minutes 2025#ICU Database Task Group Meeting – May 14, 2025. This template will need to be updated with the decision. | 2025-01-09 7:29:24 PM |
| edit | Pneumonia, NOS | Allan | that's supposed to say "on admission", not "on infection", right ? | 2025-01-09 7:29:24 PM |
| edit | Pneumonia, ventilator-associated (VAP) | Allan | A decision to change this was made at Task Team Meeting - Rolling Agenda and Minutes 2025#ICU Database Task Group Meeting – May 14, 2025. This template will need to be updated with the decision. | 2025-05-20 3:21:57 AM |
| edit | Pneumonia, ventilator-associated (VAP) | Allan | that's supposed to say "on admission", not "on infection", right ? | 2025-05-20 3:21:57 AM |
| edit | Pneumonia, viral | Allan | A decision to change this was made at Task Team Meeting - Rolling Agenda and Minutes 2025#ICU Database Task Group Meeting – May 14, 2025. This template will need to be updated with the decision. | 2025-01-09 7:28:18 PM |
| edit | Pneumonia, viral | Allan | that's supposed to say "on admission", not "on infection", right ? | 2025-01-09 7:28:18 PM |
| edit | PowerBI Data Model for CCMDB | Tina | ER Delay and Overstay
Need to make sure I do things this way and include this in the right pages, possibly Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry but a lot of other pages touch on this, so maybe it needs to be a template? It may not be consistent everywhere:
Note from email from Julie 2024-20-24:
I do not use any cut-off e.g. 2020-10-15 because the tmp has been populated by boarding data since July 2018 for ICU and Sept 2019 for Med. The cut-off Oct 2020 Patient Follow only applies for tmp Service but not for tmp Boarding loc. By the way. the patient follow started early at Grace Oct 1, 2020 (they piloted it), while HSC and STB started Oct15, 2020. Similar with EMIPs, I have two sources of ER-delay namely 1. from Accept and Arrive 2. from Tmp : first boarding dttm and second boarding dttm. If both have values, I use the one from the tmp source. | 2024-12-12 12:11:55 AM |
| edit | Project MR | all |
- Do we want that to be the first time during a medicine program admission, or only the first time during a hospitalization? Ttenbergen 08:45, 26 February 2025 (CST)
- Also, we define Transfer Ready DtTm tmp entry to be able to do this per level of care to enable reporting separately for HOBS. I think there are problems with that concept since I doubt users of the data keep the detailed definition in mind, but we still need to decide if we want to be able to report this the same way. If so, we need the the same connector integer in the instructions. Ttenbergen 08:51, 26 February 2025 (CST)
- emailed DR about this Ttenbergen 11:36, 28 February 2025 (CST)
| 2025-02-28 5:36:05 PM |
| edit | Project MR | all |
How do we want to define where to get this? Unless we get physicians to put this information into a specific spot we are right back to all the definition difficulties in Transfer Ready DtTm tmp entry, only it will be worse because collectors will need to keep conflicting but similar instructions in mind. Ttenbergen 08:49, 26 February 2025 (CST)
- emailed DR about this Ttenbergen 11:36, 28 February 2025 (CST)
| 2025-02-28 5:36:05 PM |
| edit | Project Overstay2 | all |
ADLmean_nh - in the CCMDB Script it is written -- Adlmean_nh = (ADLScore - 12)*(from a nursing home), what does 12 mean?
- Very good question. The function adl_sc used to get the individual scores just generates a score of 0, 3 or 6, or -1 if given bad input. That doesn't explain why -12. And I can't imagine why this would be. But it's consistent between two functions, so unlikely to be just a finger fumble. Ttenbergen 19:15, 25 January 2025 (CST)
- looks like ADLmean does not imply average of the 6 individual ADL categories (e.g. total ADL SCore/6) but (TOTAL ADL Score -12). I'm guessing here, maybe 12 is the Grand Mean of total ADL and Leigh Anne is trying to evaluate the deviation of the individual data point from the mean of the dataset of those from Nursing Home . --JMojica 09:29, 27 January 2025 (CST)
| 2025-03-05 1:56:38 AM |
| edit | Project Overstay2 | Julie |
Charlson categories are provided but the CCMDB Script model only includes MI, Pulmonary, Connective, Renal
- It also contains the full score as part of Charlson_nh. Ttenbergen 19:15, 25 January 2025 (CST)
- correct, there are selected subcategories and also FULL CHARLSON SCORE for those from Nursing Home. --JMojica 09:29, 27 January 2025 (CST)
- I think "connective" became "Rheumatic disease" in ICd10, right? Ttenbergen 16:41, 24 January 2025 (CST)
- Yes it refers to Connective Tissue Disease-Rheumatic Disease. --JMojica 09:29, 27 January 2025 (CST)
| 2025-03-05 1:56:38 AM |
| edit | Project Overstay2 | Tina |
OutsideWPG - I have used Previous Location because Leigh Anne specified the patient came from a facility outside of Winnipeg.
- MB - I would think Leigh Anne had used the Province because the data set has no Postal Code yet
- I just checked the query check_from_out_of_town I used to derive this and it only considered Pre-admit Inpatient Institution having geog like "out-of*"! Ttenbergen 16:57, 24 January 2025 (CST)
- Will ask Dr. Roberts what this was all about to better understand what to use now. Specifically, if we use previous location, would we only care about hospitals, or also e.g. nursing stations, PCH, hospice, "unknown/other" loc_types. Ttenbergen 16:51, 24 January 2025 (CST)
| 2025-03-05 1:56:38 AM |
| edit | Query check has transfer ready date or checkbox | Tina |
This check doesn't seem to catch when a time is entered without a date. It would be good to update that. Don't have time right now, so leaving a note. Email exchange 2024-11-14. Ttenbergen 12:12, 2024 November 15 (CST) | 2024-11-15 6:12:47 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)
| 2025-03-18 10:17:59 PM |
| edit | Re-analysis and generation of Overstay2 model | all |
initial thoughts were "15-17% being red, with an aim to get 60-75% of overstay patients" | 2025-03-11 10:24:07 PM |
| edit | Re-analysis and generation of Overstay2 model | all |
the statistical tests that were done to evaluate the model
the factors leading to our decision on "Model 8"
links to files | 2025-03-11 10:24:07 PM |
| edit | Re-analysis and generation of Overstay2 model | all |
What was the consideration for the initial choice of, I think, 0.051? | 2025-03-11 10:24:07 PM |
| edit | Re-analysis and generation of Overstay2 model | all | add a table of admission numbers by year and site | 2025-03-11 10:24:07 PM |
| edit | Re-analysis and generation of Overstay2 model | all | Still needs:
considerations
values we considered and rejected
minimize duplication of Data definition for contributing factors for the Overstay2 project | 2025-03-11 10:24:07 PM |
| edit | Re-analysis and generation of Overstay2 model | Julie |
Does this page miss anything that is not addressed elsewhere as per pages either linked from here or from Overstay2 Overview? If not feel free to delete this question. Ttenbergen 15:19, 23 February 2025 (CST) | 2025-03-11 10:24:07 PM |
| edit | Re-analysis and generation of Overstay2 model | Julie |
is this really simply "to a non-hospital location" or is it the same as above: "to a destination outside of the hospital of the admission (can be to other hospital)"?
| 2025-03-11 10:24:07 PM |
| edit | Re-analysis and generation of Overstay2 model | Julie | Do you have numbers for something like false positives/ false negatives/ positive predictive value/ etc? Will rely on you to make this something that would satisfy someone questioning this from a statistical angle. Ttenbergen 15:19, 23 February 2025 (CST) | 2025-03-11 10:24:07 PM |
| edit | Re-analysis and generation of Overstay2 model | Julie | number | 2025-03-11 10:24:07 PM |
| edit | Re-analysis and generation of Overstay2 model | Julie | where? | 2025-03-11 10:24:07 PM |
| edit | Re-analysis and generation of Overstay2 model | Tina | still needs to be set up by Tina... | 2025-03-11 10:24:07 PM |
| edit | Readmission to MedWard | Julie |
when we were setting up LAU collection readmission data we realized that we are not clear on what exactly is included in a Discharged to community. We should decide how to define that and whether it should apply here and/or for other reports. | 2025-03-20 2:51:18 AM |
| edit | Record definition query in CFE | all |
We should set up a Record definition query in CFE to provide a clear way in CFE to treat historical, pre PatientFollow Project, records in a way that is consistent with our current definition. This is a good idea but not trivial, so we should decide how badly we need this, but definitely document the concept.
- JM email from 2025-03-18: "Perhaps, creating a query to link those records from old definition to become similar to patient follow is needed in ACCESS to generate at least the LOS, first admit date and last discharge date, first previous location and last dispo location. In this way, SAS will not generate it and I just get it from ACCESS query. Is this hard to do? "
- The query is probably the easiest part, but this would take some analysis to figure out what all is actually affected by this, ie which other queries would need to be updated. Having said that, we should still probably do it. I don't know who would be in a position to prioritize this, I don't have bandwidth for this as a side project right now. Don't think it's a task question because I don't know if anyone there would have anything to add to this. Ttenbergen 14:17, 18 March 2025 (CDT)
| 2025-03-18 7:35:56 PM |
| edit | S dispo table | Julie |
"Hospice - other, WPG" is currently not grouped as Hospital = "Other Institution in WPG" as the other hospices - should it be? Ttenbergen 17:03, 11 March 2025 (CDT) | 2025-03-12 5:26:14 AM |
| edit | S dispo.center | Julie | Is this just an arbitrary sorting of units or is there a plan to it? Ttenbergen 16:02, 11 March 2025 (CDT) | 2025-03-11 10:09:28 PM |
| edit | S dispo.geog | Julie | Use
??? | 2025-03-12 4:47:50 AM |
| edit | S dispo.geog | Julie | Should these be geog = winnipeg
- Interventional Radiology
- Other Procedure Location
| 2025-03-12 4:47:50 AM |
| edit | S dispo.loc type | Julie |
in s_dispo table HSC Lennox Bell is listed as loc_type=unknown/other ; many in that location would be most similar to "home", so should these be grouped as "non-patient" instead? Wherever we deal with "home", are we already including these? For example, for Readmission to MedWard, would we include anyone who has been discharged to a "non-patient" location, or do we use more explicit groupings? Ttenbergen 15:24, 11 March 2025 (CDT)
also in s_dispo table HSC Lennox Bell is listed as site=HSC; it kind of is, but wherever that column is used to group, would this be a location we would expect in that group? Or should it be blank? Ttenbergen 15:24, 11 March 2025 (CDT) | 2025-03-11 10:13:35 PM |
| edit | SBGH L2 | Julie |
I have linked this in from several reports based on those having "L2" in them. There might be others where I just don't know that they also use this building location because they word it through stb icu or cardiac unit or something. It would be worth updating and linking those reports so that, when a location related to them changes, we will be easily able to find it on the wiki and know the underlying SAS might need updating. Ttenbergen 12:35, 20 March 2025 (CDT) | 2025-03-21 3:27:04 AM |
| edit | SBGH L2 | Lisa |
We need to clean up this page and likely some linking to it. I don't know the truth on the ground so can't just do it. Something do do in one of the wiki wrangling efforts LK and TT may want to schedule one of these days. Ttenbergen 12:35, 20 March 2025 (CDT) | 2025-03-21 3:27:04 AM |
| edit | Scanning to network | Julie | That scanner is gone, right? | 2025-03-18 11:06:02 PM |
| edit | Service/Location field | Lisa |
is this section still current? Ttenbergen 11:13, 6 March 2025 (CST)
It up for discussion tomorrow at JALT Meeting - Rolling Agenda and Minutes 2025 Lisa Kaita 21:04, 10 March 2025 (CDT)
Allan spoke with Bojan, to be discussed at next JALT Lisa Kaita 14:48, 16 April 2025 (CDT) | 2025-04-16 7:48:25 PM |
| edit | Standard data cleaning process | Julie |
While discussing Visit Admit DtTm differences within same admission at JALT Meeting - Rolling Agenda and Minutes 2025#JALT 2025-03-11 I realized we don't have any part of your "cleaning" process documented. We should, even if it is a rudimentary notice of the SAS files you use and what you check for. Ttenbergen 21:51, 11 March 2025 (CDT)
If there is linking beyond Populate linking pairs, or if you use a different linkage, we need to document that as well; do you? Ttenbergen 21:51, 11 March 2025 (CDT) | 2025-03-12 2:51:43 AM |
| edit | STB CICU Admissions start at Arrive DtTm | Lisa | Moved here from Service tmp entry to avoid duplication, will need validating and integrating into this page:
at StB, the Service tmp date and time for ICU patients coming from ER is taken from the orders. If the time is written after the patient has already arrived to the ICU, the Service tmp date and time is the same time as the Boarding Loc time
if the patient is coming from the Cath Lab, or the OR, the time is obtained from the ICU flowsheet | 2025-03-19 2:55:54 PM |
| edit | STB IMCU | all | is there a successor? | 2025-03-20 5:35:06 PM |
| edit | Task Team Meeting - Rolling Agenda and Minutes 2025 | all | Someone will need to update Template:ICD10 Recent Previous Pneumonia and/or Template:ICD10 Guideline Pneumonia with this decision. Ttenbergen 22:27, 19 May 2025 (CDT) | 2025-05-20 4:27:59 AM |
| 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?
I have sent an email to John Lisa Kaita 20:49, 10 March 2025 (CDT)
I think we can leave things as is for now, as this doesn't happen all that often, like MRSA, if it becomes more prevalent we can revisit this Lisa Kaita 14:41, 16 April 2025 (CDT) | 2025-04-16 7:41:58 PM |
| edit | Template:ICD10 Guideline Pneumonia | Allan | A decision to change this was made at Task Team Meeting - Rolling Agenda and Minutes 2025#ICU Database Task Group Meeting – May 14, 2025. This template will need to be updated with the decision. | 2025-01-10 2:31:16 AM |
| edit | Template:ICD10 Guideline Pneumonia | Allan | that's supposed to say "on admission", not "on infection", right ? | 2025-01-10 2:31:16 AM |
| edit | Template:ICD10 Recent Previous Pneumonia | Allan | A decision to change this was made at Task Team Meeting - Rolling Agenda and Minutes 2025#ICU Database Task Group Meeting – May 14, 2025. This template will need to be updated with the decision. | 2025-05-20 3:55:55 AM |
| edit | Template:ICD10 Recent Previous Pneumonia | Allan | that's supposed to say "on admission", not "on infection", right ? | 2025-05-20 3:55:55 AM |
| edit | Visit Admit DtTm differences within same admission | all |
This came up again during Re-analysis and generation of Overstay2 model. We need to add here what we learned and what we need to do about this. Ttenbergen 15:12, 23 February 2025 (CST) | 2025-02-23 9:12:56 PM |