Questions

From CCMDB Wiki
Jump to navigationJump to search

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

Unassigned questions

There are currently 86 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
Allan's links
  • does these mean you need to put both below in the article of concerns with question? Why?
    • No you don't need to put both. Not sure what happened there. Actually there is an easier way altogether, so I updated it to that. Once you read and understood pls remove the discussion. Ttenbergen 12:02, 2021 March 17 (CDT)
2021-03-17 5:02:40 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 to start collection at accept rather than arrive time
  • At least some of these started, but does someone know when this actually got implemented?
2021-04-06 9:46:53 PM
Cognos2 Ender
  • I have noticed in the charts that often there are discrepancies between COGNOS (date and time) and when the order is written for service changes. Should we be changing these in the database or going by what is on COGNOS? Lisa Kaita 13:36, 2020 December 18 (CST)
    • Generally collectors seem to be using what they find in the chart when the Cognos Service doesn't match what is in the chart. Ttenbergen 20:00, 2021 January 1 (CST)
2021-03-08 2:55:50 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
Critical Care and Medicine Database Core Curriculum
  • This is no longer true with PatientFollow Project; how should we best give the one-liner here and then link to the instructions there? Ttenbergen 15:11, 2020 October 23 (CDT)
2021-01-22 2:02:50 AM
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
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-01-14 4:14:49 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-01-14 4:14:49 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-01-14 4:14:49 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-01-14 4:14:49 PM
Emergency Surgery (concept) This info is from 2009 - is it still the same? 2020-04-10 1:44:48 AM
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
EPR Reports Integrator
  • As reported by Mailah: "I am trying to open reports integrator and I am encountering this error message. This also happened on Monday. "
    • Requesting a copy of the exported file from Mailah. Also asking if there is a file from a few days ago that didn't cause this misbehaviour. Ttenbergen 09:46, 2020 July 16 (CDT)
2020-12-08 5:43:57 AM
EPR Reports Integrator
  • As reported by Michelle: "I am using the integrator to enter a couple of patients that aren’t on the Cognos admitter. When I enter them, the MRN is showing up with all of the leading zeros, and the dash. I checked with Lisa, and she hasn’t had the same issue this morning."
    • Requesting a copy of the exported file from Michelle. Also asking if there is a file from a few days ago that didn't cause this misbehaviour. Ttenbergen 09:46, 2020 July 16 (CDT)
2020-12-08 5:43:57 AM
EPR Reports Integrator
  • Noted that after using Reports Integrator upon return to ccmdb list, the find patient function screen freezes and does not work. To remedy, the collector has to exit from ccmdb entirely and restart ccmdb, then the find patient function will work. (Pam)
    • emailed Pam to set time for next week to have her show me this. Ttenbergen 14:34, 2020 May 29 (CDT)
      • We never set a time for this. Pam, if this is still an issue, please lets book a time to discuss Ttenbergen 09:33, 2020 July 16 (CDT)
2020-12-08 5:43:57 AM
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?
2020-12-02 5:48:18 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
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 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
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
Lost/missing charts
  • Do we want a different RecordStatus for these? If not, should they be considered complete or incomplete?
    • I suggest we enter a new one say, LostChart, in the RecordStatus which implies incomplete and some data are missing. --JMojica 13:34, 2021 April 7 (CDT)
      • Would there be any problems with reporting queries including or excluding these in unintended ways? Could happen if any use a "not incomplete" or similar. I am pretty sure if we change this some CFE cross checks will show false positives for these, but those would be easily tweaked as we encounter them. Would there be false negatives, though? Ttenbergen 14:15, 2021 April 7 (CDT)
        • do you have a query about missing entry in any fields? I can't think of any query with false negative. --JMojica 17:13, 2021 April 7 (CDT)
2021-04-07 10:13:32 PM
Lost/missing charts
  • How long should we wait? Is 3 months after discharge or end of next quarter after discharge reasonable?
2021-04-07 10:13:32 PM
Lost/missing charts
  • What (if anything) should be done to find the chart before writing it off? Obviously following the appropriate Category:Medical Records Requests instructions, but is there any special process to nudge a suspected lost chart?
2021-04-07 10:13:32 PM
Lost/missing charts
  • what should be the instruction for APACHE - the usual "enter normal if not available" or should they enter extremes or 0s, or leave blank? What will not mess with Julie's processes?
    • I would rather have a missing APACHE Score when any of the APACHE elements are missing due to Lost or missing chart. Entry of zero for numeric or blank for character on any of the elements results to blank APACHE Score (but this refutes the guideline for APACHE Physiologic Not available). Normal values result to Zero APACHE Score (when age pts is zero).
2021-04-07 10:13:32 PM
Lost/missing charts Julie says Pagasa keeps a list of records for which this applies. Can we keep it here instead? If there are good reasons not to, can we link from here?
  • If we change the RecordStatus to LostChart for these there will be no need for lists, just a one-time update needed by Pagasa; I think that would be the best way to do this.
2021-04-07 10:13:32 PM
Lost/missing charts Working on std instructions on what to do about lost charts. More to come. 2021-04-07 10:13:32 PM
MediaWiki:Common.js ", post: " 2021-01-28 8:29:32 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 Service field 2021-02-11 6:32:24 PM
Process for bad data in Cognos
  • should we exclude and overcome the bad records right away or wait for a correction that might never come and how would we keep track of it?
2021-02-12 7:56:45 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
Project Discharge Documentation I could set up a query in CFE to dump this to keep it off Julie's desk. This user might find speed more important than quality? If needed, let me know. 2020-05-06 2:18:46 AM
Project Discharge Documentation Will these documents be retained on charts once they hit med records? 2020-05-06 2:18:46 AM
Proposed future changes to Location and Transfer Ready and related fields
  • As for unit, I propose we drop the "end" one...
2021-03-10 3:36:13 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-03-10 3:36:13 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 CLI vs DX but no TISS17 CentralLine
  • T17 has been retired and replaced by CVC presence, any location. There is discussion on whether some changes in that batch will need to be reverted. If they are, then this cross-check would need to be re-defined.
2021-04-08 7:42:50 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
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
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
Transfer Ready DtTm tmp entry
  • We discussed at Task that it might be easier to have different dropdowns as "item" entry instead of manually populating the comment. I think that's a good idea but wanted to give people a chance to shout "NOOOOO". So if you have concerns please post them here, else this will change likely when I am back from vacation early March. Ttenbergen 15:49, 2021 February 10 (CST)
    • If we do this I need to also remove the automatically added item from the "Make loc" button so no one forgets to enter this. Ttenbergen 09:31, 2021 March 10 (CST)
2021-03-24 7:55:30 PM
Transfer Ready DtTm tmp entry If the pt doesn't change to a transfer ready state during a location stay, should the comment be "not ready"? The comment "not available" is indicated in above statement-is this inconsistent? Or is this comment intended for scenarios of never transfer ready patients moving from ER (higher acuity) to lower acuity medicine units whereby a transfer date/time is "not available"? 2021-03-24 7:55:30 PM
Update of D ID exclude service/location
  • can someone else think of how this might not work out right?
2021-03-18 7:11:42 PM
Wrong service or unit entries in Cognos
  • Should collectors just totally wing it for these? Enter what seems right when they review the chart? Or do we need to be more consistent and deliberate about it? Ttenbergen 11:58, 2020 December 2 (CST)
2020-12-02 6:09:07 PM

All questions

There are currently 261 questions.

wiki page who question
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
ALERT Scale timing of assessment Task
  • Why would this be an exceptional instruction for STB? What is different about the situation there that would lead to different instructions? Ttenbergen 11:12, 2021 April 1 (CDT)
    • This has always been collected at STB this way. (Pam)
      • That doesn't mean it should stay that way since we used to collect all of this only upon arrival. So let's discuss at Task what this should be. The difference is probably really minor, but if we have exceptions it should be clear why. Ttenbergen 13:57, 2021 April 1 (CDT)
Allan's links all
  • does these mean you need to put both below in the article of concerns with question? Why?
    • No you don't need to put both. Not sure what happened there. Actually there is an easier way altogether, so I updated it to that. Once you read and understood pls remove the discussion. Ttenbergen 12:02, 2021 March 17 (CDT)
APACHE Comorbidities in ICD10 codes Allan Dx grouping
  • Started to integrate Allan's new list but there were so many discrepancies that I am waiting for confirmation; email sent yesterday. Ttenbergen 16:40, 2021 March 18 (CDT)
Base Population for Research Julie This page is linked from the front page, so we should either make it good or get rid of that. Is there anything on Publications that would be a good example for how our DB was used for this?
Battery disposal all collectors, please document what your process is at your office location.Trish Ostryzniuk 17:38, 2019 March 5 (CST)
Bed Census Data Processing Instructions Pagasa
  • copy the database back up to the server
    • which server?
Bed Census Data Processing Instructions Pagasa
  • probably incomplete... Ttenbergen 18:17, 2016 April 14 (CDT) emailed Trish/PAgasa Ttenbergen 16:46, 2018 October 30 (CDT)
Bed Census Data Processing Instructions Pagasa
  • is this the current process, or is Bed_census.mdb? I think the process is better off here than in the .mdb article.
Bed Census Data Processing Instructions Pagasa what is the purpose of having clerk processing this data?
  • quality control?
  • preparing for reports?
  • ?
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.
Boarding Loc Julie Which if any of Project_Borrow_arrive#Data_Integrity_Checks_.28SMW.29 will need to be moved over to this instead?
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 to start collection at accept rather than arrive time all
  • At least some of these started, but does someone know when this actually got implemented?
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)
Charlson Comorbidity Index Julie Is that the Annual report?
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?
Chronic Health APACHE Task
  • We are considering changing how this is collected to extracting the data from APACHE Comorbidities in ICD10 codes instead of coding a separate field. Further discussions to come. AG confirmed 2018-11-28 that this is an option
  • Discussed at AJTT:
    • need to discuss with Collectors if they can get the immunocompromising drugs
    • need to update Created Variables for this, and need to do that anyway
Cleaning up a failed send Pagasa
Cleaning up a failed send Pagasa
Clinical Assessment Unit Julie
  • do we need to do anything to get collectors to fill this out right? Or to deal with back-data? Ttenbergen 14:40, 2021 March 11 (CST)
Clinical Assessment Unit Julie
  • do we want to do this?
Clinical Assessment Unit Task
  • as per Julie: "I have checked the database and there are also CAU entries at GRA and STB in pre-admit institution, previous loc and dispo (GRA_CAU, STB_CAU). Do they move location too? Can we ask the DC? If so, make it generic _ward.
  • In the tmp Boarding Loc, there are 12 cases GH-CAU – so it looks like Internal med is borrowing CAU Bed. What to do here – change to GRA boarding?
    • I am not sure if the more recent entries for boarding loc would now list the actual location or still site-CAU.
Discussed at Task; these are now family medicine, we will start to just collect these as <local> ward. Ttenbergen 13:50, 2021 March 24 (CDT)
Cognos2 Ender all
  • I have noticed in the charts that often there are discrepancies between COGNOS (date and time) and when the order is written for service changes. Should we be changing these in the database or going by what is on COGNOS? Lisa Kaita 13:36, 2020 December 18 (CST)
    • Generally collectors seem to be using what they find in the chart when the Cognos Service doesn't match what is in the chart. Ttenbergen 20:00, 2021 January 1 (CST)
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)
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
Critical Care and Medicine Database Core Curriculum all
  • This is no longer true with PatientFollow Project; how should we best give the one-liner here and then link to the instructions there? Ttenbergen 15:11, 2020 October 23 (CDT)
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)
Delirium days Julie What are the details?
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.
Drug-induced immunosuppression Allan
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?
EMIP Allan
  • Scenario...
    • (1) Internal Med answered consult but deferred to ICMS and admitted under Critical care. Profile should be under Critical care and not Med?
    • (2) Rural Pt was accepted by Internal Med but deteriorated enroute to Winnipeg. Transport team transferred to ER resusc room and ICMS consulted and admitted pt. Is this an EMIP/Medicine profile? Or straight Critical care profile? Thank you. p:Mailah Damian ---2021_Mar_16
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?
EPR Reports Integrator all
  • As reported by Mailah: "I am trying to open reports integrator and I am encountering this error message. This also happened on Monday. "
    • Requesting a copy of the exported file from Mailah. Also asking if there is a file from a few days ago that didn't cause this misbehaviour. Ttenbergen 09:46, 2020 July 16 (CDT)
EPR Reports Integrator all
  • As reported by Michelle: "I am using the integrator to enter a couple of patients that aren’t on the Cognos admitter. When I enter them, the MRN is showing up with all of the leading zeros, and the dash. I checked with Lisa, and she hasn’t had the same issue this morning."
    • Requesting a copy of the exported file from Michelle. Also asking if there is a file from a few days ago that didn't cause this misbehaviour. Ttenbergen 09:46, 2020 July 16 (CDT)
EPR Reports Integrator all
  • Noted that after using Reports Integrator upon return to ccmdb list, the find patient function screen freezes and does not work. To remedy, the collector has to exit from ccmdb entirely and restart ccmdb, then the find patient function will work. (Pam)
    • emailed Pam to set time for next week to have her show me this. Ttenbergen 14:34, 2020 May 29 (CDT)
      • We never set a time for this. Pam, if this is still an issue, please lets book a time to discuss Ttenbergen 09:33, 2020 July 16 (CDT)
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 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?
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.
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 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 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.
Identifying patients in boarding locations Task
  • Is that actually a separate step? Still relevant now that we are using Cognos? Are there any steps collectors need to take to make sure these are captured? Ttenbergen 12:17, 2021 February 11 (CST)
Immunodeficiency state, NOS Allan are these following all addressed in the above? {sc:steroids, immunosuppressives, antibodies, SCID, }
Interstitial lung disease, NOS Allan 1

This says to include

    • Langerhans cell histiocytosis
But we had a code for that, and when we retired it we stated to use Malignancy (clonal disorder) of blood or lymphoid tissue, NOS instead. Which is it?
Isolation, infectious Julie Medicine report - need right link
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 Julie LOS Medicine per hospital admission and LOS Medicine per ward stay may duplicate content above. Do they? If we ever split these out into reporting documentation indicator pages we will need to make sure these are not duplicated.
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 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 Medicine per ward stay Task
  • this definition is no longer valid after many changes have happened.
    • Julie will update, as per Task meeting 2021-01-20 Ttenbergen 11:51, 2021 January 20 (CST)
Lost/missing charts all
  • Do we want a different RecordStatus for these? If not, should they be considered complete or incomplete?
    • I suggest we enter a new one say, LostChart, in the RecordStatus which implies incomplete and some data are missing. --JMojica 13:34, 2021 April 7 (CDT)
      • Would there be any problems with reporting queries including or excluding these in unintended ways? Could happen if any use a "not incomplete" or similar. I am pretty sure if we change this some CFE cross checks will show false positives for these, but those would be easily tweaked as we encounter them. Would there be false negatives, though? Ttenbergen 14:15, 2021 April 7 (CDT)
        • do you have a query about missing entry in any fields? I can't think of any query with false negative. --JMojica 17:13, 2021 April 7 (CDT)
Lost/missing charts all
  • How long should we wait? Is 3 months after discharge or end of next quarter after discharge reasonable?
Lost/missing charts all
  • What (if anything) should be done to find the chart before writing it off? Obviously following the appropriate Category:Medical Records Requests instructions, but is there any special process to nudge a suspected lost chart?
Lost/missing charts all
  • what should be the instruction for APACHE - the usual "enter normal if not available" or should they enter extremes or 0s, or leave blank? What will not mess with Julie's processes?
    • I would rather have a missing APACHE Score when any of the APACHE elements are missing due to Lost or missing chart. Entry of zero for numeric or blank for character on any of the elements results to blank APACHE Score (but this refutes the guideline for APACHE Physiologic Not available). Normal values result to Zero APACHE Score (when age pts is zero).
Lost/missing charts all Julie says Pagasa keeps a list of records for which this applies. Can we keep it here instead? If there are good reasons not to, can we link from here?
  • If we change the RecordStatus to LostChart for these there will be no need for lists, just a one-time update needed by Pagasa; I think that would be the best way to do this.
Lost/missing charts all Working on std instructions on what to do about lost charts. More to come.
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.
Mortality and readmission report Julie
  • who is this report given to? thank you--TOstryzniuk 18:40, 30 November 2010 (CST) Ttenbergen 23:43, 2017 June 7 (CDT)
Mortality and readmission report Julie What is the Mortality and readmission report report?
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?
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)
Paralytic syndrome, NOS Allan
  • There isn't a specific code for non traumatic cauda equina syndrome
  • Causes of non traumatic Cauda Equina Syndrome include
    • A severe ruptured disk in the lumbar area, spinal stenosis,spinal lesion or malignant tumor, spinal infection, inflammation, hemorrhage, or pathological fracture

Google search of ICD 10 cauda equina syndrome is G83.4 under diseases of nervous system. Should non traumatic cauda equina syndrome be coded using this code and perhaps combined with cause if known?

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.
PL missing L Tables content Pagasa Have there been more since?
Pleural effusion, NOS Allan 1
Pre op Admit-Cardiovasc Patient Julie This is not coded under ICD10 or CCI. Do we report this, and therefore need to accommodate otherwise, or how will we treat this? We have Preparatory care (incl preop optimization) but that doesn't capture the full concept. Ttenbergen 22:45, 2018 November 27 (CST)
Pre-admit Inpatient Institution field Allan 1
  • what should be the pre-admit entry for those, then?
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 Service field all
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)
Process for bad data in Cognos all
  • should we exclude and overcome the bad records right away or wait for a correction that might never come and how would we keep track of it?
Process for bad data in Cognos Allan
  • who would this be?
Process for bad data in Cognos Task AJTT
  • To confirm: Julie, this means that if a pt was listed in Cognos as some bogus unit for the first 6 hours of their stay, we would list their stay on our unit as starting 6 hours later. this would probably trigger some of Pagasa's cross checks, and give you 6 hours of missing occupancy. I still think it's the right way to deal with this error since messing with the times would break how entries are linked to Cognos, but I want to make sure we are all aware that this is a thing and how we approach it. Ttenbergen 13:29, 2020 November 9 (CST)
    • when does this phenomenon occur - at the beginning or in between transfers? (Julie)
      • It seems to be a matter of data entry errors, so I suppose it can occur at any time. Ttenbergen 11:00, 2020 November 18 (CST)
    • if at the beginning, then just exclude. (Julie)
    • If in between transfers during an episode, is there a query done for that? Pagasa' query will crosschecks between records and not within episode. But if that happens, since only the arrived date is entered, I will always assume continuous stay defining the end date as the start date of the next boarding location. (julie)
      • Not sure what kind of query you have in mind. We only collect the unit starts, so there are no unit ends to cross check against. This means we should define how to enter these "bogus" units as either including them with the previous or including them with the next unit. I would prefer including them with previous because it doesn't break linking with Cognos for the next unit. But we should have a consistent instruction for this.Ttenbergen 14:10, 2021 January 28 (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)
Project Discharge Documentation all I could set up a query in CFE to dump this to keep it off Julie's desk. This user might find speed more important than quality? If needed, let me know.
Project Discharge Documentation all Will these documents be retained on charts once they hit med records?
Project Discharge Documentation Julie pls fill in once you set it up
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?
Px Date Task AJTT
  • Summary: We now enter a time for TISS PX Date on the day a pt moves to another unit so we can identify in which unit something happened. By the same reasoning, do we also need to do this for all other Px Date entries (CCI Pick or CCI component)? Ttenbergen 09:38, 2021 February 4 (CST)
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?
Quarterly report Julie What is the Quarterly report report?
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 has transfer ready date or checkbox Task
  • Currently only implemented without the comment cross checks because almost all collectors are not following the instructions.
  • I had a hunch that at least some collectors aren't entering the comment field as instructed and wanted to know how common a problem this cross check would find, so I tweaked it to run in CFE and checked (SQL at bottom). There were over 1000. People seem to be using the field to indicate which TRDT is for which Boarding Loc. Which is reasonable, because hard to keep track of otherwise, but it means I can't do that check for now.
  • Do we want to change the instructions to match what people are doing? Or change the cross check?
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 cardioversion dx vs TISS Task
Query NDC CLI vs DX but no TISS17 CentralLine all
  • T17 has been retired and replaced by CVC presence, any location. There is discussion on whether some changes in that batch will need to be reverted. If they are, then this cross-check would need to be re-defined.
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?
Re-admission Julie
Reporting from ICD10/CCI Julie
  • Different procedures would be listed with the same CCI code; will Julie easily interpret and utilize CCI codes for reporting?
  • Do we care that we will not be able to differentiate between a Blakemore tube from an Upper GI scope with banding or hemostasis, when in CCI they both look the same: (T) Stomach, pylorus... and Control of Bleeding. --LKolesar 14:11, 2018 May 1 (CDT)
    • discussed at task 14:08, 2018 June 20 (CDT), Julie to review what she needs and we will discuss again Ttenbergen 14:08, 2018 June 20 (CDT)
Requested TISS changes for the next version Julie What is the intended use of these reports?
Resource Use Julie do we have a counterpart like Avoidable Days in Medicine?
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 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 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 tmp entry Julie
  • When should the new options be used rather than the other service entries for HSC?
    • if I understand it correctly, when the list of these services appear in Cognos, since they do not map well to MICU or SICU, the DC must specified which service is appropriate : MICU or SICU. In reporting, I need to separate the data belonging to MICU and SICU service. If you would like to add "HSC Critical Care - MICU" and "HSC Critical Care - SICU", we need to add them to s_Cognos_Services.xlsx
      • HSC Critical Care / Adult General
      • HSC Critical Care / Amputee
      • HSC Critical Care / General
      • HSC Critical Care / Intensive Care
      • HSC Critical Care / Obstetrics
      • HSC Critical Care / Oncology
      - --JMojica 14:18, 2021 April 6 (CDT)
  • if you mean S Cognos Services table then I am not sure we really need to add them there... that is the list of services that come in from Cognos, and these don't come in from Cognos. Actually, what we would need to do is make sure we remove the ambiguous items that came via Cognos into the s_tmp table that we don't want people to use any longer, so that people are forced to instead use our made up ...SICU and ...MICU ones. Julie and Tina might need to discuss this in our questions meeting on Thursday.
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)
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.
Transfer Delay Julie
  • How is this going to work with the transition from Transfer Ready DtTm field to Transfer Ready DtTm tmp entry? We will need an update to this page as we change the process. Obviously a field in a created_variables table is no longer the way to do this since there may be more than one per profile. Let me know if you want to discuss Ttenbergen 16:09, 2021 January 21 (CST)
Transfer Ready DtTm tmp entry all
  • We discussed at Task that it might be easier to have different dropdowns as "item" entry instead of manually populating the comment. I think that's a good idea but wanted to give people a chance to shout "NOOOOO". So if you have concerns please post them here, else this will change likely when I am back from vacation early March. Ttenbergen 15:49, 2021 February 10 (CST)
    • If we do this I need to also remove the automatically added item from the "Make loc" button so no one forgets to enter this. Ttenbergen 09:31, 2021 March 10 (CST)
Transfer Ready DtTm tmp entry all If the pt doesn't change to a transfer ready state during a location stay, should the comment be "not ready"? The comment "not available" is indicated in above statement-is this inconsistent? Or is this comment intended for scenarios of never transfer ready patients moving from ER (higher acuity) to lower acuity medicine units whereby a transfer date/time is "not available"?
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?
Upper GI scope Task
  • This contradicts the information on CCI Collection#Related Imaging, Diagnostic and Therapeutic procedures performed at the same time - can we clarify? The other page instructs to code ALL diagnostic and therapeutic procedures performed at the same time, but this is worded like we code differently. For example, if a colonoscopy was done and an inspection to the jejenum was done and then a biopsy was taken in the colon, this makes it sound like we should could Biopsy (endoscopic) + Small intestine (D), which is inaccurate. If we all agree that we code the way it is written on CCI Collection#Related Imaging, Diagnostic and Therapeutic procedures performed at the same time, I can update this page.
    • Flagged for task meeting because it will need input from Allan and possibly Julie as well. Could you take it to the next Task meeting if you will be there, Brynn? If you won't be there, please let me know and I will try to present it. 11:09, 2021 April 1 (CDT)
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
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)