Questions

From CCMDB Wiki
Revision as of 09:40, 2020 April 8 by Ttenbergen (talk | contribs) (→‎All questions)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Lists all pages in. For those that were added with Template:Discuss it also lists the question.

Unassigned questions

There are currently 67 unassigned questions.

wiki page question Last modified
Battery disposal collectors, please document what your process is at your office location.Trish Ostryzniuk 17:38, 2019 March 5 (CST) 2020-04-30 4:26:36 PM
Change of remaining location names from "our" names to EPR/Cognos names
  • that will likely be more complicated at the other sites since these are not necessarily one-to-one mappigns...
2021-06-15 9:18:03 PM
Change of remaining location names from "our" names to EPR/Cognos names
  • It's a blur to me now, but I seem to remember people still raising concerns about this change after the meeting. If you have ongoing concerns, please post them here. Ttenbergen 16:36, 2021 May 6 (CDT)
2021-06-15 9:18:03 PM
Cognos2 Hospital Discharge query
  • This is a work in progress. Feel free to have a look at the query and test it. Let me know if things are missing or if you have suggestions. Ttenbergen 10:40, 2021 September 29 (CDT)
    • Hey Tina, the query is super helpful for us, just a couple of comments, it would be helpful if we could somehow get to the profile from this page so we could just enter it, you know the binoculars thing, also if it would somehow drop off once we do enter it? This may be big asks or not even feasible to program, but thought I would ask, thank you for creating the query!! Lisa Kaita 10:06, 2021 October 15 (CDT)
      • Yes, I can add a button once I turn it into a form. There might be more than one profile for the patient on the laptop. Both will be listed, so the collector will need to keep an eye on that. But I wonder: is the next step actually to open the profile, or is it to request the chart? What would a collector do in there at that point? Because maybe what we need instead is something optimized to request the next round of charts? Then the collector would open from PatientList as they go through charts. Just trying to make sure we tie this into the actual process rather than add functionality just because we can. Ttenbergen 15:51, 2021 October 19 (CDT)
        • We go into the profile to change the record to MR*, to replace where the patient was e.g. A3S (A3stepdown lets us know as a quick glance that the patient is still in hospital, once discharged we change it to MR*) it puts it to the bottom of our MR list. When we are ready to request the chart we remove the *, generate the MR list, and then request it from medical records.
          • That is interesting. Is the MR* technique actually across sites? This is not documented anywhere, eg. Record field and MR List. If this is common procedure, then would it be better functionality to just change all records that now have a hosp discharge to have record = MR*? It doesn't sound like something that benefits from human intervention... Ttenbergen 09:50, 2021 October 20 (CDT)
2021-10-20 2:50:44 PM
Cognos2 Hospital Discharge query That would raise the question of who and how...
    • At sites where they are up to date or have a dedicated collector for that laptop only would likely not use this, as EPR lists can be used
2021-10-20 2:50:44 PM
Cognos2 Hospital Discharge query We might be able to convince the Cognos people to stretch the query to include this, but that's somewhat unlikely. However, the number of records for which this would not come in time for us to collect it might be small enough for Pagasa to grab after the fact? How small would it need to be for that to be feasible? 2021-10-20 2:50:44 PM
Confidential waste disposal collectors, please document what your process is at your office location.Trish Ostryzniuk 17:37, 2019 March 5 (CST) 2019-11-08 1:01:00 PM
Courier
  • Would that make it cheaper to just print things at GRA as required, especially since printer project means we no longer pay wear and tear or toner? Ttenbergen 10:49, 2020 September 23 (CDT)
2021-09-02 3:24:45 PM
Courier This is inconsistent with the GRA instruction below where it says no cost centre required. 2021-09-02 3:24:45 PM
Courier this needs to be made consistent with what is written above. actually, should there even be two sections of instructions or just one? Ttenbergen 2021-09-02 3:24:45 PM
Data collector's binder STB do you still do this? I have not seem any VAP or CLI email from STB from ages. Trish Ostryzniuk 17:14, 2021 February 24 (CST) 2021-02-24 11:14:28 PM
Definition of a Critical Care Laptop Admission
  • the ICU team is considered as having accepted the patient when they arrive on the scene if the patient is successfully resuscitated and goes to a unit
  • I think the wording that was in this page already is more precise, but is it what STB actually does? Ttenbergen 13:55, 2021 December 2 (CST)
2021-12-02 8:00:18 PM
Direct admit
  • It seems to me that there really are no special collection instructions for these at all. Those rules are all the same as they would be for non-direct-admits, right? If so, we shouldn't have any special instructions here, and just say that regular collection instructions apply. Otherwise, if we make any change in the regular instructions, this will become lost. The one part that might be relevant is the Visit Admit = Service... If there is a mistake in EPR we would presumably expect the collector to edit the service to coincide with the Visit Admit? Since Julie would likely use that equality to detect the pt as direct admit? Ttenbergen 09:55, 2021 September 8 (CDT)
2021-09-08 3:00:45 PM
Dispo field
  • so if a patient is taken to the OR direct from your unit (either from medicine or ICU) the dispo loc will still be <site>_ward? (Sherry)
2021-10-21 2:27:12 PM
Dispo field
  • is there any chance we can have the Dispo list cleaned up if we're using the above options? There are still +++ inpatient options for the hospitals? I guess this would also apply to the Previous Location and Pre-Admit lists as well.
2021-10-21 2:27:12 PM
ECIP
  • Actually I am not sure if "* Critical Care / *" would always be MICU, the list includes "HSC Critical Care / Orthopedics" and "HSC Critical Care / Plastics", what does that even mean? Ttenbergen 15:36, 2020 October 6 (CDT)
    • Collectors, would those always be CC patients? Ttenbergen 12:50, 2020 November 10 (CST)
2021-07-15 3:19:43 PM
ECIP
  • As per email discussion with Lisa: "We could also have a safety net where by the other ICU collectors could email the collectors at HSC when they receive an admission from HSC ER?"
    • If others receiving an admission from HSC ER would be a filter, we might actually have that info in Cognos, it just would not be showing up in your (ie HSC’s) data at this time. But that would mean collectors would always need to review patients who went to another ICU from the HSC ER (and likely the same for the STB ER, possibly even the GRA one...), so that seems like a lot of overhead. Are we OK to just identify SICU ECIPs as a population we likely usually don't capture? Ttenbergen 15:36, 2020 October 6 (CDT)
  • On the online Bed Board (https://whiteboard.manitoba-ehealth.ca/whiteboard/icu), there is a column OFF_service Patients which means any patient overflowing to either Resuscitation room in ED, PACU/PARR, ICCS, etc. and entry is real time. For HSC SICU, the common overflow location is PACU (haven’t seen any at ER). Only GRA ICU shows overflows in ER. This may give us a clue for possible ECIP but not sure how DC will crosscheck the online bed board if the timing won't synchronized. maybe we just have to ignore SICU ECIP if there is such a thing. --JMojica 16:27, 2020 October 6 (CDT)
2021-07-15 3:19:43 PM
ECIP
  • Is that really specific to STB, or even specific at all? Doesn't that just mean following the usual instructions for these three fields? If so, we don't want to duplicate them here, because if anything about them changes, we would miss this spot in any updates. Ttenbergen 12:42, 2020 November 10 (CST)
2021-07-15 3:19:43 PM
ECIP
  • what would even be the actual definition of a surgical / SICU ECIP? There is no surgical equivalent to a "Critical Care service" it seems. Ttenbergen 15:36, 2020 October 6 (CDT)
2021-07-15 3:19:43 PM
Emergency Surgery (concept) This info is from 2009 - is it still the same? Ttenbergen 17:10, 2021 April 22 (CDT) 2021-04-22 10:10:30 PM
EPR Lists Are these the manual lists where you have to add patients? Instructions almost look like it's a counterpart to EPR Reports instead. Are these even still available? What are the advantages / disadvantages for this vs EPR Reports? 2021-02-04 4:04:51 PM
EPR Lists Would it be correct to say that the lists are manually populated based on EPR Reports? 2021-02-04 4:04:51 PM
Extra shift sign up checked by whom, main office or is that a directive to collectors? 2021-11-10 9:48:17 PM
GI Scopes I consolidated several mentions of capsule endoscopy here. Some had been edited to be inconsistent so I want to be sure. The old instructions had said to use (I) Digestive System, NOS as CCI 1, the new ones say to use (D) Large Intestine. Imaging by capsule endoscopy includes both the large and small intestine, and as an imaging code it should be combined with an imaging CCI1, so I think the old code was the better one to use. Why was it changed? Ttenbergen 2021-10-05 3:06:04 PM
Health Sciences Center Office
    • Does Iris Deleon have a key?
2020-12-22 9:00:00 PM
Health Sciences Center Office
    • Joanna Velasco - I have a key, but it doesn't work on any of the cabinets in the office.
      • Is that still true? Have you talked with Trish?
2020-12-22 9:00:00 PM
Health Sciences Center Office
    • Lori Lovell - now that she's part time does she really still have a key?
2020-12-22 9:00:00 PM
HSC D5 2020-12-23 9:34:49 PM
HSC ICUs Data by Patient based on DC Treatment, ICD10 Palliative care or what? 2021-07-14 1:55:43 PM
HSC ICUs Data by Patient is that Pre-admit Inpatient Institution or Previous Location or what? 2021-07-14 1:55:43 PM
HSC MICU Collection Guide
  • The following is outdated info, but I am not sure if there is anything special for MICU now, so leaving it. The up-to-date instructions for this are in Boarding Loc and Service tmp entry.
Due to the COVID-19 outbreak, some SICU patients are now being treated in MICU, until they are proven to be negative. See COVID-19 (SARS-COV-2)under Cohorting in HSC ICUs.
  • If they are under MICU service, enter them using HSC_MIC service location, and add SICU under MICU in the tmp file. See ICUotherService.
    • Once they are transferred to SICU, make a new file with HSC_SIC service location.
  • If for some reason the patient is in MICU under SICU service, enter them using HSC_SIC service location and treat it as a Boarding Loc.
2021-03-24 6:43:17 PM
HSC SICU Collection Guide The following info is out of date. See Using Cognos2 to keep track of patients instead. I am leaving it only because I don't know if there is anything still relevant in here with the new process. Pls clean it out. Ttenbergen 19:49, 2021 January 21 (CST)
The SICU log census book is kept at the South Nursing station.
  • All admissions in the binder
  • If any admissions are missed, collectors can find them by checking the TISS forms and EPR, and add them in the log book.
  • Collectors sign off their patient admissions in the log book, by putting their serial number and initials on the left-hand side of the page.
    • Due to the COVID outbreak, we are now printing out an SICU Admission Register and Transfer Register from EPR Reports and dividing the patients the same way, but in our office.
2021-03-04 8:11:20 PM
HSC WRS3
  • Will this location profile be identical to what HSC_D5 was before?
2020-12-23 9:34:51 PM
Inspection, Exploration (non-endoscopic) I consolidated several mentions of capsule endoscopy here. Some had been edited to be inconsistent so I want to be sure. The old instructions had said to use (I) Digestive System, NOS as CCI 1, the new ones say to use (D) Large Intestine. Imaging by capsule endoscopy includes both the large and small intestine, and as an imaging code it should be combined with an imaging CCI1, so I think the old code was the better one to use. Why was it changed? Ttenbergen 2021-10-05 3:06:45 PM
Laptop identifier
  • That is phased out now, right? Where is that laptop now? Did the Workstation.mdb get updated with the info? Ttenbergen 10:44, 2021 December 2 (CST)
2021-12-02 4:52:58 PM
Mechanism of injury: hanging or strangulation (accidental or intentional)
  • Some other related codes re the injury to the neck itself were discussed at task, can a collector pls fill them in for more comprehensive guidance re what might be codable with a hanging? Ttenbergen 10:18, 2021 November 10 (CST)
2021-11-10 4:18:59 PM
MediaWiki:Common.js ", post: " 2021-01-28 8:29:32 PM
Microsoft Teams
  • Tina is looking into what it would take for collectors to have Teams provisioned without Office 2019 being installed. It is possible, since it's set up on Tina's laptop that way. There is an add-in that would facilitate booking Teams meetings from 2010, but Teams works without this and collectors may not really need that, if that's the hold up.
  • We will need to put in an ACMT form that now includes Teams, and put a comment to specifically not include the MS Office update. Then when we get the incident number we need to contact the service desk to request a work note as well to make sure there is no update to 2019, which will populate a part of their process documentation that might be more likely to be seen by whoever fulfills the ticket.
2021-04-14 5:23:23 PM
Minimal Data Set If we want to prioritize like that it needs to be discussed in whatever page talks about data collection process and priorities - not here. That could link to here. 2021-11-12 4:02:06 PM
Minimal Data Set Operationally what does "as soon as possible" mean? What collector process would capture this prior to the final chart review. If we want a requirement it needs to be actionable. 2021-11-12 4:02:06 PM
Multiple LOS errors
  • At some point we had disabled Query check_ER_Delay_not_too_big which would have automatically taken care of this bug, but we have since reinstated around 2021-09-15. Is this again a problem now, or is this solved? If I don't hear back from anyone that this is a problem I will consider it solved in 2 weeks. Ttenbergen 14:39, 2021 November 18 (CST)
2021-11-18 8:39:14 PM
Notes field
  • track all lab and pharmacy manually, the notes save time in that it eliminates the need to go back & recount.
    • would you not just enter a new line for these, and the date of the new line would tell you how far you got? Ttenbergen 14:24, 2014 September 19 (CDT)
2020-04-02 4:38:27 PM
Outcomes Improvement Team Is Jodi Walker Tweed (admin assistant) still the contact for this? 2021-11-18 8:32:08 PM
Pharmacy collection working on this as of Ttenbergen 09:57, 2021 November 25 (CST) 2012-09-26 3:56:22 PM
Pharmacy collection working on this as of Ttenbergen 09:57, 2021 November 25 (CST) 2021-11-25 5:50:33 PM
Query check CCI TISS discontinuous ETT
  • Should we include a request to add a comment in notes when clicking past this to preempt future follow-up? Ttenbergen 13:36, 2021 November 10 (CST)
2021-12-02 10:59:14 PM
Query check ICD10 duplicates
  • the count is wrong, there wasn't a quick fix, so disabling the query for now. Ttenbergen 15:56, 2019 March 27 (CDT)
2021-10-07 10:30:41 PM
Service/Location field
  • Could we remove this from the STB ICU laptops as we are doing a kind of follow system?
    • I think Julie still uses this. Also, other sites still have to enter it, they simply always enter the same thing. I think you requested this because of some confusion lately about what defines a new profile at STB CC. And that was important to figure out, and we still need to document it, likely at STB Critical Care Collection Guide. But once that is clear then entering this field should be trivial. I will send an email to DC STB CC; Jmojica to pls review Ttenbergen 11:37, 2020 December 10 (CST)
2021-01-22 2:19:33 AM
Sorting in PatientList breaks when some Cognos Entries are done
  • With entry of any data using ADT2 tab via CSS/CUS/CE into a profile will result in patient list freezing.
    • This happens even if the PatientList was closed (and maybe it happens only if it was closed? )
  • This occurs when the Patient list is closed, I have not used CSS/CUS/CE with the patient list open. Should the patient list be open or closed while using CSS/CUS/CE or does it matter? Thanks, --Pamela Piche 14:11, 2020 December 10 (CST)
    • you should be able to have it opened or closed, depending on how you do your work, it should not cause the sorting to freeze. And hopefully no longer will, once I roll out the fix I just added. Ttenbergen 14:23, 2020 December 10 (CST)
2021-01-14 5:56:21 PM
STB ACCU Collection Guide Is this section still relevant with Cognos? 2021-03-24 8:57:54 PM
STB Boarding Locations
  • Any other boarding locs for STB Med?
2020-12-15 3:49:06 PM
STB Cardiac Care patients
  • the Arrive DtTm for CICU pts is when the pt. actually enters the unit
    • Isn't that true everywhere? Emailed Steph to clarify. Ttenbergen 11:56, 2021 February 22 (CST)
2021-03-24 9:02:13 PM
STB CICU Collection Guide Is the following still true or relevant with new processes? :
  • The unit admission log book is kept at the main desk in front of where the ward clerk sits along with a binder to keep the completed TISS
  • Check the white board every day for those patients who will likely be transferred out to the ward that day. If they are on the transfer list you may want to pull the tiss sheet before they get transferred.
2021-03-04 8:30:20 PM
STB CICU Collection Guide The following list is different from Contacting Quality Officer and Manager for VAPs and CLIs. Is it still accurate? If so, we need to link from that page to here, else we should get rid of this section. Ttenbergen 14:30, 2021 March 4 (CST) Belinda Landy, Nurse Educator, Geri Henry, CRN, Teresa Rostek, CRN & Rob Ariano, Pharmacist 2021-03-04 8:30:20 PM
STB General Collection Guide Is info in this section still up-to-date? Ttenbergen 10:00, 2021 December 1 (CST) 2021-12-01 4:01:38 PM
Swap Locations
  • Another option, and this seems to be what is being done now, is for collectors to "exclude" unit lines from Cognos that list "wrong" start or end times because part of the time is in a swap location.
2021-11-16 10:41:30 PM
Swap Locations
  • Debbie: When you say "the next entry in the location history", you mean the history on the EPR, right? Ttenbergen 09:26, 2020 December 3 (CST)
    • Yes, the location history in the epr. Each scenario with a swing bed entry can be different, and needs to be reviewed to ascertain the true and correct information. DPageNewton 09:45, 2020 December 3 (CST)
2021-11-16 10:41:30 PM
Swap Locations
  • I supposed this swing bed is already happening in the past, before we have this COGNOS admitter. How it is handle? 1) is it included – such that the accept date is taken from that line of swing bed or 2) excluded and the next line where the Accommodation has an entry is the one chosen? I think we need to decide first if to include or not before solving the exclusion process. who to ask? --JMojica 16:02, 2020 December 2 (CST) we do 2)
    • excluded and the next line where the Accommodation has an entry is the one chosen? DPageNewton 10:59, 2020 December 3 (CST)
  • Absolutely agreed, Julie. But there is also an element of us reporting info different than maybe what other, EPR based reports would show. #"Swing beds" at STB shows the list of swing bed locations that show up in the Cognos data. They all are associated by name and data to the ward locations. So anyone generating data from EPR/Cognos would associate these with the units, not the previous location. We would be the only place associating them with still being in the ER. I just reviewed the raw Cognos data, and we get the bed, but not the bed start and end dttm. If we could get that we would be able to figure out what percentage of total LOS is affected by this, but it probably has the biggest impact on ER wait times
    • in the example I gave above, yes the er wait time is what would be affected. DPageNewton 10:59, 2020 December 3 (CST)
      • It sounds like anyone just looking at Cognos data would underestimate that time because pts look like they are on unit already. Ttenbergen 09:56, 2020 December 3 (CST)
        • I've spoken with the ward clerks on E5 on more than one occasion, and have been told, that when there is a swing bed entry for example, between an er location, and a ward location, the patient is still physically in the er, and has not been transferred up to the ward. e.g. #2-if the swing bed location is between say, E5, and another usual ward or unit location, then the patient is still physically on E5. In this example the los for E5 would be affected. I think that this is a concept that is not so easy to explain in words, especially if you're not particularly familiar with the ins and outs of epr. DPageNewton 10:59, 2020 December 3 (CST)
2021-11-16 10:41:30 PM
Swap Locations
  • Is there ever "room for interpretation" where both collectors would still consider the pt on their unit, or where both would consider them already/still on the other unit? If not, how and why?
    • I don't think there is room for "interpretation" as the entry for the "swing bed" is simply ignored, as if it weren't there. We at St. B. have been dealing with this issue since the beginning of time. DPageNewton 10:59, 2020 December 3 (CST)
2021-11-16 10:41:30 PM
Swap Locations
  • One option would be to omit lines with current unit is a swap location from the cognos data via filter automatically, but it's not clear if this will result in the previous and subsequent records having non-matching next locations and previous locations. Can we just delete these lines from Cognos? Ttenbergen 14:03, 2020 August 28 (CDT)
2021-11-16 10:41:30 PM
Swap Locations
  • Would it make sense to talk to STB about how the swing beds are used by ER? I don't think talking to anyone about how the swing beds are used by er would be helpful. I've explained in great detail a number of times, to a number of people why this occurs. I can't think of anything different that could potentially be done to work around the issue as it occurs in the first place. DPageNewton 10:59, 2020 December 3 (CST)
2021-11-16 10:41:30 PM
Swap Locations One problem with filtering these out would be that, I think, the unit record for a swap location might be the same as the unit record for a successive stay in that unit; ie. the bed entry chagnes, but the unit remains the same. So, the unit start dttm and unit end dttm don't care if part of the unit stay was in a swap location. Is that not true? If it is true, then how would we filter these out? if I eliminate every line that has a swap/swing bed (which I can do) then we will not get any line for those pts who never get into a real bed on that unit (which may be good), but we would still get the same line with unit start and end times including the swap/swing time for patients who eventually get into a bed on that unit. Ttenbergen 12:07, 2020 December 2 (CST) 2021-11-16 10:41:30 PM
Task Team Meeting - Rolling Agenda and Minutes 2021 '* What if awaiting code is primary reason? Sent Allan an email with counts about this. Ttenbergen 14:03, 2021 August 26 (CDT) 2021-12-01 5:24:05 PM
Task Team Meeting - Rolling Agenda and Minutes 2021 Not sure why this is listed in this spot, but Tina has made the time component available in the Dx Date field and updated instructions. 2021-12-01 5:24:05 PM
Template:CCI Guideline Capsule Endoscopy I consolidated several mentions of capsule endoscopy here. Some had been edited to be inconsistent so I want to be sure. The old instructions had said to use (I) Digestive System, NOS as CCI 1, the new ones say to use (D) Large Intestine. Imaging by capsule endoscopy includes both the large and small intestine, and as an imaging code it should be combined with an imaging CCI1, so I think the old code was the better one to use. Why was it changed? Ttenbergen 2021-10-21 4:22:36 PM
Transitional Care Last used 2021-03 as per query z_s_dispo_lastUsed - is this still a thing? 2021-11-02 5:12:56 PM
Update of D ID exclude service/location
  • can someone else think of how this might not work out right?
2021-03-18 7:11:42 PM
Wrong service or unit entries in Cognos
  • Should collectors just totally wing it for these? Enter what seems right when they review the chart? Or do we need to be more consistent and deliberate about it? Ttenbergen 11:58, 2020 December 2 (CST)
2020-12-02 6:09:07 PM

All questions

There are currently 255 questions.

wiki page who question
2020-04 HSC COVID unit transition Julie
  • April 2020 HSC_MICU will admitted both SICU and MICU physician Service patients that are either suspect or confirmed COVID patients. No suspect or positive covid will be admitted to HSC SICU. Though MICU is a close unit the SICU patient in this unit will be under the SICU attending service physician. Depending on skill set required, sometime may be a SICU nurse or just MICU nurse. The nurse bit we will not be able to track. We need to ask Randy and Bojan how they want this tracked in Database in terms of service occupancy. Put service Loc as HSC SICU and tag in TMP as boarding location? Julie would some of the logic applied to bed board apply to how we tag this.
2020-05 HSC COVID unit transition Julie
  • If all the covid wards are operational, how to handle the case where the patient stayed in 2 official covid wards consecutively - 1) separate records or 2)one continuous record? I think we should consider (2) as continuous.
    • No idea what was actually done for this. Julie, could you either fill in what was done, or eliminate the question altogether? Ttenbergen 09:23, 2021 September 2 (CDT)
2020-05 HSC COVID unit transition Julie
  • You said: We need to ask Randy and Bojan how they want this tracked in Database in terms of service occupancy. Put service Loc as HSC SICU and tag in TMP as boarding location? and Tina asked Julie would some of the logic applied to bed board apply to how we tag this. Julie: is there anything from this that should be documented? If so, can you fill it in, and if not can you delete the question? Ttenbergen 09:25, 2021 September 2 (CDT)
ABG Data Allan z
  • 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
Acquired Diagnosis / Complication Allan Como Admit Acquired Primary Limits - this is part of that discussion - if we limit which admits will count as comos we need to review
Acquired Diagnosis / Complication Allan Rules 1 and 2 are clear, could rule 3 be further clarified
Acquired Diagnosis / Complication Task this relates to Attribution of infections and we need to be sure to have it consistent.
Admit Diagnosis Allan Como Admit Acquired Primary Limits - this is part of that discussion - if we limit which admits will count as comos we need to review
Admit Diagnosis Allan Rules 1 and 2 are clear, could rule 3 be further clarified
Admit Type for APACHE II Task
  • at some point we went through a thorough definition of this at Emergency Surgery (concept) - should we refer to that, or keep this reduced definition? Ttenbergen 17:09, 2021 April 22 (CDT)
Base Population for Research Julie This page is linked from the front page, so we should either make it good or get rid of that. Is there anything on Publications that would be a good example for how our DB was used for this?
Battery disposal all collectors, please document what your process is at your office location.Trish Ostryzniuk 17:38, 2019 March 5 (CST)
Bed occupancy Julie 1
Beds occupied by transferrable patients (Medicine) Julie 1
Beds occupied by transferrable patients (Medicine) Julie 1
  • Needs detail.
Blood Product Data Allan z
  • Identified as something we should do to streamline data collection. I have made this page to document progress toward this import.
Cardiac arrest Allan Como Admit Acquired Primary Limits 1/ Dx grouping - this is part of both of those discussion
  • This question was answered, just leaving this as an example of the more general discussion above:
  • Should we be coding cardiac arrest as a comorb if they have a past history of cardiac arrest? Or is it considered resolved? Some of us are coding it as a comorb and some of us aren't. Thanks - Brynn
    • TT note: See Controlling Dx Type for ICD10 codes - we can instruct not to code this specific code as a comorbid, but the problem is likely more widespread and should be addressed that way
CCI Volumes 2019 Task There have been concerns about the volume of work generated by CCI entries. Since we had already reduced certain entries earlier in 2019, the numbers referenced here are only for pts admitted during the third quarter of 2019.
Change of GRA location names from "our" names to EPR/Cognos names Julie As per email from 2021-05-04, "The question is whether to use the generic HIGH OBS and IMCU instead of physical locations H7S or L2ME if we would like to enter the physical locations COGNOS is showing. If the decision is physical Locations – how would I know which are the high obs wards? we would have to put it in the comments, so are we any further ahead?" How does that feature into our plan to move all to Cognos values? On the same note, it appears that GRA is using two designations for PACU dependign on post-OR vs Covid use...
Change of remaining location names from "our" names to EPR/Cognos names all
  • that will likely be more complicated at the other sites since these are not necessarily one-to-one mappigns...
Change of remaining location names from "our" names to EPR/Cognos names all
  • It's a blur to me now, but I seem to remember people still raising concerns about this change after the meeting. If you have ongoing concerns, please post them here. Ttenbergen 16:36, 2021 May 6 (CDT)
Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc Task Is there a target date for eliminating this field? Ttenbergen 15:10, 2021 April 15 (CDT)
Changing D IDs Pagasa
  • what queries would get you to change a D_ID for medicine? We would want to cross-link them so they point to these instructions, and so these instructions can list them as cause.
Changing D IDs Pagasa
  • what queries would get you to change a D_ID? We would want to cross-link them so they point to these instructions, and so these instructions can list them as cause.
Changing D IDs Pagasa
  • Which program do you do this in? This may actually need to be different instructions for different scenarios.
Changing D IDs Pagasa How about L TISS Form table, L TISS Item table and L Labs DSM table? Are there others I am not thinking about ? Ttenbergen 22:20, 2019 February 6 (CST)
Chart Review Lists Julie This is linked from the front page and intended to give an idea of how one could use our data. Is there anything on Publications that would be a good example for how our DB was used for this? If not, should we take it out? With nothing here it doesn't look very good coming from front page.
Check CRF vs ARF across multiple encounters Julie
  • Using the ICD10 renal codes, we still need to know when the transition from acute to chronic occurs - so we can decide whether the multiple encounters consistency checking is still relevant. --JMojica 11:51, 2018 November 14 (CST)
    1. is the transition on the next hospital stay? Example in this hospital stay, patient is diagnosed with ARF and stayed continuously in both ICU and ward in same or different hospital. On the next hospital stay, he is now chronic renal patient.
    2. Or the transition is on the next ICU or ward stay? Ex. the first stay is ICU and diagnosed with ARF. then patient was transferred in a ward of same or diff hospital - is he now a chronic renal patient?
    • The data collection instructions are in the related pages, and additional info is in Renal Coding Considerations for ICD10, but they are a beast of a network of concepts. Those might tell you how we currently propose to collect the renal codes, but not necessarily what you or the users of the data would want. Usually these cross checks would be driven by what you need for data requests, so do our proposed instructions line up with how you want to use this? Or is this maybe too case-by-case of a concept to even make a cross check? Ttenbergen 18:59, 2019 January 6 (CST)
Check ICD10 some cant be primary Allan Como Admit Acquired Primary Limits - Category:Mechanism would need to be excluded as well, and so would past history, and quickly the list gets so large again that we are back at discussing Controlling Dx Type for ICD10 codes where we should simply include "Primary"-ability.
  • AG OBSERVATION --- we will just take care of this when we take care of Admit/Comorbid/Acquired
Check pre acute consistent Julie
  • ... unless they are discharged somewhere else entirely, like another ward. So what do we really mean with this? That they can't come from one PCH and go to another or maybe "home" after all?
    • I realize this maybe hard to do. what I mean here is that if one is already a PCH resident, when leaving the hospital, the dispo location must be a PCH location too. or is a patient is already in CHF, the destination when leaving the hospital must either be a CHF or another PCH.
Check pre acute consistent Julie
  • from a data perspective, what do you mean by "admitted directly"? If I were to build a check, where would I find that? OR maybe I don't need to know, but then I need to have a definition of what combination of data would be an error.

Integrity check

Check pre acute consistent Julie
  • The listed postal codes are correlated to the items ‘PCH’ and ‘Chronic Health facility’ of the Pre-Acute Living Situation. Since the data collectors are collecting the postal code from the patient’s address, will it be possible to automatically fill up the Pre-Acute Living Situation as PCH or Chronic Health facility if the PCH postal codes are entered or ‘other ways’ to link the two fields and make them consistent. Info about PCH is now getting more attention/request. Tina, Will this be hard to do? Any suggestions?
    • I have changed my mind to add the PCH postal code to the Postal_Code_Master due to the possible effect on its size (when adding a new column containing text where most of the records will only be blanks). It is better to have it in separate table since this pertains to Winnipeg area only. I have added the exact address of these PCH facilities - link to table in email sent on Jan 12.18 at 1224 hrs from p:Julie Mojica
      • Is any change to CFE still required then? If not, please remove this discussion and heading. Ttenbergen 15:47, 2019 July 4 (CDT)
Check pre acute consistent Julie How does Chronic Health Facility fit into this? Or Imprisonment/incarceration and other info in Prison / Jail / Correctional Institution?
Check pre acute consistent Julie There was talk about comparing Postal Codes to known PCH Postal Codes. Since these might include other buildings at the same site that are not PCHs, this check can at best be a soft check. Please add the list of these postal codes here.
Check pre acute consistent Julie what exactly do we want to check for? Please also have a look at the stuff below that doesn't specifically have your name. This requested check ties into a bunch of things and if we want the check we need to be sure that instructions stay consistent and lose ends are tied up.
Check VAP acquired only first encounter Julie We decided that VAP can actually happen in medicine if pt admitted from ICU. How would we deal with that for this check? What do we even mean by encounter, now with patientFollow?
Cleaning up a failed send Pagasa
Cleaning up a failed send Pagasa
Clinical Assessment Unit Julie
  • Do we need to correct these old inconsistencies? Ttenbergen 11:09, 2021 May 5 (CDT)
Clinical Assessment Unit Julie
  • Do you care if we keep the old entries around, or do you want them converted to plain *Ward entries to show up differently in any reporting you do? If fine as is then we should set this page (and the local equivalents) to Legacy. If you want to convert, we can do that and then delete the old CAU pages.
Cognos2 Hospital Discharge query all
  • This is a work in progress. Feel free to have a look at the query and test it. Let me know if things are missing or if you have suggestions. Ttenbergen 10:40, 2021 September 29 (CDT)
    • Hey Tina, the query is super helpful for us, just a couple of comments, it would be helpful if we could somehow get to the profile from this page so we could just enter it, you know the binoculars thing, also if it would somehow drop off once we do enter it? This may be big asks or not even feasible to program, but thought I would ask, thank you for creating the query!! Lisa Kaita 10:06, 2021 October 15 (CDT)
      • Yes, I can add a button once I turn it into a form. There might be more than one profile for the patient on the laptop. Both will be listed, so the collector will need to keep an eye on that. But I wonder: is the next step actually to open the profile, or is it to request the chart? What would a collector do in there at that point? Because maybe what we need instead is something optimized to request the next round of charts? Then the collector would open from PatientList as they go through charts. Just trying to make sure we tie this into the actual process rather than add functionality just because we can. Ttenbergen 15:51, 2021 October 19 (CDT)
        • We go into the profile to change the record to MR*, to replace where the patient was e.g. A3S (A3stepdown lets us know as a quick glance that the patient is still in hospital, once discharged we change it to MR*) it puts it to the bottom of our MR list. When we are ready to request the chart we remove the *, generate the MR list, and then request it from medical records.
          • That is interesting. Is the MR* technique actually across sites? This is not documented anywhere, eg. Record field and MR List. If this is common procedure, then would it be better functionality to just change all records that now have a hosp discharge to have record = MR*? It doesn't sound like something that benefits from human intervention... Ttenbergen 09:50, 2021 October 20 (CDT)
Cognos2 Hospital Discharge query all That would raise the question of who and how...
    • At sites where they are up to date or have a dedicated collector for that laptop only would likely not use this, as EPR lists can be used
Cognos2 Hospital Discharge query all We might be able to convince the Cognos people to stretch the query to include this, but that's somewhat unlikely. However, the number of records for which this would not come in time for us to collect it might be small enough for Pagasa to grab after the fact? How small would it need to be for that to be feasible?
Cognos2 Hospital Discharge query Task
  • This query raises the possibility of also capturing Hospital disposition and dttm, a value Allan has wanted for a long time. But it also raises the problem that we are only finalizing records late now, and do we want to risk similar delay going fwd?
Cognos2 No Service or Loc in some time query Task
  • Are people using this? Would it be worth having a button to open the record directly from the query screen? Would take about 30 min to set up...
Collection location documentation Julie
  • How should we now keep track of the ward/unit info on the wiki? More questions on page.Ttenbergen 16:07, 2021 July 14 (CDT)
Comorbid Diagnosis Allan Como Admit Acquired Primary Limits - this is part of that discussion - if we limit which admits will count as comos we need to review
Confidential waste disposal all collectors, please document what your process is at your office location.Trish Ostryzniuk 17:37, 2019 March 5 (CST)
Continuous Stay Julie
Continuous Stay Julie
  • That last line seems to be obvious in new schema from the other definitions... is AMA still at all relevant here or can it be taken out?
Continuous Stay Julie
  • This def of Bed holds is not consistent with the one in Bed holds; they probably should be, i.e. the same definition should be used throughout. Are they actually consistent in your program? Can we remove the detail from here and link to bed hold?
Continuous Stay Julie
  • This will likely have changed when we eliminated the 5 minute rule for local transfers; Julie, could you confirm that this was also changed wherever it has an impact?
  • Does this use Arrive DtTm or Accept DtTm in the new schema?
Continuous Stay Julie
  • would it make sense to take out the ICU requirement for this? The same might be rarer for Medicine patients but would still be true. I will implement Encounter processing like that for now unless I hear otherwise. Ttenbergen 12:06, 2015 January 22 (CST)
    • Glad you put that in Tina, I was going to make a similar comment.--CMarks 12:48, 2015 January 22 (CST)
Continuous Stay Julie Not sure where this is used, but using Visit Admit DtTm is likely cleaner. You back-populated that for old records, so that definition would work even for old records.
Controlling Dx Type for ICD10 codes Allan Como Admit Acquired Primary Limits 1/ Dx grouping - this is part of both of those discussion
  • I have emailed Allan the table with all Dxs to set them as Como_allowed, Admit_allowed, Acquired_allowed. Will set up infrastructure to contain this once I have data. Ttenbergen 12:31, 2019 February 13 (CST)
    • Allan won't have a chance to review until at least mid Sept 2019
Courier all
  • Would that make it cheaper to just print things at GRA as required, especially since printer project means we no longer pay wear and tear or toner? Ttenbergen 10:49, 2020 September 23 (CDT)
Courier all This is inconsistent with the GRA instruction below where it says no cost centre required.
Courier all this needs to be made consistent with what is written above. actually, should there even be two sections of instructions or just one? Ttenbergen
Crash TISS MDB Pagasa
Created Variables Common maker query Julie 1
  • I have made a new query created_variables_common_maker_2021 and corresponding table. I have populated the table with data for today, but not updated the calc created button yet because this is so slow that I don't want to run new AND old routinely. I have started to do comparisons, but so far all discrepancies I have found seem to stem from data errors. Emailed Julie and Pagasa about those. Aside from that, I am putting a copy of CFE with the new query and a populated Created_variables_common_2021 and old version to ::\\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB\centralized_front_end\2021-created_test
  • How do you want to test and proceed to using the new version? Ttenbergen 16:39, 2021 May 19 (CDT)
    • I suppose you are changing the columns from adm to ER-delay, are these correct? are you just changing the data source from L_Log to tmp service or changing how to present the LOS - by record or by each service of each record? how about the transfer delay for MED involving High obs and regular ward where there are more than one legit transfer dates - are you including that in the calculation?
      • I just changed the source from the L_Log values to the tmp values, where available, ie they would still be by profile. If we wanted them by service it could not really go onto Created Variables as it is right now, since it outputs one line per profile. I can make queries that e.g. do LOS per service, but those would have to be different queries that would have more than one line per profile, and we would need to define them before I can build them. Ttenbergen 15:10, 2021 June 3 (CDT)
    • I need the rest for the ALERT Score in Medicine report - these have no change, right?
      • The only things in CV common that I changed are the ones that use start times. Ttenbergen 15:10, 2021 June 3 (CDT)
    • Ok to roll out since you have both the old and new in CFE. I will crosscheck the entries of LOS, transfer delay, ER wait once I have completed mine in SAS and will let you know. Thanks.---JMojica 10:22, 2021 May 20 (CDT)
      • I have rolled the change. You will have to generate the output manually by running query created_variables_common_maker_2021. Ttenbergen 15:36, 2021 June 3 (CDT)
Critical Care Inter-facility Transfer Report Julie
  • Is semi-annual a thing? I don't see any in Reports.
Critical Care Program Quality Indicator Report Julie
  • Julie mentioned a second report: "from database request by STB which is being reported by month.--JMojica 15:55, 2021 September 7 (CDT)
    • The second report you mention, is that documented as one of the Reports yet? Or is it really a version of this report so we can just list it here?
Critical Care Program Quality Indicator Report Julie
  • somewhere it mentioned "Quarterly report of Delirium cases, Delirium Rates, Delirium Days and Delirium Rate Days for all ICUs in the region"; we have Delirium days in Indicators, but not the others. Are they all defined around the same concept, so that we could rename that indicator "Delirium" and describe them all in there?
Critical Care Program Quality Indicator Report Julie If Tabular is no longer done, then can we put it to a legacy section in the very bottom? Or possibly even delete it, since an old report we no longer do likely has no bearing on our current documentation?
Critical Care Program Quality Indicator Report Julie We don't have 30 listed at the top, which are missing?
CRRT Days Julie Based on what, CRRT, CRRT, CRRT Project?
CT Summary Discharges FiscalYear query Julie
  • The previous query said "*Data: will be counts of Completes in RecordStatus field" - why would this be only completes? Wouldn't we still report on incompletes that have dispo dttm filled in?
Data collector's binder all STB do you still do this? I have not seem any VAP or CLI email from STB from ages. Trish Ostryzniuk 17:14, 2021 February 24 (CST)
Data Integrity Checks/review list Pagasa Pagasa, regarding the meeting with Trish, Julie and Allan to decide which checks to continue to do when, please
  • expand this list to 50
  • click the “edit w f” link at the start of the line to open any that need change right in a form to use dropdowns to update them
  • confirm that all queries correctly list
    • whether you check them always or only complete (timing field)
    • whether they use L_Problem
    • whether there is a backlog (I just added that field, it defaults to "yes" so change to no if caught up)
Data User Portal for the Manitoba Critical Care and Medicine Databases Allan Can you make sure that the following lives in the pages linked above, and no duplicating details remain in here?
  • Previously, a single database record represented a patient under the care of a single ICU service, regardless of physical location. Thus when a patient moved from one ICU service to another (e.g. MICU to SICU at HSC) a new record was begun, and the same for when an IM ward patient moved from service to service (including even moving from teaching to non-teaching and vise versa). But this is artificial, because from the patient perspective, such moves are really parts of a single episode of inpatient care.
  • Our eventual goal is to have a single record include all such changes and comprise all direct ICU-to-ICU changes (and all ward-to-ward changes) even across different Winnipeg hospitals. We are not there yet though.
  • Beginning 10/1/2020 for Grace Hospital, and 10/15/2020 for Health Sciences Centre and St. Boniface Hospital, we moved part-way in this direction by: (a) having all moves within IM ward services in a single hospital be a single record, (b) having direct movement back and forth between MICU and SICU at Health Sciences Centre being a single record. See PatientFollow Project for details on the transition. Thus, the period on any of these ICU services: IICU at HSC, ICMS as St. B, CICU at St. B, and the ICU at Grace Hospital --- is represented in a single record in the database.
Data User Portal for the Manitoba Critical Care and Medicine Databases Allan You will probably want Database Request Process, but not sure where in here.
Definition of a Critical Care Laptop Admission all
  • the ICU team is considered as having accepted the patient when they arrive on the scene if the patient is successfully resuscitated and goes to a unit
  • I think the wording that was in this page already is more precise, but is it what STB actually does? Ttenbergen 13:55, 2021 December 2 (CST)
Direct admit all
  • It seems to me that there really are no special collection instructions for these at all. Those rules are all the same as they would be for non-direct-admits, right? If so, we shouldn't have any special instructions here, and just say that regular collection instructions apply. Otherwise, if we make any change in the regular instructions, this will become lost. The one part that might be relevant is the Visit Admit = Service... If there is a mistake in EPR we would presumably expect the collector to edit the service to coincide with the Visit Admit? Since Julie would likely use that equality to detect the pt as direct admit? Ttenbergen 09:55, 2021 September 8 (CDT)
Direct admit Julie
  • above it seems to say these no longer need to be via ED, or does the report still only list the ED ones? Ttenbergen 09:58, 2021 September 8 (CDT)
  • I think we might want to mention here that we capture these by Visit Admit = first service (or however else we do it) since we don't list a data based definition yet.
Direct Data Access for RIS/PACS Allan z
  • Identified as something we should do; the notes below are quite old but might still be a starting point.
Director's Chart Report Julie
Director's Chart Report Julie as in Bed occupancy?
Director's Chart Report Julie as in Severity of illness?
Director's Chart Report Julie is that Primary Admit Diagnosis only, or of all dxs?
Director's Chart Report Julie What are Quality Indicators?
Director's Chart Report Julie What are Regional Indicators?
Directors Annual Report (Critcal Care) Julie
Directors Quarterly Report (Medicine) Julie 1
  • You had Medicine Task Elements listed here, but they are no longer collected. What do you include in this report instead of those task elements now? Ttenbergen 16:56, 2021 October 20 (CDT)
Dispo field all
  • so if a patient is taken to the OR direct from your unit (either from medicine or ICU) the dispo loc will still be <site>_ward? (Sherry)
Dispo field all
  • is there any chance we can have the Dispo list cleaned up if we're using the above options? There are still +++ inpatient options for the hospitals? I guess this would also apply to the Previous Location and Pre-Admit lists as well.
Dispo field Julie
  • Julie contacted Pam re STB Transitional, and will contact Lisa about HSC transitional and Lennox Bell and other HSC locations.
ECIP all
  • Actually I am not sure if "* Critical Care / *" would always be MICU, the list includes "HSC Critical Care / Orthopedics" and "HSC Critical Care / Plastics", what does that even mean? Ttenbergen 15:36, 2020 October 6 (CDT)
    • Collectors, would those always be CC patients? Ttenbergen 12:50, 2020 November 10 (CST)
ECIP all
  • As per email discussion with Lisa: "We could also have a safety net where by the other ICU collectors could email the collectors at HSC when they receive an admission from HSC ER?"
    • If others receiving an admission from HSC ER would be a filter, we might actually have that info in Cognos, it just would not be showing up in your (ie HSC’s) data at this time. But that would mean collectors would always need to review patients who went to another ICU from the HSC ER (and likely the same for the STB ER, possibly even the GRA one...), so that seems like a lot of overhead. Are we OK to just identify SICU ECIPs as a population we likely usually don't capture? Ttenbergen 15:36, 2020 October 6 (CDT)
  • On the online Bed Board (https://whiteboard.manitoba-ehealth.ca/whiteboard/icu), there is a column OFF_service Patients which means any patient overflowing to either Resuscitation room in ED, PACU/PARR, ICCS, etc. and entry is real time. For HSC SICU, the common overflow location is PACU (haven’t seen any at ER). Only GRA ICU shows overflows in ER. This may give us a clue for possible ECIP but not sure how DC will crosscheck the online bed board if the timing won't synchronized. maybe we just have to ignore SICU ECIP if there is such a thing. --JMojica 16:27, 2020 October 6 (CDT)
ECIP all
  • Is that really specific to STB, or even specific at all? Doesn't that just mean following the usual instructions for these three fields? If so, we don't want to duplicate them here, because if anything about them changes, we would miss this spot in any updates. Ttenbergen 12:42, 2020 November 10 (CST)
ECIP all
  • what would even be the actual definition of a surgical / SICU ECIP? There is no surgical equivalent to a "Critical Care service" it seems. Ttenbergen 15:36, 2020 October 6 (CDT)
Emergency Surgery (concept) all This info is from 2009 - is it still the same? Ttenbergen 17:10, 2021 April 22 (CDT)
Encounter processing Pagasa
  • says inactive, but do you actually do this? Is there anything else to it? Do we have, and do you run any multi-encounter checks yet? I guess a lot of the PLs kind of are those...
EPR Lists all Are these the manual lists where you have to add patients? Instructions almost look like it's a counterpart to EPR Reports instead. Are these even still available? What are the advantages / disadvantages for this vs EPR Reports?
EPR Lists all Would it be correct to say that the lists are manually populated based on EPR Reports?
Extra shift sign up all checked by whom, main office or is that a directive to collectors?
Fixing a D ID in TISS28.accdb Pagasa Pagasa will test the quicker way, and if satisfied, will clean out the two old methods.
Form Covid rept Julie
  • Julie, pls have a look at that query in CFE and let me know if it contains what we need, otherwise explain what we need.
    • The query looks great. Just one additional request on the pivot - please make the column area to be combination of Arrived_Dt and Obs_for_Covid in order to show the trend across time. Thanks. --JMojica 08:58, 2020 April 20 (CDT)
Function long LOS() Julie Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry changed Service/Location to aggregate values for the whole stay in a program. The values used in s_dispo table for the longest likely LOS were filled with previous entries from the same program, but should likely be longer now, since an aggregate stay would on average be longer. Once we have some data with the new aggregate model we should update these values.
GI Scopes all I consolidated several mentions of capsule endoscopy here. Some had been edited to be inconsistent so I want to be sure. The old instructions had said to use (I) Digestive System, NOS as CCI 1, the new ones say to use (D) Large Intestine. Imaging by capsule endoscopy includes both the large and small intestine, and as an imaging code it should be combined with an imaging CCI1, so I think the old code was the better one to use. Why was it changed? Ttenbergen
Grace Hospital Contacts Manager Where is that form? Is there a link?
H1N1 Trish seems odd that we would have done a flu study only for 1 month in a summer...
Health Sciences Center Office all
    • Does Iris Deleon have a key?
Health Sciences Center Office all
    • Joanna Velasco - I have a key, but it doesn't work on any of the cabinets in the office.
      • Is that still true? Have you talked with Trish?
Health Sciences Center Office all
    • Lori Lovell - now that she's part time does she really still have a key?
Height and weight Task Z) decided to revisit SOFA scoring 6 months after ICD10 so same should likely go for this.
Hemodialysis days Julie
  • you requested this indicator page in one of our documentation meetings - please fill in the details or delete headings as appropriate.
Hospice Julie
Hospitalization in Winnipeg, Canada due to Occupational Disease: A Pilot Study Trish I see Pat's name... did this actually use the DB or just a collector? how did we support this publication?
HSC Boarding Locations Task
  • With Cognos, we would no longer capture boarding patients by looking at a location. So, is there any value in having this page? Is it being kept updated? Ttenbergen 09:48, 2021 September 2 (CDT)
HSC D5 all
HSC ICUs Data by Patient all based on DC Treatment, ICD10 Palliative care or what?
HSC ICUs Data by Patient all is that Pre-admit Inpatient Institution or Previous Location or what?
HSC MICU Collection Guide all
  • The following is outdated info, but I am not sure if there is anything special for MICU now, so leaving it. The up-to-date instructions for this are in Boarding Loc and Service tmp entry.
Due to the COVID-19 outbreak, some SICU patients are now being treated in MICU, until they are proven to be negative. See COVID-19 (SARS-COV-2)under Cohorting in HSC ICUs.
  • If they are under MICU service, enter them using HSC_MIC service location, and add SICU under MICU in the tmp file. See ICUotherService.
    • Once they are transferred to SICU, make a new file with HSC_SIC service location.
  • If for some reason the patient is in MICU under SICU service, enter them using HSC_SIC service location and treat it as a Boarding Loc.
HSC SICU Collection Guide all The following info is out of date. See Using Cognos2 to keep track of patients instead. I am leaving it only because I don't know if there is anything still relevant in here with the new process. Pls clean it out. Ttenbergen 19:49, 2021 January 21 (CST)
The SICU log census book is kept at the South Nursing station.
  • All admissions in the binder
  • If any admissions are missed, collectors can find them by checking the TISS forms and EPR, and add them in the log book.
  • Collectors sign off their patient admissions in the log book, by putting their serial number and initials on the left-hand side of the page.
    • Due to the COVID outbreak, we are now printing out an SICU Admission Register and Transfer Register from EPR Reports and dividing the patients the same way, but in our office.
HSC WRS3 all
  • Will this location profile be identical to what HSC_D5 was before?
Hypomagnesemia, severe or symptomatic Allan Per EPR normal Mg++ range is 0.63-0.94 mmol/L, to confirm are collectors to enter according to the guidelines above? Thanks!
ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rate Julie Do you mean "reported once per patient"? Because it could legitimately be duplicated in data if it happened twice, and it would now be more "per service admission" than "per patient"
ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rate Julie Just to be clear, is it number of cases (possibly >1 per pt) or once per pt as mentioned above?
ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rate Julie There was no significance listed in your PPT - what is it.
ICU Acquired Sepsis Julie
  • which dxs are used?
ICU Acquired Sepsis Julie Just to be clear, is it number of cases (possibly >1 per pt) or once per pt as mentioned above?
ICU Acquired Sepsis Julie Nothing was listed in your power point, what is the significance?
ICU Interfacility Transfer Julie What are the details?
ICU Resource Utilization - Chest Xrays Julie Is this DSM Lab Extract?
ICU Resource Utilization - Chest Xrays Julie What are the details?
ICU Resource Utilization - Creatinine Tests Julie Is this DSM Lab Extract?
ICU Resource Utilization - Creatinine Tests Julie What are the details?
ICU Var 6 - AMA Julie Did we transition the following into tmp or otherwise? Ttenbergen 13:58, 2017 June 6 (CDT) If we did not then this question can just be removed, but if we did move this elsewhere we should explain where to.
Inspection, Exploration (non-endoscopic) all I consolidated several mentions of capsule endoscopy here. Some had been edited to be inconsistent so I want to be sure. The old instructions had said to use (I) Digestive System, NOS as CCI 1, the new ones say to use (D) Large Intestine. Imaging by capsule endoscopy includes both the large and small intestine, and as an imaging code it should be combined with an imaging CCI1, so I think the old code was the better one to use. Why was it changed? Ttenbergen
L ICD10 APACHE Dx query Julie
  • You and Allan discussed what should be on the list. At some point we will need to integrate the result into this query. Did you end up including Acquireds? Since the first 24hrs might include them, but they might happen later, and the difference is not clear from Dx_Date? Ttenbergen 20:20, 2018 November 24 (CST)
Lab identification in the DSM data Julie
  • We should change this; however, do we only change it going forward or do we also re-import back data? Julie is about to re-import back data until 2019-01-01, so maybe we should reimport back data for all that far?
    • shouldn't it be Accept_DtTm and use Arrive_DtTm if Accept_DtTm is blank. We have discussed that in the Project Boarding Loc, we can still determine the counts in between Accept_DtTm and Arrive_DtTm if needed. --JMojica 10:25, 2019 December 10 (CST)
      • That is pretty much what I mean, it should be as you say. Do we want to do this going back in data as you re-import, or just going forward for future imports? Ttenbergen 09:41, 2019 December 11 (CST)
Labs data Task
  • Can we try to have blood gas results uploaded to EPR at the GGH? currently the blood gas results are transcribed from the lab report to a flowsheet. Often there are missing gases on either the flow sheet or hard copies of the lab report, this is time consuming for the collector to reconcile. Blood gases are uploaded to EPR for GGH ER and there was some talk about doing this some time ago. The manager for GGH repiratory is Ingrid Murphy Lisa Kaita 12:25, 2021 October 26 (CDT)
Laptop identifier all
  • That is phased out now, right? Where is that laptop now? Did the Workstation.mdb get updated with the info? Ttenbergen 10:44, 2021 December 2 (CST)
Length of Time for Transfer from ED to ICU within same facility Julie No significance in your ppt?
Length of Time for Transfer from ED to ICU within same facility Julie What are the details?
Link suspect mismatch to ours incomplete query Pagasa
  • There is a query Link suspect mismatch to ours incomplete2 (with a 2 at the end) in CFE. What is the story, and which one do you actually use?
LOS Medicine per hospital admission Julie "None yet." What does that mean in the context of "Target"? And how does "Target" fit in with the structure you described in Template:Reporting Indicators?
LOS Medicine per hospital admission Julie p:Dr. Dan Roberts You had this as "PRESCRIBED BY: "; which is not how you set it in Template:Reporting Indicators. Also, Dan is likely no longer the user of this, so it should probably be updated. If we use a title rather than a name it will be self updating.
LOS Medicine per hospital admission Julie
  • Is this still a thing? This would now be three different profiles, right? What of pt went to surgical ward in between instead? Ttenbergen 16:33, 2021 May 5 (CDT)
LOS Medicine per hospital admission Julie Does this mean time spent in an ICU between wards is included in the LOS? If not, can we tweak the text so that is clearer?
LOS Medicine per hospital admission Julie is this Arrive DtTm or Accept DtTm?
LOS Medicine per hospital admission Julie this still talks about TMSX... what is the new status of this field?
LOS per Location Julie Julie will fill in...
Lost/missing chart Pagasa
  • Pagasa, please let Tina know if these profiles with RecordStatus "Discontinued" are falsely triggering any cross checks in CFE. Ttenbergen 14:36, 2021 June 15 (CDT)
Julie says Pagasa keeps a list of old lost charts. Could you do a one-time update to set the relevant records to Discontinued in CFE and then get rid of that list.
Lung abscess Julie
  • SMW
  • Cargo


  • Categories
  • Lisa updated the includes for this to add "necrotizing cavitary pneumonias". So, I added the "Pneumonia" category. I think this is something Julie occasionally reports on, so I want to make sure that coding this pneumonia in a more generic waste basket will not cause problems for her reporting. Emailed Julie and Lisa with link to this.
    • Thanks. The investigator who had CAP request included this code too so I have added this code under pneumonia in my filtering. --JMojica 10:26, 2021 October 21 (CDT)
      • Do you not use the s_ICD10_Categories table for this kind of filtering? I thought we implemented that so we can be consistent with these things over time. Ttenbergen 10:59, 2021 October 21 (CDT)
Manitoba Health Crosschecking Background Julie
  • Need to know how this arrives to set up processing. Where will this data live? Ttenbergen 16:11, 2014 August 25 (CDT)
    • Actually, I think you have not been getting those for ages, right? We would just need to update that. We may or may not blow away this page, depending on whether we think we will ever get this again.
Mechanism of injury: hanging or strangulation (accidental or intentional) all
  • Some other related codes re the injury to the neck itself were discussed at task, can a collector pls fill them in for more comprehensive guidance re what might be codable with a hanging? Ttenbergen 10:18, 2021 November 10 (CST)
MediaWiki:Common.js all ", post: "
MediaWiki:Common.js Allan ", post: "
MediaWiki:Common.js Task ", post: "
MediaWiki:Common.js Tina ", post: "
Medical Assistance In Dying Julie
  • When we started out this dx used code U23, but then as of 2018-07-17 ICD10 actually added a code for this so we changed ours to that code. I don't really think we are interested in keeping that very early test data, so this comment can probably just go, and we can delete them. I am removing the code from our s_ICD10 table.
Medical noncompliance Allan Como Admit Acquired Primary Limits
Microsoft Teams all
  • Tina is looking into what it would take for collectors to have Teams provisioned without Office 2019 being installed. It is possible, since it's set up on Tina's laptop that way. There is an add-in that would facilitate booking Teams meetings from 2010, but Teams works without this and collectors may not really need that, if that's the hold up.
  • We will need to put in an ACMT form that now includes Teams, and put a comment to specifically not include the MS Office update. Then when we get the incident number we need to contact the service desk to request a work note as well to make sure there is no update to 2019, which will populate a part of their process documentation that might be more likely to be seen by whoever fulfills the ticket.
Minimal Data Set all If we want to prioritize like that it needs to be discussed in whatever page talks about data collection process and priorities - not here. That could link to here.
Minimal Data Set all Operationally what does "as soon as possible" mean? What collector process would capture this prior to the final chart review. If we want a requirement it needs to be actionable.
Mortality and readmission report Julie
  • we don't collect hospital discharge, what exactly is this?
Mortality and readmission report Julie
  • what kind of "admit dttm" is this, accept, arrive, service, boarding?
Mortality and readmission report Julie
  • With PatientFollow, do we still do this by unit?
Multiple LOS errors all
  • At some point we had disabled Query check_ER_Delay_not_too_big which would have automatically taken care of this bug, but we have since reinstated around 2021-09-15. Is this again a problem now, or is this solved? If I don't hear back from anyone that this is a problem I will consider it solved in 2 weeks. Ttenbergen 14:39, 2021 November 18 (CST)
Myocarditis, acute NOS Task
Night Time Discharges Julie Why only to wards? How about to home?
Non-standard ICD10 Diagnoses Allan
  • That link is broken, do you use a different reference now?

CIHI listing

    • I have contacted CIHI to find new link, there are problems on their web site. Ttenbergen 10:50, 2021 October 28 (CDT)
Notes field all
  • track all lab and pharmacy manually, the notes save time in that it eliminates the need to go back & recount.
    • would you not just enter a new line for these, and the date of the new line would tell you how far you got? Ttenbergen 14:24, 2014 September 19 (CDT)
Nursing Workload Julie Average or mean? Different in description and definition.
Nursing Workload Julie What are the details?
Outcomes Improvement Team all Is Jodi Walker Tweed (admin assistant) still the contact for this?
Over Census at Midnight Julie What are the details?
Palliative Service Julie
  • there was a question about palliation at beginning vs end of stay. It was discussed at task but never cleaned up. Could you have a look a this page? If this is all no longer an option, please delete the section. If it was resolved, then what did we decide? Or was that why we starte Comfort Care? Ttenbergen 00:01, 2018 November 27 (CST)
Pharmacy collection all working on this as of Ttenbergen 09:57, 2021 November 25 (CST)
Pre op Admit-Cardiovasc Patient Julie This is not coded under ICD10 or CCI. Do we report this, and therefore need to accommodate otherwise, or how will we treat this? We have Preparatory care (incl preop optimization) but that doesn't capture the full concept. Ttenbergen 22:45, 2018 November 27 (CST)
Pre-admit Inpatient Institution field Julie
  • Julie contacted Pam re STB Transitional, and will contact Lisa about HSC transitional and Lennox Bell and other HSC locations.
Pre-linking checks Pagasa This automatic list includes an PL missing L Tables content - where does it fit in into the order in which you run these above? It is likely a very first thing, right?
Pre-OP Admit - Research Patient - Cardiovascular Julie This is not coded under ICD10 or CCI. Do we report this, and therefore need to accommodate otherwise, or how will we treat this? We have Preparatory care (incl preop optimization) but that doesn't capture the full concept. Ttenbergen 22:45, 2018 November 27 (CST)
Previous Location field Julie
  • Julie contacted Pam re STB Transitional, and will contact Lisa about HSC transitional and Lennox Bell and other HSC locations.
Previous Service field Allan For non in-patients admitted direct to med via ER from endoscopy-is this considered ambulatory care? Also, for gastroenterology service what is entered: other (known but not on list)? Thanks!
Processing errors in patient data Pagasa
Project Borrow arrive Julie did they ever get back to us? no response from HSC SICU --JMojica 10:14, 2019 May 6 (CDT)
Public Entrance Likely Initial Page Task AJTT
  • Should we have a plan to review these regularly since they are front page linked, or are we OK with them being unmaintained? Or should we delete them altogether?
QA Infection VAP Julie will we still need to collect this in ICD10, since I think all the data now lives in the dx codes as well. I am holding off on implementing Query s tmp QAInf tmp no dx until resolved. same reply as in QA CLI. --JMojica 12:04, 2018 December 27 (CST)
QA Septic Shock Julie If we ever pick this back up we need to answer: Is "Every entry for project QA Septic must have either a date or a time." a request for a cross check? or does that check exist already?
Query check CCI CXR vs LOS Julie
  • ... This reminds me of another concern - should this be done vis-a-vis to boarding loc. if pt moves to another loc, enter a separate CXR entry starting on the next boarding loc date. Are we over doing these CCIs - too much work, are they needed? In the CC report, I need only a separation of CXR for HSC MICU and HSC SICU. This would not be a problem if we are handling continuous stay of MICU and SICU service in two records and not as one record in patient follow model. --JMojica 14:36, 2021 September 2 (CDT)
    • additional decision needed from Px Date - if we do collect different dttms for each Boarding Loc then the count needs to be per Boarding Loc LOS, not overall LOS. Ttenbergen 15:52, 2021 September 2 (CDT)
      • I am checking the sum of all counts in CCI since collectors can enter them over time, so for now I can do a cross check over overall LOS. If we want to break the cross check down further, let's discuss. Ttenbergen 16:49, 2021 September 15 (CDT)
Query check CCI CXR vs LOS Julie
  • Any checks required for these?
Query check CCI TISS discontinuous ETT all
  • Should we include a request to add a comment in notes when clicking past this to preempt future follow-up? Ttenbergen 13:36, 2021 November 10 (CST)
Query check CCI TISS discontinuous ETT Julie
  • I don't even understand when this check would ever make sense... what do you mean with this one?
Query check CCI TISS discontinuous ETT Julie
  • Most intubated patients eventually get extubated without getting intubated again; this check would flag every one of them! Is that actually what you want, or am I misunderstanding this one?
Query check has service entry Julie
  • This probably needs to be considered in context of Minimal Data Set - if it is part of that it changes the check time (ie for all records or only for complete records?).
Query check ICD10 duplicates all
  • the count is wrong, there wasn't a quick fix, so disabling the query for now. Ttenbergen 15:56, 2019 March 27 (CDT)
Query check long transfer delay Julie
  • At the meeting about cross checks (a long time ago) it was decided to change the cut-off to SD*3; if we want to proceed with this check, I will need values for that. Ttenbergen 23:08, 2020 October 15 (CDT)
Query check long transfer delay Julie
  • If we actually want a cross check like this it needs to be based not on NTU/CTU. We could either base it on specific units or on Level of care hierarchy, ie. add another column to s_level_of_care table. Would that work for you? Ttenbergen 23:08, 2020 October 15 (CDT)
Query check long transfer delay Julie
  • Requiring notes to have content is really a very soft error check... do we need to consider something better?
Query Import request matcher Pagasa This one is fairly easy, Pagasa will try to make it. Decided ages ago, but put on Pagasa's list today.
Query NDC Bad Postal Code Pagasa You mentioned that you occasionally got patients with letters rather than numbers; if that happens again, pls let me know.
Query s ICD10 Chapter block dxs Julie any other plans for these?
Query s tmp Boarding Loc date item Julie
  • if we enter unit info from Cognos, then the unit start date and time for the initial boarding loc will almost always be before the accept date and time. So I have removed that cross check for now so we can decide how we want to do this. I think we should enter the unit start from Cognos; this will be easier, less typo-prone, and it will allow us to eventually move to a system where we simply import this from Cognos possibly without human intervention (or in any case, possibly with only administrative intervention rather than from nurse data collector). It would mean treating this data differently to screen out the time on unit before service, and it would mean we can no longer cross check for this. We will need to review out cross-checks anyway, we don't have one for services yet at all. Emailing Julie for input. Regardless of the what we decide, we will need to clarify this in Boarding Loc since collectors are likely entering this first boarding slightly differently. Ttenbergen 16:48, 2020 November 6 (CST)
Readmission Julie
  • Does the following need to be moved to one of the sub pages? Or can it be deleted, if it is only about how we used to report (vs store) data in the distant past?

Legacy information

  • (Legacy: planned surgery used to be excluded, but this stopped because of insufficient data when we stopped collecting some APACHE elements in the medicine program Dec 31, 2006)
Readmission Rate to ICU Julie
  • might be readmitted from Ward within or outside Winnipeg hospitals or home or nursing home
    • can also specify to include only from any ward within the region.
Readmission Rate to ICU Julie
Reporting from ICD10/CCI Julie
  • Different procedures would be listed with the same CCI code; will Julie easily interpret and utilize CCI codes for reporting?
  • Do we care that we will not be able to differentiate between a Blakemore tube from an Upper GI scope with banding or hemostasis, when in CCI they both look the same: (T) Stomach, pylorus... and Control of Bleeding. --LKolesar 14:11, 2018 May 1 (CDT)
    • discussed at task 14:08, 2018 June 20 (CDT), Julie to review what she needs and we will discuss again Ttenbergen 14:08, 2018 June 20 (CDT)
Requested TISS changes for the next version Julie
  • Is this still relevant or required? After the changes we made to TISS 28? What is the intended use of these reports? I will add the report template so this gets drawn into relevant lists, but if we want to go ahead with it each report should be on its own page. Ttenbergen 13:22, 2021 July 5 (CDT)
Resource Use Julie which others in Category:Indicators
Risk factors for seizures in cardiac surgery ICU Patients Julie Can't find any reference to this paper. The Pubmed link instead goes to an article "A survival benefit of combination antibiotic therapy for serious infections associated with sepsis and septic shock is contingent only on the risk of death: a meta-analytic/meta-regression study." how did we support this publication?
S dispo.loc type Julie Indeed, what is the description? Especially in contrast to S dispo.service type; when you give the answer, please put it behind "element_description" above and delete this question.
S dispo.service type Julie Do you know what is the description? Especially in contrast to S dispo.loc_type. How do you use this? Please put the answer in the element_description above
S dispo.service type Julie entries in s_dispo table might be inconsistent with entries on wiki. Which are right? These are mostly used by you for Reporting so could you please make sure wiki and dispo are consistent? Or, we could take them out of wiki if you would rather not maintain them in two places.
SAS application for Missing Transfer Ready Time Julie Is this all still a thing? If so, then since tehre is no more CCVSM what are the criteria?
SAS Data Integrity Checks Julie Now that we have a structure for cross-checks we should add those you do in SAS to here as well, using the same structure as for those listed in Data Integrity Checks Ttenbergen 20:46, 2018 October 26 (CDT)
Scheduled Tasks Pagasa Do we still schedule Backup Checker?
Sending Patients Task
  • I just came across over 200 sent patients on a laptop data that had been sent and not been deleted; I have not systematically checked the situation on other laptops. We are only supposed to have currently active records on the laptops. Our documentation of this is not completely clear, it just says you can but should not, but gives no further guidance. On the laptop I reviewed almost half the total records were of sent patients, and if the "last opened" dates are right some had not been touched since March, which is definitely more than I had figured when I last read that on wiki. What would be a reasonable but tighter guideline for how long send records can be kept and how they should be managed? Ttenbergen 09:58, 2021 May 13 (CDT)
Service/Location field all
  • Could we remove this from the STB ICU laptops as we are doing a kind of follow system?
    • I think Julie still uses this. Also, other sites still have to enter it, they simply always enter the same thing. I think you requested this because of some confusion lately about what defines a new profile at STB CC. And that was important to figure out, and we still need to document it, likely at STB Critical Care Collection Guide. But once that is clear then entering this field should be trivial. I will send an email to DC STB CC; Jmojica to pls review Ttenbergen 11:37, 2020 December 10 (CST)
Service/Location field Julie
  • Julie contacted Pam re STB Transitional, and will contact Lisa about HSC transitional and Lennox Bell and other HSC locations.
Severe Sepsis Julie I don't think this was ever implemented, can't find any evidence of it. Do we need it? Ttenbergen 11:04, 2018 September 25 (CDT)
Severity of illness Julie Is this average as in description or mean as in definition?
Severity of illness Julie What are the details?
SOFA scoring Task Z) decided to revisit 6 months after ICD10
Sorting in PatientList breaks when some Cognos Entries are done all
  • With entry of any data using ADT2 tab via CSS/CUS/CE into a profile will result in patient list freezing.
    • This happens even if the PatientList was closed (and maybe it happens only if it was closed? )
  • This occurs when the Patient list is closed, I have not used CSS/CUS/CE with the patient list open. Should the patient list be open or closed while using CSS/CUS/CE or does it matter? Thanks, --Pamela Piche 14:11, 2020 December 10 (CST)
    • you should be able to have it opened or closed, depending on how you do your work, it should not cause the sorting to freeze. And hopefully no longer will, once I roll out the fix I just added. Ttenbergen 14:23, 2020 December 10 (CST)
Spontaneous breathing via ETT without PEEP/CPAP, with or without supplemental O2 (TISS Item) Task
  • we changed the name of this, but we are not actually collecting it right now. Do we really want to start to collect it again?
  • the original had 2 points (as per info box), will it really change to 1?
Statistical Analysis Julie This article will likely be one of the more common landing points for external users. What do we want to tell them? Do we have any project articles we want to link in that especially highlight what we can do? ALERT Scale?Ttenbergen 22:50, 2017 June 7 (CDT)
StatusReport.bat Pagasa
  • have we got rid of all these old files? IF so we can delete these articles, but if they are still around we might want to keep them... I think we should just get rid of the files, though. Ttenbergen 22:42, 2017 June 7 (CDT)
    • confirmed that X:\PAGASA\STATUS_REPORT still exists; can we clean that up?
STB ACCU Collection Guide all Is this section still relevant with Cognos?
STB Boarding Locations all
  • Any other boarding locs for STB Med?
STB Cardiac Care patients all
  • the Arrive DtTm for CICU pts is when the pt. actually enters the unit
    • Isn't that true everywhere? Emailed Steph to clarify. Ttenbergen 11:56, 2021 February 22 (CST)
STB CICU Collection Guide all Is the following still true or relevant with new processes? :
  • The unit admission log book is kept at the main desk in front of where the ward clerk sits along with a binder to keep the completed TISS
  • Check the white board every day for those patients who will likely be transferred out to the ward that day. If they are on the transfer list you may want to pull the tiss sheet before they get transferred.
STB CICU Collection Guide all The following list is different from Contacting Quality Officer and Manager for VAPs and CLIs. Is it still accurate? If so, we need to link from that page to here, else we should get rid of this section. Ttenbergen 14:30, 2021 March 4 (CST) Belinda Landy, Nurse Educator, Geri Henry, CRN, Teresa Rostek, CRN & Rob Ariano, Pharmacist
STB General Collection Guide all Is info in this section still up-to-date? Ttenbergen 10:00, 2021 December 1 (CST)
STB ICUs CAM Rate, VAP Rate, CLIBSI Rate Summary Julie
  • Julie said: "Monthly statistics regarding the Delirium/Confusion cases in complication Diagnosis, counts of patients with at least one day marked with CAM+ and total CAM+ days and their associated rates for STB ICMS, ICCS and ACCU." - Is that the indicator Delirium days which I suggested elsewhere we should turn into just "delirium" so it can include rates etc? If so, we should move this description into that page and leave this page to mention the indicator in the template above, unless this report does something very specific with that indicator concept.
Swap Locations all
  • Another option, and this seems to be what is being done now, is for collectors to "exclude" unit lines from Cognos that list "wrong" start or end times because part of the time is in a swap location.
Swap Locations all
  • Debbie: When you say "the next entry in the location history", you mean the history on the EPR, right? Ttenbergen 09:26, 2020 December 3 (CST)
    • Yes, the location history in the epr. Each scenario with a swing bed entry can be different, and needs to be reviewed to ascertain the true and correct information. DPageNewton 09:45, 2020 December 3 (CST)
Swap Locations all
  • I supposed this swing bed is already happening in the past, before we have this COGNOS admitter. How it is handle? 1) is it included – such that the accept date is taken from that line of swing bed or 2) excluded and the next line where the Accommodation has an entry is the one chosen? I think we need to decide first if to include or not before solving the exclusion process. who to ask? --JMojica 16:02, 2020 December 2 (CST) we do 2)
    • excluded and the next line where the Accommodation has an entry is the one chosen? DPageNewton 10:59, 2020 December 3 (CST)
  • Absolutely agreed, Julie. But there is also an element of us reporting info different than maybe what other, EPR based reports would show. #"Swing beds" at STB shows the list of swing bed locations that show up in the Cognos data. They all are associated by name and data to the ward locations. So anyone generating data from EPR/Cognos would associate these with the units, not the previous location. We would be the only place associating them with still being in the ER. I just reviewed the raw Cognos data, and we get the bed, but not the bed start and end dttm. If we could get that we would be able to figure out what percentage of total LOS is affected by this, but it probably has the biggest impact on ER wait times
    • in the example I gave above, yes the er wait time is what would be affected. DPageNewton 10:59, 2020 December 3 (CST)
      • It sounds like anyone just looking at Cognos data would underestimate that time because pts look like they are on unit already. Ttenbergen 09:56, 2020 December 3 (CST)
        • I've spoken with the ward clerks on E5 on more than one occasion, and have been told, that when there is a swing bed entry for example, between an er location, and a ward location, the patient is still physically in the er, and has not been transferred up to the ward. e.g. #2-if the swing bed location is between say, E5, and another usual ward or unit location, then the patient is still physically on E5. In this example the los for E5 would be affected. I think that this is a concept that is not so easy to explain in words, especially if you're not particularly familiar with the ins and outs of epr. DPageNewton 10:59, 2020 December 3 (CST)
Swap Locations all
  • Is there ever "room for interpretation" where both collectors would still consider the pt on their unit, or where both would consider them already/still on the other unit? If not, how and why?
    • I don't think there is room for "interpretation" as the entry for the "swing bed" is simply ignored, as if it weren't there. We at St. B. have been dealing with this issue since the beginning of time. DPageNewton 10:59, 2020 December 3 (CST)
Swap Locations all
  • One option would be to omit lines with current unit is a swap location from the cognos data via filter automatically, but it's not clear if this will result in the previous and subsequent records having non-matching next locations and previous locations. Can we just delete these lines from Cognos? Ttenbergen 14:03, 2020 August 28 (CDT)
Swap Locations all
  • Would it make sense to talk to STB about how the swing beds are used by ER? I don't think talking to anyone about how the swing beds are used by er would be helpful. I've explained in great detail a number of times, to a number of people why this occurs. I can't think of anything different that could potentially be done to work around the issue as it occurs in the first place. DPageNewton 10:59, 2020 December 3 (CST)
Swap Locations all One problem with filtering these out would be that, I think, the unit record for a swap location might be the same as the unit record for a successive stay in that unit; ie. the bed entry chagnes, but the unit remains the same. So, the unit start dttm and unit end dttm don't care if part of the unit stay was in a swap location. Is that not true? If it is true, then how would we filter these out? if I eliminate every line that has a swap/swing bed (which I can do) then we will not get any line for those pts who never get into a real bed on that unit (which may be good), but we would still get the same line with unit start and end times including the swap/swing time for patients who eventually get into a bed on that unit. Ttenbergen 12:07, 2020 December 2 (CST)
Swap Locations Task
  • Allan, Julie and Tina had discussed this at a different meeting and decided we should just collect the swing beds as if they were already on the unit. The assumption was that they would only be in a swing bed for a few hours at most.
    • Stephanie pointed out that some of the cardiac pts are listed as in a swing bed for the whole duration of their OR stay (whereas others are listed as in OR). So it appears that the amount of time pts spend in swing beds can be considerable.
      • We decided to hold off on this discussion and bring it forward at the next task meeting which is Dec 16. Ttenbergen 11:28, 2020 December 8 (CST)
Task Team Meeting - Rolling Agenda and Minutes 2021 all '* What if awaiting code is primary reason? Sent Allan an email with counts about this. Ttenbergen 14:03, 2021 August 26 (CDT)
Task Team Meeting - Rolling Agenda and Minutes 2021 all Not sure why this is listed in this spot, but Tina has made the time component available in the Dx Date field and updated instructions.
Template:CCI Guideline Capsule Endoscopy all I consolidated several mentions of capsule endoscopy here. Some had been edited to be inconsistent so I want to be sure. The old instructions had said to use (I) Digestive System, NOS as CCI 1, the new ones say to use (D) Large Intestine. Imaging by capsule endoscopy includes both the large and small intestine, and as an imaging code it should be combined with an imaging CCI1, so I think the old code was the better one to use. Why was it changed? Ttenbergen
Template:ICD10 Guideline Admit vs Acquired Allan Como Admit Acquired Primary Limits - this is part of that discussion - if we limit which admits will count as comos we need to review
Template:ICD10 Guideline Admit vs Acquired Allan Rules 1 and 2 are clear, could rule 3 be further clarified
Template:ICD10 Guideline Como vs Admit Allan Como Admit Acquired Primary Limits - this is part of that discussion - if we limit which admits will count as comos we need to review
Template:ICD10 Guideline MRSA Allan z "It was decided that Allan with contact Dr. Embil after COVID is over and see if we can obtain this data from Infection Control. If so, we could import it into the database, and have our data collectors cease obtaining it." - did anything come of that?
Template:ICD10 Guideline Signs Symptoms Test Results not needed when cause known Allan
  • Apply it to symptoms, physical exam findings, and radiologic findings, but NOT to laboratory findings.
    • I don't know which those would be. If we go through with this definition we should just stick them into a : or similar. Category:Testing also contains non-lab findings. Where would this leave things like Fecal occult blood test, positive? The "What links here" link on the left would show all that currently links to this page.
Template:ICD10 Guideline Transplant Failure Julie
  • Is "don't code history of transplant when coding transplant rejection because it's implied" something you are aware of? It's not something I would have thought of if you had asked me to write a query that lists all records with previous transplants. If we want to change this could you bring it to task meeting? Ttenbergen 16:41, 2020 January 31 (CST)
Template:Location dropdown cleanup Julie
  • Julie contacted Pam re STB Transitional, and will contact Lisa about HSC transitional and Lennox Bell and other HSC locations.
TISS28 backup and start.vbs Pagasa Do you still use this? It is not linked, so as part of what process?
TISS28 Form Scanning Pagasa
  • If a frozen version is kept available during TISS scanning anyways then there is no reason to not do these checks in CFE, is there? Or rather, collectors sending would not be the reason. Pagasa, let's talk about this. Maybe we can make this more convenient for you. Or write down the actual reason why it can't be done. Ttenbergen 00:34, 2017 November 12 (CST)
    • Discussed this with Pagasa. It would mean doing scanning during send time, and likely doing all fixes during pull time, so all checks could actually be done form CFE. Discussed also w Pagasaa that we would delete the error checks from TISS so there is no duplicates getting out of sync.
      • Do we want to make this change then, Pagasa? You would be the only one who would be affected, so mostly up to you. Maybe confirm with Trish.
Tracheostomy days Julie
  • you requested this indicator page in one of our documentation meetings - please fill in the details or delete headings as appropriate.
Transfer Delay (Medicine) Julie
  • I don't quite understand this. Does it mean that, for whatever report uses this, it only considers the TRDtm+4hrs?
Transfer Ready DtTm tmp entry Task 1
Transfer time rule Julie I suspect this is all legacy, we would use the proper dates and times from EPR now, right? If so I propose we delete this page without leaving a legacy entry since knowledge of this is not really required to makes sense of our data. Ttenbergen 22:08, 2020 October 15 (CDT)
Transitional Care all Last used 2021-03 as per query z_s_dispo_lastUsed - is this still a thing?
Update of D ID exclude service/location all
  • can someone else think of how this might not work out right?
Validation against Patient Registry Data Julie This page was started long ago to keep track of our attempt to get access to the registry. I think it would be good to re-convene on it so we have a central point where past efforts and current efforts can be tracked. That would also make it easier to take it to task or steering and have consistent info. Do you have a log of this somewhere? We can rename it if you want.
What is a service admission Allan
  • Service history information is available in EPR, but the data collector role doesn't have access to it. INC000004363742 was created to get access. As of 2020-11-25, this was put on hold by eHealth.
    • Allan will follow up with Don Thiessen. Ttenbergen 09:46, 2020 November 26 (CST)
      • Trish emailed Allan for involvement 2021-01-20
      • Discussed with Allan, he will contact Don Thiessen. Ttenbergen 10:53, 2021 August 5 (CDT)
      • Allan confirmed that he will follow up. Ttenbergen 10:42, 2021 September 7 (CDT)
Wrong service or unit entries in Cognos all
  • Should collectors just totally wing it for these? Enter what seems right when they review the chart? Or do we need to be more consistent and deliberate about it? Ttenbergen 11:58, 2020 December 2 (CST)