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 122 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.
2020-08-13 7:00:27 PM
2020-04 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?
2020-08-13 7:00:27 PM
2020-04 HSC COVID unit transition
  • If all the covid wards are operational, how to handle the case where the patient stayed in 2 official covid wards consecutively - 1) separate records or 2)one continuous record? I think we should consider (2) as continuous. (who asked?)
    • what was the decision? Ttenbergen 10:31, 2020 May 14 (CDT)
    • Did not happen at all. we can ignore this scenario. --JMojica 10:00, 2020 June 12 (CDT)
2020-08-13 7:00:27 PM
2020-04 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)
      • update There are no COVID specific suspect or positive wards as of May 27, 2020 Lisa Kaita 13:49, 2020 June 11 (CDT)
2020-08-13 7:00:27 PM
2020-04 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.
2020-08-13 7:00:27 PM
2020-04 HSC COVID unit transition Related to ICU, how will the patient originally at HSC_MICU then move to either H7 or A7 under the care of MICU be collected - will the move to H7/A7 be a new record or continuation?
  • Did not happen at all. We can ignore this scenario for now. --JMojica 10:02, 2020 June 12 (CDT)
2020-08-13 7:00:27 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.
2020-10-26 5:12:44 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?
2020-10-26 5:12:44 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.
2020-10-26 5:12:44 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)
2020-10-26 5:12:44 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.
2020-10-26 5:12:44 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. 2020-10-26 5:12:44 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)
2020-10-26 5:12:44 PM
2020-05 HSC COVID unit transition what needs to change on laptops? Trish Ostryzniuk 18:00, 2020 May 12 (CDT) 2020-10-26 5:12:44 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
2020-10 EMIP changes
  • To clarify: EMIPs are distributed according to MRN number ending since October 15, 2020 and included in patient distribution assignment amongst medicine collectors?

Since EMIPs should appear on Admitter/CSS, then should it be no longer required to find them as in the past?

  • correct. that si why this is under the heading of where it is. There should be very few of these old entries left, but I have no idea if they are all complete. Once they are, this whole page should probably be hidden under a legacy expandable since it will be irrelevant: there no longer are any special instructions for EMIPs in the new setup, so no one should have to worry about what it was before and how it was changed (possibly excepting Julie in her reporting). That's also why I left myself a note to review it in January. Ttenbergen 22:12, 2020 November 26 (CST)
2020-11-27 4:12:55 AM
Admit Type for APACHE II
  • Thanks for the clarification, Michelle. I like your explanation and think it is clear. We still have the flow chart floating around on this wiki, though: File:Patient Type Flowchart.gif; we should either get rid of it (preferred) or update and integrate it here (not preferred, since its contents would not be searchable). Ttenbergen 15:18, 2020 October 7 (CDT)
2020-10-07 8:18:50 PM
Attribution of infections
  • Is the following correct, then:

A decided that an infection that is discovered within the first 48 hrs after admission should be coded as an Admit Diagnosis, and an infection discovered after that as an Acquired Diagnosis.

2020-08-28 2:37:43 AM
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
Boarding Loc Which if any of Project_Borrow_arrive#Data_Integrity_Checks_.28SMW.29 will need to be moved over to this instead? 2021-01-19 4:24:08 PM
Carrier of infectious disease, unspecified
  • Presumably this would be used for Typhoid Marys and asymptomatic carriers of other pathogens as well? Ttenbergen 11:37, 2020 November 20 (CST)
2020-11-20 5:37:56 PM
Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry
  • How should we now keep track of the ward info on the wiki? Do we actually need to? Or is it sufficient to tell the number of beds at Grace Medicine on this wiki? Ttenbergen 18:11, 2020 October 13 (CD per ward is being reported.
2021-01-15 5:57:54 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?
2020-12-23 8:09:05 PM
Check has transfer ready entry
  • On a first read I am not sure how we would make sure this exists for each level of care; it would be a complicated query; how badly do we want this?
  • Is there a simplified version that only makes sure a first entry exists, and that any entry that does exist is internally consistent (no time checkbox vs having a time vs presence of acceptable comment entry)
2020-10-16 4:46:34 AM
Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm
  • new check should likely go against Boarding Loc entries instead of Arrive DtTms
  • Now that there may be several Transfer Ready DtTm tmp entry entries, is that check still the right logic? Should it instead check every awaiting code against a TR date entry? Or does the whole thing become so messy that we shouldn't do it at all?
2020-10-16 4:28:47 AM
Check pre acute consistent How does Chronic Health Facility fit into this? Or Imprisonment/incarceration and other info in Prison / Jail / Correctional Institution? 2019-09-22 4:44:32 PM
Check pre acute consistent There was a previous attempt to address some of this in Care levels in the community; this page and it need to be consistent, and consistently linked from the relevant field definitions. If we can get it short enough we might make a template to apply the instructions to each of the field pages. 2019-09-22 4:44:32 PM
Check pre acute consistent 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. 2019-09-22 4:44:32 PM
Cognos data not showing up in ADT tab
  • If you encounter the problem, please try the steps above and tell me what you find. I have thought several times now that I finally figured this out, but there must still be some scenarios I have not thought of. Ttenbergen 17:43, 2020 October 13 (CDT)
    • Have not heard about this in a while, is it still a problem? Ttenbergen 10:25, 2021 January 14 (CST)
2021-01-14 5:56:05 PM
Cognos2 Ender
  • Any chance we can get the name added to this list? Surbanski 12:35, 2020 December 3 (CST)
    • It's doable, but make your case why it would be helpful? If you used this as described in Using Cognos2 to keep track of patients, how would having the name in here help? Ttenbergen 11:03, 2020 December 4 (CST)
      • Nurse brain - we're trained double check things to make sure we're doing what we're supposed to be doing with the person we're supposed to be doing it with. If I'm the only one asking about it then don't worry about it … I can learn to trust the system :) Surbanski 09:25, 2020 December 10 (CST)
        • To do anything with the record you'd have to open it, so it seems safe to say that the risk of doing something to the wrong record is very low. Also, if there was a bug and you opened a record other than the one flagged, there should be nothing to do in the ADT2 tab. But maybe I misunderstand - is it a cross-check to another list where a name would be helpful? Ttenbergen 11:30, 2020 December 10 (CST)
2021-01-14 6:07:19 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-01-14 6:07:19 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)
2020-09-23 3:51:24 PM
Courier This is inconsistent with the GRA instruction below where it says no cost centre required. 2020-09-23 3:51:24 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 2020-09-23 3:51:24 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)
2020-12-04 12:09:27 AM
Data collection log form 2021-01-14 5:28:01 PM
Data collector's binder
  • At STB we keep track of CLI and VAP's on a paper list in our binders for the purpose of our Quality coordinator in the hospital. Lois and I attend the STB VAP Committee meetings and need to share this information at the meeting each time (monthly). --LKolesar 10:26, 2017 July 19 (CDT)
    • Would it make sense to just notify the coordinator with this info ASAP when the VAP/CLI happens? That's what we do at STB, we use a button right in the program for it so there is very little overhead for collectors. One less thing to carry around, and the coordinator gets the info in a more timely manner... Ttenbergen 18:04, 2017 July 26 Ttenbergen 11:28, 2020 April 9 (CDT) (CDT)
    • At HSC we are supposed to email Basil Evan and 'cc' the ICU managers with identified VAPs and CLIs. We are to include the main admission diagnosis as well as the the criteria we used to identify these infections, so there is a bit of work involved in typing up these emails. --Jvelasco 12:32, 2020 April 9 (CDT)
      • Do they involve the data collector's binder, though? I was asking the question here to see if this really needs to go in the binder, hoping to have less and less in that binder over time. Ttenbergen 15:12, 2020 April 14 (CDT)
2020-04-14 8:12:27 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
EMIP
  • Should we now re-define this as "Patient who has a record in EPR/Cognos Report Integrator for a Service we collect while in ER , and who does not then end up on one of the wards/units that correspond with that service, regardless where they go instead." and then turn the specific scenarios into examples rather than keep them part of the definition? I guess it depends on the outcome of the discussions under #Identifying EMIPs and What is a service admission
2020-11-26 4:19:24 AM
EMIP
  • There has been some discussion whether or not a patient accepted by our service but still in ER when Cognos first lists them should actually be entered then, or only after they either leave from ER or become an inpatient. People have been leaving these un-entered both out of old habit (when EMIPs were entered following different rules you first had to know if a pt would need to be entered as EMIP or as regular) and to be able to enter the unit at the same time, rather than having to remember to go back to the record later to enter the unit. There really is no longer a reason to delay these, especially starting with Using Cognos2 to keep track of patients, instead they become something for which we would need to add tools to CSS to identify them. Please enter them as they show up on Cognos2 Service Starter, or explain why you think it's better not to. Ttenbergen 22:19, 2020 November 25 (CST)
2020-11-26 4:19:24 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? 2019-10-23 10:19:51 PM
EPR Lists who uses this?
  • uses:
    • names?
  • doesn't use:
    • names?
2019-10-23 10:19:51 PM
EPR Lists Would it be correct to say that the lists are manually populated based on EPR Reports? 2019-10-23 10:19: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
Exporting EPR Reports for EPR Reports Integrator
  • Filter the report; Val/Michelle, could you provide details for what filtering you used for this, if it is other than what was given in those three pages? If same just take out question....
2019-11-14 12:17:56 AM
First Annual Baking Event if you have a recipe you would be willing to share, please post it here. 2019-12-17 7:25:11 PM
Form Covid rept
  • 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)
      • Sorry, missed this when it was written - is it still needed? Ttenbergen 16:16, 2020 July 29 (CDT)
2020-07-29 9:16:32 PM
GH-SWAP Location
  • Is that a normal frequency for these, and an average duration? Ttenbergen 22:21, 2020 December 15 (CST)
2020-12-16 4:21:33 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
HD (Hemodialysis)
  • I need clarification on this one-if a patient is either dialysed in Emerg, or on a different ward, (ie. anytime during the current hospitalization prior to coming to your area), are we to enter this only as an admit CCI?Mlagadi 10:26, 2019 February 11 (CST)
    • Please have a look at Admit Procedure, it should explain whether to code a procedure or not. There is no explicit exception for Dialysis. If the info there does not give you the answer you need, please elaborate. If the info is there, then, would you have looked there? How can we make clearer to look there? Ttenbergen 11:53, 2019 February 13 (CST)
2019-02-13 5:53:56 PM
Health Sciences Center Office
    • Does Iris Deleon have a key?
2020-12-22 9:00:00 PM
Health Sciences Center Office
    • Joanna Velasco - I have a key, but it doesn't work on any of the cabinets in the office.
      • Is that still true? Have you talked with Trish?
2020-12-22 9:00:00 PM
Health Sciences Center Office
    • Lori Lovell - now that she's part time does she really still have a key?
2020-12-22 9:00:00 PM
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
  • I have spoken to the clerks in MICU and they do order their own TISS forms and Green sheets. Is it not possible to have SICU and IICU order their own as well? --Jvelasco 11:57, 2020 February 28 (CST)
    • will check this out with Pagasa and printshop. If we made changes to the form then unit would not get most current. Trish Ostryzniuk 14:44, 2020 February 28 (CST)
    • Which Cost Center they are charging to?
      • I do not know. --Jvelasco 15:14, 2020 April 7 (CDT)
2020-06-05 3:48:57 PM
HSC MICU Collection Guide Another question: Since we are not to go to the units during the COVID outbreak, how do we supply the ICU's with TISSs and Green sheets? For sure SICU and IICU will need to be restocked. MICU seems to restock their own according to the ward clerks, but that does not seem to be verified so far...--Jvelasco 15:14, 2020 April 7 (CDT)
  • when was the last time you request TISS form for SICU or IICU guys? Pagasa say HSC has not requested any for long time since Oct 2019 actually. Trish Ostryzniuk 17:19, 2020 April 15 (CDT)
    • We do not request TISS forms/Green sheets for SICU or IICU. We go to your office and Pagasa gives us a stack of both. Or we email Pagasa when the supply is running low in our office, she brings them here and we then deliver some to both units. --Jvelasco 13:26, 2020 April 17 (CDT)
2020-06-05 3:48:57 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
Identifying patients in boarding locations 2020-12-15 3:47:09 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
Langerhans' cell histiocytosis (Histiocytosis X, Eosinophilic granulomatosis) 2020-10-27 6:43:49 PM
MediaWiki:Common.js ", post: " 2020-04-02 5:06:12 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
PL missing L Tables content Have there been more since? 2019-12-11 10:21:47 PM
PL missing L Tables content Have there been more since? 2020-05-05 9:53:39 PM
Pre-admit Inpatient Institution field what are those entered as then? 2020-12-03 8:53:53 PM
Previous Service field
  • As per last Task Meeting - is this correct or do we need to discuss further? --Jvelasco 14:39, 2019 June 26 (CDT)
    • Good question. 6 months later, what do people think?
2020-10-19 4:18:25 AM
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
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 start dttm could well be before the arrive dttm.
2021-01-16 2:48:10 AM
Query Import request matcher This one is fairly easy, Pagasa will try to make it. 2019-05-15 5:39:43 PM
Query Import request matcher This one is fairly easy, Pagasa will try to make it. 2020-05-05 9:53:45 PM
Query NDC Dxs vs TISS Dialysis Would we need to add COVID to this before implementing? 2020-12-08 3:12:54 AM
Query TISS Errors missing days This seems to imply Query TISS Errors NrTISSDays NE LOS, so is that other query actually necessary still? 2020-12-03 3:30:09 AM
Query TISS Errors NrTISSDays NE LOS Is this check actually needed? 2020-12-03 3:31:22 AM
Reset Button
  • This button exists for ancient legacy reasons, generally opening and closing the program is easier and as fast. I will get rid of it in some future version unless someone tells me within the next week or so that they use it and would like to keep it. If you don't use it, NNTR. Ttenbergen 15:17, 2020 July 23 (CDT)
2020-07-23 8:17:18 PM
Resource Use do we have a counterpart like Avoidable Days in Medicine? 2019-11-05 4:25:07 PM
Resource Use which others in Category:Indicators 2019-11-05 4:25:07 PM
Selection and timing of APACHE components
  • Does ICU start there APACHE and TISS from the ER accept time or ICU admit time. Currently we collect from the ER accept time only when the patient is boarded in the ER for greater than 2 hours. Gthomson2 10:43, 2020 October 20 (CDT)
          • Since Oct.15th, I have been using the 24 hour period after the accept time, which means that I am including the applicable Vitals from ER if the patient was from the ER. I wasn't at the task meeting yesterday, so I don't know if this was discussed, but this was my understanding of how we are supposed to collect apacheMlagadi 11:02, 2020 October 23 (CDT)
      • Gail, where does this 2 hour delay rule come from? Is there anything on wiki about it? Ttenbergen 14:49, 2020 December 23 (CST)
2020-12-23 8:50:40 PM
Sending TISS forms Do you do collect forms for combined sending / drop off? Where, how? 2020-09-23 3:50:33 PM
Sending TISS forms Do you do collect forms for combined sending? Where, how? 2020-09-23 3:50:33 PM
Service/Location field
  • Could we remove this from the STB ICU laptops as we are doing a kind of follow system?
    • I think Julie still uses this. Also, other sites still have to enter it, they simply always enter the same thing. I think you requested this because of some confusion lately about what defines a new profile at STB CC. And that was important to figure out, and we still need to document it, likely at STB Critical Care Collection Guide. But once that is clear then entering this field should be trivial. I will send an email to DC STB CC; Jmojica to pls review Ttenbergen 11:37, 2020 December 10 (CST)
2021-01-14 5:34:19 PM
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 still done? How does this actually impact collection, ie why would these pts be marked so?
2020-06-29 4:03:48 PM
STB Boarding Locations
  • Any other boarding locs for STB Med?
2020-12-15 3:49:06 PM
STB CICU Admissions start at Arrive DtTm
  • Does the following also go for STB_ACCU ?
2020-12-15 4:41:29 PM
STB CICU Admissions start at Arrive DtTm
  • How are Service tmp entry entered for these, then? Do they also just start at arrive time? If the regular rules on that page are not followed it needs to link here as well. Ttenbergen 20:16, 2020 November 1 (CST)
2020-12-15 4:41:29 PM
STB Critical Care Collection Guide
  • The following seems to be different than what is in Admit_Type_for_APACHE_II - there it says they have to be directly from OR.
  • These things should be the same for medicine and critical care at STB, no? If any instructions separate from Admit Type for APACHE II are actually required, they should live in STB General Collection Guide instead of here. Ttenbergen 15:40, 2020 October 7 (CDT)
2020-11-18 5:03:45 PM
STB MICU Collection Guide
  • With the new instructions for Contacting Quality Officer and Manager for VAPs and CLIs, can we discontinue that sheet? We should not be retaining patient info once we are done dealing with it. Ttenbergen 10:26, 2017 September 18 (CDT)
    • Basil Evan , QI officer, is asking that perhaps a worksheet be submitted to him regarding which criteria were met for either VAP for CLI when collector make determination from chart. Perhaps we could make a checklist in TMP instead in regards to which criteria are met for these two special projects instead of paper worksheets that are different at each collection site? Suggestions? --Trish Ostryzniuk 17:14, 2018 November 19 (CST)
    • added to tmp was abandoned. Trish Ostryzniuk 18:46, 2019 February 4 (CST)
      • Emailed Trish "What do you mean by was abandoned, the question or the project or the paperwork?" Ttenbergen 22:29, 2019 February 5 (CST)
2020-05-05 7:05:35 PM
Survey about deleting files after sending
  • How frequently does Pagasa send for people and therefore requires manual deletion?
2020-06-05 11:40:40 AM
Survey about deleting files after sending emailed Marla for reply 2020-06-05 11:40:40 AM
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.
2020-12-15 9:13:35 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)
2020-12-15 9:13:35 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)
2020-12-15 9:13:35 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)
2020-12-15 9:13:35 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)
2020-12-15 9:13:35 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) 2020-12-15 9:13:35 PM
Tables and queries not hidden in CCMDB.accdb
  • Do any other collectors find that the panel with the tables and queries is open when you open CCMDB? Ttenbergen 16:47, 2020 December 8 (CST)
2020-12-08 10:47:30 PM
Task Team Meeting - Rolling Agenda and Minutes 2020 2021-01-07 4:44:49 AM
Task Team Meeting - Rolling Agenda and Minutes 2020
  • Will this mean entering and possibly later changing Service/Location and therefore D_ID of patient records?
2021-01-07 4:44:49 AM
The value you entered isn't valid for this field
  • I don't know enough about how that field is generally filled by collectors to know what is less hassle: have the convenience of the datepicker or the convenience of easy typing in of a date. Only CC uses the times, and even they only use it for some TISS entries. However, if it turned out that everyone uses the *, + and - buttons and no one uses the date picker, I could change the field so that typed date entry is less flaky. Do collectors have thoughts about this? Ttenbergen 11:03, 2020 December 23 (CST)
2020-12-23 5:03:15 PM
TISS28 Collection Guide 2020-12-16 8:42:20 PM
Transfer Ready DtTm field
  • I believe this contradicts the information on the Transfer Ready DtTm tmp entry page, not sure which is correct. I thought we were doing a transfer ready line for every physical location, not just lower levels of care?
    • The distinction is between what means transfer ready (that is a matter of intent to discharge) and the things that actually happen (pt became worse and went to a higher level of care). The definition below is right for what defines when pt is transfer ready. The explanation in Transfer Ready DtTm tmp entry essentially just says when the clock re-sets, and that could either be because pt was successfully moved to a lower level of care, or because they died (still no longer taking up a bed) or because they became worse and went to a higher level of care (again no longer waiting for that initial lower level of care). Ttenbergen 14:19, 2020 October 19 (CDT)
2021-01-14 8:02:02 PM
Transfer Ready DtTm tmp entry
  • For the date cutoff are we referring to admission date, transfer ready date, or discharge date? Surbanski 10:22, 2020 October 16 (CDT)
2020-10-20 3:14:50 PM
Transfer Ready DtTm tmp entry
  • So do we need a transfer ready time for every physical move - for example, ER to D4, D4 to H4? Or only when a patient moves to a lower level of care. So when ER --> D4, no transfer ready time, but D4 --> WRS3, we would have a transfer ready time.
    • no new entry for same level of care, but entry for higher or lower level of care. Why higher as well? Because once a patient actually moves to a higher level of care, the original determination that they were transfer ready almost certainly is no longer valid. The only exception might be the original ER entry - that is a high level of care location, but would we expect someone to become transfer ready there and then still move to the ward? Probably not. I'd say no entry for that part, but should see what Julie has to say. Ttenbergen 15:16, 2020 October 16 (CDT)
      • Should we be entering a date/TM for every entry? the reason I ask is because if we check off B and put not transfer ready in column Q, we often have multiple entries, How will Julie know which boarding LOC is associated with each transfer ready entry without a date? Lisa Kaita 10:14, 2020 October 20 (CDT)
2020-10-20 3:14:50 PM
Transfer Ready DtTm tmp entry Moving this into a different topic because it's about how to interpret these, not how to enter them
  • This is my dilemma with our definition, it is the intent which I cannot qualify thru the data. if I see an entry in transfer ready date but the physical transfer location is the same or higher level of care, I have to consider that transfer ready date to be valid. I rely that the entry is correct. I rather have the definition to be consistent with the level of care (except for Deaths) so I can quality check the transfer date entry and remove the intent as part of the definition. The goal is to measure bed wastage and when the patient moves to the same or higher level of care, that is not bed wastage to me. --JMojica 10:18, 2020 October 16 (CDT)
    • When the patient was deemed transfer ready, additional time in the ward was "wasted time" - if we could have sent them elsewhere we would have. If the patient later crashes, that doesn't make it not-wasted time - they could have crashed anywhere. So the interpretation that a pt moving to a higher level of care after transfer ready is not wasted time is not right. We discussed this repeatedly at task. The only way this makes sense is if it is done by intent. Ttenbergen 15:16, 2020 October 16 (CDT)
2020-10-20 3:14:50 PM
Update of D ID exclude service/location
  • can someone else think of how this might not work out right?
2020-12-08 3:50:14 AM
Update of D ID exclude service/location This would be a fairly troublesome change for sending. With everyone now entering fewer profiles and fewer Service Locations due to PatientFollow Project, there should be much fewer problems caused by this. So we should review if this is still a thing we want to do right now. I will consider this on hold unless someone tells me we should still do it. Ttenbergen 11:22, 2020 December 3 (CST) 2020-12-08 3:50:14 AM
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 326 questions.

wiki page who question
"Delete Sent Patients" button Tina dev_CCMDB
  • disallow individual record delete on the patient lister built-in.
  • add a delete button that does the logical delete correctly on a per-patient basis.
  • this seems to be relatively low priority since we are not basing anything absolute on the logical delete feature, but needs to get done eventually to clean this up.
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-04 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-04 HSC COVID unit transition all
  • If all the covid wards are operational, how to handle the case where the patient stayed in 2 official covid wards consecutively - 1) separate records or 2)one continuous record? I think we should consider (2) as continuous. (who asked?)
    • what was the decision? Ttenbergen 10:31, 2020 May 14 (CDT)
    • Did not happen at all. we can ignore this scenario. --JMojica 10:00, 2020 June 12 (CDT)
2020-04 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)
      • update There are no COVID specific suspect or positive wards as of May 27, 2020 Lisa Kaita 13:49, 2020 June 11 (CDT)
2020-04 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-04 HSC COVID unit transition all Related to ICU, how will the patient originally at HSC_MICU then move to either H7 or A7 under the care of MICU be collected - will the move to H7/A7 be a new record or continuation?
  • Did not happen at all. We can ignore this scenario for now. --JMojica 10:02, 2020 June 12 (CDT)
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...
2020-10 EMIP changes all
  • To clarify: EMIPs are distributed according to MRN number ending since October 15, 2020 and included in patient distribution assignment amongst medicine collectors?

Since EMIPs should appear on Admitter/CSS, then should it be no longer required to find them as in the past?

  • correct. that si why this is under the heading of where it is. There should be very few of these old entries left, but I have no idea if they are all complete. Once they are, this whole page should probably be hidden under a legacy expandable since it will be irrelevant: there no longer are any special instructions for EMIPs in the new setup, so no one should have to worry about what it was before and how it was changed (possibly excepting Julie in her reporting). That's also why I left myself a note to review it in January. Ttenbergen 22:12, 2020 November 26 (CST)
2020-10 EMIP changes Tina Will need to reconcile the following:
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 Task this relates to Attribution of infections and we need to be sure to have it consistent.
ADL General Collection Information Task
Admit Diagnosis Allan 1
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 Type for APACHE II all
  • Thanks for the clarification, Michelle. I like your explanation and think it is clear. We still have the flow chart floating around on this wiki, though: File:Patient Type Flowchart.gif; we should either get rid of it (preferred) or update and integrate it here (not preferred, since its contents would not be searchable). Ttenbergen 15:18, 2020 October 7 (CDT)
ALERT Scale timing of assessment Allan APACHE
  • Should we merge this with Selection and timing of APACHE components? Med doesn't collect all of these, but those that are collected should probably be collected following the same instructions... This especially should be reviewed since we no longer make a distinction between EMIPs and inpts for most other instructions. Should this instruction instead simply be:
    • "Use the most recent value before service acceptance. If no value is available before service acceptance, use the first value available after service acceptance."
  • if we reject this change, we should at least state once and for all that they are similar but different, and why. Ttenbergen 14:29, 2020 December 23 (CST)
Allan's links Allan
Attribution of infections all
  • Is the following correct, then:

A decided that an infection that is discovered within the first 48 hrs after admission should be coded as an Admit Diagnosis, and an infection discovered after that as an Acquired Diagnosis.

Attribution of infections Task
  • I finally figured out how to ask this at task: I was worried that we might apply the delay at the data entry end and also at the reporting end (i.e. the delay might be included twice or not at all, so we need to phrase and then link this correctly so it's clear whether the delay is considered at collection or at reporting. Ttenbergen 21:37, 2020 August 27 (CDT)
Attribution of infections Tina When this is all settled, the details need to be integrated into Template: ICD10 Guideline Infection, Lab and culture reports, Infections in ICD10
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?
  • ?
Bed holds Julie Julie seems to set the limit at 1 day - emailed Julie Ttenbergen 10:07, 2016 November 10 (CST)
Blood Product Data Allan z
  • Identified as something we should do to streamline data collection. I have made this page to document progress toward this import.
Boarding Loc all Which if any of Project_Borrow_arrive#Data_Integrity_Checks_.28SMW.29 will need to be moved over to this instead?
Boarding Loc Julie
  • CCMDB automatically populates the comment column with the local actual unit names. To make this blank, collectors have to remove the entry. Is there a good reason why it can't just stay in there? (emailed Julie)Ttenbergen 16:43, 2021 January 18 (CST)
    • Not sure I understand. do you mean when the item='STB CICU' then comment='STB CICU', when item='STB ER' then comment='STB ER', when item='STB ICU Boarding' then comment=the localunit say 'STB_CICU' or 'STB ACCU' or 'STB_*'. I think it is just OK if they stay in comment. no need to remove.
      • Yes, generally speaking the comments for boarding and covid would stay the same, just the comment for home locations would now be allowed to stay the same. Specifically, the values listed in "Boarding Loc" column of s_Cognos_unit would be used. Ttenbergen 10:14, 2021 January 19 (CST)
Boarding Loc Julie
  • To confirm: Julie, this means that if a pt was listed in Congos 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 we ignore it if it happens at the beginning, it will mean Cognos lines that are not linked to anything. They will either clutter the screen as "not yet entered", or will need to be excluded manually by collectors. I think manually excluding them would get them off the list, but if a collector then tries to make sense of what they see the next day it will be confusing. Ttenbergen 11:00, 2020 November 18 (CST)
    • 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. Ttenbergen 11:00, 2020 November 18 (CST)
Boarding Loc Tina
  • inactivate legacy entry Home Medicine ward once last pt using it is discharged
Boarding Loc Tina
CAM positive (TISS Item) Julie
  • Did these ever get better? Ttenbergen 12:44, 2017 May 11 (CDT) Does anything need to be done about this? Ttenbergen 20:15, 2018 November 27 (CST)
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
    • I think Comorbid_Diagnosis#When_not_to_code_a_dx_at_all answers this, but you say some people code it differently. Could someone who codes this as a comorbid explain why they code it? I want to flag this for my meeting with Allan to address collector questions, and I think we will need to know what the reasoning is. Ttenbergen 09:30, 2020 August 26 (CDT)
      • I have included this code for a patient with a fairly recent arrest and also to highlight the extent of their CAD and comorbs. I would also likely include it if the admitting diagnosis is cardiac related.

--Mailah Damian 13:08, 2020 September 4 (CDT)

  • AG REPLY --- cardiac arrest is a manifestation of a disease (examples include arrythmias, coronary artery disease, acute MI, etc). Thus it should NOT be coded as a comorbid disorder
    • 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
Care levels in the community Julie
  • There usually isn't much info in the charts about the "type" of group home or level of care provided there, so in those cases we have been coding "other - known but not listed". Please clarify --Jvelasco 13:47, 2019 September 4 (CDT)
    • Julie, how do we use this, and how should this be coded in unclear cases? If you are not sure about the answer either, could you bring it to Task?
Carrier of infectious disease, unspecified all
  • Presumably this would be used for Typhoid Marys and asymptomatic carriers of other pathogens as well? Ttenbergen 11:37, 2020 November 20 (CST)
CCI Allan
CCI Volumes 2019 Task There have been concerns about the volume of work generated by CCI entries. Since we had already reduced certain entries earlier in 2019, the numbers referenced here are only for pts admitted during the third quarter of 2019.
Central Line Associated Blood-Stream Infection (CLA-BSI) rate Julie
    • A central lines (CL) is a central venous catheters (CVC) that terminates at or close to the heart or one of the great vessels. Great vessels include the pulmonary artery, superior vena cava, inferior vena cava, brachiocephalic, internal jugular, subclavian, external iliac and the common femoral veins.
      • Could we link to Central Line for details instead so that if we change any they will remain consistent?
Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry all
  • How should we now keep track of the ward info on the wiki? Do we actually need to? Or is it sufficient to tell the number of beds at Grace Medicine on this wiki? Ttenbergen 18:11, 2020 October 13 (CD per ward is being reported.
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?
Change to start collection at accept rather than arrive time Allan
  • For ICU patients we will decide on a Minimum data set of TISS items to be collected when patients are boarding. These will have to be recorded by collectors.
    • Of note, Tina reports that the DSM data we’re getting DOES include labs from the time in ED, so she will simply need to include the lab data from the time when our service takes over care.
  • Regarding the “machinery” for this -- discuss next time expanding the “Boarding Location” machinery to initial admission and all moves thereafter. In this schema, the name would be changed to something like “Physical Locations”, and the initial one would be wherever the patient was when he/she first began to be cared for by the service/team. This machinery can then easily be used by Julie to report on boarding, lengths of stay and every other aspect of location and timing of care. Because such moves are much more frequent and confusing for Medicine than ICU, as suggested by Michelle, for Medicine patients we would have only 3 possible physical locations: ED, their service location, or a generic boarding location which is not further subdivided.
  • We began to discuss that with the above changes, and the increased boarding that will likely become the norm, it would be simpler to keep track of database records not as we do now (i.e. by home location) but rather by home service. The machinery discussed above will allow Julie to write SAS code to slice and dice the information in any way desired -- e.g. time in each physical location (including high obs). After we discuss this more next time, Allan will talk to Drs. Renner/Hajadiacos if they see any major problems with such a change in process.
    • Allan confirmed that Hajidiacos is fine with this. Ttenbergen 12:01, 2020 October 27 (CDT)
Changing D IDs Pagasa
  • what queries would get you to change a D_ID for medicine? We would want to cross-link them so they point to these instructions, and so these instructions can list them as cause.
Changing D IDs Pagasa
  • what queries would get you to change a D_ID? We would want to cross-link them so they point to these instructions, and so these instructions can list them as cause.
Changing D IDs Pagasa
  • Which program do you do this in? This may actually need to be different instructions for different scenarios.
Changing D IDs Pagasa How about L TISS Form table, L TISS Item table and L Labs DSM table? Are there others I am not thinking about ? Ttenbergen 22:20, 2019 February 6 (CST)
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 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?).
Check has transfer ready entry all
  • On a first read I am not sure how we would make sure this exists for each level of care; it would be a complicated query; how badly do we want this?
  • Is there a simplified version that only makes sure a first entry exists, and that any entry that does exist is internally consistent (no time checkbox vs having a time vs presence of acceptable comment entry)
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 if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm all
  • new check should likely go against Boarding Loc entries instead of Arrive DtTms
  • Now that there may be several Transfer Ready DtTm tmp entry entries, is that check still the right logic? Should it instead check every awaiting code against a TR date entry? Or does the whole thing become so messy that we shouldn't do it at all?
Check pre acute consistent all How does Chronic Health Facility fit into this? Or Imprisonment/incarceration and other info in Prison / Jail / Correctional Institution?
Check pre acute consistent all There was a previous attempt to address some of this in Care levels in the community; this page and it need to be consistent, and consistently linked from the relevant field definitions. If we can get it short enough we might make a template to apply the instructions to each of the field pages.
Check pre acute consistent all 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
  • ... 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 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?
Chest Physio (TISS Item) Trish sounds to me like this is still done differently by different people. Ttenbergen 12:58, 2017 July 27 (CDT)
Chronic Health APACHE Allan z
  • 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
Cleaning up a failed send Pagasa
Cleaning up a failed send Pagasa
Cognos data not showing up in ADT tab all
  • If you encounter the problem, please try the steps above and tell me what you find. I have thought several times now that I finally figured this out, but there must still be some scenarios I have not thought of. Ttenbergen 17:43, 2020 October 13 (CDT)
    • Have not heard about this in a while, is it still a problem? Ttenbergen 10:25, 2021 January 14 (CST)
Cognos2 Ender all
  • Any chance we can get the name added to this list? Surbanski 12:35, 2020 December 3 (CST)
    • It's doable, but make your case why it would be helpful? If you used this as described in Using Cognos2 to keep track of patients, how would having the name in here help? Ttenbergen 11:03, 2020 December 4 (CST)
      • Nurse brain - we're trained double check things to make sure we're doing what we're supposed to be doing with the person we're supposed to be doing it with. If I'm the only one asking about it then don't worry about it … I can learn to trust the system :) Surbanski 09:25, 2020 December 10 (CST)
        • To do anything with the record you'd have to open it, so it seems safe to say that the risk of doing something to the wrong record is very low. Also, if there was a bug and you opened a record other than the one flagged, there should be nothing to do in the ADT2 tab. But maybe I misunderstand - is it a cross-check to another list where a name would be helpful? Ttenbergen 11:30, 2020 December 10 (CST)
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 1
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
COVID-19 (SARS-COV-2) Julie
  • how should this be done now under PatientFollow Project / Boarding Loc ? Is it even still applicable? Likely should live under Boarding Loc instead and just be linked from here? Ttenbergen 12:24, 2020 October 29 (CDT)
    • It seems this instruction is more related to differentiating between Admit Diagnosis & Acquired Diagnosis. The note about transferring location could be taken out because what we're doing for patient follow will capture the move, but the rest of the instruction still applies I would think.
COVID-19 (SARS-COV-2) Task
  • What are we doing for COVID recovered cases? So if MB Health considers someone to be non-infectious after 14 days, if someone is admitted to hospital >14 days from their swab date are we still coding them COVID POS? Are we using whether they are/are not isolated on admission as the deciding factor in how these are coded? Do we need a code for the recovered folks who are still needing acute care (for example patients admitted to medicine from ICU after the 14 day isolation period) Surbanski 08:21, 2020 December 10 (CST)
    • I have changed this to a Task discussion because we will need Julie and Allan for this. Could you bring it up there, please? Ttenbergen 11:26, 2020 December 10 (CST)
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 collection log form all
Data collector's binder all
  • At STB we keep track of CLI and VAP's on a paper list in our binders for the purpose of our Quality coordinator in the hospital. Lois and I attend the STB VAP Committee meetings and need to share this information at the meeting each time (monthly). --LKolesar 10:26, 2017 July 19 (CDT)
    • Would it make sense to just notify the coordinator with this info ASAP when the VAP/CLI happens? That's what we do at STB, we use a button right in the program for it so there is very little overhead for collectors. One less thing to carry around, and the coordinator gets the info in a more timely manner... Ttenbergen 18:04, 2017 July 26 Ttenbergen 11:28, 2020 April 9 (CDT) (CDT)
    • At HSC we are supposed to email Basil Evan and 'cc' the ICU managers with identified VAPs and CLIs. We are to include the main admission diagnosis as well as the the criteria we used to identify these infections, so there is a bit of work involved in typing up these emails. --Jvelasco 12:32, 2020 April 9 (CDT)
      • Do they involve the data collector's binder, though? I was asking the question here to see if this really needs to go in the binder, hoping to have less and less in that binder over time. Ttenbergen 15:12, 2020 April 14 (CDT)
Data Integrity Checks/review list Pagasa Pagasa, regarding the meeting with Trish, Julie and Allan to decide which checks to continue to do when, please
  • expand this list to 50
  • click the “edit w f” link at the start of the line to open any that need change right in a form to use dropdowns to update them
  • confirm that all queries correctly list
    • whether you check them always or only complete (timing field)
    • whether they use L_Problem
    • whether there is a backlog (I just added that field, it defaults to "yes" so change to no if caught up)
Definition of a Critical Care Laptop Admission Allan
Definition of a Critical Care Laptop Admission Julie
Definition of a Critical Care Laptop Admission Task
  • This definition does not deal with surgical / SICU pts who may well not be under the critical service. If they are in Emerg or ECIP or PACU, how would a pt be identified as an SICU pt?
Definition of a Critical Care Laptop Admission Task Thanks to Steph for making me aware that Bed borrow might tell to exclude some patients who would otherwise be Critical Care admissions: if patients are brought into ICUs for procedures only, we don't collect them. Emailed her back to find out if a pt like that would still show up in the Cognos lists for either unit or service start. Ttenbergen 16:23, 2020 December 7 (CST)
  • In email response Steph doubted these procedure pts would show up in the Cognos reports because the service does not change to ICU for them, and that would be right. If everyone else agrees then we should just add a statement to this page to explicitly exclude them, and link to Bed borrow for more details. Ttenbergen 23:19, 2020 December 7 (CST)
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.
Discharge Register Trish The following needs clarification, I don't have a report in front of me, how would a new collector read which of these are EMIPs and which not? Emailed Laura Ttenbergen 16:53, 2019 January 3 (CST)
  • is this just available for STB or is this how GRACE and HSC can find in EPR?Trish Ostryzniuk 18:01, 2019 January 3 (CST)
  • I would think that all the hospitals have this because it is just a demographic issue and I believe that everyone has access to this, just get them to test it in other centers to make sure.--LKolesar 07:56, 2019 January 4 (CST)
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)
Eliminating distinction between different ward types Julie any of Julie's Reporting that use this concept? I no longer used the hierarchy level when computing transfer delays. I assume that if transfer ready datetime is present, DC follows the rule and they are included in the computation. In Medicine Report, there is no more tables showing teaching vs. non teaching. --JMojica 11:10, 2020 January 30 (CST)
Emergency Surgery (concept) all This info is from 2009 - is it still the same?
EMIP all
  • Should we now re-define this as "Patient who has a record in EPR/Cognos Report Integrator for a Service we collect while in ER , and who does not then end up on one of the wards/units that correspond with that service, regardless where they go instead." and then turn the specific scenarios into examples rather than keep them part of the definition? I guess it depends on the outcome of the discussions under #Identifying EMIPs and What is a service admission
EMIP all
  • There has been some discussion whether or not a patient accepted by our service but still in ER when Cognos first lists them should actually be entered then, or only after they either leave from ER or become an inpatient. People have been leaving these un-entered both out of old habit (when EMIPs were entered following different rules you first had to know if a pt would need to be entered as EMIP or as regular) and to be able to enter the unit at the same time, rather than having to remember to go back to the record later to enter the unit. There really is no longer a reason to delay these, especially starting with Using Cognos2 to keep track of patients, instead they become something for which we would need to add tools to CSS to identify them. Please enter them as they show up on Cognos2 Service Starter, or explain why you think it's better not to. Ttenbergen 22:19, 2020 November 25 (CST)
Employee Assistance Program Trish Emailed Trish to fill this in. Ttenbergen 16:26, 2017 June 22 (CDT)
Encounter processing Pagasa
  • says inactive, but do you actually do this? Is there anything else to it? Do we have, and do you run any multi-encounter checks yet? I guess a lot of the PLs kind of are those...
EPR Analytics Tina
  • looking for further information about this.
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 who uses this?
  • uses:
    • names?
  • doesn't use:
    • names?
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)
Exporting EPR Reports for EPR Reports Integrator all
  • Filter the report; Val/Michelle, could you provide details for what filtering you used for this, if it is other than what was given in those three pages? If same just take out question....
First Annual Baking Event all if you have a recipe you would be willing to share, please post it here.
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 all
  • 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)
      • Sorry, missed this when it was written - is it still needed? Ttenbergen 16:16, 2020 July 29 (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.
GH-SWAP Location all
  • Is that a normal frequency for these, and an average duration? Ttenbergen 22:21, 2020 December 15 (CST)
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...
HD (Hemodialysis) all
  • I need clarification on this one-if a patient is either dialysed in Emerg, or on a different ward, (ie. anytime during the current hospitalization prior to coming to your area), are we to enter this only as an admit CCI?Mlagadi 10:26, 2019 February 11 (CST)
    • Please have a look at Admit Procedure, it should explain whether to code a procedure or not. There is no explicit exception for Dialysis. If the info there does not give you the answer you need, please elaborate. If the info is there, then, would you have looked there? How can we make clearer to look there? Ttenbergen 11:53, 2019 February 13 (CST)
HD (Hemodialysis) Julie
  • We used to have a special procedure for indicating if a renal transplant patient received dialysis post transplant under the tasks. If we are now only coding HD once, it will often be missed if the patient required HD post renal transplant. Do we care about collecting this information? There is the post procedural renal failure code that will be coded in the acquireds, but this does not automatically mean that they received dialysis.
    • AG REPLY -- I don't see any special reason to need this info. Unless Julie tells us it's being requested, I think we can do without it.
      • Julie, what are your thoughts on this? Ttenbergen 11:53, 2019 February 13 (CST)
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
  • I have spoken to the clerks in MICU and they do order their own TISS forms and Green sheets. Is it not possible to have SICU and IICU order their own as well? --Jvelasco 11:57, 2020 February 28 (CST)
    • will check this out with Pagasa and printshop. If we made changes to the form then unit would not get most current. Trish Ostryzniuk 14:44, 2020 February 28 (CST)
    • Which Cost Center they are charging to?
      • I do not know. --Jvelasco 15:14, 2020 April 7 (CDT)
HSC MICU Collection Guide all Another question: Since we are not to go to the units during the COVID outbreak, how do we supply the ICU's with TISSs and Green sheets? For sure SICU and IICU will need to be restocked. MICU seems to restock their own according to the ward clerks, but that does not seem to be verified so far...--Jvelasco 15:14, 2020 April 7 (CDT)
  • when was the last time you request TISS form for SICU or IICU guys? Pagasa say HSC has not requested any for long time since Oct 2019 actually. Trish Ostryzniuk 17:19, 2020 April 15 (CDT)
    • We do not request TISS forms/Green sheets for SICU or IICU. We go to your office and Pagasa gives us a stack of both. Or we email Pagasa when the supply is running low in our office, she brings them here and we then deliver some to both units. --Jvelasco 13:26, 2020 April 17 (CDT)
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?
Hypoalbuminemia, severe Allan I see you removed the link to the guideline:

Symptom/Sign/Test Result not needed when cause known

  • This code identifies a symptom or a sign, or an abnormal test result, not a disorder.
    • So, you should code the cause of the symptom/sign/abnormal test, if known -- and if you do so, then also coding and combining the symptom/sign/abnormal test result to that cause is generally optional, but is guided by the following guidelines.
  • Here are guidelines for whether or not to ALSO code the symptom/sign/abnormal test when you DO code the underlying cause:
    • If it is a subjective symptom (e.g. pain) then coding it is optional
    • When it is a physical exam finding (e.g. abdominal tenderness) then coding it is generally optional
      • An exception is when the symptom/sign/abnormal testis so severe that all by itself it mandates hospitalization and/or a procedure -- a good example is a patient who has Wegener's granulomatosis is admitted due withHemoptysis. Since hemoptysis is a physical finding that fits this description of "severe" it should be coded, and combined with Wegener's.
    • When it is an abnormal laboratory finding which in and of itself has relevance (e.g. hyperkalemia, hypoalbuminemia) then USUALLY code it
      • You don't need to code the abnormal lab finding is when it is actually a major component of the underlying cause --- example is when a person presents with an acute MI, there is no need to code the abnormal troponin as Abnormal blood chemistry NOS
    • The trickiest of these guidelines is for abnormal radiologic tests
      • When the abnormal test is fully explained by the underlying diagnosis/diagnoses (e.g. pneumonia as cause of abnormal chest imaging, or a skull fracture with an intracranial hemorrhage both identified by an abnormal head CT) then coding the abnormal imaging result is optional
      • But remember there are some rare things for which the abnormal imaging result IS part of coding the entity, for example we code retroperitoneal hemorrhage by the combination of Hemorrhage, NOS and Retroperitoneal area, diagnostic imaging, abnormal
  • Sometimes there may be multiple symptom/sign/test result that might or might NOT be related to each other by virtue of having the same underlying cause. Since in the absence of KNOWING that cause, such assumptions may well be incorrect, do NOT combine them together if you are not certain they actually have the same underlying cause.
That guideline says that when reasons for results are known, the results don’t need to be entered. I just want to be sure that you removed that intentionally. If you did, we should probably both review that rule (since hypoalbuminuria is now an exception that should be stated) and probably review which other pages also call that template where you now think we should code them even if the cause is known.
Iatrogenic, puncture or laceration, related to a procedure or surgery NOS Tina find page for general rule of not coding iatrogenic events as traumas
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 all
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)
Langerhans' cell histiocytosis (Histiocytosis X, Eosinophilic granulomatosis) all
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?
Level of care hierarchy Allan
  • we are confused about the distinction with "lower level of care" with NTU... how do we resolve that? Ttenbergen 14:50, 2020 October 19 (CDT)
Level of care hierarchy Julie
  • I populated most of the s_level_of_care table; for the rest I would need a list of all locations tracked in comment and what level of care we would attribute to them. List needs to be pulled from CFE, and then levels added, and I don't know what those would be, so we need someone (Lisa?) to help us fill that in. This will be needed by Julie for reporting, but not for collectors to be able to work tomorrow, so I am leaving this for now. It if becomes important before I get back to it, catch me. Ttenbergen 19:35, 2020 October 15 (CDT)
    • where is the list? cannot see it in CFE. I got the ver2020-10-15. --JMojica 11:56, 2020 October 20 (CDT)
      • List is in CCMDB.accdb, would need to be linked into CFE if you want to see it from there. Ttenbergen 11:01, 2020 October 22 (CDT)
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?
Link suspect transfer ready before arrive date Pagasa
  • Someone could be transfer ready before theArrive_DtTm , if they become transfer ready after the Accept_DtTm. Is this really a good check to do? It sounds like it would have plenty of false positives. Should it be Accept_DtTm instead?
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)
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?
Multiple LOS errors Tina
  • Flagged as still a problem in 2020-10, possibly for Query ''check ER Delay not too big''; if so, it's now fixed since that check got disabled. Ttenbergen 22:08, 2020 October 18 (CDT)
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)
Patient record or move shows in Cognos but not in EPR Tina
  • waiting to hear back if there is a way for us to verify that this is what happened if it happens again. Email subject "RE: Cognos shows WRS3 for patient where EPR only ever shows H4" . Ttenbergen 09:59, 2020 September 18 (CDT)
  • Sherry may have encountered this as well, email subject "Cognos Admitter Troubleshooting", forwarded to Chastity. Ttenbergen 10:58, 2020 September 18 (CDT)
  • There have been other instances since then, I think one from Michelle Oct1/2 Ttenbergen 14:51, 2020 October 7 (CDT)
PHIA policy Trish Trish will put link.
PL missing L Tables content all Have there been more since?
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.
Pneumothorax, nontension, nontraumatic Tina find page for general rule of not coding iatrogenic events as traumas
Pneumothorax, nontraumatic, NOS Tina find page for general rule of not coding iatrogenic events as traumas
Pneumothorax, tension, nontraumatic Tina find page for general rule of not coding iatrogenic events as traumas
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 all what are those entered as 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
  • As per last Task Meeting - is this correct or do we need to discuss further? --Jvelasco 14:39, 2019 June 26 (CDT)
    • Good question. 6 months later, what do people think?
Procedure when there are differences between L Log and L PHI Pagasa Why, what does that tell you? The only way I can imagine this would happen is if the record was deleted in centralized L_Log. In that case, if you are lucky and there is still a ccmdb_data with the completed/sent record, you can follow the Re-sending data process. If not, find it in a previous version of Centralized data.mdb, print or write down all data for the record, and manually re-enter it in a CCMDB.accdb and follow the Re-sending data process. Or what do you do? Ttenbergen 21:38, 2019 February 6 (CST)
Processes around changing a PatientFollow assignment all The error is annoying because it comes up repeatedly. There is an email exchange between Pam, Julie and Tina to find out how best to deal with this. Ttenbergen 20:56, 2021 January 14 (CST)
Processes around changing a PatientFollow assignment Julie
  • We discussed this today and you would need to make changes to how you derive these markers. A number of them probably need to be re-defined and revised after all the changes we have made because they would still be based around the old concepts of Accept DtTm, Arrive DtTm etc that should really not be used any longer for calculations. What would it take, and where are these things documented? Ttenbergen 16:50, 2020 November 23 (CST)
Processing errors in patient data Pagasa
Project Borrow arrive Julie did they ever get back to us? no response from HSC SICU --JMojica 10:14, 2019 May 6 (CDT)
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
Property:Collection Location Service Type Trish What is CTE? I am adding it for now because not having it is breaking SMW, but we really should not have it here if it isn't defined.
Psychoactive substance NOS, chronic abuse/dependence/addiction Task We were wondering if we should ever be using any of the chronic abuse codes as an admit diagnosis. For example, some of our patients are being followed by an Addictions service on the wards. Some are started on the methadone program, others get discharged to an addictions unit. If it is actively being treated on our unit, then should we code it as an admit, as well as a comorb?Mlagadi 10:20, 2020 May 15 (CDT)
    • This is about any of the codes in Category:Addiction and any outcome should likely live in Template:ICD10 Guideline Chronic Substance Abuse. I moved the question here from the category because (a) categories should only contain info about what would qualify a page to be in the category and (b) some of the queries and templates don't work the same with categories. This way it will show up on the task agenda. Ttenbergen 22:06, 2020 May 18 (CDT)
Px Date Task
  • Just noticed today - when I go to the CCI Pick tab and enter a date, there's now a space for a time entry. I check the Recent changes and couldn't find anything. Are we tracking time now as well as date?? Surbanski 09:33, 2020 November 24 (CST)
    • This became available and is documented under CCMDB.accdb Change Log 2020#2020-11-23. The time is only needed for Change to collect TISS data in CCI Picklist. But, now that I think of it, the same reasoning why we needed to add it there applies to CCI entries in general, so we need to think about this further.
      • We'll just leave the time as 00:00 until we're given further direction. Will this be discussed at the next task meeting? Surbanski 12:42, 2020 November 24 (CST)
        • Please make sure it does ;-) Will you be there? Ttenbergen 21:43, 2020 November 24 (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 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 start dttm could well be before the arrive dttm.
Query Import request matcher all This one is fairly easy, Pagasa will try to make it.
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 Dialysis TISS CCI Task
  • We are now going to be collecting almost the same info twice; should we implement the cross check for this, or stop collecting it twice and instead adjust the collection instructions?
Query NDC Dxs vs TISS Dialysis all Would we need to add COVID to this before implementing?
Query NDC zCRRT TISS no tmp Tina _dev_CFE - remove this and *old
Query NDC zCRRT tmp no TISS Tina _dev_CFE - remove this and *old
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 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 missing days all This seems to imply Query TISS Errors NrTISSDays NE LOS, so is that other query actually necessary still?
Query TISS Errors missing days Julie which report/s are these actually included in?
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?
Reset Button all
  • This button exists for ancient legacy reasons, generally opening and closing the program is easier and as fast. I will get rid of it in some future version unless someone tells me within the next week or so that they use it and would like to keep it. If you don't use it, NNTR. Ttenbergen 15:17, 2020 July 23 (CDT)
Resource Use all do we have a counterpart like Avoidable Days in Medicine?
Resource Use all which others in Category:Indicators
Respiratory failure (insufficiency), chronic Task
  • This is the first time I am reading the WIKI on this code. It looks like this code should be used as a comorb on some of our patients. in the pre ICD 10 codes, we had COPD-mild, moderate or severe as Comorb options, with guidelines for when to use each. It would be helpful to have some "cut-off" guidelines for when to use this code, rather than having it be subjective. For example, if someone has chronic COPD now, I am simply coding it in the COMORB field as COPD, without exacerbation, even if that patient is on home oxygen.
    • Does Allan's recent edit address this question? If so, please take it out Ttenbergen 15:18, 2020 July 3 (CDT)
Respiratory failure (insufficiency), chronic Task I am confused by the last 2 statements which follow the sentence "it's appropriate in the ICU record prior to IICU transfer to code it as an acquired diagnosis". So if a patient with no prior history of chronic respiratory failure has a long admission with multiple moves in acute care facilities and "evolves" into a chronic respiratory insufficiency/failure, are we supposed to use this code or not? --Jvelasco 14:44, 2020 July 14 (CDT)
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 Como patterns table Allan
  • Allan, if you have a reference, ideally online, for what you used to make the APACHE comorbid ranges, please add it here.
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 Chapter block pattern table Allan Broken link, do you use different reference now?
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?
Selection and timing of APACHE components all
  • Does ICU start there APACHE and TISS from the ER accept time or ICU admit time. Currently we collect from the ER accept time only when the patient is boarded in the ER for greater than 2 hours. Gthomson2 10:43, 2020 October 20 (CDT)
          • Since Oct.15th, I have been using the 24 hour period after the accept time, which means that I am including the applicable Vitals from ER if the patient was from the ER. I wasn't at the task meeting yesterday, so I don't know if this was discussed, but this was my understanding of how we are supposed to collect apacheMlagadi 11:02, 2020 October 23 (CDT)
      • Gail, where does this 2 hour delay rule come from? Is there anything on wiki about it? Ttenbergen 14:49, 2020 December 23 (CST)
Selection and timing of APACHE components Allan APACHE
  • ALERT Scale timing of assessment uses slightly different definition, but it is closer than it used to be now that we start Apache at accept rather than arrive. Can we combine? Ttenbergen 14:26, 2020 December 23 (CST)
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 Tina
  • add a cross check to make sure this is not left as "no service entered"
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 still done? How does this actually impact collection, ie why would these pts be marked so?
STB Boarding Locations all
  • Any other boarding locs for STB Med?
STB CICU Admissions start at Arrive DtTm all
  • Does the following also go for STB_ACCU ?
STB CICU Admissions start at Arrive DtTm all
  • How are Service tmp entry entered for these, then? Do they also just start at arrive time? If the regular rules on that page are not followed it needs to link here as well. Ttenbergen 20:16, 2020 November 1 (CST)
STB Critical Care Collection Guide all
  • The following seems to be different than what is in Admit_Type_for_APACHE_II - there it says they have to be directly from OR.
  • These things should be the same for medicine and critical care at STB, no? If any instructions separate from Admit Type for APACHE II are actually required, they should live in STB General Collection Guide instead of here. Ttenbergen 15:40, 2020 October 7 (CDT)
STB MICU Collection Guide All
  • With the new instructions for Contacting Quality Officer and Manager for VAPs and CLIs, can we discontinue that sheet? We should not be retaining patient info once we are done dealing with it. Ttenbergen 10:26, 2017 September 18 (CDT)
    • Basil Evan , QI officer, is asking that perhaps a worksheet be submitted to him regarding which criteria were met for either VAP for CLI when collector make determination from chart. Perhaps we could make a checklist in TMP instead in regards to which criteria are met for these two special projects instead of paper worksheets that are different at each collection site? Suggestions? --Trish Ostryzniuk 17:14, 2018 November 19 (CST)
    • added to tmp was abandoned. Trish Ostryzniuk 18:46, 2019 February 4 (CST)
      • Emailed Trish "What do you mean by was abandoned, the question or the project or the paperwork?" Ttenbergen 22:29, 2019 February 5 (CST)
Survey about deleting files after sending all
  • How frequently does Pagasa send for people and therefore requires manual deletion?
Survey about deleting files after sending all emailed Marla for reply
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)
Tables and queries not hidden in CCMDB.accdb all
  • Do any other collectors find that the panel with the tables and queries is open when you open CCMDB? Ttenbergen 16:47, 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?
Task Team Meeting - Rolling Agenda and Minutes 2020 all
Task Team Meeting - Rolling Agenda and Minutes 2020 all
  • Will this mean entering and possibly later changing Service/Location and therefore D_ID of patient records?
Task Team Meeting - Rolling Agenda and Minutes 2020 Allan
Task Team Meeting - Rolling Agenda and Minutes 2020 Allan
Template:Collection Location Tina
  • Template:Collection Location fields "Collection Service Type Legacy" and "Collection Workload Split" and "Collection Service Type" and "Collection Collector" are becoming meaningless, what is the best way to clean that up? This whole template needs to move to Cargo instead of SMW. Ttenbergen 17:39, 2020 October 15 (CDT)
Template:ICD10 Guideline Como vs Admit Allan 1
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 Iatrogenic Pneumothorax Tina find page for general rule of not coding iatrogenic events as traumas
Template:ICD10 Guideline MRSA Allan z "It was decided that Allan with contact Dr. Embil after COVID is over and see if we can obtain this data from Infection Control. If so, we could import it into the database, and have our data collectors cease obtaining it." - did anything come of that?
Template:ICD10 Guideline Signs Symptoms Test Results not needed when cause known Allan
  • Apply it to symptoms, physical exam findings, and radiologic findings, but NOT to laboratory findings.
    • I don't know which those would be. If we go through with this definition we should just stick them into a : or similar. Category:Testing also contains non-lab findings. Where would this leave things like Fecal occult blood test, positive? The "What links here" link on the left would show all that currently links to this page.
Template:ICD10 Guideline Transplant Failure Julie
  • Is "don't code history of transplant when coding transplant rejection because it's implied" something you are aware of? It's not something I would have thought of if you had asked me to write a query that lists all records with previous transplants. If we want to change this could you bring it to task meeting? Ttenbergen 16:41, 2020 January 31 (CST)
Template:Newsflash Tina needs troubleshooting
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)
The value you entered isn't valid for this field all
  • I don't know enough about how that field is generally filled by collectors to know what is less hassle: have the convenience of the datepicker or the convenience of easy typing in of a date. Only CC uses the times, and even they only use it for some TISS entries. However, if it turned out that everyone uses the *, + and - buttons and no one uses the date picker, I could change the field so that typed date entry is less flaky. Do collectors have thoughts about this? Ttenbergen 11:03, 2020 December 23 (CST)
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 Ready DtTm field all
  • I believe this contradicts the information on the Transfer Ready DtTm tmp entry page, not sure which is correct. I thought we were doing a transfer ready line for every physical location, not just lower levels of care?
    • The distinction is between what means transfer ready (that is a matter of intent to discharge) and the things that actually happen (pt became worse and went to a higher level of care). The definition below is right for what defines when pt is transfer ready. The explanation in Transfer Ready DtTm tmp entry essentially just says when the clock re-sets, and that could either be because pt was successfully moved to a lower level of care, or because they died (still no longer taking up a bed) or because they became worse and went to a higher level of care (again no longer waiting for that initial lower level of care). Ttenbergen 14:19, 2020 October 19 (CDT)
Transfer Ready DtTm tmp entry all
  • For the date cutoff are we referring to admission date, transfer ready date, or discharge date? Surbanski 10:22, 2020 October 16 (CDT)
Transfer Ready DtTm tmp entry all
  • So do we need a transfer ready time for every physical move - for example, ER to D4, D4 to H4? Or only when a patient moves to a lower level of care. So when ER --> D4, no transfer ready time, but D4 --> WRS3, we would have a transfer ready time.
    • no new entry for same level of care, but entry for higher or lower level of care. Why higher as well? Because once a patient actually moves to a higher level of care, the original determination that they were transfer ready almost certainly is no longer valid. The only exception might be the original ER entry - that is a high level of care location, but would we expect someone to become transfer ready there and then still move to the ward? Probably not. I'd say no entry for that part, but should see what Julie has to say. Ttenbergen 15:16, 2020 October 16 (CDT)
      • Should we be entering a date/TM for every entry? the reason I ask is because if we check off B and put not transfer ready in column Q, we often have multiple entries, How will Julie know which boarding LOC is associated with each transfer ready entry without a date? Lisa Kaita 10:14, 2020 October 20 (CDT)
Transfer Ready DtTm tmp entry all Moving this into a different topic because it's about how to interpret these, not how to enter them
  • This is my dilemma with our definition, it is the intent which I cannot qualify thru the data. if I see an entry in transfer ready date but the physical transfer location is the same or higher level of care, I have to consider that transfer ready date to be valid. I rely that the entry is correct. I rather have the definition to be consistent with the level of care (except for Deaths) so I can quality check the transfer date entry and remove the intent as part of the definition. The goal is to measure bed wastage and when the patient moves to the same or higher level of care, that is not bed wastage to me. --JMojica 10:18, 2020 October 16 (CDT)
    • When the patient was deemed transfer ready, additional time in the ward was "wasted time" - if we could have sent them elsewhere we would have. If the patient later crashes, that doesn't make it not-wasted time - they could have crashed anywhere. So the interpretation that a pt moving to a higher level of care after transfer ready is not wasted time is not right. We discussed this repeatedly at task. The only way this makes sense is if it is done by intent. Ttenbergen 15:16, 2020 October 16 (CDT)
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?
Update of D ID exclude service/location all This would be a fairly troublesome change for sending. With everyone now entering fewer profiles and fewer Service Locations due to PatientFollow Project, there should be much fewer problems caused by this. So we should review if this is still a thing we want to do right now. I will consider this on hold unless someone tells me we should still do it. Ttenbergen 11:22, 2020 December 3 (CST)
Update of D ID exclude service/location Tina
  • created Function make_D_ID
    • Problem: If I use a function for this, then the way the delete queries work breaks with a non-specific #Error if a record has been deleted; Possible solutions:
      • Save D_ID locally already rather than only generating it on sending
      • there might' be another way to re-write the query so it doesn't break
  • To do:
    • Make sure that PHI sending and importing will work
    • make sure that TISS scanning and importing will work
  • I plan to have this function just generate the old style D_ID for now, and integrate it into all the sending spots. Then we can decide the start dttm after which we want to use the new format, and I just set that as a parameter in the function.
Vacation and staff shortage collection priorities Trish For coverage on the medicine ward isn't the overstay project the priority and not the discharges. Are we not trying to generate a color on admissions as soon as possible to identify reds and letting managers know as soon as possible? GHall 11:51, 2017 August 14 (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)
What is a service admission Tina
  • There are sometimes two service entries at the same time in Cognos. Chastity says this is related to how the data is aggregated for our extract and will provide a different view that should fix this. The change has been outstanding for a little while due to Chastity's workload due to COVID reporting for province. Ttenbergen 12:01, 2020 December 10 (CST)
Working from home Trish
  • What forms need filling? Space requirements? Responsibility for records? Anything else?
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)