Statistician

From CCMDB Wiki
Jump to navigationJump to search

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.

52

 QuestionModification date"Modification date" is a predefined property that corresponds to the date of the last modification of a subject and is provided by Semantic MediaWiki.
Panelling or Discharge PlanningThat link no longer goes anywhere, the heading is not on that page. Can the reference be deleted from here, or do we need to review? And, how will this affect the use of the Category:Awaiting/delayed transfer codes? Ttenbergen 14:51, 2018 September 6 (CDT)
28 November 2018 04:53:25
Check pre acute consistentwhat exactly do we want to check for? Please also have a look at the stuff below that doesn't specifically have your name. This requested check ties into a bunch of things and if we want the check we need to be sure that instructions stay consistent and lose ends are tied up.
There was a previous attempt to address some of this in Care levels in the community; this page and it need to be consistent, and consistently linked from the relevant field definitions. If we can get it short enough we might make a template to apply the instructions to each of the field pages.
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


  • ... 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.
21 December 2018 16:09:26
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)
29 April 2019 02:59:08
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)
29 April 2019 02:49:19
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)
21 March 2019 16:11:32
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)
28 November 2018 01:50:05
Notes field
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
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.
1 December 2018 05:45:16
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)
13 February 2019 17:53:56
Transitional CareIs this part of any reports? Ttenbergen 10:03, 2017 November 9 (CST)
  • I recently had a patient discharged to Misericordia Transitional Care Unit. Should we be adding this as an option to our dispo field? The only other options were Winnipeg PCH or Institution NOS.Mlagadi 10:41, 2019 May 2 (CDT)
    • Flagging for Julie, since what we should collect should really be driven by what people want ask. Julie, if you prefer pls flag for the task meeting by replacing the first line of the discussion with DiscussTask.


  • I had a discharge to Misercordia Hospital yesterday, and the notes indicated that it was a “transitional care unit”. My only options from the Dispo drop down would be “Institution, NOS”, or “Winnipeg PCH”. I usually put PCH for all of my transfers to Misericordia, but I’m not sure this is the most accurate in this situation. The patient did not have a paneling code, nor was paneling ever mentioned. --Michelle - May 2.19
15 May 2019 22:57:55
Readmission Rate to ICU
Resistance to antimicrobials, methicillin (anti-staph penicillins)
  • Julie, the above question specifically affects some projects you work with as well - do you think unifying this rule will be a problem for any of them?


Also affected are :

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

31 October 2018 20:50:53
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.
16 May 2019 16:37:17
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?
1 March 2019 19:10:53
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.
31 December 2018 15:58:59
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)
25 November 2018 02:20:14
Data dictionarysomething 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.
14 January 2019 11:34:54
STB E6
  • are you still running these? Ttenbergen 21:06, 2018 November 24 (CST)
12 March 2019 16:54:59
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)
28 November 2018 04:55:03
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)
1 February 2019 21:16:24
Check organ donors must be dead 24 December 2018 18:47:30
Check CRF vs ARF across multiple encountersI 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)
    1. is the transition on the next hospital stay? Example in this hospital stay, patient is diagnosed with ARF and stayed continuously in both ICU and ward in same or different hospital. On the next hospital stay, he is now chronic renal patient.
    2. Or the transition is on the next ICU or ward stay? Ex. the first stay is ICU and diagnosed with ARF. then patient was transferred in a ward of same or diff hospital - is he now a chronic renal patient?
    • The data collection instructions are in the related pages, and additional info is in Renal Coding Considerations for ICD10, but they are a beast of a network of concepts. Those might tell you how we currently propose to collect the renal codes, but not necessarily what you or the users of the data would want. Usually these cross checks would be driven by what you need for data requests, so do our proposed instructions line up with how you want to use this? Or is this maybe too case-by-case of a concept to even make a cross check? Ttenbergen 18:59, 2019 January 6 (CST)
1 March 2019 19:10:53
Eliminating distinction between different ward typesany of Julie's Reporting that use this concept?
CTU vs NTU - we decided at task that we wanted to eliminate the distinction. A lot of things are part of their network of information, so we will need to work out the details above before we can move ahead.
  • I believe it was only related to transfer ready DtTm between CTU and NTU not eliminate the concept. Medicine program would have to weigh in. Trish Ostryzniuk 16:11, 2018 July 30 (CDT)
    • I seem to remember the reason to stop doing this also involved that we have more and more locations that don't fall into a clean place. For now we pretend we can give medicine this data, but is it true and meaningful? Ttenbergen 15:51, 2018 July 31 (CDT)
      • Allan will contact the medicine stakeholders about eliminating this distinction. Will email Mary-Ann Lynch, VanAmeyde, Griffin. Ttenbergen 12:18, 2019 January 24 (CST)
        • pinged again for Allan to Follow-up. Ttenbergen 13:44, 2019 February 25 (CST)
  • AG REPLY: DONE. NOBODY is using or seeking this info. So let's stop collecting it.
11 April 2019 02:55:58
STB Cardiac Care patientsCan you confirm new facts now that we are eliminating Registry Patient Type. (obviously this is a pretty old question...)10 March 2019 04:38:24
ICU Var 6 - AMADid we transition the following into tmp or otherwise? Ttenbergen 13:58, 2017 June 6 (CDT) If we did not then this question can just be removed, but if we did move this elsewhere we should explain where to.3 January 2019 21:31:41
S dispo.service typeDo you know what is the description? Especially in contrast to S dispo.loc_type. How do you use this? Please put the answer in the element_description above7 February 2019 04:47:51
Query NDC VAP no TISSFYI 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.
  • 29 April 2019 02:55:12
    Severe SepsisI don't think this was ever implemented, can't find any evidence of it. Do we need it? Ttenbergen 11:04, 2018 September 25 (CDT)31 December 2018 21:36:56
    LOS Medicine per hospital admissionthis 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
    AaDO2I wonder if "null" is actually intended here, or if it was supposed to be 0. Ttenbergen 14:44, 2017 January 8 (CST)
  • AaDO2 is null if there is no data for FIO2, PaO2 and PaCO2. However, no data was set to zero value instead of null. In addition, AaDO2 and the corresponding score are required only when FIO2 >= 50%, otherwise should be treated as null. (Similarly with PO2 score, it is required when FIO2 < 50% and otherwise should be treated as null. When FIO2 =0, both AaDO2 and its score and PO2 score should be null.) Are we setting null to zero to facilitate the programming calculation? Is it possible to differentiate null from valid zero in both L_LOG and created_variables_CC - will the work be big? In L_LOG, these are the FIO2, CO2, PO2 and SerCO2. 14:49, 2017 March 16 (CDT)
  • 3 January 2019 06:36:25
    S dispo.loc typeThis value is not yet encoded on the wiki as Property:Collection Location Location Type for locations that have their own article, but maybe it should be. Should it be? Ttenbergen 09:46, 2017 November 9 (CST)
    Indeed, what is the description? Especially in contrast to S dispo.service type; when you give the answer, please put it behind "element_description" above and delete this question.
    25 October 2018 03:37:29
    QA Septic ShockIs "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
    HSC IICU Collection GuideIs 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
    Critical Care Vital Signs MonitoringIt says that CCVSM is in Quarterly report. If CCVSM is no longer, is it still in quarterly?21 January 2019 18:46:58
    Bed holdsJulie seems to set the limit at 1 day - emailed Julie Ttenbergen 10:07, 2016 November 10 (CST)
    Laura and Tina discussed this and there clearly are different understandings about this. Need to review. LKolesar 14:43, 2017 March 1 (CST)
    duplication on wiki needs to be cleaned up once we are on same page
    3 January 2019 22:22:52
    Transition to Database ServerJulie, 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.
    11 March 2019 19:02:11
    SAS Data Integrity ChecksNow that we have a structure for cross-checks we should add those you do in SAS to here as well, using the same structure as for those listed in Data Integrity Checks Ttenbergen 20:46, 2018 October 26 (CDT)30 October 2018 01:48:15
    Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff daysThere 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.1 March 2019 19:10:56
    Statistical AnalysisThis article will likely be one of the more common landing points for external users. What do we want to tell them? Do we have any project articles we want to link in that especially highlight what we can do? ALERT Scale?Ttenbergen 22:50, 2017 June 7 (CDT)7 February 2019 04:48:08
    Chart Review ListsThis is linked from the front page and intended to give an idea of how one could use our data. Is there anything on Publications that would be a good example for how our DB was used for this? If not, should we take it out? With nothing here it doesn't look very good coming from front page.3 January 2019 22:31:09
    Pre-OP Admit - Research Patient - CardiovascularThis is not coded under ICD10 or CCI. Do we report this, and therefore need to accommodate otherwise, or how will we treat this? We have Preparatory care (incl preop optimization) but that doesn't capture the full concept. Ttenbergen 22:45, 2018 November 27 (CST)31 December 2018 03:05:46
    Pre op Admit-Cardiovasc PatientThis is not coded under ICD10 or CCI. Do we report this, and therefore need to accommodate otherwise, or how will we treat this? We have Preparatory care (incl preop optimization) but that doesn't capture the full concept. Ttenbergen 22:45, 2018 November 27 (CST)31 December 2018 03:06:12
    Base Population for ResearchThis page is linked from the front page, so we should either make it good or get rid of that. Is there anything on Publications that would be a good example for how our DB was used for this?7 February 2019 04:47:59
    Validation against Patient Registry DataThis page was started long ago to keep track of our attempt to get access to the registry. I think it would be good to re-convene on it so we have a central point where past efforts and current efforts can be tracked. That would also make it easier to take it to task or steering and have consistent info. Do you have a log of this somewhere? We can rename it if you want.3 January 2019 21:26:12
    Check VAP acquired only first encounterWe decided that VAP can actually happen in medicine if pt admitted from ICU. How would we deal with that for this check?26 March 2019 01:57:30
    ADL General Collection InformationWhat else in addition to ALERT Scale Calculation uses this?4 January 2019 02:25:07
    Requested TISS changes for the next versionWhat is the intended use of these reports?26 March 2019 04:25:24
    Query s ICD10 Chapter block dxsany other plans for these?27 March 2019 15:28:43
    Project Borrow arrivedid they ever get back to us? no response from HSC SICU --JMojica 10:14, 2019 May 6 (CDT)14 May 2019 15:26:20
    Check CCI CXR vs LOSwould we not use Accept DtTm here? Because we could have CXRs on days before arrival...
    started implementation but had question for Julie, added below
    10 May 2019 01:50:58
    Query TISS Errors missing dayswhich report/s are these actually included in?11 February 2019 22:14:57
    QA Infection VAPwill we still need to collect this in ICD10, since I think all the data now lives in the dx codes as well. I am holding off on implementing Query s tmp QAInf tmp no dx until resolved. same reply as in QA CLI. --JMojica 12:04, 2018 December 27 (CST)9 May 2019 19:10:29

    IT Access used

    Related Articles

    Related articles: