Portal related pages with questions

Data User Portal for the Manitoba Critical Care and Medicine Databases has a audience outside of our organization, so we should attempt to keep on top of Category:Questions on pages that are linked from there. There is no easy way to do this for pages that are linked from there, specifically, but most pages linked from there are in one of the following categories: Category:Data structure, Category:Project or Category:Indicators. Here is a list of pages that are in one of those categories and that have questions:

	Who	DiscussQuestion	ModDtTm"Modification date" is a predefined property that corresponds to the date of the last modification of a subject and is provided by Semantic MediaWiki.
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)	18 March 2025 22:18:15
Chronic Health Facility	all Lisa Tina	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. 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) 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) Do we need to consider 1010 Sinclair separately as well? 1010 sinclair is an independent apartment living see https://tenten.mb.ca/housing/1010-sinclair-street/. so I would think this might be home or community facility with support? Lisa Kaita 12:49, 10 March 2025 (CDT) 1011 supports ventilated patients (or used to anyway, so that's pretty heavy support... Ttenbergen 17:54, 10 March 2025 (CDT) Any others we might need to consider separately? 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. 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.	20 March 2025 02:47:21
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)	5 December 2024 15:52:23
Dispo field	Lisa all	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 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 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)	24 March 2025 22:53:08
ER Delay	all Julie	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) 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) 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)	18 March 2025 22:18:16
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?	15 March 2025 03:15:57
LAU LTC consult	Lisa	For any record collected as part of LAU Collection Project, enter... For every LAU Collection Project who XXX enter the following: Project: ?? - Item: "??" Date/Time: ?? Orders consult section progress notes EPR ER notes/documents	18 March 2025 16:56:43
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. 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	18 March 2025 17:00:04
LAU Public Trustee	Lisa	For any record collected as part of LAU Collection Project, enter... For every LAU Collection Project who XXX enter the following: Project: ?? - Item: "??" Date/Time: ?? Orders consult section progress notes EPR ER notes/documents	18 March 2025 16:56:47
LAU collection readmission data	Lisa	We need to decide if we will use the criteria set out in Readmission to MedWard The criteria may be too restrictive for the LAU project. waiting for Dan to weigh in also see Discharged to community decided not to use the Readmission to MedWard criteria instead use criteria of readmission within 7 days of previous inpt admission (any inpt location) or readmission within 7 days after current admission. 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)	14 March 2025 00:16:04
Overstay2 data processing and reporting in CFE	all Tina	Nothing yet, fill in as it becomes available. add functions/subs when I finalize this	23 February 2025 22:13:18
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)	23 February 2025 22:22:38
Overstay2 scoring model	all	add the content for the chosen model 8 here, with links	28 February 2025 21:00:24
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) 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)	28 February 2025 17:36:05
Project Overstay2	Julie Tina all	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) 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) 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)	5 March 2025 01:56:38
Re-analysis and generation of Overstay2 model	all Julie Tina	add a table of admission numbers by year and site What was the consideration for the initial choice of, I think, 0.051? initial thoughts were "15-17% being red, with an aim to get 60-75% of overstay patients" 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) 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) Still needs: considerations values we considered and rejected minimize duplication of Data definition for contributing factors for the Overstay2 project where? still needs to be set up by Tina... the statistical tests that were done to evaluate the model the factors leading to our decision on "Model 8" links to files 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)"? Also see Discharged to community number	11 March 2025 22:24:07
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.	20 March 2025 02:51:18
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)	17 March 2025 17:04:47
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)	12 March 2025 05:26:14
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)	11 March 2025 22:09:28
s_dispo.geog	Julie	== Use == ??? Should these be geog = winnipeg Interventional Radiology Other Procedure Location	12 March 2025 04:47:50
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)	11 March 2025 22:13:35

Review

This article is tagged to be reviewed periodically. The next scheduled review is on 1 Jan 1900.