| | Question | Modification date"Modification date" is a predefined property that corresponds to the date of the last modification of a subject and is provided by Semantic MediaWiki. | Last editor is"Last editor is" is a predefined property that contains the page name of the user who created the last revision and is provided by Semantic MediaWiki. |
|---|
| Intended1stSrvc |
- I don't think any checks are possible for this, or can someone think of one?
This project is not live yet, do not follow the instructions to stop the old collection yet. I hope to have this set up to start collecting with the new instructions Dec1. For now, continue to use the instructions in ICUotherService. Ttenbergen 14:27, 26 September 2025 (CDT)
is that the right report? I have added this new data to that report's dependencies. If it's the wrong one it will need to be taken out of there. If other reports also use this, it will need to be added to them. If only that report you can remove this comment. Ttenbergen 15:20, 26 September 2025 (CDT)
- Yes, the plan is to show them here - the intended 1st service along with the other scenarios which will be presented maybe tabular or graphical (preferably). --JMojica 17:06, 18 December 2025 (CST)
Things we need to resolve:
- We need to review anything that links to ICUotherService, and anything that page lists to. The "anything that links there" can be accessed by expanding the "related articles (expand)" at the bottom of ICUotherService. Ttenbergen 10:59, 25 September 2025 (CDT)
- This Intended1stSrvc assumes a whole stay on the borrowed service. How about the case where there is only partial stay being taken care by borrowed service and then the patient now becomes a legit patient of that service. Example, Intended1stSrvc is STB ICSM taken care by ACCU service (May 24,2023 13:17) boarding at ACCU bed , then by May 26,2023 15:40 became an ACCU patient taken care by ACCU in same ACCU bed until discharge to ward June 5,2023 16:22. This is currently just one record. For me to breakdown the days, there is a need to enter the start dttm and/or end dttm aside from the intended unit. OR Should this case be two records, thus there is no need to enter dttm?--JMojica 17:31, 18 December 2025 (CST)
as per JALT Meeting - Rolling Agenda and Minutes 2025#JALT 2025-12-18, needs to be integrated:
- We agreed that the options for the dropdown listings should all be the same for Boarding Loc, Service/Location, and the new field Intended1stSrvc, and that these will be the same as those currently used for Boarding Loc, i.e: HSC-MICU, HSC-SICU, HSC-IICU, STB-MICU, STB-CICU, STB-ACCU and GH-CC
- We recognize that these will then be different from the "official" ADT services listings provided to us in Cognos2
| 19 December 2025 04:13:49 | Ttenbergen |
| s_dispo table |
"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)
| 27 September 2025 02:12:27 | Ttenbergen |
| Beds occupied by transferrable patients (Critical Care) |
| 7 December 2025 21:02:14 | Ttenbergen |
| Transfer Delay (Critical Care) |
- The Dispo location will be used to define the destination. As per Dr. Garland & Dr. Paunovic.
- I think we discussed at Task that we will do this differently now... right?
- The above is really about stratification, and not the indicator itself. Do you really only use it to stratify delays, or do you also report other indicators such as Length of Stay with it. Even if it is single-use, I think we should probably treat any generated value we use to stratify pretty much as we do Indicators, possibly using the same templates on the wiki. The stratification affects averages and totals, so it needs to be transparent. This is likely a can of worms because there must be much stratification in the reports. Ttenbergen 14:50, 7 December 2025 (CST)
| 7 December 2025 20:50:58 | Ttenbergen |
| Dispo field | 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)
JALT
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)
- no because the previous location would usually be <site>_ER Lisa Kaita 09:53, 28 May 2025 (CDT)
- Sorry, I should have asked about "pre-hospital location in ADT". Ttenbergen 16:21, 28 May 2025 (CDT)
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
- what is this about again? we already collect these with the exception of the transitional care units, which don't exist, at GH, HSC, SBGH and VIC, but there is a TCU at Miseri and DLC Lisa Kaita 21:18, 6 September 2025 (CDT)
- we discussed whether we should shift to EPR's "TRSF to Residential Care" and decided not to because our data is more granular. But we should be able to compare to their TRSF, so should understand which of our data would compare to theirs, and how. I think the above is a list of what we have in dispo, so which of those correspond do what listing in EPR? Ttenbergen 10:31, 8 September 2025 (CDT)
- Are there others? I think H6...
JALT Task
- Home O2 return
- Those that have home O2 prior to admission, and go home with O2, do we use Home with support services everytime? Or is it only during the first time they get set up with home O2 service?
Allyson Alcudia 14:40, 12 December 2025 (CST)
JALT Task
- Private Nursing Service
- does this include patients who are discharged home with private nursing service? (steph)
- With "this" do you mean "TRSF Group/Supportive housing"? I would not have thought so. If you mean "Home with Support Services", good question. How would HIS use it (aside from getting it wrong at times)? We should probably stick with their definition for consistency. Convince me otherwise. Julie also might have thoughts on how we would use this entry, will flag for her. Ttenbergen 01:02, 24 October 2025 (CDT)
- I think this would be belong under home with support services...Lisa Kaita 14:03, 14 November 2025 (CST)
JALT Task
- HSC Virtual Ward
- .... but do the virtual wards fall under transfer to Group/Supportive housing? Lisa Kaita 14:03, 14 November 2025 (CST)
- is there more than on VW now? Ttenbergen 22:07, 18 December 2025 (CST)
| 19 December 2025 04:07:48 | Ttenbergen |
| Service tmp post-send consistency checks |
As discussed at JALT Meeting - Rolling Agenda and Minutes 2025#JALT 2025-11-27: Do we need any post-send, cross-record checks relating to Service tmp entry? Ttenbergen 16:44, 27 November 2025 (CST)
| 27 November 2025 22:44:27 | Ttenbergen |
| Postal_Code_Master table |
- Do we want a regular update process? See comments in that file. Ttenbergen 12:15, 4 August 2025 (CDT)
| 4 August 2025 17:33:09 | Ttenbergen |
| Parked in ER |
| 31 July 2025 03:06:45 | Ttenbergen |
| John or Jane Doe patient |
- Entries for these would affect Overstay2 Overview and initial entry practice isn't currently clear in Minimal Data Set; is there anything we need to review with that in mind? Ttenbergen 13:47, 20 June 2025 (CDT)
- Most of our JD patients are identified at some point during their admission, I can't think of any that haven't been, are there many in the database? Lisa Kaita 21:29, 6 September 2025 (CDT)
- We use some of this data while incomplete, and it also has been a candidate for overstay parameters. Think of it coming from the "is this patient from Manitoba" vs "is this patient a JD". Even if they eventually become identified, that doesn't help with initial data. We are trying to define how this data should be handled in that scenario as well. Ttenbergen 10:13, 8 September 2025 (CDT)
- Julie had added some chart info for JD patients to the Postal code page, but its about chart so belongs here or in the chart page. So: do we want to consolidate the JD info here and link to field pages, or in field pages and link to this and use this just as an index? Or do we want templates for each so we can list the whole bit consistently on both? Ttenbergen 09:47, 11 August 2025 (CDT)
|
- Entries for these would affect Overstay2 Overview and initial entry practice isn't currently clear in Minimal Data Set; is there anything we need to review with that in mind? Ttenbergen 13:47, 20 June 2025 (CDT)
- Most of our JD patients are identified at some point during their admission, I can't think of any that haven't been, are there many in the database? Lisa Kaita 21:29, 6 September 2025 (CDT)
- We use some of this data while incomplete, and it also has been a candidate for overstay parameters. Think of it coming from the "is this patient from Manitoba" vs "is this patient a JD". Even if they eventually become identified, that doesn't help with initial data. We are trying to define how this data should be handled in that scenario as well. Ttenbergen 10:13, 8 September 2025 (CDT)
- Julie had added some chart info for JD patients to the Postal code page, but its about chart so belongs here or in the chart page. So: do we want to consolidate the JD info here and link to field pages, or in field pages and link to this and use this just as an index? Or do we want templates for each so we can list the whole bit consistently on both? Ttenbergen 09:47, 11 August 2025 (CDT)
| | 8 September 2025 15:13:24 | Ttenbergen |
| Transfer Ready DtTm tmp entry |
- Grace Hospital not filled this out according to instructions documented here, but some old version instead. That makes data between GRA and other sites problematic to compare. Lisa and Gail have more info. We should document which version they have been using so it can be accounted for when using this data.
| 27 June 2025 19:15:51 | Ttenbergen |
| Transfer Delay (Medicine) |
- How about scenario Med(with TR) -> HOBS -> Med(with TR) -> hosp discharge
- According to the definition that would result in two delays but we only get a single Delay metric per record. So is it
- (a) sum (time from TR1 to start of HOBS, time from TR2 to hosp discharge)
- (b) sum (time from TR1 to start of HOBS, entire time at subsequent med level of care locations)
- In Beds occupied by transferrable patients (Medicine) you state that the metric is per patient, but is it really per patient, per record or per boarding loc? So if a patient goes from a boarding loc to another and back to the first, you presumably report the sum of the time at that loc for that pt, but for an average, would the N be 1 patient or 2 records? To take that further, if the pt goes to ICU and then comes back, would the N become 3? the inclusion criteria on that page don't really clarify how this is resolved.
I realize we were breaking out these indicators and trying to have each explained all on page for ease of use by report users, but this is an example where I think it would be better to define things like 'the transfer delay complex' as individual indicators, individual stratifiers, and then possibly define a compound indicator that combines them, but refers to the earlier definitions. It makes it slightly harder to follow, but hopefully anyone who actually looks at a data definition value coherence of the details over light reading.
- Also, I realize it's more friendly to read in indicators that something is "per patient", but I think it is also important to be specific about this, so suggest we should change this to be the actual N used in any of our indicators.
- in file 20_... for GRA data Julie provides an explanation that may resolve this question. I am putting it below. If I understand that one correctly,
- W1 - W1TR - W2 - H1 - W3 - W3TR - Dispo would result in a delay of dispo-W1TR
- W1 - W2 - W2TR - H1 - W3 - W3TR - Dispo would result in a delay of dispo-W3TR
- Is that the right understanding? If Julie agrees the discussion can go.
| 11 December 2025 07:22:50 | Ttenbergen |
| SBGH L2 |
- 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)
- 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)
| 21 March 2025 03:27:04 | Ttenbergen |
| ER Delay |
- 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)
- This measure is not referenced by any of the Reports pages. Which reports actually use this? Is it wrapped into a specifically stratified indicator like beds lost or similar? Ttenbergen 15:14, 7 December 2025 (CST)
| 8 December 2025 22:03:52 | Ttenbergen |
| Transfer for bed management |
- which of the reports/indicators is affected by this? You were working with Bojan to get a metric.... Ttenbergen 17:37, 27 November 2025 (CST)
| 28 November 2025 15:00:46 | Lisa Kaita |
| Decubitus (pressure) ulcer, stage not indicated, of heel |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:56:14 | Ttenbergen |
| Decubitus (pressure) ulcer, Stage IV (involves muscle, tendon, or bone) |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 1 July 2025 02:48:33 | Ttenbergen |
| Decubitus (pressure) ulcer, Stage II (to fascia, just under skin), of other area |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:49:54 | Ttenbergen |
| Decubitus (pressure) ulcer, Stage I (surface reddening) |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 1 July 2025 02:48:27 | Ttenbergen |
| Decubitus (pressure) ulcer, Stage I (surface reddening), of other area |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:49:34 | Ttenbergen |
| Decubitus (pressure) ulcer, Stage III (deep, to but not including muscle) |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 1 July 2025 02:48:57 | Ttenbergen |
| Decubitus (pressure) ulcer, Stage III (deep, to but not including muscle), of sacral area |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:50:03 | Ttenbergen |
| Decubitus (pressure) ulcer, stage not indicated, of other area |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:56:19 | Ttenbergen |
| Pressure-induced deep tissue damage, of heel |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:50:50 | Ttenbergen |
| Decubitus (pressure) ulcer, Stage II (to fascia, just under skin) |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 1 July 2025 02:48:29 | Ttenbergen |
| Decubitus (pressure) ulcer, Stage IV (involves bone), of other area |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:50:36 | Ttenbergen |
| Decubitus (pressure) ulcer, Stage III (deep, to but not including muscle), of other area |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:50:15 | Ttenbergen |
| Pressure-induced deep tissue damage, of sacral area |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:50:43 | Ttenbergen |
| Decubitus (pressure) ulcer, Stage IV (involves bone), of sacral area |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:50:21 | Ttenbergen |
| Decubitus (pressure) ulcer, stage not indicated |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 1 July 2025 02:48:35 | Ttenbergen |
| Decubitus (pressure) ulcer, stage not indicated, of sacral area |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:56:12 | Ttenbergen |
| Decubitus (pressure) ulcer, Stage III (deep, to but not including muscle), of heel |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:50:08 | Ttenbergen |
| Decubitus (pressure) ulcer, Stage II (to fascia, just under skin), of sacral area |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:49:42 | Ttenbergen |
| Decubitus (pressure) ulcer, Stage II (to fascia, just under skin), of heel |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:49:47 | Ttenbergen |
| Decubitus (pressure) ulcer, Stage I (surface reddening), of sacral area |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:48:54 | Ttenbergen |
| Pressure-induced deep tissue damage, of other area |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:50:56 | Ttenbergen |
| Decubitus (pressure) ulcer, Stage I (surface reddening), of heel |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:49:29 | Ttenbergen |
| ICD10 Guideline Decubitus Ulcer |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 14 August 2025 16:15:46 | Ttenbergen |
| Decubitus (pressure) ulcer, Stage IV (involves bone), of heel |
- Julie will report on the worst stage from Acquired Diagnosis
- How will that work now with the locations included? How will the report aggregate? And: which report? It should link to the diagnoses using the wiki infrastructure. If you tell me which report(s) I can set that up. Ttenbergen 15:35, 30 June 2025 (CDT)
- what is the rank of this in relation to decubitus stages? is this before stage 1 or what? - Julie
- By "this" do you mean the Category:Decubitus Deep Tissue Damage? It's not before 1, it's a different thing and can apparently be serious, and likely to progress to a higher stage pressure ulcer. Might be best to report it as its own thing. Ttenbergen 01:25, 31 July 2025 (CDT)
- Julie emailed Carmen Hrymak 7/13/2025 to inquire about the reporting of ulcer rate now that the locations of ulcer were added. Waiting for response.
| 23 October 2025 19:50:29 | Ttenbergen |
| O365 Testing |
- The laptop doesn't have SAS so we need to plan separately for testing this. Julie, what are your thoughts?
| 18 October 2025 02:47:30 | Ttenbergen |
| Decubitus Ulcer Study |
- This data is not in the tmp table (at least not under a project "Decubitus Ulcer". Where does it live?
| 23 October 2025 20:21:24 | Ttenbergen |
| Project Overstay2 |
- We have had patients admitted from the chronic care unit at DLC (they live there) the nurses check off PCH for where they reside (on DPST), for Pre acute living situation field we enter Chronic Health Facility and for dispo we enter Deer Lodge, should we be considering this a PCH? as per instructions on DPST they do not continue the DPST form Lisa Kaita 12:35, 24 November 2025 (CST)
- yes that answers my question, for the most part we can figure it out through the notes, lets leave collection as is. If you are ok with this lets take it off the JALT list Lisa Kaita 09:06, 17 December 2025 (CST)
- Agreed it doesn't need to be on JALT. I will keep it around as a comment because it's part of the whole Chronic Health Facility issue. Ttenbergen 11:44, 17 December 2025 (CST)
| 17 December 2025 17:44:01 | Ttenbergen |
| SAS |
- What is the correspondence of generating SAS files to those programs? Are there naming or folder structure conventions? Ttenbergen 17:58, 25 June 2025 (CDT)
| 30 June 2025 06:12:36 | Ttenbergen |
| Re-analysis and generation of Overstay2 model | still needs to be set up by Tina...
Still needs:
- considerations
- values we considered and rejected
- minimize duplication of Data definition for factor candidates for the Overstay2 project, things that users of the data need to know going forward need to live there, decisions taken that don't affect ongoing process should be documented here.
- When I looked at your code that breaks out Location / living arrangement into groupings and measures it seemed to me that it was mixing up data cleaning and validation with measure definition and it might be good to keep those separate. Cleaning and validation should apply to the data in general, not just this model, no? It would make sense to document the steps taken and things found and remedies implemented on this page, but having them part of the definition seems problematic. I think I sent that as an email, but I think it would be better to track this on the wiki to have a trail for the decisions. Ttenbergen 12:03, 25 June 2025 (CDT)
| 12 August 2025 20:43:59 | JMojica |
| Standard data cleaning process |
| 12 March 2025 02:51:43 | Ttenbergen |
| Manitoba RHAs |
| 20 June 2025 19:53:36 | Ttenbergen |
| s_dispo.loc_type |
- 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 | Ttenbergen |
| Service/Location field |
- 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)
- still being discussed at JALT Lisa Kaita 21:45, 9 September 2025 (CDT)
- OK, discussion seems to be complete, we will change ICUotherService to Intended1stSrvc. I have cleaned up most peripheral links, but Lisa, could you make sure that this page reflects post-ICUotherService collection instructions? Any info about the change should really only be in 2025-05 Revision of concept around ICUotherService, which I have already linked from the legacy section of this page. We need to make sure that the info to make sense of the continuity of the data lives in that page. Ttenbergen
- What will be the turn-over for this? New admissions starting Oct 1? Ttenbergen 14:54, 26 September 2025 (CDT)
|
- 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)
- still being discussed at JALT Lisa Kaita 21:45, 9 September 2025 (CDT)
- OK, discussion seems to be complete, we will change ICUotherService to Intended1stSrvc. I have cleaned up most peripheral links, but Lisa, could you make sure that this page reflects post-ICUotherService collection instructions? Any info about the change should really only be in 2025-05 Revision of concept around ICUotherService, which I have already linked from the legacy section of this page. We need to make sure that the info to make sense of the continuity of the data lives in that page. Ttenbergen
- What will be the turn-over for this? New admissions starting Oct 1? Ttenbergen 14:54, 26 September 2025 (CDT)
| | 26 September 2025 19:54:49 | Ttenbergen |
| ICUotherService |
- what does this mean split HSC CC records by service rather than by program only? no more documentation of borrowed bed and service say, SICU overflow in MICU or MICU overflow in SICU? --JMojica 11:20, 15 September 2025 (CDT)
| 27 November 2025 16:14:17 | Ttenbergen |
| Readmission to MedWard |
- 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.
- In a meeting with Dan, Julie and Tina we also realized we need to include the newer home with supports etc in the definition of where someone was discharged to, and we may want to base this on Visit_Admit_dttm instead and so consider re-admission to either CC or med. If I understand right, the current definition considers someone who is re-admitted to ED the next day but then spends a week in CC before coming to a medicine bed is not considered a re-admission to medicine. I think EMIPs are excluded in the same way.
| 24 November 2025 21:36:16 | Ttenbergen |
| Change to coding locations for Decubitus Ulcers |
- will there be a regular report for Andie, or is the change to ICU Acquired Ulcer Rate all that was needed? If so, here is the start, lets spin it out into its own page. If not, we can delete this discussion. Ttenbergen 23:31, 11 July 2025 (CDT)
Once complete the following section is used on any report page to provide structured data
- the following is needed for the application of the Report template
Program: Critical Care
StartDtTm: <eg 2018-01-01>
EndDtTm: <eg 2018-01-01>
Frequency: <eg monthly, quarterly, annually, as requested>
ContactPerson: <names, organization if outside of Shared Health>
Recipients: <names>
MailingList: <Outlook list if applicable>
DataDependencies: <likely list of dxs, possibly including admit or dispo dttm>
SASFiles: <path(s) for SAS files>
| 23 October 2025 20:26:20 | Ttenbergen |
| Boarding Loc | what is this sentence telling me, can I not use the specific medicine entry? Why/how? What would a new collector need to know?
- I have no idea, I suppose this can happen although I have not ever seen this at any of the facilities, I believe you were the original author of this so feel free to do what you want with this Lisa Kaita 13:46, 6 August 2025 (CDT)
- Julie, do you know what this is about? If the same applies for Med as for ICU in this, then lets get rid of the confusing entry. Ttenbergen 17:23, 6 August 2025 (CDT)
- we have one case S4_STB_Med-2892 where first3 days at SBGH ICMS then transferred to SBGH-L2CC.--JMojica 16:42, 18 August 2025 (CDT)
- What else would they use? The entry would come from Cognos, no? It's entered by drop-down, so I don't think they could enter anything but the actual entry. Is this stated here really as a reminder for you, in case this happens again? If so, would it be better to store it in L_Problems table? If it is an instruction to collectors, would you explain further what you actually intend? Ttenbergen 17:33, 19 August 2025 (CDT)
- leave what is in Cognos, the main office doesn't use this part for anything for home locations, but it can be used to crosscheck accuracy.
- what is this about? Ttenbergen 17:42, 19 August 2025 (CDT)
It says:
- Change one to be off by one minute, put a note in Notes field to check boarding location to confirm the correct date and time for the boarding locations of concern.
- how does that fit in with reviewing reality in the chart?
- I don't know what you mean by this? It means you double check the correct first service and first and second boarding loc dttm Lisa Kaita 21:14, 6 September 2025 (CDT)
- Well, it seems like this triggers an error check, so you pull the times a minute apart to overcome the error check and put a note to remind you to check later. So either the check should run later (on complete or send) or we shouldn't have it at all. But a check that just gets you to "tweak" the data to make it go away isn't a good idea.
- sure if you can have the cross check on completion that would be better, the prior scenario is almost always for SICU admissions from ER Lisa Kaita 15:51, 26 November 2025 (CST)
- Julie, do you use Boarding Loc info on incomplete charts? Would either the current collection practice, or delaying the check, mess with measures or indicators? Ttenbergen 22:09, 26 November 2025 (CST)
| 27 November 2025 04:09:31 | Ttenbergen |
| Query Check_VADT_too_close_to_first_boarding_loc | We discussed this in our after-Task meeting 2023-07-23 and I just stumbled across it. I do not remember what this was about, nor what a reasonable delay would be. Could one of you fill in the details for the query if we still want it? No hurry. In fact I'd prefer if you not hurried ;-). Ttenbergen 21:38, 13 August 2025 (CDT)
this came about when the Pre-admit Inpatient Institution location is own site and previous location is own ER and the VADT is too close to first boarding loc dttm. If I remember correctly you mentioned 6 hours (0.25d) gap as maybe entry error on the preadmit inpt. Is 12 hours (0.50d) reasonable? --JMojica 09:23, 14 August 2025 (CDT)
|
|
We discussed this in our after-Task meeting 2023-07-23 and I just stumbled across it. I do not remember what this was about, nor what a reasonable delay would be. Could one of you fill in the details for the query if we still want it? No hurry. In fact I'd prefer if you not hurried ;-). Ttenbergen 21:38, 13 August 2025 (CDT)
- this came about when the Pre-admit Inpatient Institution location is own site and previous location is own ER and the VADT is too close to first boarding loc dttm. If I remember correctly you mentioned 6 hours (0.25d) gap as maybe entry error on the preadmit inpt. Is 12 hours (0.50d) reasonable? --JMojica 09:23, 14 August 2025 (CDT)
| | 19 August 2025 22:10:00 | Ttenbergen |
| 2025-05 Revision of concept around ICUotherService | Lose ends:
|
|
Lose ends:
| | 17 December 2025 15:24:43 | Lisa Kaita |
| s_dispo.geog | == Use ==
???
Should these be geog = winnipeg
- Interventional Radiology
- Other Procedure Location
| 12 March 2025 04:47:50 | Ttenbergen |
| Cognos downtime procedure | Are there any hard commitments? Soft commitments? | 8 October 2025 01:19:28 | Lisa Kaita |
| L TmpV2 multi-entry clean-up | 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 | Ttenbergen |
| DSM Labs data.accdb | Emailed Julie:
found overlap in old file, what does it mean
proposed using labDtTm for split threshold
Ttenbergen 16:51, 2024 May 2 (CDT) | 30 June 2025 06:12:40 | Ttenbergen |
| Unit Mortality | I seem to remember hearing that this excludes palliative patients or something like that. If not, did it use to? If it used to and changed we should state that here. If it still does, or never did, we might want to be specific about that above so it doesn't come up again. | 8 December 2025 22:40:52 | Ttenbergen |
| s_dispo.center | 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 | Ttenbergen |
| Scanning to network | That scanner is gone, right? | 18 March 2025 23:06:02 | Ttenbergen |
| Respite care | There have only been 17 of these ever, last in 2022. Do we treat these different / exclude them from any indicators like we do with palliative etc pts? Ttenbergen 14:52, 16 June 2025 (CDT) | 16 June 2025 19:52:46 | Ttenbergen |
| Query check_tmp_Overstay2 | others? | 7 August 2025 16:32:42 | Lisa Kaita |