p:Julie Mojica is the full time Statistician for the Critical Care and Medicine Database.
Questions on wiki
Here is a list of questions driven by the Template:Discuss that have been flagged for Julie.
"Modification date" is a predefined property that corresponds to the date of the last modification of a subject and is provided by Semantic MediaWiki.
|Last editor is|
"Last editor is" is a predefined property that contains the page name of the user who created the last revision and is provided by Semantic MediaWiki.
|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)||28 November 2018 04:53:25||Ttenbergen|
|Previous Location field||
||21 December 2018 16:10:01||Ttenbergen|
|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.
It may be relevant to this check that we have ICD10 Imprisonment/incarceration and other info in Prison / Jail / Correctional Institution.
|21 December 2018 16:09:26||Ttenbergen|
|CAM positive (TISS Item)||
||31 December 2018 06:41:52||Ttenbergen|
|Reporting from ICD10/CCI||
This is part of the discussion with Julie about Apache diagnoses today I think Ttenbergen 08:49, 2019 January 10 (CST)
|10 January 2019 14:49:53||Ttenbergen|
|Correcting Person IDs||
||7 November 2018 20:43:19||Ttenbergen|
|Transfer-for Organ Transplantation||
||28 November 2018 01:50:05||Ttenbergen|
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)
|20 December 2018 19:46:33||Ttenbergen|
|Drug or biological substance/agent NOS, adverse effect||
||1 December 2018 05:45:16||Ttenbergen|
||7 November 2018 21:07:06||Ttenbergen|
CFE button "open suspect links" also needs to be dealt with when this is done. And needs to be documented.
|7 January 2019 14:39:21||Ttenbergen|
||4 January 2019 02:25:16||Ttenbergen|
|Resistance to antimicrobials, methicillin (anti-staph penicillins)||
Also affected are :
Does anyone think making this one rule for all will be a problem?
|31 October 2018 20:50:53||Trish Ostryzniuk|
|APACHE Comorbidities in ICD10 codes||
||23 December 2018 04:06:53||Ttenbergen|
|S ICD10 Blocks table||
||30 October 2018 20:49:54||Ttenbergen|
|Primary Admit Diagnosis||
||28 November 2018 04:43:31||Ttenbergen|
|Check Inf Potential Infection must have pathogen or alt combined code||
||9 November 2018 02:32:12||Ttenbergen|
|Medical Assistance In Dying||
||31 December 2018 15:58:59||Dr. Allan Garland|
|L ICD10 APACHE Dx query||
||25 November 2018 02:20:14||Ttenbergen|
|Check VAP vs TISS ventilated||
||7 January 2019 04:24:41||Ttenbergen|
|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:
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.
|14 January 2019 11:34:54||Ttenbergen|
||25 November 2018 03:06:17||Ttenbergen|
|Bronchitis, acute or chronic not specified, infectious or noninfectious||
||20 December 2018 22:33:51||Ttenbergen|
|Query TISS Errors CAM positive vs Dx||
I am not actually sure what is supposed to be tested here... that CAM and Dilirium always show up together?
is there a sensible list that could be used for this, or should this check be declined?
|7 January 2019 02:56:02||Ttenbergen|
||28 November 2018 04:55:03||Ttenbergen|
|Query NDC Dxs vs TISS Dialysis||
||7 January 2019 02:51:51||Ttenbergen|
|Check organ donors must be dead||
||24 December 2018 18:47:30||Ttenbergen|
|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)||7 January 2019 00:59:22||Ttenbergen|
|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?||2 January 2019 21:58:47||Ttenbergen|
|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.||3 January 2019 21:31:41||Ttenbergen|
|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)||31 December 2018 21:36:56||Ttenbergen|
|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 ...
|4 January 2019 02:34:53||Ttenbergen|
|AaDO2||I wonder if "null" is actually intended here, or if it was supposed to be 0. Ttenbergen 14:44, 2017 January 8 (CST)
||3 January 2019 06:36:25||Ttenbergen|
|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.
|25 October 2018 03:37:29||Ttenbergen|
|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?||3 January 2019 05:41:09||Ttenbergen|
|Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)||Is this still part of Critical Care Vital Signs Monitoring? Ttenbergen 17:22, 2018 May 31 (CDT)||20 December 2018 16:50:43||Ttenbergen|
|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?||16 January 2019 16:08:27||Ttenbergen|
|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)
|3 January 2019 22:22:52||Ttenbergen|
|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)||30 October 2018 01:48:15||Ttenbergen|
|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.||3 January 2019 22:31:09||Ttenbergen|
|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)||31 December 2018 03:05:46||Ttenbergen|
|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)||31 December 2018 03:06:12||Ttenbergen|
|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.||3 January 2019 21:26:12||Ttenbergen|
|ADL General Collection Information||What else in addition to ALERT Scale Calculation uses this?||4 January 2019 02:25:07||Ttenbergen|
|Query s ICD10 Chapter block dxs||any other plans for these?||11 January 2019 05:15:41||Ttenbergen|
|Characteristics and Outcomes of Acute Exacerbation of Chronic Obstructive Pulmonary Disease Admissions in Intensive Care Units in Manitoba||do we have any reference for this one? how did we support this publication?||3 January 2019 22:29:18||Ttenbergen|
|A citywide analysis of the utilization of common laboratory tests and imaging procedures in ICUs||how did we support this abstract?||3 January 2019 21:18:30||Ttenbergen|
|Epidemiology of Critically Ill Patients in Intensive Care Units: A Population-based Observational Study||how did we support this publication?||3 January 2019 21:13:36||Ttenbergen|
|Changes Over Time in Intensive Care Unit Admission Diagnoses: A Population-Based Analysis||how did we support this publication?||3 January 2019 21:12:51||Ttenbergen|
|A Population-based Analysis of Leaving the Hospital Against Medical Advice: Incidence and Predictors||how did we support this publication?||3 January 2019 21:14:04||Ttenbergen|
|Rates of Readmission and Death Associated with Leaving Hospital Against Medical Advice: A Population-based Study||how did we support this publication?||3 January 2019 21:13:51||Ttenbergen|
|Increased Incidence of Critical Illness in Psoriasis||how did we support this publication?||3 January 2019 21:13:38||Ttenbergen|
|Eliminating Needless Testing in Intensive Care - An Information Based Team Management Approach||how did we support this publication?||3 January 2019 21:12:57||Ttenbergen|
|Health Care Utilization Before and After Intensive Care Unit Admission In Multiple Sclerosis||how did we support this publication?||3 January 2019 21:14:05||Ttenbergen|
|A Population-based Observational Study of ICU-Related Outcomes: With Emphasis on Post-Hospital Outcomes||how did we support this publication?||3 January 2019 21:13:51||Ttenbergen|
|Age related changes in intensive care bed utilization over time: A population based study.||how did we support this publication?||3 January 2019 21:13:38||Ttenbergen|
|Outcomes of chronic dialysis patients admitted to the intensive care unit||how did we support this publication?||3 January 2019 21:12:57||Ttenbergen|
|Quality Improvement in Critical Care: Selection and Development of Quality Indicators||how did we support this publication?||3 January 2019 21:14:27||Ttenbergen|
|Comparison of different methods to describe intensive care bed use||how did we support this publication?||3 January 2019 21:12:31||Ttenbergen|
|Duration of hypotension before initiation of effective antimicrobial therapy is the critical determinant of survival in human septic shock||how did we support this publication?||3 January 2019 21:13:52||Ttenbergen|
|Long-term outcomes of end-stage renal disease patients admitted to the ICU Nephrology Dialysis Transplant||how did we support this publication?||3 January 2019 21:13:42||Ttenbergen|
|Predictors of ICU admission and outcomes one year post admission in persons with IBD: A population based study||how did we support this publication?||3 January 2019 21:13:07||Ttenbergen|
|Surge Capacity: Analysis of Census Fluctuations to Estimate the Number of Intensive Care Unit Beds Needed||how did we support this publication?||3 January 2019 21:14:29||Ttenbergen|
|Specific Reporting Requirements Improves the Accuracy of Administrative Data for Identifying Intensive Care Unit Admission||how did we support this publication?||3 January 2019 21:12:46||Ttenbergen|
|Population Trends in Substances Used in Deliberate Self Poisoning Admissions to the ICU between 2000-2010||how did we support this publication?||3 January 2019 21:13:59||Ttenbergen|
|Comparing Use Of Intensive Care Units Between Rural And Urban Canadian Populations||how did we support this publication?||3 January 2019 21:13:43||Ttenbergen|
|Hospitalization is associated with subsequent disability in multiple sclerosis||how did we support this publication?||3 January 2019 21:13:36||Ttenbergen|
|Laboratory Testing in the Intensive Care: Does the Admitting Hospital Affect Costs?||how did we support this publication?||3 January 2019 21:14:32||Ttenbergen|
|Intensive Care Unit Admission in Multiple Sclerosis: Increased Incidence and Increased Mortality||how did we support this publication?||3 January 2019 21:12:46||Ttenbergen|
|Relationship Between Apache II SAcore & Combined Laboratory & Pharmacy Costs in ICU Survivors and Nonsurvivors||how did we support this publication?||3 January 2019 21:14:02||Ttenbergen|
|End Stage Renal Disease Status and Critical Illness in the Elderly||how did we support this publication?||3 January 2019 21:13:43||Ttenbergen|
|Statistical Analysis||not summarized||4 January 2019 02:37:01||Ttenbergen|
|S dispo.service type||not summarized||3 January 2019 21:49:57||Ttenbergen|
|Base Population for Research||not summarized||3 January 2019 21:52:34||Ttenbergen|
|Encephalopathy, septic or metabolic||q
||18 November 2018 05:49:41||Ttenbergen|
|QA Infection CLI||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. There is no need to continue the QA infection VAP/CLI project since the dates are now collected for acquired ICD10. I will get the data from the L_ICD10 dx table for reporting. Thus the crosscheck queries are no longer needed except the one about LT 48HRS after admit. Also the instruction to email the QI Officer should continue. Also the --JMojica 11:57, 2018 December 27||3 January 2019 05:08:43||Ttenbergen|
|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)||3 January 2019 05:08:29||Ttenbergen|