Questions

From CCMDB Wiki
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 96 unassigned questions.

wiki page question Last modified
2020-04 HSC COVID unit transition
  • 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.
 2021-03-24 9:47:26 PM
2020-05 HSC COVID unit transition
  • 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.
 2021-03-18 6:35:09 PM
2020-05 HSC COVID unit transition
  • Have not yet checked how this will impact CFE Data Integrity Checks. Pagasa, of the top of your head which would be impacted and how?
 2021-03-18 6:35:09 PM
2020-05 HSC COVID unit transition
  • Julie wrote - We should have a cut-off date for the additional covid ward D2 and MS3. As I understand these new wards are for covid positives. Once dates are confirmed, then we start collecting at D2 and MS3.
    • Currently D2 is still a suspect ward, D4 is still our only COVID + ward Lisa Kaita 17:01, 2020 April 16 (CDT)
      • May 12.20 D2 C is no longer suspect ward. will now be ortho pts. D4 will house both suspect and +ve covid
      • May 26th.20 D4 started transitioning to accept all D medicine patients, no longer a dedicated COVID positive or suspect ward. By May 28th, this transition was completed, and all patients from D5 were moved back to D4.
 2021-03-18 6:35:09 PM
2020-05 HSC COVID unit transition
  • We have no CCMDB.accdb Data Integrity Checks yet for Boarding Loc , so that won’t limit our options. Is this the time to add cross-checks?
    • Yes, I think we need to add now the integrity checks. See below and check if I have missed anything:
      • 1. Date_var and Time_var must not be before Accept DtTm/Arrive DtTm
      • 2. Date_var and Time_var must not be on or after Dispo DtTm
      • 3. Item should not be the same as the service_location for Medicine profile
      • 4. Item should be either ‘no borrow’ or with boarding item but must not have both
      • 5. When having a boarding location, both date and time must be present. Should not have missing time.
---JMojica 08:52, 2020 May 28 (CDT)		 2021-03-18 6:35:09 PM
2020-05 HSC COVID unit transition
  • Does that mean all those should be removed as s_dispo table entries? If we keep them in both linking will mess up.
    • are you using the tmp entries in linking? I use the s_dispo when I do linking. I use the tmp entries to calculate time spent in each boarding loc and home ward. --JMojica 11:03, 2020 April 15 (CDT)
      • No, not using tmp entries for linking, but if info is kept in tmp instead of new record added then the dispo entry in previous record or previous entry in next record may not match with the service location.
 2021-03-18 6:35:09 PM
2020-05 HSC COVID unit transition Depending on how we do this with tmp vs service location we may end up with linking issues and orphans; need to review. 2021-03-18 6:35:09 PM
2020-05 HSC COVID unit transition what is STB ICU doing for suspect or positive covid patients? Will they be in the ICMS along with nocovid?Trish Ostryzniuk 17:27, 2020 May 7 (CDT)
  • Suspects are on units ICSM, ICCS and ACCU. COVID+ are in ICMS together with the nonCovid as shown in the database.--JMojica 10:33, 2020 June 11 (CDT)
 2021-03-18 6:35:09 PM
2020-05 HSC COVID unit transition what needs to change on laptops? Trish Ostryzniuk 18:00, 2020 May 12 (CDT) 2021-03-18 6:35:09 PM
2020-06 s dispo table cleanup
  • Emailed Pagasa to change STB_E5a-880 one to service location STB_E5 so we can delete the STB_E5 entry. Ttenbergen 14:22, 2020 June 5 (CDT)
 2020-06-17 2:34:54 PM
2020-06 s dispo table cleanup
  • The pages behind the following links should probably be deleted, since there are no entries for them; however, at least some of them are linked from other places, so those links need to be cleaned up as well...
 2020-06-17 2:34:54 PM
Admit Type for APACHE II
  • 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)
 2021-04-22 10:09:25 PM
Arrive DtTm field
  • This may still be inconsistent with the dt and tm in Boarding Loc, need to make sure we all use the same instructions.
 2021-08-03 4:45:43 PM
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
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-03-04 8:43:53 PM
Courier This is inconsistent with the GRA instruction below where it says no cost centre required. 2021-03-04 8:43:53 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-03-04 8:43:53 PM
Created Variables Common table
  • details needed
 2021-04-21 7:37:10 PM
Created Variables Common table
  • details needed
 2021-04-22 2:21:31 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
Direct admit
  • So we only report those that do come through the ED? Do we report how long they spend in ED, or just counts?
 2021-08-04 6:52:54 PM
Director's Chart Report as in Bed occupancy? 2021-07-13 10:05:28 PM
Director's Chart Report as in Severity of illness? 2021-07-13 10:05:28 PM
Director's Chart Report is that Primary Admit Diagnosis only, or of all dxs? 2021-07-13 10:05:28 PM
Director's Chart Report What are Quality Indicators? 2021-07-13 10:05:28 PM
Director's Chart Report What are Regional Indicators? 2021-07-13 10:05:28 PM
Directors Quarterly Report (Critical Care) CCVSM is no more, what should really be listed here? 2021-07-13 9:32:43 PM
Directors Quarterly Report (Critical Care) Is that the dx reported, or the Ventilator Associated Pneumonia Rate? 2021-07-13 9:32:43 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-04-21 4:53:13 PM
GRA General Collection Guide
  • is that still true? Is there a local link that could be put so that when this changes it will get updated?
 2021-07-22 4:59:11 PM
GRA General Collection Guide
  • That link is broken; is Winnipeg West still relevant or can we remove the whole line?
 2021-07-22 4:59:11 PM
GRA Medical Records requests I moved info here that was in GRA General Collection Guide. It needs to be pruned down to a current state instruction for what a vacation covering collector would need to know: where is MedRec, how do we request charts, and how do we access them once available. Ttenbergen 15:36, 2020 October 7 (CDT) 2020-12-15 3:47:55 PM
GRA Medicine Collection Guide Is this section actually relevant to collection? How would a vacation covering collector from elsewhere need to use this? If it's not relevant, can we take it out? 2020-10-09 2:03:28 AM
GRA PACU inconsistent with count in infobox, what is the location profile? 2021-07-14 9:35:37 PM
Grace Hospital Contacts Where is that form? Is there a link? 2020-01-02 2:15:10 AM
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
Hospice 2020-04-10 4:32:49 AM
HSC Boarding Locations
  • 2018_Aug_1: Dr Dowhanik /Dr. Vanymede are emptying the B5 medicine beds and will not admit into them unless "emergency/ absolute need" for medicine overflow patient movement. The B5 bed overflow option will be "formally closed" within 6 months.-Llemoine 09:25, 2018 August 1 (CDT)
    • Did that ever happen? If so, can we clean this section out of here if it's no longer applicable? Ttenbergen 21:36, 2020 October 8 (CDT)
 2020-12-15 3:48:13 PM
HSC D4
  • for a while we had a mention of a D4 pre COVID ward. No such thing in s_dispo table and not sure if the ward is back to being the regular H Service ward. Could someone update what happened there and where we are at now? There might be hints and mentions in Category:2020 COVID unit transition Ttenbergen 21:31, 2020 October 8 (CDT)
 2020-12-23 9:25:05 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 IICU Collection Guide 2021-05-05 2:27:01 PM
HSC IICU Collection Guide Could someone pls update that list to the new Laptop identifiers H7, h8, h9? I didn't just do it because want to be sure the most current numbers are used, if there were changes. 2021-05-05 2:27:01 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 Unknown Service
  • So if Lisa had to cover for one of you while you are aware, how would she know which ones to pick up. Do you have a method for splitting these?
 2020-01-30 10:28:50 PM
HSC WRS3
  • Will this location profile be identical to what HSC_D5 was before?
 2020-12-23 9:34:51 PM
ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rate 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" 2021-04-30 3:28:49 AM
Lab identification in the DSM data
  • 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)
 2020-05-14 7:39:29 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
Mortality and readmission report we don't collect hospital discharge, what exactly is this? 2021-06-15 9:38:28 PM
Mortality and readmission report what kind of "admit dttm" is this, accept, arrive, service, boarding? 2021-06-15 9:38:28 PM
Mortality and readmission report With PatientFollow, do we still do this by unit? 2021-06-15 9:38:28 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
Previous Location field this is wrong 2021-07-27 4:25:40 PM
Processes around changing a PatientFollow assignment The error is annoying because it comes up repeatedly. There is an email exchange between Pam, Julie and Tina to find out how best to deal with this. Ttenbergen 20:56, 2021 January 14 (CST) 2021-01-15 2:58:01 AM
Proposed future changes to Location and Transfer Ready and related fields
  • As for unit, I propose we drop the "end" one...
 2021-06-15 9:29:39 PM
Proposed future changes to Location and Transfer Ready and related fields
  • I propose we drop the "end" one since it would be the start of the next one (ie duplication) or the Dispo DtTm. If we include the Unit End DtTm we should get rid of the Dispo DtTm. Ttenbergen 15:50, 2021 February 11 (CST)
 2021-06-15 9:29:39 PM
Query check tmp Service and Boarding Loc during admission timeframe
  • Accept DtTm resp Arrive DtTm are largely duplication of the Service tmp entry and Boarding Loc dates and times. I believe we had discussed that we should therefore remove those fields eventually. So we should not implement a check now on fields we are planning to get rid of shortly.
  • Even if we kept the fields, Accept DtTm is only to be entered for pts from ER, so would not always be there, and the Service tmp entry start dttm could well be before the arrive dttm.
 2021-03-10 3:34:40 PM
Query NDC Dxs vs TISS Dialysis Would we need to add COVID to this before implementing? 2021-04-07 10:17:12 PM
Query TISS Errors NrTISSDays NE LOS Is this check actually needed? 2020-12-03 3:31:22 AM
Readmission Rate to ICU
  • 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.
 2021-08-04 3:56:21 PM
Sending TISS forms Do you do collect forms for combined sending / drop off? Where, how? 2020-09-23 3:50:33 PM
Sending TISS forms Do you do collect forms for combined sending? Where, how? 2020-09-23 3:50:33 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
Statistician's PC Is that report in Quarterly report? Which one is it? Or do we need a new page for it? Ttenbergen 10:22, 2021 July 8 (CDT) 2021-07-08 3:22:50 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
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-03-29 2:59:31 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-03-29 2:59:31 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-03-29 2:59:31 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-03-29 2:59:31 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-03-29 2:59:31 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-03-29 2:59:31 PM
TISS28 Collection Guide 2021-03-04 8:39:00 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
Urinary system NOS, congenital malformation 2021-08-03 3:04:51 PM
Urinary system NOS, congenital malformation again, if not congenital wouldn;t this be a different code, see below? 2021-08-03 3:04:51 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 276 questions.

wiki page who question
(I) Digestive System, NOS Allan
  • What would this code be used for? An example here would be helpful, thanks!
2020-04 HSC COVID unit transition all
  • 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 all
  • 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 all
  • Have not yet checked how this will impact CFE Data Integrity Checks. Pagasa, of the top of your head which would be impacted and how?
2020-05 HSC COVID unit transition all
  • Julie wrote - We should have a cut-off date for the additional covid ward D2 and MS3. As I understand these new wards are for covid positives. Once dates are confirmed, then we start collecting at D2 and MS3.
    • Currently D2 is still a suspect ward, D4 is still our only COVID + ward Lisa Kaita 17:01, 2020 April 16 (CDT)
      • May 12.20 D2 C is no longer suspect ward. will now be ortho pts. D4 will house both suspect and +ve covid
      • May 26th.20 D4 started transitioning to accept all D medicine patients, no longer a dedicated COVID positive or suspect ward. By May 28th, this transition was completed, and all patients from D5 were moved back to D4.
2020-05 HSC COVID unit transition all
  • We have no CCMDB.accdb Data Integrity Checks yet for Boarding Loc , so that won’t limit our options. Is this the time to add cross-checks?
    • Yes, I think we need to add now the integrity checks. See below and check if I have missed anything:
      • 1. Date_var and Time_var must not be before Accept DtTm/Arrive DtTm
      • 2. Date_var and Time_var must not be on or after Dispo DtTm
      • 3. Item should not be the same as the service_location for Medicine profile
      • 4. Item should be either ‘no borrow’ or with boarding item but must not have both
      • 5. When having a boarding location, both date and time must be present. Should not have missing time.
---JMojica 08:52, 2020 May 28 (CDT)
2020-05 HSC COVID unit transition all
  • Does that mean all those should be removed as s_dispo table entries? If we keep them in both linking will mess up.
    • are you using the tmp entries in linking? I use the s_dispo when I do linking. I use the tmp entries to calculate time spent in each boarding loc and home ward. --JMojica 11:03, 2020 April 15 (CDT)
      • No, not using tmp entries for linking, but if info is kept in tmp instead of new record added then the dispo entry in previous record or previous entry in next record may not match with the service location.
2020-05 HSC COVID unit transition all Depending on how we do this with tmp vs service location we may end up with linking issues and orphans; need to review.
2020-05 HSC COVID unit transition all what is STB ICU doing for suspect or positive covid patients? Will they be in the ICMS along with nocovid?Trish Ostryzniuk 17:27, 2020 May 7 (CDT)
  • Suspects are on units ICSM, ICCS and ACCU. COVID+ are in ICMS together with the nonCovid as shown in the database.--JMojica 10:33, 2020 June 11 (CDT)
2020-05 HSC COVID unit transition all what needs to change on laptops? Trish Ostryzniuk 18:00, 2020 May 12 (CDT)
2020-06 s dispo table cleanup all
  • Emailed Pagasa to change STB_E5a-880 one to service location STB_E5 so we can delete the STB_E5 entry. Ttenbergen 14:22, 2020 June 5 (CDT)
2020-06 s dispo table cleanup all
  • The pages behind the following links should probably be deleted, since there are no entries for them; however, at least some of them are linked from other places, so those links need to be cleaned up as well...
AaDO2 Julie I wonder if "null" is actually intended here, or if it was supposed to be 0. Ttenbergen 14:44, 2017 January 8 (CST)
  • AaDO2 is null if there is no data for FIO2, PaO2 and PaCO2. However, no data was set to zero value instead of null. In addition, AaDO2 and the corresponding score are required only when FIO2 >= 50%, otherwise should be treated as null. (Similarly with PO2 score, it is required when FIO2 < 50% and otherwise should be treated as null. When FIO2 =0, both AaDO2 and its score and PO2 score should be null.) Are we setting null to zero to facilitate the programming calculation? Is it possible to differentiate null from valid zero in both L_LOG and created_variables_CC - will the work be big? In L_LOG, these are the FIO2, CO2, PO2 and SerCO2. 14:49, 2017 March 16 (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 all
  • 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)
Arrive DtTm field all
  • This may still be inconsistent with the dt and tm in Boarding Loc, need to make sure we all use the same instructions.
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)
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.
CAM positive (TISS Item) Julie
Cardiac arrest Allan Como Admit Acquired Primary Limits 1/ Dx grouping - this is part of both of those discussion
  • 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; Just leaving it here as an example.
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.
Central Line Associated Blood-Stream Infection (CLA-BSI) rate Julie
    • A central lines (CL) is a central venous catheters (CVC) that terminates at or close to the heart or one of the great vessels. Great vessels include the pulmonary artery, superior vena cava, inferior vena cava, brachiocephalic, internal jugular, subclavian, external iliac and the common femoral veins.
      • Could we link to Central Line for details instead so that if we change any they will remain consistent?
Change from Awaiting/delayed dx codes to Transfer Ready DtTm Task Change on hold until discussed.
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 CCI CXR vs LOS Julie would we not use Accept DtTm here? Because we could have CXRs on days before arrival...
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?
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 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 CC table Julie does that field still make sense now with Boarding Loc?
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)
Created Variables Common table all
  • details needed
Created Variables Common table Julie
  • Not sure why we have this field, it seems to be the same as GCS_Eye_text. Can we remove it? Ttenbergen 16:22, 2021 April 21 (CDT)
Critical Care Inter-facility Transfer Report Julie
  • Is semi-annual a thing? I don't see any in Reports.
Critical Care Regional OpPlan Julie Added this because CAM positive (TISS Item) refers to it. What is this report?
CRRT Days Julie Based on what, CRRT, CRRT, CRRT Project?
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)
Definition of a Medicine Laptop Admission Task
Delirium days Julie What are the details?
Direct admit all
  • So we only report those that do come through the ED? Do we report how long they spend in ED, or just counts?
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 all as in Bed occupancy?
Director's Chart Report all as in Severity of illness?
Director's Chart Report all is that Primary Admit Diagnosis only, or of all dxs?
Director's Chart Report all What are Quality Indicators?
Director's Chart Report all What are Regional Indicators?
Director's Chart Report Julie
Directors Annual Report (Critcal Care) Julie
Directors Quarterly Report (Critical Care) all CCVSM is no more, what should really be listed here?
Directors Quarterly Report (Critical Care) all Is that the dx reported, or the Ventilator Associated Pneumonia Rate?
Directors Quarterly Report (Medicine) Julie
  • Medicine Task Elements
    • tasks are no longer collected, what should really be listed here?
Distribution of Annual and Quarterly Reports Julie Julie, what, is this "regional report", is it different from all sites or own site?
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.
GRA General Collection Guide all
  • is that still true? Is there a local link that could be put so that when this changes it will get updated?
GRA General Collection Guide all
  • That link is broken; is Winnipeg West still relevant or can we remove the whole line?
GRA Medical Records requests all I moved info here that was in GRA General Collection Guide. It needs to be pruned down to a current state instruction for what a vacation covering collector would need to know: where is MedRec, how do we request charts, and how do we access them once available. Ttenbergen 15:36, 2020 October 7 (CDT)
GRA Medicine Collection Guide all Is this section actually relevant to collection? How would a vacation covering collector from elsewhere need to use this? If it's not relevant, can we take it out?
GRA PACU all inconsistent with count in infobox, what is the location profile?
Grace Hospital Contacts all 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 all
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 all
  • 2018_Aug_1: Dr Dowhanik /Dr. Vanymede are emptying the B5 medicine beds and will not admit into them unless "emergency/ absolute need" for medicine overflow patient movement. The B5 bed overflow option will be "formally closed" within 6 months.-Llemoine 09:25, 2018 August 1 (CDT)
    • Did that ever happen? If so, can we clean this section out of here if it's no longer applicable? Ttenbergen 21:36, 2020 October 8 (CDT)
HSC D4 all
  • for a while we had a mention of a D4 pre COVID ward. No such thing in s_dispo table and not sure if the ward is back to being the regular H Service ward. Could someone update what happened there and where we are at now? There might be hints and mentions in Category:2020 COVID unit transition Ttenbergen 21:31, 2020 October 8 (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 IICU Collection Guide all
HSC IICU Collection Guide all Could someone pls update that list to the new Laptop identifiers H7, h8, h9? I didn't just do it because want to be sure the most current numbers are used, if there were changes.
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 Unknown Service all
  • So if Lisa had to cover for one of you while you are aware, how would she know which ones to pick up. Do you have a method for splitting these?
HSC WRS3 all
  • Will this location profile be identical to what HSC_D5 was before?
ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rate all 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 in your PPT.
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 Mortality Julie Allan says don't include Brain death admits in the numerator or denominator ?
ICU Mortality Julie Does this also consider any of the Diagnosis implying death?
ICU Mortality 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.
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 all
  • 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)
Length of Stay (ICU Report) Julie Right now this is slightly inconsistent with Definition of a Critical Care Laptop Admission which doesn't explicitly exclude the ER pts. I have flagged that page for task review. Once that is done, can we just use that definition here as well to ensure consistency?
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
  • 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 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 per Critical Care Unit 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.
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.
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.
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.
Mortality and readmission report all we don't collect hospital discharge, what exactly is this?
Mortality and readmission report all what kind of "admit dttm" is this, accept, arrive, service, boarding?
Mortality and readmission report all With PatientFollow, do we still do this by unit?
Myocardial infarction, acute (AMI), NOS Task "We are bringing it up at task, because it was 8 days old and the primary reason for admission, and treated like an acute, when I searched ICD codes for missed MI this is the code that came up. But you are right if it’s a month old it would be a comorb, so need some clarification. "
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
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 Quarterly ICU Report Julie Mentioned on Statistician's PC page. What is this report? And most importantly, what Indicators does it use? Ttenbergen 13:36, 2021 July 13 (CDT)
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)
Paracentesis (diagnostic) Allan
  • Is this the code to use for samples taken via in situ PD catheters for C&S, cytology etc.? Or would it be (D) Abdominal, Pelvic or Peritoneal Cavity, NOS, combined with Biopsy (non-endoscopic)? Thanks! (Pam)
    • It likely wouldn't be the non-endoscopic code because someone seeing this data without access to full story would then expect this to be a full surgical procedure, which this isn't. Leaving this open to see if this would be the right code, though. Ttenbergen 09:45, 2021 July 13 (CDT)
PL missing L Tables content Pagasa
  • Pagasa, could you please log here when this query lists errors, and what was found to be the problem (ie whether there was data in CCMDB.accdb that didn't make it, or no data in first place.
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-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 all this is wrong
Procedure when there are differences between L Log and L PHI Pagasa Why, what does that tell you? The only way I can imagine this would happen is if the record was deleted in centralized L_Log. In that case, if you are lucky and there is still a ccmdb_data with the completed/sent record, you can follow the Re-sending data process. If not, find it in a previous version of Centralized data.mdb, print or write down all data for the record, and manually re-enter it in a CCMDB.accdb and follow the Re-sending data process. Or what do you do? Ttenbergen 21:38, 2019 February 6 (CST)
Processes around changing a PatientFollow assignment all The error is annoying because it comes up repeatedly. There is an email exchange between Pam, Julie and Tina to find out how best to deal with this. Ttenbergen 20:56, 2021 January 14 (CST)
Processes around changing a PatientFollow assignment Julie
  • We discussed this today and you would need to make changes to how you derive these markers. A number of them probably need to be re-defined and revised after all the changes we have made because they would still be based around the old concepts of Accept DtTm, Arrive DtTm etc that should really not be used any longer for calculations. What would it take, and where are these things documented? Ttenbergen 16:50, 2020 November 23 (CST)
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)
Proposed future changes to Location and Transfer Ready and related fields all
  • As for unit, I propose we drop the "end" one...
Proposed future changes to Location and Transfer Ready and related fields all
  • I propose we drop the "end" one since it would be the start of the next one (ie duplication) or the Dispo DtTm. If we include the Unit End DtTm we should get rid of the Dispo DtTm. Ttenbergen 15:50, 2021 February 11 (CST)
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 must have entry Pagasa
  • Patients without CCI entries are slipping through and found by PL missing L Tables content , must fix PTorres 09:42, 2019 February 7 (CST)
    • I seem to remember discussing this with Pagasa. There was a misconception that a "no CCIs" had to be present in both component and picklist, but that is not true: it only needs to be in the Picklist. Is this still a problem? If so, please tell me an example when one comes up.
    • Michelle sent email 2019-10-31 that she was able to click "D" with no CCIs entered. I tested on my copy and got an error when I tried. Will need more info about the scenarios where this can slip through.
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 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 check tmp Service and Boarding Loc during admission timeframe all
  • Accept DtTm resp Arrive DtTm are largely duplication of the Service tmp entry and Boarding Loc dates and times. I believe we had discussed that we should therefore remove those fields eventually. So we should not implement a check now on fields we are planning to get rid of shortly.
  • Even if we kept the fields, Accept DtTm is only to be entered for pts from ER, so would not always be there, and the Service tmp entry start dttm could well be before the arrive dttm.
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 NDC Dxs vs TISS Dialysis all Would we need to add COVID to this before implementing?
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)
Query TISS Errors CAM positive vs Dx Task AJTT
  • I started implementing this and then started wondering if there might be many more dxs that may or may not cause CAM positive (eg Encephalopathy, NOS). Is this a reasonable check to run?
Query TISS Errors ETT consistent Julie
  • A patient might arrive intubated, so there would be no intubation. Does this check really make sense? Ttenbergen 23:23, 2019 March 25 (CDT)
    • I have revised the conditions, pls check if they now make sense.--JMojica 16:38, 2019 July 9 (CDT)
      • Actually, no: Someone can arrive intubated from another ICU and then be extubated their first day here. I don't see how Insertion can be included in these two. Ttenbergen 20:13, 2020 December 2 (CST)
Query TISS Errors NrTISSDays NE LOS all Is this check actually needed?
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 all
  • 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
Readmission Rate to MedWard Julie
Readmission Rate to MedWard Julie
  • moved here from Readmission page, will either need to be integrated or cleaned out:

Exclusions

Exclusions for readmissions are the following:

  • There is a planned admission like elective surgery
  • Left the ward or unit against medical advice (AMA)
  • Palliative patients
StatsLogo.svg
  • SMW


  • Cargo


  • Categories
  • HSC IICU has no readmission
Readmission Rate to MedWard Julie {{{1}}}
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.
S ICD10 APACHE Dx patterns table Allan dx grouping

if you have a reference, ideally online, for what you used to make the APACHE comorbid ranges, please add it here.

  • AG NOTE TO SELF -- you have to go through and confirm the ICD10/CCI codes to automatically code for the AP2 comorbs
But mainly I used this ref: https://rstudio-pubs-static.s3.amazonaws.com/231351_940f14aa51a6427a9e92d5a04daefc3e.html
S ICD10 Charlson Como patterns table Allan Como Admit Acquired Primary Limits - this is part of that discussion - if we want to limit some of these to not being allowed as admits, it will likely have to be done here.
  • AG REPLY --- yes we can and should go through ALL ICD10 codes and indicate which of the 3 Dx Types they're allowed in (ie deal with Controlling Dx Type for ICD10 codes). AG needs to be reminded to deal with this around June 2019
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)
Sending TISS forms all Do you do collect forms for combined sending / drop off? Where, how?
Sending TISS forms all Do you do collect forms for combined sending? Where, how?
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)
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)
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)
Statistician's PC all Is that report in Quarterly report? Which one is it? Or do we need a new page for it? Ttenbergen 10:22, 2021 July 8 (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
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 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 Allan
  • 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 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 2019 Julie Actually, I think Julie decided to re-claim these from backups, no?
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)
Temporary page to list dxs documented as requiring treatment to be coded Trish
  • Tina -- to deal with these, let's make a template and put it in all the ICD10 pages that link to the list right below here. That template to say: This is an entity which you SHOULD code even if it is not being treated.
    • I have made Template:ICD10 Guideline code even if not treated; should it be applied to the new codes or only those old pages?
      • We need to decide were to put that info; adding it to old pages is probably not the right place. ICD10 collection might be it - will people look there?
        • Emailed Trish about this. Ttenbergen 09:07, 2019 April 30 (CDT)
          • We never did anything about this at the time. Now it seems like old news, and implementing this might cause more confusion than leaving it alone. Should we just delete this page and the template I made back then?
TISS28 backup and start.vbs Pagasa Do you still use this? It is not linked, so as part of what process?
TISS28 Collection Guide all
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 (Critical Care) Julie
  • I don't quite understand this. Does it mean that, for whatever report uses this, it only considers the TRDtm+4hrs?
Transfer Delay (Critical Care) Task
  • Multiple ward/unit stays are now in one profile. What will Transfer Delay mean, will it be from the first time the pt is ready (ie one per profile) or one for each Boarding Loc? Once we settle the details we should implement this in CFE so it can be derived without the use of SAS.
    • Luckily this didn't happen on first round of reporting. We need to discuss at Task how collectors actually collect this. And then also how we would want to report this, by profile or by Boarding Loc. Because we can't really report it by service.
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 Delay (Medicine) Tina are you planning to add the updated calculation based on the new process in the created variables ? --JMojica 16:55, 2021 June 11 (CDT)
Transfer Ready DtTm tmp entry Task
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)
Update of D ID exclude service/location all
  • can someone else think of how this might not work out right?
Urinary system NOS, congenital malformation all
Urinary system NOS, congenital malformation all again, if not congenital wouldn;t this be a different code, see below?
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
  • Allan discussed with someone at STB what should be entered for Service with STB mgr of admitting Chantal Plaetnik.
  • Confirmed with Allan that this is still in progress and should move forward today. Ttenbergen 09:46, 2020 November 26 (CST)
  • STB Med flagged various pts where Service in Cognos doesn't match with services in orders. There is still something going on here, and I don't know how to troubleshoot it. Ttenbergen 12:01, 2020 December 10 (CST)
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)
WRHA Critical Care Quality Indicator Chart Report Julie
WRHA Critical Care Quality Indicator Chart Report Julie Added this because CAM positive (TISS Item) refers to it. What is this report?
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)
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Questions&oldid=143064"