Property:DiscussQuestion
Jump to navigation
Jump to search
This is a property of type text.
P
'''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. +
s
* "Hospice - other, WPG" is currently not grouped as Hospital = "Other Institution in WPG" as the other hospices - should it be? [[User:Ttenbergen|Ttenbergen]] 17:03, 11 March 2025 (CDT)
+
D
* 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).
+
P
*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*"! [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 16:51, 24 January 2025 (CST)
+,
*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. [[User:Ttenbergen|Ttenbergen]] 19:15, 25 January 2025 (CST)
*** correct, there are selected subcategories and also FULL CHARLSON SCORE for those from Nursing Home. --[[User:JMojica|JMojica]] 09:29, 27 January 2025 (CST)
** I think "connective" became "Rheumatic disease" in ICd10, right? [[User:Ttenbergen|Ttenbergen]] 16:41, 24 January 2025 (CST)
*** Yes it refers to Connective Tissue Disease-Rheumatic Disease. --[[User:JMojica|JMojica]] 09:29, 27 January 2025 (CST)
+,
* 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. [[User:Ttenbergen|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 . --[[User:JMojica|JMojica]] 09:29, 27 January 2025 (CST)
+
J
* Could you summarize what we would need to change from [[ICUotherService]] to get to this? It sounds similar. [[User:Ttenbergen|Ttenbergen]] 13:25, 17 March 2025 (CDT)
+
C
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. +,
* review, that might need to be consolidated with this page as well.
+,
* These should be made consistent with [[Template:PCH Riverview Deer Lodge]] and should probably use that template to enforce consistent use. [[User:Ttenbergen|Ttenbergen]] 14:23, 2024 October 16 (CDT)
** and I have lost track of the details [[User:Ttenbergen|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...[[User:Ttenbergen|Ttenbergen]] 20:27, 2024 December 11 (CST)
+, …
* 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. [[User:Ttenbergen|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. --[[User:JMojica|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.--[[User:JMojica|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. [[User:Ttenbergen|Ttenbergen]] 18:08, 29 January 2025 (CST)
+
* Do we need similar instructions or mechanisms as for MRSA for this one? eg coding for [[Resistance to carbapenem antibiotics]]? [[User:Ttenbergen|Ttenbergen]] 11:18, 18 February 2025 (CST)
* I'm not clear on what you are asking [[User:Lkaita|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. [[User:Ttenbergen|Ttenbergen]] 00:51, 11 March 2025 (CDT)
+
L
* 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.
+,
* 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?
** I think so
*** OK, will set up [[Query check_Project_OT_PT_Consults]]
+
P
* Do we want that to be the first time during a medicine program admission, or only the first time during a hospitalization? [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 08:51, 26 February 2025 (CST)
** emailed DR about this [[User:Ttenbergen|Ttenbergen]] 11:36, 28 February 2025 (CST)
+,
* 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. [[User:Ttenbergen|Ttenbergen]] 08:49, 26 February 2025 (CST)
** emailed DR about this [[User:Ttenbergen|Ttenbergen]] 11:36, 28 February 2025 (CST)
+
R
L
* 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. [[User:Ttenbergen|Ttenbergen]] 22:49, 11 March 2025 (CDT)
+
E
* 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 <span class="info-tooltip">[[Regional Server]]\/output<span class="tooltip-text">\\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\/output </span></span> 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. [[User:Ttenbergen|Ttenbergen]] 10:41, 2024 November 30 (CST)
+
S
* 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. [[User:Ttenbergen|Ttenbergen]] 12:35, 20 March 2025 (CDT)
+,
* 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. [[User:Ttenbergen|Ttenbergen]] 12:35, 20 March 2025 (CDT)
+
E
* 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. [[User:Ttenbergen|Ttenbergen]] 13:25, 2022 June 28 (CDT)
** emailed Tina some inconsistencies found in ER Delays Aug 15,2022. --[[User:JMojica|JMojica]] 13:21, 2022 August 29 (CDT)
*** are these still an issue? [[User:Ttenbergen|Ttenbergen]] 11:15, 2024 May 1 (CDT)
**** I will re-check again. Can't remember if have been resolved. --[[User:JMojica|JMojica]] 14:40, 2024 October 2 (CDT)
+,
* 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? [[User:Ttenbergen|Ttenbergen]] 22:50, 2024 November 16 (CST)
+,
* 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. [[User:Ttenbergen|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. --[[User:JMojica|JMojica]] 16:35, 2024 December 11 (CST)
+
Q
* 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. [[User:Ttenbergen|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. [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 15:36, 2022 March 24 (CDT)
+
A
* I think this might be what is changing ti "Left Post Initial Treatment" after the email from 2025-02-20. [[User:Ttenbergen|Ttenbergen]] 11:00, 20 February 2025 (CST)
+
* 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 [[User:Ttenbergen|Ttenbergen]] 11:34, 2022 February 9 (CST)
*** Allan is negotiating inclusion of Labs data with Grace hospital as per [[Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2023#ICU Database Task Group Meeting – April 19, 2023]], leaving this flagged to ensure update. [[User:Ttenbergen|Ttenbergen]] 14:00, 2023 May 17 (CDT)
+