Statistician

p:Julie Mojica is the full time Statistician for the Critical Care and Medicine Database.

She provides Statistical Analysis and Reporting using our data.

The Statistician is a member of the Steering Committee & the Task Team.

Questions on wiki

Here is a list of questions driven by the Template:Discuss that have been flagged for Julie.

75

edit	page	question
edit	LOS Medicine per hospital admission	"None yet." What does that mean in the context of "Target"? And how does "Target" fit in with the structure you described in Template:Reporting Indicators?
edit	Panelling or Discharge Planning	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)
edit	Check pre acute consistent	... 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.
edit	Query TISS Errors ETT consistent	A patient might arrive intubated, so there would be no intubation. Does this check really make sense? Ttenbergen 23:23, 2019 March 25 (CDT) I have revised the conditions, pls check if they now make sense.--JMojica 16:38, 2019 July 9 (CDT)
edit	Data dictionary	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. how about adding the program as part of the sub header instead of table columns. --JMojica 13:36, 2019 June 26 (CDT) I have added subheadings, or comments in headings when only one program applies. Does that work? Ttenbergen 15:32, 2019 July 4 (CDT)
edit	STB E6	are you still running these? Ttenbergen 21:06, 2018 November 24 (CST)
edit	Guideline for coding organ donation after death	As per Allan, "It’s necessary to avoid double counting the death for patients who transfer after brain death". Mortality and readmission report - that page has very limited information. Is this report still done? If so, can we update that and make sure this change won't mess with it? The effect on mortality rate will be negligible if we include or exclude these cases, so it was decided that there is no need to make any change at all in the calculation of the rates. --JMojica 10:30, 2019 July 5 (CDT) Are there other reports that count death rates or mortality? If so we should make a page for it and add it to Category:End-of-life related data and make sure it records how we will address this scenario. Ttenbergen 16:04, 2019 May 21 (CDT)
edit	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)
edit	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)
edit	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)
edit	Check pre acute consistent	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.
edit	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.
edit	72hr 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.
edit	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?
edit	Check pre acute consistent	The listed postal codes are correlated to the items ‘PCH’ and ‘Chronic Health facility’ of the Pre-Acute Living Situation. Since the data collectors are collecting the postal code from the patient’s address, will it be possible to automatically fill up the Pre-Acute Living Situation as PCH or Chronic Health facility if the PCH postal codes are entered or ‘other ways’ to link the two fields and make them consistent. Info about PCH is now getting more attention/request. Tina, Will this be hard to do? Any suggestions? I have changed my mind to add the PCH postal code to the Postal_Code_Master due to the possible effect on its size (when adding a new column containing text where most of the records will only be blanks). It is better to have it in separate table since this pertains to Winnipeg area only. I have added the exact address of these PCH facilities - link to table in email sent on Jan 12.18 at 1224 hrs from p:Julie Mojica Is any change to CFE still required then? If not, please remove this discussion and heading. Ttenbergen 15:47, 2019 July 4 (CDT)
edit	Re-admission	There must be some clause to exempt someone who just comes from a previous internal unit, right? How is that defined? Wondering whether it will be affected by Guideline for coding organ donation after death.
edit	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)
edit	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)
edit	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?
edit	HD (Hemodialysis)	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)
edit	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.
edit	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)
edit	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)
edit	Primary Admit Diagnosis	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.
edit	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)
edit	Primary Admit Diagnosis	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
edit	Check CRF vs ARF across multiple encounters	Using the ICD10 renal codes, we still need to know when the transition from acute to chronic occurs - so we can decide whether the multiple encounters consistency checking is still relevant. --JMojica 11:51, 2018 November 14 (CST) 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)
edit	Mortality and readmission report	who is this report given to? thank you--TOstryzniuk 18:40, 30 November 2010 (CST) Ttenbergen 23:43, 2017 June 7 (CDT)
edit	ICU Mortality	Allan says don't include Brain death admits in the numerator or denominator ?
edit	Eliminating distinction between different ward types	any of Julie's Reporting that use this concept?
edit	Query s ICD10 Chapter block dxs	any other plans for these?
edit	ICU Acquired Sepsis	Are other dxs included?
edit	Nursing Workload	Average or mean? Different in description and definition.
edit	ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rate	Based on which dxs and delays?
edit	STB Cardiac Care patients	Can you confirm new facts now that we are eliminating Registry Patient Type. (obviously this is a pretty old question...)
edit	Boarding Loc	did they ever get back to us? no response from HSC SICU --JMojica 10:14, 2019 May 6 (CDT). will follow-up again. --JMojica 16:39, 2019 July 5 (CDT)
edit	Project Borrow arrive	did they ever get back to us? no response from HSC SICU --JMojica 10:14, 2019 May 6 (CDT)
edit	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.
edit	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
edit	ICU Mortality	Does this also consider any of the Diagnosis implying death?
edit	LOS Medicine per hospital admission	Does this mean time spent in an ICU between wards is included in the LOS? If not, can we tweak the text so that is clearer?
edit	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.
edit	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)
edit	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)
edit	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)
edit	S dispo.loc type	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.
edit	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?
edit	ICU Acquired Antibiotic Resistant Organism (ARO) rate	Is it really only colonization, or does/should this include infections? Category:Antibiotic resistance?
edit	ICU Acquired Antibiotic Resistant Organism (ARO) rate	Is it still defined just around those? Should it now be defined around Category:Antibiotic resistance?
edit	Bed occupancy	Is this about Bed census.mdb or a different thing?
edit	Severity of illness	Is this average as in description or mean as in definition?
edit	Length of Stay (ICU Report)	Is this based on Accept DtTm or Arrive DtTm?
edit	ICU Acquired Sepsis	Is this based on Shock, septic? Severe sepsis? Dx Date? Anything else?
edit	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?
edit	ICU Resource Utilization - Creatinine Tests	Is this DSM Lab Extract?
edit	ICU Resource Utilization - Chest Xrays	Is this DSM Lab Extract?
edit	Critical Care Vital Signs Monitoring	It says that CCVSM is in Quarterly report. If CCVSM is no longer, is it still in quarterly?
edit	Bed holds	Julie seems to set the limit at 1 day - emailed Julie Ttenbergen 10:07, 2016 November 10 (CST)
edit	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)
edit	Length of Time for Transfer from ED to ICU within same facility	No significance in your ppt?
edit	72hr Readmission Rate to ICU	Not those that were discharged home or elsewhere?
edit	ICU Acquired Sepsis	Nothing was listed in your power point, what is the significance?
edit	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)
edit	LOS Medicine per hospital admission	originally you called this "Calculation Procedure:" - which do you prefer?
edit	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)
edit	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.
edit	ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rate	There was no significance in your PPT.
edit	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)
edit	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.
edit	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)
edit	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)
edit	Length of Stay (ICU Report)	This is per ICU, not across ICUs, right? How do we make the definition specific for this?
edit	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?
edit	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.
edit	LOS Medicine per hospital admission	this still talks about TMSX... what is the new status of this field?
edit	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?
edit	Delirium days	What are the details?
edit	Severity of illness	What are the details?
edit	ICU Mortality	What are the details?
edit	Length of Stay (ICU Report)	What are the details?
edit	Over Census at Midnight	What are the details?
edit	ICU Interfacility Transfer	What are the details?
edit	Central Line Associated Blood-Stream Infection (CLA-BSI) rate	What are the details?
edit	ICU Acquired Ulcer Rate	What are the details?
edit	ICU Acquired Antibiotic Resistant Organism (ARO) rate	What are the details?
edit	ICU Acquired Sepsis	What are the details?
edit	ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rate	What are the details?
edit	ICU Resource Utilization - Creatinine Tests	What are the details?
edit	ICU Resource Utilization - Chest Xrays	What are the details?
edit	Length of Time for Transfer from ED to ICU within same facility	What are the details?
edit	Nursing Workload	What are the details?
edit	ADL General Collection Information	What else in addition to ALERT Scale Calculation uses this?
edit	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.
edit	Bi-monthly report	What is the Bi-monthly report?
edit	Requested TISS changes for the next version	What is the intended use of these reports?
edit	Mortality and readmission report	What is the Mortality and readmission report report?
edit	Quarterly report	What is the Quarterly report report?
edit	Query TISS Errors missing days	which report/s are these actually included in?
edit	Night Time Discharges	Why only to wards? How about to home?
edit	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)
edit	Bed occupancy	with TMSX not having been around for a while, is this still relevant? Do you provide this data otherwise? Do we need to implement this?
edit	Check CCI CXR vs LOS	would we not use Accept DtTm here? Because we could have CXRs on days before arrival...
edit	LOS	LOS Medicine per hospital admission and LOS Medicine per ward stay may duplicate content above. Do they? If we ever split these out into reporting documentation indicator pages we will need to make sure these are not duplicated.
edit	LOS Medicine per hospital admission	p:Dr. Dan Roberts You had this as "PRESCRIBED BY: "; which is not how you set it in Template:Reporting Indicators. Also, Dan is likely no longer the user of this, so it should probably be updated. If we use a title rather than a name it will be self updating.

IT Access used

• File share HSC Critical Care
• Critical Care Sharepoint ExtraNet