View table: Discussions

• After 24 rows, open and closed assigning Pseudo Phin an error message pop up then I cannot assign Phin anymore. I closed CFE then open then I am good to go again. The second time the error message pop up not 24 rows it less than 24 like 15 rows then it will show again the error message. PTorres 16:09, 2022 June 14 (CDT)
  • Is it the "cannot open..." error or the "enter parameter..." error you get at this point? Emailed Pagasa... Ttenbergen 10:49, 2022 November 16 (CST)
    • Still shows "cannot open "so I clicked ok then it says run time error 3014 cannot open any more tables. Closed the CFE then log back in.
    • After I continue assigning Pseudo Phin after 25 rows "cannot open" showed up again I clicked ok then error message shows again. Closed CFE then log back in.PTorres 14:42, 2022 November 30 (CST)

• • • • Are you following the steps in Generating PseudoPHINs when this goes wrong? Which step in those instructions are you at when it stops responding and you need to restart the program? Ttenbergen 13:48, 2022 November 29 (CST)
    • Yes, I am. I am clicking and assigning the new Pseudo Phin and not moving. PTorres 14:47, 2022 November 30 (CST)

• Assigning Pseudo Phin or working on the queries if I worked long enough opened closed it then the error message pop up "Enter Parameter Value". PTorres 17:01, 2022 April 14 (CDT)
  • What is the specific action or button press after which this happens? I.e. which step in Generating PseudoPHINs? Ttenbergen 10:49, 2022 November 16 (CST)
    • When I click the pseudo button to the left of the PHIN field label, nothing is moving.PTorres 15:23, 2022 November 30 (CST)
      • I don't understand what you mean by that. What is the last thing you do before the "Enter Parameter Value" error happens? As in, what is the last button you click or last field you enter? Ttenbergen 12:15, 2022 December 7 (CST)

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)

• Identified as something we should do to streamline data collection. I have made this page to document progress toward this import. Blood gas data is in DSM listing; need to compare to see if we can use it
  • Allan will revisit with Lab people whether this is obtainable now Ttenbergen 11:34, 2022 February 9 (CST)
    • Allan is negotiating inclusion of Labs data with Grace hospital as per Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2023#ICU Database Task Group Meeting – April 19, 2023, leaving this flagged to ensure update. Ttenbergen 14:00, 2023 May 17 (CDT)

Task

• I had understood that DR wanted to know if the doctors on the current service are processing this. That might be a misunderstanding, though. DR if a patient is admitted to our service from another service or ward (icu to medicine, ER to medicine/ICU, surgical ward to ICU/medicine) and has an ACP already established by the previous service, can we use this as the first documented ACP? or do you want to know when the new service establishes an ACP status?
  • Ah... I don't think I got clarification on that one. I have added it to my list for my next meeting with Dr. Roberts (Thu Jul 3). Also added to Task in case that happens sooner. Ttenbergen 22:57, 29 June 2025 (CDT)

• I just saw this line, its probably been there for a while, but just thinking that in our definition of community living with support, in Pre acute living situation, we include assisted living, supportive housing, AIA, lennox bell, and 1010 Sinclair, we currently do not use this code for these dispo locations, should we include them or we should rethink this Lisa Kaita 21:24, 10 June 2025 (CDT)
  • I actually just don't understand what this means... is the full statement "This includes those living in a community facility with support and being panelled for PCH" or what? In any case, yes, judging by how often this comes up in a search, we should likely make a page for community facility with support and store the details there to be back-linkable if we mess with the concept anywhere. Possibly that should be a template:community facility with support instead or in addition, depending on the details we need. But have a look at the search link above and let's make sure we pick the right solution that can tie in to everywhere the concept is used. Ttenbergen 00:42, 11 June 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)

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)

• 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>

• We have had patients admitted from the chronic care unit at Deer Lodge (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? Lisa Kaita 12:32, 24 November 2025 (CST)
  • They live there, so that makes this also related to Collection of locations on the spectrum between home and PCH. Ttenbergen 18:00, 27 November 2025 (CST)
• so we will continue to enter as Chronic health facility for now Lisa Kaita 07:43, 28 November 2025 (CST)

• Discussed this at JALT Meeting - Rolling Agenda and Minutes 2025#JALT 2025-03-11 but I don't remember if we came to an answer or next step. Just found a note to add that we will also need to decide if any of these are in-patient locations. This would make them collectable as Pre-admit Inpatient Institution, and is relevant as per Pre-admit Inpatient Institution field#Data Use / Purpose.
• are you referring to PCH's because they are not inpt locations or are you referring to chronic health facilities? Lisa Kaita 14:52, 25 June 2025 (CDT)

• These should be made consistent with [[Template:PCH Riverview Deer Lodge (DLC)]] and should probably use that template to enforce consistent use. Ttenbergen 14:23, 2024 October 16 (CDT)
  • and I have lost track of the details Ttenbergen 10:45, 2024 November 1 (CDT)
    • There might be an easy way out of this question. We now only have one awaiting code; if waiting for any of them qualifies for this code then we may not need to know about the level of care. But then again, some of those sites also have acute/LAU type settings so we may need to figure this out after all...Ttenbergen 20:27, 2024 December 11 (CST)
• that template does not exist or I can't find it Lisa Kaita 14:56, 25 June 2025 (CDT)

• This issue raised a problem with medicine data recently, and we will review again if this needs to be coded more granular after all,
• dicussed at JALT June 25, 2025: while Bojan would like this it is not possible to keep track of unit changes and not always easy to tell which unit they arrive from so leave a Riverview and Deer Lodge (DLC), with the exception of the PCH units in each facility.Lisa Kaita 14:52, 25 June 2025 (CDT)

We have discussed lately that we might want to become more nuanced about some chronic care locations (Deer Lodge (DLC) and Riverview). I have removed the details from the above linked fields and consolidated here. Once this page is cleaned up this discussion entry can be removed.

• Discussed at
  • Task Team Meeting - Rolling Agenda and Minutes 2025#CHF4
  • Task Team Meeting - Rolling Agenda and Minutes 2025#CHF3
  • JALT Meeting - Rolling Agenda and Minutes 2025#CHF2
  • Task Team Meeting - Rolling Agenda and Minutes 2025#CHF1

• Lisa, any idea why this might be happening from a collection perspective? Is the problem in what we receive the right info from Cognos, or is there an issue in the collection process that makes this happen? Ttenbergen 09:52, 2024 December 5 (CST)
• Julie, do we need to flag anywhere further that this data is suspect? Ttenbergen 09:52, 2024 December 5 (CST)

• Province - That definition doesn't make it clear to me whether the entry should be "NK Not Known / Not available" or "MB" - can we clarify that? Ttenbergen 00:17, 12 July 2025 (CDT)

* who should we clarify with, I would think if they have a MB PHIN or are self pay then you would choose MB, if they don't then I would choose Not known Lisa Kaita 21:25, 6 September 2025 (CDT)

• more of a "tighten definition" than "check with"; from talking with SW this population frequently doesn't have their paperwork or registrations figured out, or their MB Health status has expired even if they would theoretically be covered, etc. This all came up when Julie checked for outliers and compared the province and postal code to determine status for homelessness.

Integrate these better

• re pre admit for outside Winnipeg facility discussion, change from getting from Previous Location only to getting it from both Previous Location and Pre-admit Inpatient Institution; this was missed before because we based the initial fields on the last overstay project, and back then these two fields were still combined
• re-institute amputation; before we were only looking at the CCI code, but we should consider Past history, loss of limb(s) as well

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

Just a placeholder for now because the idea of how we define dispo to community (or for that matter, re-admit Previous Location) in data came up re. things like Readmission to MedWard and others. We have the obvious "Home" but if someone is discharged to something like Dialysis, would that also count? How do we define? Ideally by a column in s_dispo table such as s_dispo.loc_type, but that one uses "non-patient" which it also uses for Deceased patients (should we just split that out?). There is probably even more to this. Likely Julie has more than one approach in reporting. This came up because we were looking to define this for LAU collection readmission data.

• This is actually just as much regarding to admitted from community, so maybe this should just be renamed to "outpatient sites in s_dispo table"?

• This will need to be concistent with the concept of Pre-admit Inpatient Institution field ie they should not overlap, and possibly an entry's inclusion in that (ie s_dispo.inpatient unchecked) could be a way to define this.

• 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, but do the virtual wards fall under transfer to Group/Supportive housing? Lisa Kaita 14:03, 14 November 2025 (CST)

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)

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)

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)

do we need to be specific here that this should always mean setting a boarding loc to a later dttm in case a pt was there earlier? I would not want someone to omit an initial boarding loc and set the second location's time to earlier

• wouldn't our cross checks capture this? As long as collectors follow the above instruction the first boarding loc has to have the same DTTM Lisa Kaita 11:16, 7 August 2025 (CDT)

• 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)
  • This is reported in ICU quarter report Length_of_Time_for_Transfer_from_ED_to_ICU_within_same_facility but not in Medicine. ER delay is reported as requested. --JMojica 10:32, 8 December 2025 (CST)

• I have a hunch that this error may be related to a send failing for one collector and a second collector then also sending, leading to problems with the lock file.

So, when the error happens, please have a look at Regional Server\​/output\\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\/output and see if there is a second centralized_data file there with an extension .lccdb. See Lccmdb and ldb files for details. Please log here about what you find. Ttenbergen 10:41, 2024 November 30 (CST)

this is one of the things we needed to discuss further, currently we capture RR5 as HSC_ward, but it is a combination of spinal cord rehab, NMSK rehab, amputation rehab, Riverview has stroke rehab, Deer Lodge (DLC) has Geri rehab, If we are capturing these rehab wards for CGH, SOGH and VGH should we not be capturing this for all dispo locations that are rehab? Lisa Kaita 13:11, 8 April 2025 (CDT)

For a patient who intend to be an organ donor and died in the unit or ward but the organ donor did not happen for some reason (e.g. family changed their mind, or some other circumstance occurred, and they did not end up going to the OR), do we still need to code Organ donor (organ/tissue donation by the donor) in admit or acquired? maybe not and the Dispo entry is just - Died to morgue ? Or if we want to keep the organ donor code, we need a code telling it did not happen, is that possible? --JMojica 16:58, 18 November 2025 (CST)

Another scenario - For a patient who has an acquired diagnosis of Organ donor (organ/tissue donation by the donor) and brain death and the harvesting done during the same ICU admission and did not go to OR, then the dispo is Died to morgue , is this correct? --JMojica 16:58, 18 November 2025 (CST)

• Question is under the MAID heading in here but does not necessarily seem to be related to MAID... or is it? Ttenbergen 23:20, 18 November 2025 (CST)
• I have a feeling this question comes with context - what were you looking for? Ttenbergen 23:20, 18 November 2025 (CST)

• • the two items listed here are general questions about organ donor and how to know if the donor happened or not. i just inserted the discussions after the MAID but not meant to be related to MAID. Sorry, I notice how the two comments came out , one with a box and another under it. I tried to change but unsuccessful so I leave them as is. The main goal is to add them to the instruction if making sense. --JMojica 09:05, 19 November 2025 (CST)

• 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)
  • does the introduction of Intended1stSrvc and the change described in 2025-05 Revision of concept around ICUotherService take care of this concern? If not pls clarify, if so please remove comment. Ttenbergen 14:58, 26 September 2025 (CDT)

JALT

• How do we want to do this, we could use the currently active entries for CC in s_dispo table:
• HSC_IICU
• HSC_MICU
• HSC_SICU
• STB_ACCU
• STB_CICU
• STB_MICU

or the full possible names under the CC services in S Cognos Services table that we actually use (in the last 2 months we had): Item

• GH Critical Care / ACSS
• GH Critical Care / General
• GH Critical Care / General ICU
• HSC Critical Care - MICU
• HSC Critical Care / A Medicine
• HSC Critical Care / A Non Teaching Med
• HSC Critical Care / D Medicine
• HSC Critical Care / D Non Teaching Med
• HSC Critical Care / General
• HSC Critical Care / H Medicine
• HSC Critical Care / H Non Teaching Med
• HSC Critical Care / Intermediate
• HSC Critical Care / Medicine
• HSC Critical Care / Neurosurgery
• HSC Critical Care / Obstetrics
• HSC Critical Care / Orthopedics
• HSC Critical Care / Otolaryngology
• HSC Critical Care / Plastics
• HSC Critical Care / Respiratory
• HSC Critical Care / Trauma
• HSC Critical Care / Vascular
• HSC Surgery / Neurosurgery
• SBGH Cardiac / Cardiac Surgery
• SBGH Cardiac / Crit Care Cardiology
• SBGH Critical Care / Acute Care Surgery
• SBGH Critical Care / B Service
• SBGH Critical Care / C Service
• SBGH Critical Care / Cardiac Surgery
• SBGH Critical Care / Crit Care Cardiology
• SBGH Critical Care / General
• SBGH Critical Care / Medicine

or we could use only the part before the "/" for the CC services in S Cognos Services table:

• GH Critical Care
• HSC Critical Care / Intermediate (this wouldn't be captured without the post-/ part)
• HSC Critical Care
• (but what would actually signify SICU, or would we again still need Service/Location for that?
• SBGH Cardiac
• SBGH Critical Care
• SBGH Cardiac / Cardiac Surgery (this wouldn't be captured without the post-/ part)
• SBGH Cardiac / Crit Care Cardiology (this wouldn't be captured without the post-/ part)

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)
  • I have reviewed the links to ICUotherService and changed what needs changing. Ttenbergen 15:05, 26 September 2025 (CDT)

• We need to move the change-related parts of what Allan wrote in Intended1stSrvc to 2025-05 Revision of concept around ICUotherService to keep this page on target and keep the explanation in one place. Ttenbergen 15:05, 26 September 2025 (CDT)
  • I think I have done that, mostly, but someone should have a look at 2025-05 Revision of concept around ICUotherService to confirm that the change is explained fully enough to make sense of the before and after data Ttenbergen 23:03, 28 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)

• Could you summarize what we would need to change from ICUotherService to get to this? It sounds similar. Ttenbergen 13:25, 17 March 2025 (CDT)
  • in the example mentioned, the service is STB ICMS and flag in the tmp ICUotherService with item entry CICU under MICU service which is ICCS under ICMS service. the current list we have is clearer and less confusing than ICU other service- MICU. And when this patient is accepted to the STB ICMS as an ICMS patient, we continue the profile and the tmp ICUotherService will have a new line with entry MICU under MICU service. Such profile then will have part of ICMS service as an ICCS patient and as an ICMS patient. In the qtr report, this profile is included in the ICMS unit. However, a separate report if requested can be done if wanted to know the LOS of overflowed patients on borrowed service. --JMojica 17:30, 7 April 2025 (CDT)

• 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)

• what if they spend time in an ED in between as part of re-admission, possibly pushing past the 7 day range? Due to the very long ER delays for LAU I think we would want to include those. Ttenbergen 00:06, 12 March 2025 (CDT
  • These would be included because I am using the ADT/EPR readmits and the admit time reflects first time of presentation and an ensuing admission Lisa Kaita 12:13, 10 April 2025 (CDT))
    • to be perfectly clear: if someone is discharged from LAU on Jan 1, and then presents to an ED at GRA, where they decide the person should go to LAU, but the patient is not transferred and made an inpatient again at an LAU for another 3 days (pushing their new admission past the 10 day window), would you tag them as a re-admission? Ttenbergen 12:42, 10 April 2025 (CDT)
• Yes, I believe it would because in EPR for patient visits, the patient you describe would show them as an inpatient, beginning Jan 7, even though by our definition they are not an inpt til the LAU folks accept them. I would not be able to decipher the actual first service time without having the chart or running an EPR report. Lisa Kaita 12:49, 10 April 2025 (CDT)

• 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)

• When I talked with Andrea Thiessen she said there was no SOP for the clerk yet, and that the form is not yet part of the admission package because they are finalizing some forms approval for it. Until we hear it's set up it might be good to flag when you run low on forms or forms are not in the admission package.

• According to the draft SOPs we are to provide communication of the results as below. Andrea Thiessen explained that they would want something like a list split by colour. Then people would start manually populating other documents with this. I should follow up to determine the details and possibly set up a better way.
• 2025-07-03 TT emailed to Katherine Graham and Kathy Kwiatkowski how they will use it (include Andrea Thiessen)

• The 110.500.411, Discharge Planning Screening Tool (DPST) says that we will provide a report or patient colours. The details need to still be worked out.
  • • I need to work with Andrea and Katherine Graham on overall reporting, so please don't do a separate approach on this. Separate emails are awkward for them, I asked to do it like that for now because it's low effort on collector part and you said you are already overwhelmed by all the changes. Ttenbergen 12:12, 3 July 2025 (CDT)
• If this remains in email form there may end up being a mailing list for this.

Once the final reports are figured out collectors may or may not be involved in providing these. Ttenbergen 00:11, 2 July 2025 (CDT)

• • As of July25,2025 collectors were advised they can stop sending the automatically generated emails to Andrea, so we have, TT removed this function Sept 5, 2025 Lisa Kaita 07:28, 6 September 2025 (CDT)