Statistician

From CCMDB Wiki
Jump to navigation Jump to search

p:Julie Mojica is the full time Statistician for the Critical Care and Medicine Database.

She provides Statistical Analysis and Reporting using our data.

The Statistician is a member of the Steering Committee & the Task Team.

Indicators w questions

edit page question Description
edit page question Description
edit Beds occupied by transferrable patients (Critical Care) Beds Occupied by Transferable Patients is the average number of ICU bed per day being occupied by the patient no longer requiring the intensity of care provided in an ICU setting. Another term used to call it is Wasted beds.
edit 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?
    		•  Transfer Delay is the difference between Dispo_DtTm and #Transfer Ready DtTm in use at different times in decimal days.
    edit 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.
    		 Transfer Delay is the difference between Dispo_DtTm and #Time patient is ready for transfer in decimal days. Other terms use to call it are Beds Occupied by transferable patients, Wasted Beds, Avoidable Days.
    edit ER Delay
    • 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)
    		 The ER Delay is the difference between the initial ER Boarding Loc and first post-ER Boarding Loc, for patients arriving from the ER.
    edit Transfer Delay (Critical Care)
  • 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)
    		•  Transfer Delay is the difference between Dispo_DtTm and #Transfer Ready DtTm in use at different times in decimal days.
    edit ER Delay
  • 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)
    		•  The ER Delay is the difference between the initial ER Boarding Loc and first post-ER Boarding Loc, for patients arriving from the ER.
    edit ER Delay
  • 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)
    		• The ER Delay is the difference between the initial ER Boarding Loc and first post-ER Boarding Loc, for patients arriving from the ER.
    edit 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.
    		•  Number of Ward readmission within 7 days per 100 discharges from discharging hospital.
    edit 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. Percent unit deaths per calendar month

    Reports w questions

    No questions found

    Questions on wiki

    Here is a list of questions driven by the Template:Discuss that have been flagged for Julie.

    edit page question ModDate
    edit page question ModDate
    edit Beds occupied by transferrable patients (Critical Care) 2025-12-07 9:02:14 PM
    edit 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?
    		•  2025-12-07 8:50:58 PM
    edit 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)
    		•  2025-09-27 2:12:27 AM
    edit Manitoba RHAs
  • Manitoba RHAs is not currently considered under Data Dependencies, a blind spot we should probably fix if we do, we should probably do it by making separate pages for Postal_Code_Master.rhaname and s_dispo.MB_RHA with proper use of Template:Data element, and up date the Data Dependencies in Reports and Indicators accordingly. Ttenbergen 14:53, 20 June 2025 (CDT)
    		•  2025-06-20 7:53:36 PM
    edit Dispo field
  • Are there others? I think H6...
    		•  2025-12-12 8:44:55 PM
    edit 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)
    		•  2025-11-27 10:44:27 PM
    edit Postal Code Master table
  • Do we want a regular update process? See comments in that file. Ttenbergen 12:15, 4 August 2025 (CDT)
    		•  2025-08-04 5:33:09 PM
    edit Parked in ER
  • Does that make this one of the Indicators? If so we should apply Template:Reporting Indicators so this is linked and tracked appropriately. If it isn't a separate indicator and only a component of ICU Interfacility Transfer then it should be added to the template there.
    		•  2025-07-31 3:06:45 AM
    edit 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)
    		•  2025-09-08 3:13:24 PM
    edit 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.
    		•  2025-06-27 7:15:51 PM
    edit 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.
    		 2025-12-11 7:22:50 AM
    edit SBGH L2
  • 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 ER Delay
  • 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-12-08 10:03:52 PM
    edit 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)
    		•  2025-03-11 10:13:35 PM
    edit 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.
    		•  2025-10-23 7:50:03 PM
    edit Template: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.
    		•  2025-08-14 4:15:46 PM
    edit 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.
    		•  2025-10-23 7:50:36 PM
    edit 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.
    		•  2025-10-23 7:50:29 PM
    edit 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.
    		•  2025-10-23 7:50:21 PM
    edit 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.
    		•  2025-10-23 7:50:15 PM
    edit 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.
    		•  2025-10-23 7:50:08 PM
    edit 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.
    		•  2025-10-23 7:50:56 PM
    edit 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.
    		•  2025-10-23 7:49:54 PM
    edit 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.
    		•  2025-10-23 7:48:54 PM
    edit 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.
    		•  2025-10-23 7:49:29 PM
    edit 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.
    		•  2025-10-23 7:49:34 PM
    edit 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.
    		•  2025-10-23 7:49:42 PM
    edit 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.
    		•  2025-10-23 7:49:47 PM
    edit 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.
    		•  2025-10-23 7:50:50 PM
    edit 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.
    		•  2025-07-01 2:48:27 AM
    edit 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.
    		•  2025-07-01 2:48:29 AM
    edit 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.
    		•  2025-07-01 2:48:57 AM
    edit 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.
    		•  2025-07-01 2:48:33 AM
    edit 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.
    		•  2025-07-01 2:48:35 AM
    edit 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.
    		•  2025-10-23 7:56:19 PM
    edit 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.
    		•  2025-10-23 7:56:14 PM
    edit 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.
    		•  2025-10-23 7:56:12 PM
    edit 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.
    		•  2025-10-23 7:50:43 PM
    edit Re-analysis and generation of Overstay2 model
  • leaving these here as examples how to link to the definitions on Data definition for factor candidates for the Overstay2 project. The currently used definition should live there, but changes and reasons should probably live here. We can change that format, talk to me if needed. Ttenbergen 11:35, 25 June 2025 (CDT)
    		•  2025-08-12 8:43:59 PM
    edit Transfer Delay (Critical Care)
  • 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)
    		•  2025-12-07 8:50:58 PM
    edit O365 Testing
  • The laptop doesn't have SAS so we need to plan separately for testing this. Julie, what are your thoughts?
    		•  2025-10-18 2:47:30 AM
    edit Decubitus Ulcer Study
  • This data is not in the tmp table (at least not under a project "Decubitus Ulcer". Where does it live?
    		•  2025-10-23 8:21:24 PM
    edit ER Delay
  • 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-12-08 10:03:52 PM
    edit ER Delay
  • 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)
    		• 2025-12-08 10:03:52 PM
    edit 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)
    		• 2025-11-27 4:14:17 PM
    edit 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)
    		•  2025-06-30 6:12:36 AM
    edit Re-analysis and generation of Overstay2 model
  • 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)
    		•  2025-08-12 8:43:59 PM
    edit 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.
    		•  2025-11-24 9:36:16 PM
    edit 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)
    		• 2025-11-28 3:00:46 PM
    edit Standard data cleaning process
  • 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 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>    		 2025-10-23 8:26:20 PM
    edit Service/Location field
    • SMW


    • Cargo


    • Categories
    		 2025-09-26 7:54:49 PM
    edit S dispo.geog

    Use

    ???    		 2025-03-12 4:47:50 AM
    edit Cognos downtime procedure Are there any hard commitments? Soft commitments? 2025-10-08 1:19:28 AM
    edit 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? 2025-03-15 3:15:57 AM
    edit 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)    		 2025-06-30 6:12:40 AM
    edit 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. 2025-12-08 10:40:52 PM
    edit Intended1stSrvc 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) 2025-11-27 9:55:36 PM
    edit 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) 2025-03-11 10:09:28 PM
    edit Boarding Loc 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)
    		 2025-11-27 4:09:31 AM
    edit Project Overstay2 JALT
  • 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)
    		• 2025-11-27 4:25:29 AM
    edit 2025-05 Revision of concept around ICUotherService Lose ends:
  • Definition of a Critical Care Program Admission uses the Service_tmp entry
  • STB CICU Admissions start at Arrive DtTm as linked from Service_tmp entry - can that go / become legacy?
  • someone will need to review the 108 links from other pages to service_tmp entry (link was breaking discuss, see below discussion) to make sure that we are not breaking anything by changing this. Ttenbergen 16:55, 27 November 2025 (CST)
    		•  2025-11-27 11:12:17 PM
    edit Query check tmp Overstay2 others? 2025-08-07 4:32:42 PM
    edit S dispo.geog Should these be geog = winnipeg
  • Interventional Radiology
  • Other Procedure Location
    		•  2025-03-12 4:47:50 AM
    edit Scanning to network That scanner is gone, right? 2025-03-18 11:06:02 PM
    edit 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) 2025-06-16 7:52:46 PM
    edit 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)
    		• 2025-08-19 10:10:00 PM
    edit 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)
    		•  2025-11-27 4:09:31 AM

    IT Access used

    Related Articles

    Related articles:
    Retrieved from "https://ccmdb.kuality.ca/index.php?title=Statistician&oldid=158666"