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. The old ones added with Template:Discussion only list the page.

There are currently 342 questions on this wiki.

 Summary
"almost same patient" checkIf we need this page at all it needs to be integrated better.
ADL General Collection InformationWhat else in addition to ALERT Scale Calculation uses this?
APACHE Acute Diagnosesneed here some general info what these are, links to wiki articles they are actually related to under old coding scheme, etc. I need help with this because I don't know if any of this is on the wiki, or else what it is about. Ttenbergen 17:20, 2018 February 23 (CST)
APACHE Comorbid DiagnosesDx grouping
  • either need details or need to revise this when we re-group dxs; meeting booked with Julie and Allan 2019-01-20 Ttenbergen 15:42, 2019 January 3 (CST)
APACHE Comorbidities in ICD10 codesDx grouping
  • Need to update from Allan's email 2018-11-26, but he said he would need to review this in light of the changes that had been made to ICD10 and CCI since he and Julie discussed. Ttenbergen 00:36, 2018 November 27 (CST)
  • AaDO2I 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)
  • Aborted ProcedureI have to find a CCI code for a patient who was given cardiac anaesthesia for a scheduled aortic valve replacement, but upon TEE intraop, was found to not need the procedure. She was brought to ICCS for recovery, weaning & extubation
    Acute Kidney Injury in Critically Ill Patients Infected With 2009 Pandemic Influenza A (H1N1): Report From a Canadian Provincehow did we support this publication?
    Acute kidney injury in septic shock: clinical outcomes and impact of duration of hypotension prior to initiation of antimicrobial therapyhow did we support this publication?
    Adding a CCI or ICD10 entry in CFEwe need a better solution, I need to make that ID field populate automatically.
    Admit DiagnosisComo Admit Acquired Primary Limits - this is part of that discussion - if we limit which admits will count as comos we need to review
    An institutional review of fulminant hepatic failure in an urban Canadian centrehow did we support this publication?
    Angiogram, coronary (diagnostic cardiac catheterization)
  • I recall discussing this in TASK a while ago and I remember that we were talking about now coding both the diagnostic Angiogram, coronary (diagnostic cardiac catheterization) and therapeutic Angioplasty, coronary (with stenting) if both were done. I just want to make sure that we have the correct instructions here. --Jvelasco 12:24, 2019 April 17 (CDT)
  • Antibiotic Resistant Organism
    • Allan has agreed to add a list to the relevant drugs to the difference resistance pages
    • It is awkward to work with/find readily available specific information as to the antibiotics included in the general antibiotic resistant

    articles. Some articles include links to sites that may/may not be that helpful in determination of inclusion antibiotics.

    • Would it be possible to include a listing of common antibiotics in the general antibiotic resistant articles? It would be helpful for collectors to

    have an inclusion list in those articles to use as a quick and easy reference. p:Pam Piche

      • Pam Piche: Question from Allan: I'm not quite sure what you're asking here. Is it which antimicrobials are for which type of bug (bacteria, fungal, etc), or something else?? Please expand on your question.
      • I was thinking along the lines of a listing of inclusion antibiotics such as is available in ICU Pharm flow tab (when hovering over category). I was wondering if such a listing would be helpful in quick determination of inclusion antibiotics?
    ApLab CompleteLegacy field cleanup.
    Automatic updating of MS Access Databases using scheduled tasksI think PHI copy automation uses this. It might accomplish this in a different way...
    Awaiting/delayed transfer to other care facility NOS
    BacteremiaThis lists as Apache Neuro and is in APACHE Acute Dxs in ICD10 codes because it is in the following range:

    Nonop - Large categories - Neuro NOS - A17. - A69.22

    When we touched on this at an Allan's list meeting you agreed that probably wasn't right. Emailed Allan. Ttenbergen 15:42, 2019 June 25 (CDT)
    Base Population for ResearchThis 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 disposalcollectors, please document what your process is at your office location.Trish Ostryzniuk 17:38, 2019 March 5 (CST)
    Bed Census Data Processing Instructions
    • is this the current process, or is Bed_census.mdb? I think the process is better off here than in the .mdb article.


    • probably incomplete... Ttenbergen 18:17, 2016 April 14 (CDT) emailed Trish/PAgasa Ttenbergen 16:46, 2018 October 30 (CDT)
    Bed borrowis this about to change with Boarding Loc?
    Bed holdsJulie seems to set the limit at 1 day - emailed Julie Ttenbergen 10:07, 2016 November 10 (CST)
    duplication on wiki needs to be cleaned up once we are on same page
    Laura and Tina discussed this and there clearly are different understandings about this. Need to review. LKolesar 14:43, 2017 March 1 (CST)
    Bed occupancyIs this about Bed census.mdb or a different thing?
    with TMSX not having been around for a while, is this still relevant? Do you provide this data otherwise? Do we need to implement this?
    Bentall ProcedureAre these right? Or only the stenosis or insufficiency?
    Bladder, disorder NOS
    • A bladder disorder does not necessarily mean that an infection is present. The check for pathogen should be removed.--CMarks 14:18, 2019 February 13 (CST)
      • The dx has been removed from the infection requiring pathogen category. Please try entering this again. If still a problem, post here, else pls remove the question. Ttenbergen 16:43, 2019 February 14 (CST)
    Blood Product DataI have made this page to document progress toward this import.
    Boarding LocAny Medicine special cases we can think of?
    How will we phase out Project Borrow arrive and the Off ward field? There will be patients who straddle the boundary. Also, Tina will need to know when the last applicable patients with Project Borrow arrive have been discharged so the entries can be inactivated in tmp.
    Which if any of Project_Borrow_arrive#Data_Integrity_Checks_.28SMW.29 will need to be moved over to this instead?
    Additional entries for additional moves? Tina needs to add the home units for medicine for cases with only partial stay on boarding bed and moves back to home unit.
    • If from home unit, another move to a boarding bed happens, then need to make another borrowed bed location entry and select your hospital's "boarding" entry for medicine or specific location for ICU . --JMojica 10:55, 2019 September 20 (CDT)
    • Will replace Off ward field to provide more meaningful data.
      • When?
    CAM positive (TISS Item)
    • 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)
    CCI Volumes 2019There 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.
    CTECTU vs NTU
    Can't check ICD10 ARF vs APACHE ARFIt used to be impossible to cross-check between dxs and ARF (APACHE) because of different definitions. With ICD10 now, and new definitions (Template:ICD10 Guideline KDIGO Guidelines for Acute Renal Failure), can we build a cross check that ARF (APACHE) can't be checked if pt has Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15? And further, would we be able to require that pt has (which) ARF dx in order to have ARF (APACHE) checked?
    Cardiac/cardiovascular drug NOS, adverse effect
  • Is this the code we use for Amiodarone lung? --LKolesar 14:15, 2019 January 23 (CST)
  • Care levels in the community
    • 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?
    Central Line Associated Blood-Stream Infection (CLA-BSI) rate
      • 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?
    Centralized data front end.accdbStill has old name, need to update. Also, isn't really documented here yet
    Centralized data front end.accdb Change Request_dev_CFE
    • add button for link suspect queries to patient list, then update Correcting suspect links with change in steps
    • 2019 March 01 - move priority number column for ICD10 to be after the primary type column. This would make it the same as CCMDB.
    • add TDI column to query L_CCI_Combined
    • fix dc treatment box that isn't showing up in form Ttenbergen 15:52, 2018 April 11 (CDT)
    • fix table reconnector to not look for L_Labs_DSM any longer, since it's now elsewhere. Ttenbergen 15:52, 2018 April 11 (CDT)
    • CCI and ICD10 make button for Pagasa
      _dev_CFE
    Linked pairs, better storage
    Change Prioritiesis this Check Renal Tasks? If so, there are questions there. Ttenbergen 14:09, 2014 May 14 (CDT)
    Changing D IDs
    • Which program do you do this in? This may actually need to be different instructions for different scenarios.


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


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

    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)
    Characteristics Of ICU Patients Who Died Or Were Readmitted Within Seven Days Of Transferhow did we support this publication?
    Charlson Comorbid Score query_dev_CFE
    • the query needs to be cleared out of CFE once we are done. Possibly sooner, I sort of doubt it is used.
    Chart Review ListsThis 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.
    Chart number
  • EPR sometimes lists something like MRN 123456-1; in that case, do we code the -1, or do we code 1234561, or just 123456?
  • Check CCI CXR vs LOSwould we not use Accept DtTm here? Because we could have CXRs on days before arrival...
    Check CRF vs ARF across multiple encounters
    • Using the ICD10 renal codes, we still need to know when the transition from acute to chronic occurs - so we can decide whether the multiple encounters consistency checking is still relevant. --JMojica 11:51, 2018 November 14 (CST)
      1. is the transition on the next hospital stay? Example in this hospital stay, patient is diagnosed with ARF and stayed continuously in both ICU and ward in same or different hospital. On the next hospital stay, he is now chronic renal patient.
      2. Or the transition is on the next ICU or ward stay? Ex. the first stay is ICU and diagnosed with ARF. then patient was transferred in a ward of same or diff hospital - is he now a chronic renal patient?
      • The data collection instructions are in the related pages, and additional info is in Renal Coding Considerations for ICD10, but they are a beast of a network of concepts. Those might tell you how we currently propose to collect the renal codes, but not necessarily what you or the users of the data would want. Usually these cross checks would be driven by what you need for data requests, so do our proposed instructions line up with how you want to use this? Or is this maybe too case-by-case of a concept to even make a cross check? Ttenbergen 18:59, 2019 January 6 (CST)
    Check ICD10 some cant be primaryComo 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 Inf Potential Infection must have pathogen or alt combined code_dev_CCMDB
  • Discussed on Agarland 09:56, 2019 August 22 (CDT) - we should implement this. At least for a while. If too much extra work, we can take it out.
  • Check TISS Intubation consistent_Dev_CFE
  • this cross check would not know the difference between (on one day, intubated, extubated, and reintubated) vs (intubated and then extubated); while this hopefully not too common of a thing, would it cause false positives for Pagasa to run after? Ttenbergen 11:33, 2018 October 29 (CDT)
    • yes that is correct because both have a difference of zero. Using the cut off GTE Abs(2) will get true negatives and not false positives. This query considers only the counts and not the dates which will have numerous scenarios and too complicated to define. For those having a difference of -1,0,1 , there are also the possibility for incorrect sequence of dates of intubation or extubation - this is not captured in the query. If you have other suggestions, let us know.--JMojica 12:19, 2018 October 29 (CDT)
      • What I was trying to say is that I am worried this would be a false positive, which will then create work load for Pagasa and/or Collectors to confirm. Do we really want cross checks that bring up potential errors? We have talked about this before, but never really come up with a general answer. Should we take it to task meeting? Ttenbergen 23:45, 2018 October 29 (CDT)
      • Are you saying I should use "difference between A and B can be -2, -1, 0, 1, 2. Other values will be questionable?
        • The basic scenarios are
          • 1. no new insert and no extubation (0-0=0) ,
          • 2. no new insert and then extubated - this assumes currently with tube and then extubated (0-1=-1),
          • 3. insert new tube and no extubation(1-0=1),
          • 4) insert new tube and then extubated (1-1=0). When there are 2 insertions, the valid number of extubations =1,2,3 even if occurring at same or different days as insertion day, the difference will either be -1,0,1. Same holds true with 3 insertions or 4 insertions. there will be definite errors if the difference is >= 2 or <= -2. Having 1 insertion and 3 extubations or 3 insertions and 1 extubation are not possible and are errors.
            • Scenario: Pt arrives intubated. On day 1, they are extubated. On day 2 they are intubated, extubated and then intubated again on the same day, which will look on TISS as one insertion on that day and one removal. If you then had a removal the next day you will have an error because you have a count of 3 extubations with only 1 intubation.
            • yes, this scenario if indeed correct has to be checked with the dates and also not that frequent. I found a case of 3 days extubations and 1 day insertion which is questionable because the 2nd day extubation (4/18/2018) is not the same day as the insertion day (4/16/2018) and the 3rd extubation day is 4/23/2018 - is there a missing insertion before 4/23 or an extra extubation 4/18 or 4/23? Actually, the most common cases are either extubations >= 2 and zero intubations or zero extubation and intubations >= 2 which we assume as missed bubble that is why -2 and 2 are not included in the acceptable values. When I discussed with Trish the scenario you have cited, she said we still need an audit so we are aware and clear about the cases of two insertions done in a day.--JMojica 10:19, 2018 November 21 (CST)
  • I will have to sit down with this and work through it.
    Check VAP acquired only first encounterWe decided that VAP can actually happen in medicine if pt admitted from ICU. How would we deal with that for this check?
    Check organ donors must be dead
    Check pre acute consistentwhat 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.
    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.
    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.
    • 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


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


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

    How does Chronic Health Facility fit into this? Or Imprisonment/incarceration and other info in Prison / Jail / Correctional Institution?
    Chest Physio (TISS Item)sounds to me like this is still done differently by different people. Ttenbergen 12:58, 2017 July 27 (CDT)
    Chronic dependence on mechanical ventilator1ChronicVent Need better definition to include the possibility of chronic before acute.
    Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15only if done on your unit, or also if done while admitted to your unit? Do they ever haul people off to dialysis while admitted?
    Cleaning up a failed send
    Clinically significant gastrointestinal bleeding in critically ill patients in an era of stress prophylaxishow did we support this publication?
    Collection Location Service TypeWhat 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.
    Community Nursing Home Location Helper
    • I think it would be utilized more if you had it as a "helper" button.--LKolesar 07:48, 2017 March 15 (CDT)
      • A helper button works even if wifi does not. We tend to have a significant number of times we lose wireless at HSC as not all wards have it.--CMarks 07:42, 2017 March 16 (CDT)
        • Sorry, this fell between the cracks. Do we still want this? Does anyone have a master list that I can use as a starting point? Ttenbergen 14:16, 2019 October 4 (CDT)
    Community-acquired pneumonia (CAP) in ICD10What does that even mean, since we don't have a code for CAP?
    Comorbid DiagnosisComo Admit Acquired Primary Limits - this is part of that discussion - if we limit which admits will count as comos we need to review
    Comparison of ICU Antibiotic Use and Costs in Pnuemonia Admission in Two Urban Centershow did we support this publication?
    Comparison of ICU Investigation Patterns & Costs in Two Urban Centershow did we support this publication?
    Completeness of TISS records
    • we will track the TISS outstanding status in the L_PHI.notes field
    • that field will be made available in CFE underneath notes field
    • email button will be changed to store in L_PHI.notes
    • Pagasa will clear notes field when done
    • update definition for "vetted" to reflect it does not include TISS
    • move all TISS queries into CFE
    Confidential waste disposal
    Constructing episodes of inpatient care: data infrastructure for population-based researchhow did we support this publication?
    Continuous Stay
    Controlling Dx Type for ICD10 codesComo 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
    Coordination of data between collectorsWe have discussed this at Task meeting and will tweak these instructions. Val is working on this, updates coming, just some working notes for now:
    • comparing admit/discharge times
    • sharing serials if that is still done anywhere, I think not... if anyone is still sharing a location and serial pool please post here...
    • "One more point, D5 & B3 use consecutive numbers also. These would be hard to keep track of without a paper log for the really quick admissions & discharges that are sometimes seen on B3.--CMarks 13:22, 2012 October 1 (CDT)"
    Copy here only centralized data.vbs
  • What does it mean work as a set? Does this mean if one change (like the path in the "copy to here only centralized data.vbs" then push/pull script also needs to have changes? Pagasa does not seem to have any issue with the push or pull script.--Trish Ostryzniuk 11:44, 2019 July 15 (CDT)
    • Yes, when one of the three is changed, e.g. for a path, the others should need to be changed as well. Why would Pagasa be having issues with the scripts? If this is about the changes to the scanning folder, that is not part of push pull so would not expect any problems. Ttenbergen 12:47, 2019 July 18 (CDT)
  • Crash TISS MDB
    Critical Care Vital Signs MonitoringIt says that CCVSM is in Quarterly report. If CCVSM is no longer, is it still in quarterly?
    Critical Care and Medicine Database Core CurriculumHow does Critical Care and Medicine Database Core Curriculum co-exist with Data Collector Portal? The audience is different, one is for newbies and one as day-to-day reference, but how does that change what needs to be told, without just duplicating all? Ttenbergen 21:08, 2019 January 3 (CST)
    DSM Lab Extract
    DSM Labs Consistency check.accdb_DEV_DSM
    • Next version:
      • lock out sending of request if any sent but not vetted records are present to make sure they are not missed; or send all <> incomplete?
      • fix auto email it says "Hi, \n \n here is a new data request file for the CCMDB export. Could you please generate the lab export and let us know when done? \n \n Thanks!"
        • why would I change it and to what?
      • Add a debug.stop after the new-lab-finding part so the import can just continue.
      • the error it gives for there already existing a file needs more helpful text.
      • automate reconnecting; I thought this was done but it's not.
    Data Collector PortalHow does Critical Care and Medicine Database Core Curriculum co-exist with Data Collector Portal? The audience is different, one is for newbies and one as day-to-day reference, but how does that change what needs to be told, without just duplicating all? Ttenbergen 21:08, 2019 January 3 (CST)
    Data Integrity Checks/review listPagasa, regarding the meeting with Trish, Julie and Allan to decide which checks to continue to do when, please
  • expand this list to 50
  • click the “edit w f” link at the start of the line to open any that need change right in a form to use dropdowns to update them
  • confirm that all queries correctly list
    • whether you check them always or only complete (timing field)
    • whether they use L_Problem
    • whether there is a backlog (I just added that field, it defaults to "yes" so change to no if caught up)
  • Data Processorleave these for now, Tina will go over these and take those that are not really data processing out of the category before we try to address the rest.
    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 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 (CDT)
  • Deceased patientsI needed clarification on this. I recently had a patient that was sent for a coronary angio, who arrested and died during the procedure. At the time, I was told that my dispo field should be the coronary cath lab, and to not code the angio or any complications that arose from it. The above statement seems to contradict thisMlagadi 07:44, 2019 August 29 (CDT)
    Definition of an ICU admissionThe following was written here, is it true? : For ICU patients collection starts at unit Arrive DtTm.
    We need to update this to explicitly exclude ER pts. Yes, allegedly this "never happens", but since we explicitly exclude these, we should state so. This would also ensure consistency with pages like Length of Stay (ICU Report) which rely on this definition.
    Delirium daysWhat are the details?
    Depression (major depressive disorder, recurrent depression)


    Differences Between Intensive Care Unit Admissions Located In Rural And Urban Hospitals In A Canadian Populationhow did we support this publication?
    Direct Data Access for RIS/PACSZ) Should we pursue this now? Where would it be on our priorities? It might be related to CCI coding.
    Discharge RegisterThe 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)
    DiscussSteering
    Distinct Determinants of Short-term and Long-term Mortality After Critical Illnesshow did we support this publication?
    Drug or biological substance/agent NOS, adverse effect
  • Had code T88.7 when we first started but was later changed to this code. I have deleted the original code from the tables, but it might still linger in other references. Once you are sure you don't need this info, please delete the comment. Since this would only exist in test data we don't need to keep it long-term.
  • Dx PrimaryFor reporting purposes, Julie puts the primary diagnosis into 8 different categories:
    • respiratory disorders
    • post cardiac arrest
    • trauma and poisoning
    • metabolic/renal/GI/hypovolemic shock
    • cardiac disease
    • neurologic disorder
    • post-operative care
    • sepsis/septic shock

    Traditionally we have put the "primary" diagnosis as the main reason they are in the ICU (or ward). The problem is that the reason they came may not really fit the proper category in all cases. For example, the patient came to the ICU with respiratory failure requiring intubation, however the patient may have sepsis which caused the respiratory failure and technically we should be putting sepsis as our primary. Another example is cardiac arrest which traditionally has always been put as the primary diagnosis. However, it does not always capture the correct category which is why they went into cardiac arrest. They may have had an overdose or an airway obstruction or apnea or sepis or it may be a true cardiac event. We would put the cause still as #1 along with the cardiac arrest but it would be missed because Julie only picks up the primary (checked) diagnosis. Putting cardiac arrest as primary can miss the true category. To make it even more complicated however, there is a category for cardiac arrest so which is more important to capture? We all need direction on which diagnosis is "primary". --LKolesar 13:38, 2019 June 25 (CDT)

      • I guess the question is if any dxs can not be captured in those 8 groups. If they are all captured there is no problem, or is there? Ttenbergen 10:09, 2019 October 4 (CDT)
    EMIP
  • need to resolve EMIP and figure out where that info will live. Ttenbergen 11:30, 2016 December 29 (CST)
    • If a patient is still considered an ER patient in a CAU, they can potentially be an EMIP if they get accepted by internal medicine but subsequently are discharged or sent to another hospital.
      • At STB CAU contains inpatients under family Medicine (they are not under the ER physician).
        • If the CAU is considered part of ER then I guess patients that are accepted by internal medicine and go out elsewhere could be EMIP's. It depends how you view the area.
          • Is the CAU considered the same as ER or not? Management will have to determine how they want this done. Currently no one at STB collects data at all on the patients in the CAU. --LKolesar 11:49, 2017 October 27 (CDT)

    • I have had a couple of scenarios in the past few months that I have not considered an EMIP, but I thought I should get a second opinion: The emergency notes state that a patient from another hospital/nursing station, etc. is a "direct for internal medicine". The patient gets to our ER, and is immediately deemed too sick for the ward, and ICU is consulted. The internal medicine doctor may or may not have even laid eyes on this patient, and there is no admission order. In these cases, although the medicine doctor may have written a note about seeing the patient in the ER, they never took over care/wrote orders for the patient. How are other collectors entering these patients?Mlagadi 11:38, 2019 October 1 (CDT)
      • I think this scenario is not an EMIP since the Med doc did not took over. Did the patient go to ICU - if yes then this is an ICU admission? --JMojica 17:09, 2019 October 3 (CDT)
        • This is an interesting case because the medicine service technically accepted the patient to begin with, as they came direct to medicine, and an ER physician did not see them. If medicine sees them, then it could be considered an EMIP? but if medicine doesn't see them, who decided that the patient was too sick for the ward? and consulted ICU? if it was the ER physician than I don't think it would be an EMIP. Just my two cents, it is definitely not clear cut Lisa Kaita 11:03, 2019 October 8 (CDT)
    EPRwe need to update this...
    EPR Reports
    • Is it only your sites, or all sites in Regional.
    • Do you use them to obtain transfers admits and discharges?
    Early Administration of Crystalloid Fluids Reduces Mortality in Septic Shockhow did we support this publication?
    Early combination antibiotic therapy yields improved survival compared with monotherapy in septic shock: a propensity-matched analysishow did we support this publication?
    Early intravenous unfractionated heparin and mortality in septic shockhow did we support this publication?
    Effects of a Resource Mangement System on ICU Laboratory Utilizationhow did we support this publication?
    Eliminating a diagnosis from collection
    Eliminating distinction between different ward typesany of Julie's Reporting that use this concept?
    CTU vs NTU - we decided at task that we wanted to eliminate the distinction. A lot of things are part of their network of information, so we will need to work out the details above before we can move ahead.
    • I believe it was only related to transfer ready DtTm between CTU and NTU not eliminate the concept. Medicine program would have to weigh in. Trish Ostryzniuk 16:11, 2018 July 30 (CDT)
      • I seem to remember the reason to stop doing this also involved that we have more and more locations that don't fall into a clean place. For now we pretend we can give medicine this data, but is it true and meaningful? Ttenbergen 15:51, 2018 July 31 (CDT)
        • Allan will contact the medicine stakeholders about eliminating this distinction. Will email Mary-Ann Lynch, VanAmeyde, Griffin. Ttenbergen 12:18, 2019 January 24 (CST)
          • pinged again for Allan to Follow-up. Ttenbergen 13:44, 2019 February 25 (CST)
    • AG REPLY: DONE. NOBODY is using or seeking this info. So let's stop collecting it.
    Employee Assistance Program
    Encephalopathy, septic or metabolicThese instructions imply that anytime we have someone come in with altered mentation due to hepatic encephalopathy, that we need to code them as one of the liver failures. This leads to a lot of patients being labelled as liver failure. I'm not sure if I am using this code correctly
    Encephalopathy, toxicSome parts of the following should probably go back in there, emailed Allan.

    incl drug-induced (also code drug if known) except

    Encounter processing
  • 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...
  • Error: There isn't enough free memory to update the display. Close unneeded programs and try again.Please enter your laptop and under what circumstances you have seen this error below.
    Ethical and practical considerations of withdrawal of treatment in the Intensive Care Unithow did we support this publication?
    Exporting and sorting an admission list from EPR
    • Val, you went through the process of exporting this with me there last time. Could you write up how we exported the list to .xls?
      • we just discussed that we don't need to save that file, just generate it and copy from it.

    Building this now, more info to come.
    External Files
    Facilitated Management of Serial numbers
    FinalCheck field_DEV_CCMDB_data
    FirstName fieldunder #Legacy info it said we stopped messing with names so cross checks with old data would work. If we no longer do that we should fix the reasoning there.
    please confirm what we actually do now:
  • in case of a typo
  • in case of a change
  • do you use the Alias ID collection for this?
  • Fixing a D ID in TISS28.accdbPagasa will test the quicker way, and if satisfied, will clean out the two old methods.
    Flagging for TISS
  • I think this could be helpful, however I generally have to check against the MAR, flowsheet,etc, is Pagasa finding that there are days missed or items missed with the consistency checks? If yes, than perhaps this should be implemented? Lisa Kaita 12:43, 2017 May 2 (CDT)
    • Yes, Pagasa finds missing items. See #Applicable checks for the kinds of things she checks.
    • Not sure how this editing flag would look in CCMDB. ... Just wondering how this would work??--LKolesar 13:54, 2017 May 2 (CDT)
      • This would probably end up as a list of items that was entered for this patient that should be confirmed in TISS. EG if you enter an endoscopic CCI for a pt, the list would contain that entry as something you should confirm is present on TISS. In theory you guys are already doing these cross checks, but apparently Pagasa and Julie are finding discrepancies... Ttenbergen 15:20, 2019 October 4 (CDT)
    • I personally would not like to have more error messages pop up during data entry. I know how the tiss and other data relate and re-check this frequently. Also, there are exceptions to the checks. For example, a person can have a cardioversion, endoscopy, temp pacer, etc. which would be coded in the complications but if it happened off the unit, it would not be on the tiss. Tiss is only for things that happen in the ICU. --LKolesar 06:54, 2017 May 4 (CDT)
      • Agreed, this would also be one more thing collectors have to check. It would not be likely to include any checks that are not 100% checks. Ambiguous situations like what you describe, Laura, already can't have cross checks, so would not be part of this list.
    Focus moving from ICD10 tab to Dispo tab when trying to enter a dx
    • Is anyone else encountering this and can give me any pattern to consistently cause it to happen? Ttenbergen 14:08, 2019 March 20 (CDT)
    GRA CAU
    GRA General Collection Guidethis link is broken; is the info still relevant?
    GRA Medicine Collection Guide
    • CTU vs NTU
    Gender Differences in Intensive Care Utilizationhow did we support this publication?
    General Collection PracticesI have linked this from Critical Care and Medicine Database Core Curriculum, but it likely needs updating. Unless we don't want it at all.
    General Diagnosis Coding GuidelinesI have linked this from Critical Care and Medicine Database Core Curriculum, but it likely needs updating. Unless we don't want it at all.
    So, collectors, almost 10 years after I initially asked that question, did these guidelines ever become useful?
    Grace Nursing Home Ward
    Guideline for coding organ donation after death_dev_CFE

    The following in Correcting suspect links will need to be updated for this:

    H1N1seems odd that we would have done a flu study only for 1 month in a summer...
    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)

    • 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)
    HSC CAUOK, now clearer what CBA is, but I still don't understand: why it is in the HSC CAU page?
    not summarized
    Do we need to know more about the CBA designation or process, should it affect our reporting?
    HSC Electronic Patient Record
    • This is common to all sites, right, not just HSC? See comment at EPR where the non-site-specific stuff should live.
    HSC IICU
    • expanded to 8 beds - Date: ?
    HSC IICU Collection GuideIs this still relevant after workload redistribution? Ttenbergen 11:47, 2015 May 20 (CDT) And is this how you want it?
    HSC Med nonteaching contingency bedsenter HSC_B5 stop date when known
    Those are now endoscopy, right? If so can we take this section out? Trish Ostryzniuk 17:50, 2018 July 30 (CDT)
    When did the H4 contingency beds close? Are they closed for good? If so, do we need that info any longer? It should not affect our data or processes going forward , nor help make sense with old data, right?
    HSC SICUwho is unit clerk?
    Health Care Utilization Before and After Intensive Care Unit Admission in Rheumatoid Arthritishow did we support this publication?
    Health Sciences Center Office
    Heart transplant, failure or rejection or unspecified complicationis the following actually specfic to heart transplants? If not, it should be moved into Template:ICD10 Guideline Transplant Failure so it will show in all the transplant failure pages.
    Height and weightZ) decided to revisit SOFA scoring 6 months after ICD10 so same should likely go for this.
    High Rates of Mortality and Technique Failure in Peritoneal Dialysis Patients After Critical Illnesshow did we support this publication?
    High dose chemotherapy as primary admitThis page is listed as an exception in Definition of a Medicine Service admission so I wanted to make sure we include that instruction with the new codes. However, what _is_ the new code for this? Found nothing suitable in CCI Picklist, CCI component 2 codes - what was done, and ICD10 Diagnosis List only has Antineoplastic/chemotherapy or immunosuppressive drugs, adverse effect which doesn't seem a real match either. In general we would only code the cancer now, right, but this is a bit of a special case, so do we want to treat it separately?
    • AG REPLY -- we don't need this at all and there's no way to code it specifically in ICD10 -- except that such an admission would have the Dx code of the cancer being treated, and the CCI code for the chemotherapy
      • emailed Julie and Trish to make sure they are comfortable with this.
        • Trish, if you are fine with how this is or isn't addressed in ICD10 going fwd, pls remove the tag
    High occupancy increases the risk of early death or readmission after transfer from intensive carehow did we support this publication?
    Hospitalization in Winnipeg, Canada due to Occupational Disease: A Pilot StudyI see Pat's name... did this actually use the DB or just a collector? how did we support this publication?
    How many ICU beds does a population need?Can we get any reference to this? It's not on pubmed... how did we support this publication?
    Hypokalemia, severe or symptomaticThe following guideline was only meant to apply to the categories listed in it. This dx, Hypokalemia, severe or symptomatic is not in one of those categories. If we want to expand the rule to other categories we need to discuss that more broadly than just this diagnosis. Flagging this for task.

    Repeated events

    If this happens repeatedly during the same ward or unit stay, only code it the first time it happens, rather than each time it happens. See ICD10 codes only coded the first time for other diagnoses coded this way.

    Example:   
    • A person has a self-limited episode of A-fib. It goes away and then recurs. Only code the first one.
    • A person has a self-limited episode of A-fib. It goes away but then he has an episode of V-tach. As this is a different diagnosis, both of these should be listed, but only code once each.
    • Patient comes in with hypokalemia. It’s treated and remits, but the next day it recurs. Only code the first time.
    ICD/CCI remove once old pt goneICD/CCI remove once old pt gone 1
    ICD10 Diagnoses and CCI Codes that need to be coded togetherunmaintainable. emailed Trish to see if she is ok with us taking this out. Ttenbergen 12:05, 2019 February 1 (CST)
    ICD10 Dx sorting issuesWhat does everyone think, would this be a possible and worthwhile thing to add? Am I missing something and there would be an easier way to do this? Ttenbergen 10:57, 2018 August 2 (CDT)
    • This is an older discussion and I think the form has changed since. Do we still have sorting issues in the ICD10 form? If I don't hear anything I will set this to fixed and clear this out in a month or so. Ttenbergen 21:14, 2019 March 9 (CST)
    ICD10 Guideline Como vs AdmitComo Admit Acquired Primary Limits - this is part of that discussion - if we limit which admits will count as comos we need to review
    ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rateThere was no significance in your PPT.
    Just to be clear, is it number of cases (possibly >1 per pt) or once per pt as mentioned above?
    ICU Acquired SepsisNothing was listed in your power point, what is the significance?
    Just to be clear, is it number of cases (possibly >1 per pt) or once per pt as mentioned above?
    ICU Interfacility TransferWhat are the details?
    ICU MortalityWhat are the details?
    Does this also consider any of the Diagnosis implying death?
    Allan says don't include Brain death admits in the numerator or denominator ?
    ICU Resource Utilization - Chest XraysWhat are the details?
    Is this DSM Lab Extract?
    ICU Resource Utilization - Creatinine TestsWhat are the details?
    Is this DSM Lab Extract?
    ICU Var 6 - AMADid 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.
    ICUotherServiceWhen a CICU pt is in MICU under MICU service we do not have an option in the drop down for this (this occasionally happens when they have no beds). We also do not have an option for an MICU pt in CICU under CICU service (although I do not know if this ever happens but I suppose it could happen).--LKolesar 14:02, 2019 May 3 (CDT)
    ID cardsThis is info we might best keep in collaboration with the Internal Medicine folks, as it should be the same and we could learn from each other / prevent duplication. would it be OK to move this to
  • https://wiki.umintmed.ca/index.php?title=Arrange_for_ID_Badge_%26_Access
  • with a link from here? Trish, you and I at least would still have rights to edit it there, if other CCMDB people need an account we can get it for them. Emailed Trish Ttenbergen 11:28, 2018 March 20 (CDT)

      • Tina, I prefer not to move there as I don't need to be log into another Wiki. Trish Ostryzniuk 17:50, 2019 April 3 (CDT)
        • You would only need to log in if you need to edit, and that would only be once in a blue moon. There would be several advantages: more people to keep it up to date, and maybe putting ourselves on the map a bit more as part of the department.
    Iatrogenic codes in ICD10
  • The instruction for HAP is different here than the Hospital-acquired pneumonia (HAP) in ICD10 page.--Jvelasco 07:56, 2019 July 16
    • this spot here should probably just be a link to that other page, with coding details living there only. Otherwise these will just get out of sync again. Ttenbergen 12:52, 2019 July 18 (CDT)
  • Iatrogenic, mechanical complication/dysfunction, internal prosthetic device or implant or graft NOSq_iatrogenic_trauma

    CCMDB is giving an error message saying "has trauma mechanism but no related trauma", cannot send - Joanna Velasco May 29, 2019

    • AG REPLY -- the issue is that this is not a trauma that requires a cause. TINA our soln is to turn all the iatrogenic things like this into "Potential Mechanisms"
    Identifying ICU admissionsmultiple questions, especially for HSC and GRA
  • Grace, are collectors now able to use EPR Reports to generate own transfer, admit and discharge reports?Trish Ostryzniuk 11:35, 2016 May 20 (CDT)
  • no access to ERP reports yet to generate our our listsMschaffer 08:57, 2016 May 31 (CDT)


    • what are those plans? Are we still planning to? Ttenbergen 09:31, 2016 November 10 (CST)
    Increased Incidence of Critical Illness Among Patients with Inflammatory Bowel Disease: a Population-based Studyhow did we support this publication?
    Initiation of Inappropriate Antimicrobial Therapy Results in a Fivefold Reduction of Survival in Human Septic Shockhow did we support this publication?
    Instructions for importing a batch of DSM Data_dev_DSM There is a newly found and new added query for each; why are there two and can I delete one set?
    Intensive Care Unit admission following successful cardiopulmonary resuscitation: resource utilization, functional status and long term survivalhow did we support this publication?
    Isolation, infectiousFor patients who are admitted and have pre existing MRSA to code infectious isolation as an acquired CCI code is counterintuitive if it is present and treated with isolation on admission. Pre existing colonization would be included as an ADMIT DX if treated with isolation, and the isolation would be included as an admit CCI procedure.
    • I agree, it does feel counterintuitive, but if we are following the WIKI guidelines, it seems like this is how we are supposed to code it. I think their is currently a lot of discrepancy in how this is being coded.
      • there seems to be confusion all around when to code something as an admit vs acquired vs comorbid. One example we have seen, someone comes in to ICU with stab would injury to heart, has had cardiac arrests, and is in shock. We see the trauma injury to heart coded as comordid. Need to discuss collection instruction tweek that would help
        • Allan recently updated Admit Procedure with info that is relevant to this. I wonder if the instructions on this page are just a remnant from an earlier iteration of the Admit instructions. As I read the current ones, you would not code this. But yes, good we are taking it to Task...
    Kidney Transplant Coding Guidelines
  • If patients have a history of parathyroidectomy, then you can code a Comorbid Diagnosis of Past history, removal of organ NOS
    • why would this have been in the kidney instructions rather than the page of the dx that should be used (where it is already mentioned)? We want to avoid re-stating things - if we ended up changing how this is coded in the future, the instructions on this page would most likely be forgotten in the update.
  • Kidney, acute tubular necrosis (ATN)
    • If a patient has ATN on admission and later requires CRRT for kidney failure, do we need to put an acquired code of Kidney, acute renal failure NOS or not? The crrt goes into the CCI codes. --LKolesar 12:11, 2018 December 5 (CST)
      • What is special about this dx that would have you not code it? Is it that you are wondering whether coding a CCI means you don't have to code a dx? They are different things, you would still need to code the dx. Am I misunderstanding the question? Ttenbergen 07:09, 2018 December 14 (CST)
    • ATN does not necessarily imply the need for dialysis but if this distinction is no longer necessary, then I won't worry about it.--LKolesar 07:41, 2018 December 31 (CST)
      • Laura, are you concerned about this in terms of whether a cross check would find a dx that explains the CRRT, or where are you coming from with this question? Ttenbergen 20:03, 2018 December 31 (CST)
    L Hospitalization tablez
    • implementation was never finalized, and it wasn't tested and isn't used.
      still need to figure out if I need an s_table for this.
    L ICD10 APACHE Dx query
  • 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)
  • L ICD10 subform
    • I changed this around a bit so there is a background that ties the types together on the left, and the priorities on the right. Also changed it so that the priorities use different colours than the types. It doesn't look particularly nice, but the point was to group things better. So, does it do that? If not, do you have a suggestion what would (ideally without taking up much more space). Also, yuck, even if it does the trick, how would we make it look a bit less awful? Please comment below. Ttenbergen 22:06, 2018 November 24 (CST)
    LOSthis article has evil twins, need to reconcile, search for LOS Ttenbergen 21:13, 2014 October 23 (CDT)
    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 admissionthis still talks about TMSX... what is the new status of this field?
    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?
    originally you called this "Calculation Procedure:" - which do you prefer?
    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.
    "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 ward stayHi Dr. Garland,A thought came up after the last Task meeting related to the discussion on using Service LOS vs. Physical bed LOS (location). We also have A/D/H service patients go to the ward D5. This ward is typically less acute and patients will transfer to D5 from all of the medicine wards (A4/H4/D4/B3/H7). The patients retain their service (A/D/H) while they are on D5, some patients will switch attending (to the D5 Attending), others will stay with the same Attending they had prior to arrival on D5, but the service will remain the same. The Attendings on D5 do not have a specific service and, there is no rule as to which patients switch to the D5 attending. Some patients will be discharged from D5 still under the same Attending that cared for them prior to arrival on D5. When patients leave A4/D4/H4/B3/H7 their profiles are completed (discharged) by the designated ward collector and a new profile is created by the D5 collector.Thanks, Val Penner, May 16.19
    ward LOS vs Service LOS - Val Penner - HSC-D5 follow up from May 7 task meeting- May 16.19
    Lab Collection Process
    Lab and culture reportsyou wanted to remove stuff from here that's already in the infection guidelines instead.
    LastName fieldplease confirm what we actually do now:
    Length of Stay (ICU Report)need to confirm the last part?
    Right now this is slightly inconsistent with Definition of an ICU 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?
  • Collected at time of ICU discharge;
    • that's not technically true, right? It's collected whenever. Are you actually talking about when it's reported here then? That it is only reported after discharge? Is that true, are we excluding pts who are still admitted in this? Or am I misunderstanding the whole thing? Ttenbergen 19:34, 2019 August 13 (CDT)
  • Length of Time for Transfer from ED to ICU within same facilityNo significance in your ppt?
    What are the details?
    Link suspect mismatch to ours incomplete query
    • 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?
    Linking in centralized data front end.mdbWhy are these not the same as below? What are we doing now? Do these need to be done in a specific order?
    List of Factor affecting data quality
    • These points about improving APACHE were made a long time ago. Since then we added a listing for default values and ranges, and the BP Helper button, and the reference values and ranges on the Patient viewer tab APACHE. Would you say that these issues are addressed or is this still a problem?

    These comments were made a long time ago, before we used EPR, and before we split the admit time into Accept DtTm and Arrive DtTm. Are any of these still relevant? If not I would like to clean them out.
    We certainly have more guidelines now than we did in 2011... is this still a concern?
    List of diagnoses affecting Overstay Project (pre-ICD10)
    • in reconciling these, a lot are based on Charlson Comorbidities in ICD10 codes, so whatever we use there should be consistent with here.
      • Allan was OK with these at list meet today Ttenbergen 14:58, 2019 February 25 (CST)
    List of diagnosis codes corresponding to Charlson Comorbidities (pre ICD10)
    Manitoba Health Crosschecking Background
    Manitoba Health Crosschecking Reconciling Returned Data
    Manitoba Health Crosschecking Sending Data
    Medical Assistance In Dying
    • When we started out this dx used code U23, but then as of 2018-07-17 ICD10 actually added a code for this so we changed ours to that code. I don't really think we are interested in keeping that very early test data, so this comment can probably just go, and we can delete them. I am removing the code from our s_ICD10 table.
    Medical ward admissions among HIV-positive patients in Winnipeg, Canada, 2003–10how did we support this publication?
    Medworxx
    Minutes Team Meeting October 1, 2014
    Mortality and readmission report
    • who is this report given to? thank you--TOstryzniuk 18:40, 30 November 2010 (CST) Ttenbergen 23:43, 2017 June 7 (CDT)

    What is the Mortality and readmission report report?
    Multiple encounter consistency checksThe task is currently done by the Statistician and we'd like to get it off her plate.
    Newsflashneeds troubleshooting
    Night Time DischargesWhy only to wards? How about to home?
    Non-standard ICD10 DiagnosesDx grouping
    • With our addition of codes, collectors may use one of our codes rather than the closest standard ICD10 code. In that case, the dx would not show up in the range. How should we address this? The most likely candidates above seem Bronchiolitis obliterans organizing pneumonia (BOOP, cryptogenic organizing pneumonia (COP)) and SARS (severe acute respiratory syndrome)
      • AG REPLY -- for this nonstd BOOP code, there are no existing issues regarding any of the comorbid groups (e.g. Charlson)
        • Allan, could you confirm that that this is what we found when we looked into BOOP.
    • AG REPLY --- so far Tina the only 2 U-codes that would ever be a primary dx are U04 and U14.68 -- which belong respectively to ICD10 chapters J and E. But whenever we add a new U-code we need to remember to decide which chapter (if any) it needs to be included under. Tina to add to template.
    Notes field
  • A dx should not be entered into ICD10 unless it is known and confirmed (ICD10_collection#.22Suspected.22_Diagnoses). Are collectors still entering unconfirmed dxs into ICD10 and noting so in Notes? This should not be happening... Ttenbergen 10:19, 2019 September 16 (CDT)
    • if data is INCOMPLETE, main does not rely on DX info. If DX has not been confirmed, notes field is good place to put a Clear note to self or to collector who is covering you.Trish Ostryzniuk 17:26, 2017 November 20 (CST)
      • As confirmed with Julie, Main office uses the Primary Admit Diagnosis even for incomplete records, so dx codes should not be coded for suspected dxs in ICD10. If we really want to change this, then instructions on ICD10_collection#.22Suspected.22_Diagnoses need to be made consistent with those on this page. Ttenbergen 10:19, 2019 September 16 (CDT)

    • Perhaps tagging things for main office, as indicated below, should be done differently or in different place as notes are difficult to sift through in main office. Some collectors delete notes before they send. Others put no notes. People use non standard abbreviation or own codes which is not clear for main office.
    Nursing WorkloadWhat are the details?
    Average or mean? Different in description and definition.
    Object with variable error
    Off ward fieldCurrent way of checking through transfer list from ER will miss off ward patients who arrived at off-ward locations from elsewhere than emerg. Laura and Tina discussed, did not find solution yet, should be rare, though. 13:41, 2017 March 1 (CST)
    We collect data on some patients who never arrive on one of our units, e.g. EMIPs any other scenarios? There was a page for the HSC off warders I think...)
    Out of Memory Error
    Outreach efforts
    Over Census at MidnightWhat are the details?
    PHIA policy
    PL 2Phin Fake or Blank_dev_CFE As per meeting with Allan, Julie and Pagasa: (1) only if complete AND (2) only do links in incomplete if have PHIN.
    PL Chart 9 Digit
    • Function Validate Chart should capture all of these in CCMDB.accdb. Emailed Pagasa to find out if she ever actually finds any in here. If she does we need to fix Function Validate Chart, if she doesn't she could stop running this check.
    • Got this 9 digit chart error today. PTorres 11:37, 2019 August 22 (CDT)
      • Sorry, just saw this; was it a true error, and if so, what was the Chart number that was causing it? Probably too late to figure out for this particular instance, but if it happens again, that info would be helpful. I just confirmed again that CCMDB.accdb should trap this error, so we would need to find out if there is something collectors do differently to let this through.
    PL SamePHIN Site Diff chart_dev_CFE 1 this query has reached the 2GB limit, must see if I can lean it out or otherwise reduce the size
    PL missing L Tables contentHave there been more since?
    Confirm this only deals with complete records
    • 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.
    Palliative Service
    • 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)
    Panelling or Discharge PlanningThat link no longer goes anywhere, the heading is not on that page. Can the reference be deleted from here, or do we need to review? And, how will this affect the use of the Category:Awaiting/delayed transfer codes? Ttenbergen 14:51, 2018 September 6 (CDT)
    Parked in ERseveral of these should probably be retired once last pt with them in previous location are discharged. Please let Tina know when they should go.
    Patient viewer
    • I just tried to finally do this and realized have no note on what that old tab order was. I know we discussed it back when we made this change. If anyone still has the order around, please put it here and I will change the order back to that.
    PatientFollow Project
    • The list would need to be exported on a regular basis and then made available to collectors. How would this best be done?
    • There was talk about EPR lists to help collectors keep track of their patients. If we use that method then how will we handle it when there needs to be coverage?
    • How do we make sure no pts are missed?
    • How do we make sure no pts are duplicated?


    The potential to either, have multitudes of patients duplicated, or more importantly, patients missed seems astronomical. Inadvertently duplicating patients will end up being way more work for data collectors. How will we, as data collectors even know that we have duplicated a patient that another data collector has already done? Or conversely, how will we know if we have missed a patient?

    • It should be questioned then whether amalgamating all data collection units within a site for example there are 4 medicine collection units at STB + EMIPs how to possibly track and reconcile all these lists with any semblance of accuracy. This would be a very labor/time intensive and complicated process, as well as a significant logistical challenge. Use of EPR lists to create further lists/spreadsheets in Excel seems redundant and a risky proposition in terms of inclusion and accuracy. There are also potential PHIA considerations whereas patient information on laptops is currently stored/accessed through a separate program, what are the implications for "personal" and/or redundant storage of patient information on data collector accounts? Pamela Piche 10:19, 2019 September 5 (CDT)
    Pharm Flow Completelegacy data field
    Pneumonia, ventilator-associated (VAP)where is that list of sources, did it get lost in an edit?
    There is often a difficulty in trying to apply this criteria in the neuro population, as they will have elevation in both T and WBC for very long periods which are not related to infection, and obviously already have a change in LOC. How should we deal with this issue? (Joyce)
    Postoperative laboratory and imaging investigations in intensive care units following coronary artery bypass grafting: A comparison of two Canadian hospitalshow did we support this publication?
    Potential Change
    Pre op Admit-Cardiovasc PatientThis 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-2017-07-30 Overstay Predictor Project Collection Instructions
    Pre-OP Admit - Research Patient - CardiovascularThis is not coded under ICD10 or CCI. Do we report this, and therefore need to accommodate otherwise, or how will we treat this? We have Preparatory care (incl preop optimization) but that doesn't capture the full concept. Ttenbergen 22:45, 2018 November 27 (CST)
    Pre-linking checksnot working right now due to PL_SamePHIN_Site_Diff_chart size limit
    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?
    Previous Location field
    • In the instructions above it says to select "other - known but not listed" this is not in the dropdown as an option.
    • Turns out location missing/unknown wasn't implemented either. Is there any concern if we implement this now?
    • Implement both now
    Previous Service field
    • The Registry Patient Type field was replaced by the Previous Service field, how will the patient types be derived from the previous service field? the s_previous_service table must have a column defining the patient type.
      • Patient Type is Surgical if previous service is Cardiac Surgery, General surgery ,etc.,
      • Patient type is Cardiac if previous service is Cardiology,
      • what about Patient type Medical? if Ob/Gyne or Emergency Medicine, is it Medical type? how about critical care?
      • It was also mentioned earlier to use the diagnosis instead, can we begin working on this? --JMojica 15:48, 2019 May 21 (CDT)
      • If I remember right it the Registry Patient Type data was supposed to be inferred from several fields, not just Previous Service field, but I can't remember the details either. We can absolutely add a column for this to s_previous_service table once we know what we need. Ttenbergen 12:49, 2019 June 4 (CDT)
    Primary Admit Diagnosis
    • They are used in the periodic quarter and fiscal year reports of both the Critical Care and Medicine Programs. (Julie)
      • are the two I linked to above those reports? Ttenbergen 14:03, 2015 April 20 (CDT)


    • How will the primary admit dx involving ICD10 be handled - another query? or be combined to Primary_admit of old dx? --JMojica 09:17, 2019 January 31 (CST)
      • I have built query Query L_ICD10_primary and documented it. Julie, once you have found this and read it, please delete.


    • The query Primary_admit of CFE contains multi records per D_ID. These are the records with admit dates before or on Dec 31, 2018 and are still in the unit by Jan 1, 2019. The L_Dxs of these cases have all the same priority number.
    Printer
    Procedure when there are differences between L Log and L PHIWhy, 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)
    Processing errors in patient data


    _dev_CFE

    Automate the populating of notes so button just does it. 
    
    • raise an input box for a summary, if gets content put data and content into Notes, else put nothing.
    Project ABO TEE
  • If there is no TEE done pre-CPB (cardiopulmonary bypass), then can you use a pre-op standard Echo-cardiogram for this?--LKolesar 13:19, 2015 September 16 (CDT)
    • Could you ask the cardiologists who wanted this data this question? Ttenbergen 22:28, 2019 March 9 (CST)
  • Project Borrow arrivedid they ever get back to us? no response from HSC SICU --JMojica 10:14, 2019 May 6 (CDT)
    Proposed Notes field default
    QA Infection VAPwill 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 ShockIf 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 reportWhat is the Quarterly report report?
    Query Import request matcherThis part of the cross-check is now well understood and ready to program.
    This one is fairly easy, Pagasa will try to make it.
    Query NDC Bad Postal CodeYou mentioned that you occasionally got patients with letters rather than numbers; if that happens again, pls let me know.
    Query NDC CLI AcqDX but NoCLI DateinTMPV2ICD/CCI Please removePTorres 11:48, 2019 July 24 (CDT)
    Query NDC CLI No AcqDX but CLI DateinTMPV2ICD/CCI Please removePTorres 11:49, 2019 July 24 (CDT)
    Query NDC CLI unacceptable dateICD/CCI remove once old pt gone
    Query NDC CLI vs DX but no TISS17 CentralLine
    • It said here that this should be retired, but this is still relevant, no? We stopped tmp, but the dc and the TISS entry still exist... Do you still run this tests?
    Query NDC Dialysis TISS CCI_dev_CFE change to wait till complete
    Query NDC Dxs vs TISS Dialysis_DEV_CFE Discussed 10:00, 2019 August 22 (CDT) - list looks like a good start, ready to implement.
    Query NDC TISS Extubation only on TISS Intubated days_DEV_CFE
    • implement check
    Query NDC TISS vs pharmacy_Dev_CFE
  • Have all info now, Allan confirmed drug list. Once implemented let Julie know so she can not do this in SAS any longer
  • Query NDC Trach Dx TISS_DEV_CFE ready to implement
    Query NDC VAP AcqDX but NoVAP DateinTMPV2ICD/CCI remove once old pt gone
    Query NDC VAP No AcqDX but VAP DateinTMPV2ICD/CCI remove once old pt gone
    Query NDC VAP no TISSFYI Maybe
    Query NDC VAP unacceptable dateICD/CCI remove once old pt gone
    Query NDC zCRRT TISS no tmp_dev_CFE - remove this and *old
    Query NDC zCRRT tmp no TISS_dev_CFE - remove this and *old
    Query TISS Errors ETT consistent
  • 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)
  • Query TISS Errors missing dayswhich report/s are these actually included in?
    _Dev_TISS28 change to wait till complete
    Query check CCI must have entryPatients without CCI entries are slipping through and found by PL missing L Tables content , must fix PTorres 09:42, 2019 February 7 (CST)
    Query check ICD10 ESRD and AKI only if transplantWould the past history really allow for this? i think only a CCI makes it OK to have both an ESRD and an AKI dx in same patient.
    Query check ICD10 ESRD vs AP ARF
    • some of these give false positives for transplants, review what's up.
      • I have heard nothing else about these false positives I think - are they still an issue? Ttenbergen 15:19, 2019 June 18 (CDT)
    Query check ICD10 ESRD vs ARF
    • some of these give false positives for transplants, review what's up.
      • I have heard nothing else about these false positives I think - are they still an issue? Ttenbergen 15:19, 2019 June 18 (CDT)
        • Just heard from Michelle that these are still an issue
    Query check ICD10 chronic vent acute resp failure1ChronicVent
    • Question from Joanna: "Question for you… I have a patient on chronic vent at home. He develops a raging pneumonia and has to be admitted to ICU in respiratory failure. I combined the Chronic dependence on mechanical ventilator code with Pneumonia, NOS and Respiratory failure (insufficiency) NOS, acute, but I’m getting the following cross check error when I try to check off the diagnosis box:" (link to this page): Patient has a chronic vent code and an acute respiratory failure, which should not be happening in same pt.
      • I think this is more of a “how do we want to code and report this” question than a cross check question. Do we want to be able to code chronic vent with acute failure in some circumstances? If so, what are those circumstances. Or are they so complicated that we just need to abandon this check?
    • AG REPLY --- I feel your pain. Since we DO want this crosscheck, the best solution is to remove the resp failure code here, and IF YOU WANT (not required) in it's place code the aspect of resp function that is now worse, e.g. Hypoxemia (hypoxia)
    Query check ICD10 duplicatesthe count is wrong, there wasn't a quick fix, so disabling the query for now. Ttenbergen 15:56, 2019 March 27 (CDT)
    Query check ICD10 mechanism vs traumaq_iatrogenic_trauma This is the query that is what is causing trouble with entries like fractures during CPR etc. For now the check makes no allowance for iatrogenics.
    Query check ICD10 only 1 stage of renal failureq

    According to our collection instructions for Admit Diagnosis and Comorbid Diagnosis, and the instructions for these codes (e.g. Chronic kidney disease (chronic renal insufficiency, uremia) Stage 1, GFR GT 90, the diagnoses could be coded as both an Admit Diagnosis and Comorbid Diagnosis. Right now this cross check prevents that.

    • Do we want to be able to code these as both admit and como?
    • Would both need to be the same code?
      • allow this duplication in different bins
    Query check long transfer delay
  • This would need to be considered as part of Eliminating distinction between different ward types.

    • Requiring notes to have content is really a very soft error check... do we need to consider something better?

    At the meeting about cross checks it was decided to change the cut-off to SD*3; will need to get that from Julie if we ever address the other questions.
    Query s ICD10 Chapter block dxsany other plans for these?
    Query s tmp Bording Loc sensible DtTm vs no borrow
    • This cross check had been disabled for Borrow Arrive because there were many errors: check was disabled in VBA with comment "2019-01-24 disabled for now because too many errors". I think we were concerned at the time because of high workload and fresh ICD10/CCI and didn't want to analyze and fix then. We will need to review what this should be to get an acceptable number of errors only.
      • Are we ready to have a cross check for this that requires either
        • no borrow and a checkbox and no time
        • at least one borrow location and a time
    Query s tmp Borrow sensible DtTm vs no borrow
    • This cross check does not seem to require a check box to send completed chart ** confirmed, check is disabled in VBA with comment "2019-01-24 disabled for now because too many errors". I think we were concerned at the time because of high workload and fresh ICD10/CCI and didn't want to analyze and fix then. We will need to review what this should be to get an acceptable number of errors only.
    Questioning data back to collectorsz
    • Possible future scenario: The data processor puts the concern into the Notes field and sets the RecordStatus field to "questioned". Next time the collector sends, the record is returned to the laptop by a series of queries. The collector updates the record, sets it to "complete" and sends it in with the next round of sends, at which time it will be processed like any other record.

    This process is more automated and would need to be validated before we could implement. It would be the least work for all involved, though, I think.

    We keep discussing this, talked about it again today. Ttenbergen 17:44, 2016 December 1 (CST)
    Questions
    R Filter Fieldmove into dx and eliminate this field
    ICD/CCI remove once old pt gone
    REDCapJust need a place to jot down some thoughts, need to clean them out later.
    Re-admission
    Reassessing Disparities in Access to Intensive Care Using a New Methodologyhow did we support this publication?
    Reconnect CFE and initial error checksre-name these so not PL any more
    Fix why it gives this error as part of fixing DSM process.
    Tina will fix Query check CCI must have entry so those are caught going forward.
    Recurrent seizures following cardiac surgery - risk factors and outcomeshow did we support this publication?
    Regional EPR AccessI emailed Joy Lyn Roxas to find out if regular accounts team and Acute care actually share these instructions; if not this might be our problem. Ttenbergen 16:52, 2019 April 17 (CDT)
    Removal of Foreign Body
    • Does this include removal of medical devices (ie. ureteric stent/prosthetic devices...)?Mlagadi 11:36, 2019 May 16 (CDT)
    Repeat clicks being needed when entering CCI PX Typeinvestigate and fix
    Reporting from ICD10/CCI
    • 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 CCMDB changes for the next version
    Requested TISS changes for the next versionWhat is the intended use of these reports?
    Resistance to antimicrobials, methicillin (anti-staph penicillins)
    • Julie, the above question specifically affects some projects you work with as well - do you think unifying this rule will be a problem for any of them?


    Also affected are :

    Does anyone think making this one rule for all will be a problem?

    Resource Use
    Resource Utilization After Survival From Critical Illnesshow did we support this publication?
    Risk factors associated with recurrent seizures following cardiac surgery
    Risk factors for seizures in cardiac surgery ICU Patients
    Room nrlegacy data
    S AP ChronicDx grouping
    S ICD10 APACHE Como patterns table
    S ICD10 APACHE Dx patterns tabledx 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 tableJust storing this here for now, it should really be integrated into the SMW like the Charlson and Apache ones. Generated by query CCMDB.accdb.s_ICD10_Chapter_block_pattern_wikimaker.
    S ICD10 Charlson Como patterns tableComo 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
    S TISS Report tableTISS: not really sure where and how this is used, will need to update
    S dispo chooser
  • is pre-populating the hospital filter with "local" helpful or not? I can take that out. Ttenbergen 21:50, 2016 March 24 (CDT)
  • S dispo.loc typeThis value is not yet encoded on the wiki as Property:Collection Location Location Type for locations that have their own article, but maybe it should be. Should it be? Ttenbergen 09:46, 2017 November 9 (CST)
    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 typeDo 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
    SAS Data Integrity ChecksNow 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)
    SOFA scoringZ) decided to revisit 6 months after ICD10
    STB ACCU Collection GuideThis section deals with old dx codes. If the section is still relevant, and still specific to STB ACCU, then pls update these to new dxs.
    STB B5If you check Definition of a Medicine Service admission is that still true? Ttenbergen 21:07, 2018 November 24 (CST)
    STB CICU Collection Guide
    • This detail should not be on the public wiki, so I moved Info to the CICU collector profile page for now as that is not public. Need to think more about were else this would better live in Private Wiki. Thanks for posting this info. Trish Ostryzniuk 11:19, 2019 February 27 (CST)
      • While the password protected wiki is relatively secure, I would prefer if this info did not live on a web based platform. Could we put a file on the regional server? Ttenbergen 19:16, 2019 March 9 (CST)


    STB Cardiac Care patientsCan you confirm new facts now that we are eliminating Registry Patient Type. (obviously this is a pretty old question...)
    STB E5Is that exception about radiology still true? Ttenbergen 21:03, 2018 November 24 (CST)
    STB E6
    • are you still running these? Ttenbergen 21:06, 2018 November 24 (CST)
    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)
    STB Medicine Collection Guide
    STB Medicine Workload splitting
    STB VAP CommitteeNo longer Lois, who goes now?
    Is this a committee that is basically convened when a local collector rings the alarm? Do you get invited to this? We should document this so that collectors covering can follow the same process, and also so other sites might be able to investigate similar opportunities. Ttenbergen 21:22, 2017 September 22 (CDT)
    STEMI
    • Will this still be relevant after ICD10? Will it still be relevant only to STB?
    Scanning Publications
    Scheduled TasksDo we still schedule Backup Checker?
    Searching the wikiThere are ongoing problems searching the wiki. Better search functionality would be nice
    planning to try ElasticSearch when I next update the wiki software via elastica or CirrusSearch - timeframe: next 2 months Ttenbergen 13:53, 2019 February 13 (CST)
    Seizures following cardiac surgery: the impact of tranexamic acid and other risk factorshow did we support this publication?
    Seizures following cardiac surgery: the impact of tranexamic acid and other risk factors (Abstract)how did we support this publication?
    Septic shock in chronic dialysis patients: clinical characteristics, antimicrobial therapy and mortalityhow did we support this publication?
    Serial numberhow about HSC EMIP and STB EMIP? Ttenbergen 16:29, 2016 March 14 (CDT)
    How much of the following is legacy? What is the current state? Ttenbergen 16:29, 2016 March 14 (CDT)
    Severe SepsisI 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)
    Severe sepsis
    • What is the definition of "organ failure" as it pertains to severe sepsis? For example, is an acute rise in Cr (AKI) enough to meet the definition or does the patient have to be on dialysis? Could we have some criteria for the failure of different organs? --Jvelasco 15:32, 2019 May 21 (CDT)
    • AG INFO: This is a very hard issue that everybody around the world is struggling with. The SEPSIS-3 guidelines operationalizes it by defining it as a certain rise in SOFA score from baseline. BUT it's not a very good clinical definition because obtaining the baseline sofa data is a lot of work. So I'll contemplate this.
    Severity of illnessWhat are the details?
    Is this average as in description or mean as in definition?
    Sharing Of information Survey Feb 8.13
    Standard error messages
    • Many of the error messages have been made more specific by now. If any need tweaking still please let me know. Ttenbergen 12:04, 2019 September 22 (CDT)
    Statistical AnalysisThis 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
    System resource exceededHerman, do we have an idea which versions would be the "working" vs "broken" ones?
    emailed Brandon to see if this might be possible to test.
    TISS Form (TISS28)
    TISS at 2300 Hours
    TISS28 Form Scanning
    • 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.


    _dev_TISS

    • Put the queries in a drop down list or accessible through a button in TISS.mdb, similar to way queries are set up in CFE. Trish Ostryzniuk 11:21, 2019 February 7 (CST)
    TISS28 backup and start.vbsDo you still use this? It is not linked, so as part of what process?
    Task Team Meeting - Rolling Agenda and Minutes 2019Actually, I think Julie decided to re-claim these from backups, no?
    Team Meeting December 14, 2016
    Team Meeting June 14, 2018
    Team Meeting November 29, 2018
    Team Meeting November 30, 2017
    Team Meeting September 22, 2016
    Temporary page to list dxs documented as requiring treatment to be coded
  • 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)
  • Testneeds troubleshooting
    The Accuracy of Administrative Data for Identifying the Presence and Timing of Admission to Intensive Care Units in a Canadian Provincehow did we support this publication?
    The ability to achieve complete revascularization is associated with improved in-hospital survival in cardiogenic shock due to myocardial infarction: Manitoba cardiogenic SHOCK Registry investigatorshow did we support this publication?
    Thyroid disorder, NOS
    • How to code a tumor that is on a specific organ but we don't have a DX code and the type of tumor is NYD (Example:thyroid tumor NYD) (see ICD10 collection#Regarding "Suspected" Diagnoses.)
      • I don’t understand what the new version would mean as a statement, so it might still need clarification. Ttenbergen 09:35, 2019 April 30 (CDT)
    Transfer Delay1q
    • This says it's only for survivors. Is that actually right, to exclude deceased pt? They were still delayed while alive so still "wasted" bed time. Excluding them may be inconsistent with our definition of Transfer Ready as the first time they are ready.
    Transfer Ready DtTm fieldwould need to be reconciled as part of Eliminating distinction between different ward types
    Transfer time rule
  • will we still want this now that we have Visit Admit DtTm field and will hopefully eventually move to using the EPR to glean arrive and dispo? Ttenbergen 17:06, 2016 May 25 (CDT)
    • deferring the question to after when Julie has done the new multiple encounter linking with Dispo. Ttenbergen 15:58, 2016 June 27 (CDT)
  • Transfusion of plateletsThere are conflicting and misleading instructions here. We might need to take out Template:CCI Collection Mode since this is a one-of. Same for Template:CCI Guideline Transfusions.
    Urgent CareOak ER has not been retired yet in s_dispo since it must be present until last pt who was admitted from there is off laptops. Will need to be cleaned up when that is the case.
    Utilization of intensive care unit beds in a Canadian populationhow did we support this publication?
    VIC S3
    • Tina this table is not consistent with the VIC MICU table above. which one do we want to keep? Trish Ostryzniuk 18:42, 2017 November 20 (CST)
      • what do you mean?
    Vacation and staff shortage collection prioritiesFor 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 DataThis 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.
    Value of postprocedural chest radiographs in the adult intensive care unithow did we support this publication?
    Variation in diagnostic testing in ICUs: a comparison of teaching and nonteaching hospitals in a regional systemhow did we support this publication?
    Ward admission log formsI think you really mean the EPR in general. We should probably review that page and the local ones since we use it rather more specifically now than when we first started. Actually, what we probably want is a page for EMR Web Reports. Or do we need specific pages for specific reports that we use, so we can link to them? Ttenbergen 16:11, 2019 May 17 (CDT)
    Which sites still use the ward logs?
    Wireless networking
    • Med Rec is mentioned both in "has wireless" and in "no wifi" - which is right?


    • HSC collectors: it looks like either wireless or tethered network connections are available everywhere now. Please write down here if you find places where you enter into your laptops where there is still no connectivity. Thanks!