Questions

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 325 questions on this wiki.

	Summary
"almost same patient" check	If we need this page at all it needs to be integrated better.
24 Hour Intensivist Presence: A Pilot Study of Effects on ICU Patients, Families, Doctors and Nurses	how did we support this publication?
A survival benefit of combination antibiotic therapy for serious infections associated with sepsis and septic shock is contingent only on the risk of death: a meta-analytic/meta-regression study	how did we support this publication?
ADL General Collection Information	What else in addition to ALERT Scale Calculation uses this?
ALERT Scale	need tie-it-together page.
APACHE Acute Diagnoses	need 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 Diagnoses	Dx 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 codes	Dx 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)
APACHE II Background	the link to this last article does not seem to work anymore.-- March 22.19)
AaDO2	I wonder if "null" is actually intended here, or if it was supposed to be 0. Ttenbergen 14:44, 2017 January 8 (CST) AaDO2 is null if there is no data for FIO2, PaO2 and PaCO2. However, no data was set to zero value instead of null. In addition, AaDO2 and the corresponding score are required only when FIO2 >= 50%, otherwise should be treated as null. (Similarly with PO2 score, it is required when FIO2 < 50% and otherwise should be treated as null. When FIO2 =0, both AaDO2 and its score and PO2 score should be null.) Are we setting null to zero to facilitate the programming calculation? Is it possible to differentiate null from valid zero in both L_LOG and created_variables_CC - will the work be big? In L_LOG, these are the FIO2, CO2, PO2 and SerCO2. 14:49, 2017 March 16 (CDT)
Acute Kidney Injury in Critically Ill Patients Infected With 2009 Pandemic Influenza A (H1N1): Report From a Canadian Province	how did we support this publication?
Acute kidney injury in septic shock: clinical outcomes and impact of duration of hypotension prior to initiation of antimicrobial therapy	how did we support this publication?
Adding a CCI or ICD10 entry in CFE	we need a better solution, I need to make that ID field populate automatically.
Admit Diagnosis	Charlson Admit Como - 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 centre	how did we support this publication?
Angiogram, coronary (diagnostic cardiac catheterization)
Angiogram, vein
Antibiotic Resistant Organism	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
ApLab Complete	Legacy field cleanup.
Automatic updating of MS Access Databases using scheduled tasks	I think PHI copy automation uses this. It might accomplish this in a different way...
Awaiting/delayed transfer to other care facility NOS	We probably don't need this code from a data use perspective (as confirmed by AG 2018-11-30) but we might need it for cross checks like Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days or similar; will keep this code until we have worked out if those checks will be possible.
Base Population for Research	This page is linked from the front page, so we should either make it good or get rid of that. Is there anything on Publications that would be a good example for how our DB was used for this?
Battery disposal	collectors, 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 borrow	we want to unify this concept; started discussion today Ttenbergen 14:33, 2019 April 9 (CDT) we want to unify this concept; started discussion today pre-admission bed borrow vs post-admission bed borrow (vs current Off ward field) also consider ECIP Ttenbergen 14:33, 2019 April 9 (CDT) also related is our old concept Moves for Medicine
Bed holds	Julie 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)
Bentall Procedure	Are these right? Or only the stenosis or insufficiency?
Biopsy (non-endoscopic)	What do you mean by diagnostic lavage? Does this term include aspirating fluid from joints or abscesses for C&S? - Michelle Lagadi
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 Data	I have made this page to document progress toward this import.
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)
CFE Data Integrity Checks	information that still needs to be integrated Pre-linking checks Quality Assurance queries in CFE
CRRT	Would it make sense (e.g. are the stickers of a size where this is possible) to give the nephrologists stickers so they can attach them as needed? Ttenbergen 15:14, 2018 September 21 (CDT) Is there any follow-up as far as the end date of this project, given the lack of compliance with the stickers? --Jvelasco 14:29, 2019 March 29 (CDT) Not as far as I know. Maybe Allan can find out from them? AG emailed Nephrology for follow up. Ttenbergen 14:52, 2019 April 17 (CDT)
CTE	CTU vs NTU
CXR count cross check	needs to be implemented but not strictly needed for go-live
Can't check ICD10 ARF vs APACHE ARF	definition is changing so it might become possible soon to cross-check this.
Cardiac arrest	red links. Linking this article to two old articles. Trish Ostryzniuk 15:25, 2018 December 24 (CST) where? Ttenbergen 20:58, 2018 December 27 (CST)
Cardiac/cardiovascular drug NOS, adverse effect	Is this the code we use for Amiodarone lung? --LKolesar 14:15, 2019 January 23 (CST) nope, as listed on old dx Amiodarone Lung and in Interstitial lung disease, drug-induced (acute or chronic), use Interstitial lung disease, drug-induced (acute or chronic). Please delete the comment once you have reviewed it.Ttenbergen 09:38, 2019 January 24 (CST)
Centralized data front end.accdb	Still has old name, need to update. Also, isn't really documented here yet
Centralized data front end.accdb Change Request	Postal Code vs Pre-acute Linked pairs, better storage 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 clean up the form (whatever that meant) add button for link suspect queries to patient list update Correcting suspect links
Change Priorities	is 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 Transfer	how did we support this publication?
Charlson Comorbid Score query	the query needs to be cleared out of CFE once we are done. Possibly sooner, I sort of doubt it is used.
Charlson Comorbidity scoring in ICD10 codes	Can you have a look at this page and the queries/tables it describes to see if it makes sense?
Chart Review Lists	This is linked from the front page and intended to give an idea of how one could use our data. Is there anything on Publications that would be a good example for how our DB was used for this? If not, should we take it out? With nothing here it doesn't look very good coming from front page.
Check CRF vs ARF across multiple encounters	I think this section is largely old rules that no longer apply with how we define Comorbid Diagnosis now, ie if something was clearly present before admission we can now code it, even if it had not been diagnosed. Are any of these still required, with that in mind? Ttenbergen 21:17, 2018 October 26 (CDT) 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) 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. Or the transition is on the next ICU or ward stay? Ex. the first stay is ICU and diagnosed with ARF. then patient was transferred in a ward of same or diff hospital - is he now a chronic renal patient? The data collection instructions are in the related pages, and additional info is in Renal Coding Considerations for ICD10, but they are a beast of a network of concepts. Those might tell you how we currently propose to collect the renal codes, but not necessarily what you or the users of the data would want. Usually these cross checks would be driven by what you need for data requests, so do our proposed instructions line up with how you want to use this? Or is this maybe too case-by-case of a concept to even make a cross check? Ttenbergen 18:59, 2019 January 6 (CST)
Check ICD10 some cant be primary	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.
Check Inf Potential Infection must have pathogen or alt combined code	This would cause extra collection work, since there are quite a few potential infections (most of the NOS codes are potential infections), and a lot of them would not usually be infections. Do we really want to do this or can we decline it?
Check TISS Intubation consistent	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 encounter	We decided that VAP can actually happen in medicine if pt admitted from ICU. How would we deal with that for this check?
Check drugs vs TISS	Have all info now, Allan confirmed drug list. Once implemented let Julie know so she can not do this in SAS any longer
Check dx implying death across encounters	Need to update the definition for this and implement once we have Deceased patients figured out. I have left a link there to remember.
Check dx implying death must be dispo deceased	Started to build query but not applied yet; see discussion in Deceased patients.
Check organ donors must be dead	Might not be able to check this for organ donors, but Sudden cardiac death (and died) should always have a Dispo=dead... do we want or need a check for that? Are there other things like it? pls refer to comment on Check dx implying death across encounters. If we would like to check organ donors in admit diagnosis to have disposition=died, then the admit diagnosis must also have any of the Brain death,Sudden cardiac death (and died) and Medical Assistance In Dying codes. In this way the live organ donor will be excluded in the rule. --JMojica 16:32, 2018 November 15 (CST) I don't understand what you are saying there. This check is for CCMDB.mdb, ie not across encounters. With that in mind, do you agree that the check is not possible to do in CCMDB, ie the check on this page is not feasible. The other checks Check dx implying death across encounters and Check dx implying death must be dispo deceased can still be done. Ttenbergen 00:37, 2018 November 19 (CST)
Check pre acute consistent	what exactly do we want to check for? Please also have a look at the stuff below that doesn't specifically have your name. This requested check ties into a bunch of things and if we want the check we need to be sure that instructions stay consistent and lose ends are tied up. 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. How does Chronic Health Facility fit into this? 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 if Previous Location field ='Home' then Pre acute living situation field is either Apartment, Assisted Living,Supportive Housing,Prison / Jail / Correctional Institution or House; otherwise Error. if Previous Location field = 'Deer Lodge' or 'Riverview' or 'St Amant' then Pre acute living situation field = Chronic Health Facility; otherwise Error. if Previous Location field = 'any PCH location' then Pre acute living situation field = Personal Care Home; otherwise Error. ... 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. Need to look at the PCH Postal code data. It may be relevant to this check that we have ICD10 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 Health APACHE	Dx grouping AG REPLY -- Tina I don't know what the question is here. just flagging it to sort with the others so we can deal with it when we address them.
Chronic kidney disease (chronic renal insufficiency, uremia) Stage 1	q Tina, Could you please add the GFR ranges to each stage in the ICD10 diagnosis? This would make it simpler, rather than trying to memorize each stage or having to look it up every time. thanks in advance! Lisa Kaita 14:00, 2019 February 4 (CST) Will do, I have put it into the pipe.
Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5	How do you code patients with ESRD,who are being worked up for HD, and they present with "acute on chronic RF"? I used Kidney, acute renal failure NOS in admits, Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5 in comorbs, and HD in acquired CCI's. However, I'm getting an error with the APACHE ARF if I put "yes", because of the chronic RF code in comorbs. How should these types of patients be coded, so we are all doing it consistently? --Jvelasco 10:18, 2019 February 7 (CST) AG REPLY -- if you have Stage 5 CRF, even if not yet on dialysis, you CANNOT get any sort of acute renal failure unless you have had a renal transplant. Thus you situation is not really acute on chronic renal failure. If the Stage 5 was existing before admission, i.e. based on a prior creat clearance<15 mL/min, then it should be a comorb even if not prev dialyed. The acute admission then is going to be for either: (i) something such as hyperkalemia or fluid overload or uremia etc, i.e. a complication of the ESRD OR if they REALLY are being admitted for the Stage 5 (e.g. to install an A-V fistula in their arm and a Vascath), then the Stage 5 CRF should ALSO be an admit dx.
Chronic kidney disease, NOS (stage unspecified)	q Tina, could we please have the words kidney and renal in all of the kidney codes (ie.renal/kidney)? This code will not come up when you search the word "renal". Allan, any concerns if I rename this to "Chronic renal disease, NOS (stage unspecified)", or if I rename all of them to renal/kidney? Ttenbergen 16:34, 2019 January 21 (CST) Allan had no concerns, need to implement. Ttenbergen 22:17, 2019 February 5 (CST)
Cleaning up a failed send	How do you figure out why it happened? What are likely scenarios here? Is this related to Procedure when there are differences between L Log and L PHI or Orphans in Centralized data.mdb?
Clinically significant gastrointestinal bleeding in critically ill patients in an era of stress prophylaxis	how did we support this publication?
Collection Location Service Type	What is CTE? I am adding it for now because not having it is breaking SMW, but we really should not have it here if it isn't defined.
Colonized with organism (not infected)	make sure this is consistent with Lab and culture reports Are all of these actually things that can colonize without infection? We should only list those here that can. I started adding in links but then decided to hold off in case a lot of them drop off this list. Ttenbergen 15:34, 2018 November 28 (CST)
Comfort Care	There had been a reference that this could stop when ICD10 comes. Why was that? Is it because we will start collecting Palliative care? Because that is not really the same definition... We will need to update a the reference to this in Palliative_care#This_code_vs_Comfort_Care once decided.
Community Nursing Home Location Helper
Community-acquired pneumonia (CAP) in ICD10	What does that even mean, since we don't have a code for CAP?
Comorbid Diagnosis	Charlson Admit Como - 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 Centers	how did we support this publication?
Comparison of ICU Investigation Patterns & Costs in Two Urban Centers	how 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 research	how did we support this publication?
Continuous Stay	need to integrate Julie's definition pasted here into this page
Controlling Dx Type for ICD10 codes	not needed at go-live; Need to export the list and plan process that includes the extra items below. To export, see S_ICD10_table#Query_to_populate_s_ICD10_table_from_wiki. Charlson Admit Como - this is part of that 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) Ignore until at least April.
Conversion from our old diagnosis schema to ICD10/CCI	transition plan to CCI/ICD10 details... need to confirm this is documented, as in tied together and interlinked from relevant places
Correcting suspect links	update when the button has been added: When done, click the ... button to confirm all link_suspects queries are clean.
Crash TISS MDB	TISS28 Form Scanning doesn't have a step for run reports... is this still a thing?
Critical Care Vital Signs Monitoring	It says that CCVSM is in Quarterly report. If CCVSM is no longer, is it still in quarterly?
Critical Care and Medicine Database Core Curriculum	How 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)
DA	{{{1}}}
DSM Lab Extract
DT	{{{1}}}
Data Collector Portal	How 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 Processor	leave 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	Is there other stuff in there? This page is likely only worth keeping if it is linked from Critical Care and Medicine Database Core Curriculum, and before that it should get good content. Should we make it good or get rid of it?
Data dictionary	something went wrong with this query and it has no data Attempt at a easier to follow data dictionary. Is this what you had in mind? Yes, this is what I have in mind. Thanks. Some suggestions: I just notice some start dates are not the actual start dates - It is important for the users to know how far back the data are available so they can decide the covered period of their study. is it possible to change the date to actual earliest collection start date (not 1 Jan 1900). --JMojica 10:05, 2019 January 3 (CST) The start and end dates are stored on the individual pages. If the list shows 1900 then they were not filled in. If you know what they are and fill them in then this page will list them. I can also change the default if-not-filled value in templates to something other than 1900-01-01. I just needed a value for ranges and filters to work. Ttenbergen 14:49, 2019 January 3 (CST) add a column for program (Critical care only or Medicine only or both). I can do that, but the table is already getting quite wide for a web page. Can we lose any of the columns we currently have? The info you mean is always visible in the pages themselves as well, in case that's sufficient. But, yes, we can tweak what the tables should show. It is done in Template:DataDictionaryQuery (details visible once you edit it...) and removing fields would be easy enough. I can show you how to add fields. Or I can add them once we confirm what we want. Tina has changed the ICD10 and CCI templates to use a startdate of 2019-01-01 and will change other default dates as I receive dates Julie wants me to use.
Deceased patients	1 Julie asks: how to add a code for palliative care/ comfort care at discharge and/or change dx palliative service. Correcting suspect links also needs to be dealt with when this is done. And needs to be documented. once addressed we need to change Check dx implying death must be dispo deceased Is that really what we want? It will give occupancy but miss actual time of death.
Definition of an ICU admission	Thus, a new database record will be created if a patient changes service, even if they don't physically change location.
Differences Between Intensive Care Unit Admissions Located In Rural And Urban Hospitals In A Canadian Population	how did we support this publication?
Direct Data Access for RIS/PACS	Should we pursue this now? Where would it be on our priorities? It might be related to CCI coding. foo
Discharge Register	The following needs clarification, I don't have a report in front of me, how would a new collector read which of these are EMIPs and which not? Emailed Laura Ttenbergen 16:53, 2019 January 3 (CST) is this just available for STB or is this how GRACE and HSC can find in EPR?Trish Ostryzniuk 18:01, 2019 January 3 (CST) I would think that all the hospitals have this because it is just a demographic issue and I believe that everyone has access to this, just get them to test it in other centers to make sure.--LKolesar 07:56, 2019 January 4 (CST)
Discuss	not summarized
DiscussSteering
DiscussTask	{{{1}}}
Distinct Determinants of Short-term and Long-term Mortality After Critical Illness	how 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.
EMIP
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 Shock	how did we support this publication?
Early combination antibiotic therapy yields improved survival compared with monotherapy in septic shock: a propensity-matched analysis	how did we support this publication?
Early intravenous unfractionated heparin and mortality in septic shock	how did we support this publication?
Effects of a Resource Mangement System on ICU Laboratory Utilization	how did we support this publication?
Effects on patients, physicians and families of 24 hour, on-site intensivist coverage in academic and community ICU care	how did we support this publication?
Eliminating a diagnosis from collection
Eliminating distinction between different ward types	any 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
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...
Ethical and practical considerations of withdrawal of treatment in the Intensive Care Unit	how did we support this publication?
External Files
Facilitated Management of Serial numbers
FinalCheck field
FirstName field	under #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.mdb	Pagasa will test the quicker way, and if satisfied, will clean out the two old methods.
Flagging for TISS
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 Medicine Collection Guide	CTU vs NTU
Gender Differences in Intensive Care Utilization	how did we support this publication?
General Collection Practices	I 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 Guidelines	I 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
H1N1	seems 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 CAU	OK, 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 IICU	physical location will move from JJ to GA7, Date:? expanded to 8 beds, Date: ?
HSC IICU Collection Guide	Is this still relevant after workload redistribution? Ttenbergen 11:47, 2015 May 20 (CDT) And is this how you want it?
HSC Med nonteaching contingency beds	enter 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 SICU	who is unit clerk?
Health Care Utilization Before and After Intensive Care Unit Admission in Rheumatoid Arthritis	how did we support this publication?
Health Sciences Center Office
Heart transplant, failure or rejection or unspecified complication	is the following actually specfic to heart transplants? If not, it should be moved into Template:ICD10 Guideline Transplant so it will show in all the transplant failure pages.
Height and weight	Z) 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 Illness	how did we support this publication?
High dose chemotherapy as primary admit	This 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 care	how did we support this publication?
Hospitalization in Winnipeg, Canada due to Occupational Disease: A Pilot Study	I 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?
Hypertension, malignant	I would like to submit the following definition for peer review and discussion for Malignant Hypertension. Malignant Hypertension is extremely high blood pressure that develops rapidly and causes some type of organ damage. "Normal" blood pressure is <140/90. A person with Malignant Hypertension has a BP typically >180/120 --mvpenner 11:02, 2015 April 15 (CDT) had a brief look at https://en.wikipedia.org/wiki/Hypertensive_emergency and it looks like additional things need to be present to define as hypertension. would you be OK if we just linked to there as we do fro many articles? Ttenbergen 15:27, 2015 April 15 (CDT) Thank you!--mvpenner 06:04, 2015 April 16 (CDT) Does that mean you agree that adding a link would be a solution/improvement? Ttenbergen 17:39, 2015 April 16 (CDT) Thank Tina. I agree with posting the link, but also see benifit in having a brief summary in the definitions.--mvpenner 07:56, 2015 April 20 (CDT) Sure, but it needs to include all the relevant parts. From reading the wikipedia entry I didn't think the one you proposed would. Could someone more medical weigh in? I am just looking at it from a consistency angle... Ttenbergen 13:55, 2015 April 20 (CDT)
ICD/CCI remove once old pt gone	ICD/CCI remove once old pt gone 1
ICD10 Diagnoses and CCI Codes that need to be coded together	unmaintainable. emailed Trish to see if she is ok with us taking this out. Ttenbergen 12:05, 2019 February 1 (CST)
ICD10 Dx sorting issues	What 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 Admit	Charlson Admit Como - this is part of that discussion - if we limit which admits will count as comos we need to review
ICU Var 6 - AMA	Did we transition the following into tmp or otherwise? Ttenbergen 13:58, 2017 June 6 (CDT) If we did not then this question can just be removed, but if we did move this elsewhere we should explain where to.
ID cards	This 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.
Identifying ICU admissions	multiple 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) Con suing EPR Reports to generate transfer, admit and discharges to ID ICU admits?Trish Ostryzniuk 11:37, 2016 May 20 (CDT) what are those plans? Are we still planning to? Ttenbergen 09:31, 2016 November 10 (CST) I suspect not, since that would bring us back to the problems we had with Moves for Medicine. Then again, Project Borrow arrive does part of it. Ttenbergen 07:48, 2019 April 9 (CDT)
Increased Incidence of Critical Illness Among Patients with Inflammatory Bowel Disease: a Population-based Study	how did we support this publication?
Initiation of Inappropriate Antimicrobial Therapy Results in a Fivefold Reduction of Survival in Human Septic Shock	how did we support this publication?
Instructions for importing a batch of DSM Data	1 I have to make/fix a connector module for this. There is a newly found and new added query for each; why are there two and can I delete one set?
Instructions for requesting a batch of data from DSM	1 I have to make/fix a connector module for this.
Intensive Care Unit admission following successful cardiopulmonary resuscitation: resource utilization, functional status and long term survival	how did we support this publication?
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 table	z 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)
LOS	this article has evil twins, need to reconcile, search for LOS Ttenbergen 21:13, 2014 October 23 (CDT) Are LOS Medicine per hospital admission and LOS Medicine per ward stay evil twins of one of the below? If so pls move the link under that section.Ttenbergen 15:34, 2016 April 18 (CDT)
LOS Medicine per hospital admission	this still talks about TMSX... what is the new status of this field? I think you made several of these at some point. Did we do anything even categorize them? If we annotate them right we can include them in the Data dictionary ...
Lab Collection Process
Lab and culture reports	you wanted to remove stuff from here that's already in the infection guidelines instead.
LastName field	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?
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.mdb	Why 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–10	how did we support this publication?
Medworxx
Minutes Team Meeting October 1, 2014
Mortality and readmission report
Non-standard ICD10 Diagnoses	Dx 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	Do you use diagnosis information before patients are complete, e.g. Primary Admit Diagnosis? Yes, I use the primary diagnosis for the reason of readmission even if the record status is incomplete. --JMojica 09:07, 2018 December 6 (CST)
Object with variable error
Off ward field	Current 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...)
Organ donor (organ/tissue donation by the donor)	What date in the Acquired Diagnosis do you put for this code? Do you use the date that they decide the pt will be an organ donor? Or would you prefer the date the patient goes to the OR (which would be the same as the discharge date? These patients go to a different ward after transplant, right? So we would likely not currently track the CCI for this. Maybe transplants are something we should track if they are at the end of stay. I'll flag this for Allan. I am referring to an organ donor (not a transplant recipient). Most donors go to the morgue after donating their organs in the OR. I am not asking about CCI, just the date for the acquire ICD10 code. I am not sure who wrote the above comment.
Out of Memory Error
Outreach efforts
PHI Loader.accdb	Don't know what to solution is yet as Tina hot sure why to problem is occurring.>
PHI.mdb
PHIA policy
PL Chart 9 Digit	Function Validate Chart should capture all of these in CCMDB.mdb. 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. I did end up checking Function Validate Chart 2018-11-24 to confirm that the check >8 digits is being run. If there are others problems that slip through please log them as DT at Function Validate Chart
PL SamePHIN Site Diff chart	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 content	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.mdb 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 Planning	That 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) There are a lot of details. Which need to come over to one of the pages in Category: Awaiting/delayed transfer? Ttenbergen 14:51, 2018 September 6 (CDT)
Past history, transplanted kidney	Tina will ensure that the error trapping in place allows an individual to have ESRD as a comorbid and AKI in the same record only if the person also has a CCI code for the kidney transplant OR has the ICD10 code of Past history, transplanted kidney.
Patient copier button
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.
Pharm Flow Complete	legacy data field
Pneumonia, ventilator-associated (VAP)	where is that list of sources, did it get lost in an edit?
Postoperative laboratory and imaging investigations in intensive care units following coronary artery bypass grafting: A comparison of two Canadian hospitals	how did we support this publication?
Potential Change
Pre op Admit-Cardiovasc Patient	This is not coded under ICD10 or CCI. Do we report this, and therefore need to accommodate otherwise, or how will we treat this? We have Preparatory care (incl preop optimization) but that doesn't capture the full concept. Ttenbergen 22:45, 2018 November 27 (CST)
Pre-2017-07-30 Overstay Predictor Project Collection Instructions
Pre-OP Admit - Research Patient - Cardiovascular	This is not coded under ICD10 or CCI. Do we report this, and therefore need to accommodate otherwise, or how will we treat this? We have Preparatory care (incl preop optimization) but that doesn't capture the full concept. Ttenbergen 22:45, 2018 November 27 (CST)
Pre-linking checks	not 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	"We are aware that this may affect categorization under APACHE II but will collect like this for now. This will need to be dealt with when we move to ICD10." - Julie, I don't know what this comment is about, I just came across it when cleaning out things we need to take care of in going to ICD10. I can't think of what we would need to take care of here, if you can't either please take the comment out.
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. I updated Query L_Dxs_w_primary and query Primary_Admit to exclude all records of patients with Dispo DtTm > 2019-01-01
Printer
Procedure when there are differences between L Log and L PHI	Why, what does that tell you? The only way I can imagine this would happen is if the record was deleted in centralized L_Log. In that case, if you are lucky and there is still a ccmdb_data with the completed/sent record, you can follow the Re-sending data process. If not, find it in a previous version of Centralized data.mdb, print or write down all data for the record, and manually re-enter it in a CCMDB.mdb and follow the Re-sending data process. Or what do you do? Ttenbergen 21:38, 2019 February 6 (CST)
Processing errors in patient data	It is not really clear what the steps are for Link suspect negative transit time query in regards to checking and correcting between EPR and Centralized Data. --Srusnak 17:32, 2017 January 5 (CST) 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 arrive	did they ever get back to us?
Proposed Notes field default
QA Infection VAP	will we still need to collect this in ICD10, since I think all the data now lives in the dx codes as well. I am holding off on implementing Query s tmp QAInf tmp no dx until resolved. same reply as in QA CLI. --JMojica 12:04, 2018 December 27 (CST)
QA Septic Shock	Is "Every entry for project QA Septic must have either a date or a time." a request for a cross check? or does that check exist already?
Query NDC CLI AcqDX but NoCLI DateinTMPV2	ICD/CCI remove once old pt gone
Query NDC CLI No AcqDX but CLI DateinTMPV2	ICD/CCI remove once old pt gone
Query NDC CLI unacceptable date	ICD/CCI remove once old pt gone
Query NDC CLI vs DX but no TISS17 CentralLine	ICD/CCI remove once old pt gone
Query NDC DSM Unmatched records	This part of the cross-check is now well understood and ready to program. What proportion do we expect for (1) false positive as opposed to (2++) actual errors? What proportion do we have in old data of pt without labs. Would this number of dead ends be too high to bother for Pagasa to have to check all of these?
Query NDC VAP AcqDX but NoVAP DateinTMPV2	ICD/CCI remove once old pt gone
Query NDC VAP No AcqDX but VAP DateinTMPV2	ICD/CCI remove once old pt gone
Query NDC VAP no TISS	FYI Maybe Pneumonia,_ventilator-associated_(VAP)#VAPs_on_medicine_wards mentions to use the same rules as for other Acquired Diagnoses, ie the dx is acquired where it first manifests, so this check or rule no longer makes sense. If you are OK with this, please take this note out, else pls comment here.
Query NDC VAP unacceptable date	ICD/CCI remove once old pt gone
Query NDC zCRRT CCI Px but no TISS	ICD/CCI remove once old pt gone
Query NDC zCRRT TISS but no CCI Px	ICD/CCI remove once old pt gone
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)
Query TISS Errors NrTISSDays NE LOS	Tina to break out this standard check information to a different page to link to... and clean up duplication
Query TISS Errors missing days	which report/s are these actually included in?
Query check CCI must have entry	Patients 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 vs AP ARF	some of these give false positives for transplants, review what's up.
Query check ICD10 ESRD vs ARF	some of these give false positives for transplants, review what's up.
Query check ICD10 duplicates	the count is wrong, there wasn't a quick fix, so disabling the query for now. Ttenbergen 15:56, 2019 March 27 (CDT)
Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days	There are transfer ready reasons that would not result in an awaiting code. These resulted in false positives. If we want to check for date diff but no awaiting code we will need to enumerate these reasons, and all need to be present in data. I will put aside this half of the query until we address that. Details in wiki page.
Query check ICD10 only 1 stage of renal failure	pt could have several stages during acquired, right? Is that how we would want to code deterioration? AG REPLY -- not really. While one could have a lower level as a comorbid, and be admitted with what is finally decided to be an advancement of CRF (so that an admit dx is a higher level), in many cases what you'll have is some degree of CRF + an AKI on top of it. It's important to distinguish between these. Emailed Michelle to find out if that is how she would have understood it as a renal-focused collector. Ttenbergen 08:25, 2019 January 24 (CST) M said it made sense.
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?
Query s ICD10 Chapter block dxs	any other plans for these?
Questioning data back to collectors	z 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 Field	move into dx and eliminate this field ICD/CCI remove once old pt gone
Readmission Rate to ICU	Is this the same as Re-admission? Ttenbergen 12:03, 2017 July 5 (CDT) similar but specific with ICU. I will do a separate one for Med and delete the Re-admission after.
Reassessing Disparities in Access to Intensive Care Using a New Methodology	how did we support this publication?
Reconnect CFE and initial error checks	re-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 outcomes	how did we support this publication?
Regional EPR Access	I 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)
Repeat clicks being needed when entering CCI PX Type	investigate 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 version	What 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? What is the attribution rule for our program on MRSA colonization? For example if a patient comes from SOGH ICU to the Concordia and tests positive for MRSA in less than 24 hours I would attribute this colonization to the SOGH not the Concordia. Is that correct? If we will have such a rule at all, could it be one that applies to infections in general and would therefore live in Template: ICD10 Guideline Infection. Also, we would want to make sure that "attribution" as a concept doesn't get muddled - if we search for that there are several hits, and we use other terms like "gets credit" elsewhere I believe. And in Lab and culture reports... Allan confirmed that all the attributions should be the same and can be moved into that infection template. Ttenbergen 14:09, 2018 October 29 (CDT) This will mean that I pull the 48hr rule out of the following and instead put it into Template:ICD10 Guideline Infection that is applied to all infections, and/or Infections in ICD10 which is referenced by the template: Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI) Pneumonia, ventilator-associated (VAP) CAP-Community Acquired Pneumonia HAP-Hospital Acquired Pneumonia Iatrogenic, infection, urinary catheter there may be others dx right now that my search for 48 did not find because maybe they use a 12 hr or 17 hour... rule. Collectors, can you think of any? Ttenbergen 23:10, 2018 October 30 (CDT) Also affected are : QA Infection CLI Does anyone think making this one rule for all will be a problem?
Resource Use
Resource Utilization After Survival From Critical Illness	how did we support this publication?
Risk factors associated with recurrent seizures following cardiac surgery
Risk factors for seizures in cardiac surgery ICU Patients
River Ridge Transition Care Environment
Room nr	legacy data
S AP Chronic	Dx grouping
S ICD10 APACHE Como patterns table
S ICD10 APACHE Dx patterns table	dx grouping if you have a reference, ideally online, for what you used to make the APACHE comorbid ranges, please add it here. AG NOTE TO SELF -- you have to go through and confirm the ICD10/CCI codes to automatically code for the AP2 comorbs
S ICD10 Chapter block pattern table	Just storing this here for now, it should really be integrated into the SMW like the Charlson and Apache ones. Generated by query CCMDB.mdb.s_ICD10_Chapter_block_pattern_wikimaker.
S ICD10 Charlson Como patterns table	Charlson Admit Como - 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. AG needs to be reminded to deal with this around June 2019
S ICD10 table	There is a field "ICD10_ID" which is legacy and won't be used. Planned to remove in next version, leaving for now to have one less moving part during a data update. Ttenbergen 17:06, 2018 April 3 (CDT)
S TISS Report table	TISS: 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 type	This 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 type	Do you know what is the description? Especially in contrast to S dispo.loc_type. How do you use this? Please put the answer in the element_description above
SAS Data Integrity Checks	Now that we have a structure for cross-checks we should add those you do in SAS to here as well, using the same structure as for those listed in Data Integrity Checks Ttenbergen 20:46, 2018 October 26 (CDT)
SOFA scoring	Z) decided to revisit 6 months after ICD10
STB ACCU Collection Guide	This 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 B5	If 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 patients	Can you confirm new facts now that we are eliminating Registry Patient Type. (obviously this is a pretty old question...)
STB E5	Is 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 Committee	No 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?
Sandy Kroeger	what is the successor page where the instructions for setting up an account are actually given? Maybe Regional EPR Access for EPR, but how about regular account?
Scanning Publications
Scanning to network	Discussed with Pagasa to test scanning larger volume to make this smudge problem show up, but then giving the scanner ~15 minutes to cool down without cleaning it to test if this is really an overheating issue. Waiting to hear back. PTorres 09:49, 2019 February 11 (CST) Pagasa confirms that this is an issue only with larger batches, and that the problem goes away on its own when the scanner has had time to cool down. When a larger batch is scanned, the first few pages are OK, and then the line starts to show up. Pagasa will follow up with the printer people at eHealth about this.
Scheduled Tasks	Do we still schedule Backup Checker?
Searching the wiki	There 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 factors	how 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 mortality	how did we support this publication?
Serial number	how 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 Sepsis	I don't think this was ever implemented, can't find any evidence of it. Do we need it? Ttenbergen 11:04, 2018 September 25 (CDT)
Sex field	If EPR stores current, and a lot of our data comes only from EPR or chart, then for any patients where we don't have a previous, recognizable encounter, we may not be storing their sex assigned at birth even now. Is this true? If so, do we want to change how we treat this field as a result?
Sharing Of information Survey Feb 8.13
Standard error messages	more informative error messages requested
Start Date field
Start Time field
Statistical Analysis	This article will likely be one of the more common landing points for external users. What do we want to tell them? Do we have any project articles we want to link in that especially highlight what we can do? ALERT Scale?Ttenbergen 22:50, 2017 June 7 (CDT)
StatusReport.bat
System resource exceeded	Query tweaked and wifi disabled; let's see if this does it. Ttenbergen 13:20, 2019 March 13 (CDT) As of Wednesday Apr 17 is this still a problem? Ttenbergen
TISS Form (TISS28)
TISS at 2300 Hours
TISS28 Form Scanning	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) 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
TISS28 backup and start.vbs	Do you still use this? It is not linked, so as part of what process?
TISS28 data and collection problems
TISS28 form images	Dec 31.18 - noticed that digital images of scanned TISS forms in Teleform are no longer being stored anywhere. (screen shot as per email sent on this date) ----Trish Jan 4.18 - Tina just had a look at this with Trish, and I think that error is one of those misleading ones. It turns out the image files are not actually being stored after processing. They used to be, and we need them to be, because we regularly refer back to them. Having an electronic version is why we are able to destroy the paper forms, so we need these. I assume there is a setting in Teleform where you set whether to keep data after processing, and where to keep it. Could you have a look?---Tina Trish to remind Herman/Tina in few weeks to look at this. For now, paper forms from scan batch one onward, will be kept on file until in office.Trish Ostryzniuk 13:55, 2019 January 3 (CST) We could keep these forms in paper (we are storing paper and have an exception to the normal process), or scan them and store them in a third folder under "x:\TISS28\ExportData" (extra work). I'll leave this to Trish and Pagasa.
Task Team Meeting - Rolling Agenda and Minutes 2019	Charlson Admit Como - I have put several related pages on your list that start with the same words as this one. We need to update them to make sense with any change to this. Some still had other questions in them anyway. AG REPLY --- tina and ag to go through all the separate ICD10 codes Charlson Comorbidities in ICD10 codes that make up the 17 Charlson conditions and one by one decide if they can be included in Charlson EVEN IF they're admit or acquired diagnoses. pls have a look at Deceased_patients#organ_donor - we need to address which time to use for death in this case - actual time of death, or time they left the unit? Set a time with Julie to address these
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?
The ALERT scale: an observational study of early prediction of adverse hospital outcome for medical patients	how did we support this publication?
The Accuracy of Administrative Data for Identifying the Presence and Timing of Admission to Intensive Care Units in a Canadian Province	how 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 investigators	how did we support this publication?
Thyroid disorder, NOS	can we use this code for THYROID tumor NYD ? and then if yes can we use all disorder,NOS in replacement for NYD not yet diagnosed tumors? SKiesman 13:10, 2018 March 29 (CDT) see ICD10 collection#Regarding "Suspected" Diagnoses.
Tracheostomy care	I think this code should be removed. Coding Tracheostomy, has one, would be sufficient and this would imply that Tracheostomy care is done. Main office doing checks on data and we can see that there is no consistency and both are not always coded. Trish Ostryzniuk 14:59, 2019 March 8 (CST) AG REPLY: An excellent point. I agree that we should delete it. The only thing we lose is the ability to identify if trach care is the reason for admission -- which happens very rarely. Regarding the related question below, unless somebody is specifically asking for info on trach changes, I don't think it's a big issue to code those at all.
Tracheostomy, has one	This code could be used as an admit code if the patient is a transfer from another ICU. For example, the patient was in ICMS and there had a trach created, later, the patient was transferred to ICCS. The data collector there will have "tracheostomy, has one" in her admit codes. She would not put it in her comorbids. Our integrity checks do not allow this it seems. How do you want to resolve this? --LKolesar 11:36, 2019 April 12
Transfer Ready DtTm field	would 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) with transfer tracker gone, what will be the official instructions for this? Ttenbergen 16:36, 2017 June 21 (CDT)
Transfer-for Organ Transplantation	Do we use this in a specific report? If not we should probably consider dropping it, it's an odd thing to collect.Ttenbergen 23:00, 2012 December 12 (EST) we have 12 in ICU database to date. 2 coded in 2011 and 1 in 2010......rest random back to 1994. Julie, do you use this? Do we need to do anything about this DX? A counterpart does not exist in ICD10. Ttenbergen 19:49, 2018 November 27 (CST)
Transition to Database Server	Julie, can you confirm that SAS would be able to connect to an MS SQL Server via ODBC? Ttenbergen 22:02, 2018 March 14 (CDT) You were going to follow up with the new CHI person to make sure they are aware.
Transitional Care	Is this part of any reports? Ttenbergen 10:03, 2017 November 9 (CST)
Utilization of intensive care unit beds in a Canadian population	how 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 priorities	For coverage on the medicine ward isn't the overstay project the priority and not the discharges. Are we not trying to generate a color on admissions as soon as possible to identify reds and letting managers know as soon as possible? GHall 11:51, 2017 August 14 (CDT)
Validation against Patient Registry Data	This page was started long ago to keep track of our attempt to get access to the registry. I think it would be good to re-convene on it so we have a central point where past efforts and current efforts can be tracked. That would also make it easier to take it to task or steering and have consistent info. Do you have a log of this somewhere? We can rename it if you want.
Value of postprocedural chest radiographs in the adult intensive care unit	how did we support this publication?
Variation in diagnostic testing in ICUs: a comparison of teaching and nonteaching hospitals in a regional system	how did we support this publication?
Ward admission log forms	guys is it serial number used that you note on ward logs?-Trish Ostryzniuk 17:11, 2012 October 19 (CDT) the former or the latter live in the binders for some time? and then where do they go? Or is that in their own article, in which case just link there... Ttenbergen 00:03, 2012 October 31 (EDT)
Wireless networking	NB: most areas require a re-boot to wireless system when moving through the site areas. Is this still true with Windows 10? It really should no longer be an issue with W10 so if it is pls let me know. Ttenbergen 09:52, 2019 March 28 (CDT) Do the following still not have wifi? : No wireless: Death desk The death desk can be slow sometimes.--Jvelasco 07:33, 2019 March 22 (CDT) so it has wifi now, then? Ttenbergen 09:52, 2019 March 28 (CDT)
Work injury reporting	Links below need to be updated. As of Aug 31.18 - not working