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.

edit page question ModDate
edit page question ModDate
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? 2020-04-10 2:07:57 AM
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.
2021-02-11 6:11:08 PM
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)
      • Actually, no: Someone can arrive intubated from another ICU and then be extubated their first day here. I don't see how Insertion can be included in these two. Ttenbergen 20:13, 2020 December 2 (CST)
  • 2020-12-03 2:13:32 AM
    edit Query check long transfer delay
  • At the meeting about cross checks (a long time ago) it was decided to change the cut-off to SD*3; if we want to proceed with this check, I will need values for that. Ttenbergen 23:08, 2020 October 15 (CDT)
  • 2020-10-16 4:08:05 AM
    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)
  • 2019-03-21 4:11:32 PM
    edit Clinical Assessment Unit
  • do we need to do anything to get collectors to fill this out right? Or to deal with back-data? Ttenbergen 14:40, 2021 March 11 (CST)
  • 2021-04-01 10:03:15 PM
    edit Clinical Assessment Unit
  • do we want to do this?
  • 2021-04-01 10:03:15 PM
    edit Continuous Stay
  • Does this use Arrive DtTm or Accept DtTm in the new schema?
  • 2020-01-31 4:53:01 PM
    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

    2021-02-11 6:11:08 PM
    edit Transfer Delay
  • How is this going to work with the transition from Transfer Ready DtTm field to Transfer Ready DtTm tmp entry? We will need an update to this page as we change the process. Obviously a field in a created_variables table is no longer the way to do this since there may be more than one per profile. Let me know if you want to discuss Ttenbergen 16:09, 2021 January 21 (CST)
  • 2021-01-22 2:04:18 AM
    edit Query check long transfer delay
  • If we actually want a cross check like this it needs to be based not on NTU/CTU. We could either base it on specific units or on Level of care hierarchy, ie. add another column to s_level_of_care table. Would that work for you? Ttenbergen 23:08, 2020 October 15 (CDT)
  • 2020-10-16 4:08:05 AM
    edit Query s tmp Boarding Loc date item
  • if we enter unit info from Cognos, then the unit start date and time for the initial boarding loc will almost always be before the accept date and time. So I have removed that cross check for now so we can decide how we want to do this. I think we should enter the unit start from Cognos; this will be easier, less typo-prone, and it will allow us to eventually move to a system where we simply import this from Cognos possibly without human intervention (or in any case, possibly with only administrative intervention rather than from nurse data collector). It would mean treating this data differently to screen out the time on unit before service, and it would mean we can no longer cross check for this. We will need to review out cross-checks anyway, we don't have one for services yet at all. Emailing Julie for input. Regardless of the what we decide, we will need to clarify this in Boarding Loc since collectors are likely entering this first boarding slightly differently. Ttenbergen 16:48, 2020 November 6 (CST)
  • 2020-11-06 10:48:25 PM
    edit Template:ICD10 Guideline Transplant Failure
  • Is "don't code history of transplant when coding transplant rejection because it's implied" something you are aware of? It's not something I would have thought of if you had asked me to write a query that lists all records with previous transplants. If we want to change this could you bring it to task meeting? Ttenbergen 16:41, 2020 January 31 (CST)
  • 2020-04-10 3:51:51 AM
    edit Form Covid rept
  • Julie, pls have a look at that query in CFE and let me know if it contains what we need, otherwise explain what we need.
    • The query looks great. Just one additional request on the pivot - please make the column area to be combination of Arrived_Dt and Obs_for_Covid in order to show the trend across time. Thanks. --JMojica 08:58, 2020 April 20 (CDT)
  • 2021-02-11 6:06:45 PM
    edit Manitoba Health Crosschecking Background
  • Need to know how this arrives to set up processing. Where will this data live? Ttenbergen 16:11, 2014 August 25 (CDT)
    • Actually, I think you have not been getting those for ages, right? We would just need to update that. We may or may not blow away this page, depending on whether we think we will ever get this again.
  • 2019-11-07 10:55:54 PM
    edit Query check long transfer delay
  • Requiring notes to have content is really a very soft error check... do we need to consider something better?
  • 2020-10-16 4:08:05 AM
    edit Continuous Stay
  • That last line seems to be obvious in new schema from the other definitions... is AMA still at all relevant here or can it be taken out?
  • 2020-01-31 4:53:01 PM
    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)
  • 2021-02-11 6:11:08 PM
    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.
  • 2019-05-22 12:55:11 AM
    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)
  • 2018-11-28 4:55:03 AM
    edit Continuous Stay
  • This def of Bed holds is not consistent with the one in Bed holds; they probably should be, i.e. the same definition should be used throughout. Are they actually consistent in your program? Can we remove the detail from here and link to bed hold?
  • 2020-01-31 4:53:01 PM
    edit Query check has service entry
  • This probably needs to be considered in context of Minimal Data Set - if it is part of that it changes the check time (ie for all records or only for complete records?).
  • 2021-01-28 7:52:09 PM
    edit Continuous Stay
  • This will likely have changed when we eliminated the 5 minute rule for local transfers; Julie, could you confirm that this was also changed wherever it has an impact?
  • Does this use Arrive DtTm or Accept DtTm in the new schema?
  • 2020-01-31 4:53:01 PM
    edit Processes around changing a PatientFollow assignment
  • We discussed this today and you would need to make changes to how you derive these markers. A number of them probably need to be re-defined and revised after all the changes we have made because they would still be based around the old concepts of Accept DtTm, Arrive DtTm etc that should really not be used any longer for calculations. What would it take, and where are these things documented? Ttenbergen 16:50, 2020 November 23 (CST)
  • 2021-01-15 2:58:01 AM
    edit Service tmp entry
  • When should the new options be used rather than the other service entries for HSC?
    • if I understand it correctly, when the list of these services appear in Cognos, since they do not map well to MICU or SICU, the DC must specified which service is appropriate : MICU or SICU. In reporting, I need to separate the data belonging to MICU and SICU service. If you would like to add "HSC Critical Care - MICU" and "HSC Critical Care - SICU", we need to add them to s_Cognos_Services.xlsx
      • HSC Critical Care / Adult General
      • HSC Critical Care / Amputee
      • HSC Critical Care / General
      • HSC Critical Care / Intensive Care
      • HSC Critical Care / Obstetrics
      • HSC Critical Care / Oncology
      - --JMojica 14:18, 2021 April 6 (CDT)
  • if you mean S Cognos Services table then I am not sure we really need to add them there... that is the list of services that come in from Cognos, and these don't come in from Cognos. Actually, what we would need to do is make sure we remove the ambiguous items that came via Cognos into the s_tmp table that we don't want people to use any longer, so that people are forced to instead use our made up ...SICU and ...MICU ones. Julie and Tina might need to discuss this in our questions meeting on Thursday.
  • 2021-04-06 8:27:06 PM
    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.
  • 2019-09-24 3:20:41 PM
    edit ICU Acquired Sepsis
  • which dxs are used?
  • 2020-02-12 4:56:38 PM
    edit Continuous Stay
  • would it make sense to take out the ICU requirement for this? The same might be rarer for Medicine patients but would still be true. I will implement Encounter processing like that for now unless I hear otherwise. Ttenbergen 12:06, 2015 January 22 (CST)
    • Glad you put that in Tina, I was going to make a similar comment.--CMarks 12:48, 2015 January 22 (CST)
  • 2020-01-31 4:53:01 PM
    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)
  • 2020-04-02 5:02:37 PM
    edit Central Line Associated Blood-Stream Infection (CLA-BSI) rate
    • A central lines (CL) is a central venous catheters (CVC) that terminates at or close to the heart or one of the great vessels. Great vessels include the pulmonary artery, superior vena cava, inferior vena cava, brachiocephalic, internal jugular, subclavian, external iliac and the common femoral veins.
      • Could we link to Central Line for details instead so that if we change any they will remain consistent?
    2019-08-14 12:23:04 AM
    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)
    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)
  • 2019-09-16 4:30:12 PM
    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)
  • 2019-05-23 1:32:27 PM
    edit Task Team Meeting - Rolling Agenda and Minutes 2019 Actually, I think Julie decided to re-claim these from backups, no? 2020-05-21 9:48:20 PM
    edit ICU Mortality Allan says don't include Brain death admits in the numerator or denominator ? 2019-08-14 12:16:07 AM
    edit Query s ICD10 Chapter block dxs any other plans for these? 2019-03-27 3:28:43 PM
    edit Nursing Workload Average or mean? Different in description and definition. 2019-08-14 12:16:07 AM
    edit Risk factors for seizures in cardiac surgery ICU Patients Can't find any reference to this paper. The Pubmed link instead goes to an article "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? 2019-11-05 4:26:39 PM
    edit Project Borrow arrive did they ever get back to us? no response from HSC SICU --JMojica 10:14, 2019 May 6 (CDT) 2020-08-05 7:25:06 PM
    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. 2020-07-25 2:27:24 AM
    edit Resource Use do we have a counterpart like Avoidable Days in Medicine? 2021-01-22 2:06:54 AM
    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 2020-04-10 4:37:23 AM
    edit ICU Mortality Does this also consider any of the Diagnosis implying death? 2019-08-14 12:16:07 AM
    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? 2020-04-10 2:07:57 AM
    edit S dispo.service type entries in s_dispo table might be inconsistent with entries on wiki. Which are right? These are mostly used by you for Reporting so could you please make sure wiki and dispo are consistent? Or, we could take them out of wiki if you would rather not maintain them in two places. 2020-04-10 4:37:23 AM
    edit Check pre acute consistent How does Chronic Health Facility fit into this? Or Imprisonment/incarceration and other info in Prison / Jail / Correctional Institution? 2021-02-11 6:11:08 PM
    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) 2019-09-12 9:45:18 PM
    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) 2019-10-31 3:04:29 PM
    edit Transfer time rule I suspect this is all legacy, we would use the proper dates and times from EPR now, right? If so I propose we delete this page without leaving a legacy entry since knowledge of this is not really required to makes sense of our data. Ttenbergen 22:08, 2020 October 15 (CDT) 2020-10-19 4:23:14 AM
    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)
    2020-07-15 9:30:44 PM
    edit QA Septic Shock If we ever pick this back up we need to answer: Is "Every entry for project QA Septic must have either a date or a time." a request for a cross check? or does that check exist already? 2019-09-16 7:43:49 PM
    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. 2020-04-10 4:33:12 AM
    edit Charlson Comorbidity Index Is that the Annual report? 2020-04-09 5:43:03 PM
    edit Severity of illness Is this average as in description or mean as in definition? 2019-08-14 12:16:06 AM
    edit LOS Medicine per hospital admission is this Arrive DtTm or Accept DtTm? 2020-04-10 2:07:57 AM
    edit ICU Resource Utilization - Chest Xrays Is this DSM Lab Extract? 2019-08-14 12:16:06 AM
    edit ICU Resource Utilization - Creatinine Tests Is this DSM Lab Extract? 2019-08-14 12:16:08 AM
    edit ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rate Just to be clear, is it number of cases (possibly >1 per pt) or once per pt as mentioned above? 2019-08-14 12:44:24 AM
    edit ICU Acquired Sepsis Just to be clear, is it number of cases (possibly >1 per pt) or once per pt as mentioned above? 2020-02-12 4:56:38 PM
    edit Length of Time for Transfer from ED to ICU within same facility No significance in your ppt? 2019-08-14 12:16:06 AM
    edit ICU Acquired Sepsis Nothing was listed in your power point, what is the significance? 2020-02-12 4:56:38 PM
    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) 2018-10-30 1:48:15 AM
    edit Project Discharge Documentation pls fill in once you set it up 2020-05-06 2:18:46 AM
    edit Length of Stay (ICU Report) Right now this is slightly inconsistent with Definition of a Critical Care Laptop Admission which doesn't explicitly exclude the ER pts. I have flagged that page for task review. Once that is done, can we just use that definition here as well to ensure consistency? 2020-12-15 4:41:27 PM
    edit ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rate There was no significance in your PPT. 2019-08-14 12:44:24 AM
    edit Check pre acute consistent 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. 2021-02-11 6:11:08 PM
    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) 2019-02-07 4:48:08 AM
    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. 2020-04-04 4:11:33 AM
    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) 2018-12-31 3:05:46 AM
    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) 2018-12-31 3:06:12 AM
    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? 2021-03-11 4:11:49 PM
    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. 2019-01-03 9:26:12 PM
    edit LOS Medicine per hospital admission this still talks about TMSX... what is the new status of this field? 2020-04-10 2:07:57 AM
    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? 2019-03-26 1:57:30 AM
    edit Length of Time for Transfer from ED to ICU within same facility What are the details? 2019-08-14 12:16:06 AM
    edit ICU Resource Utilization - Chest Xrays What are the details? 2019-08-14 12:16:06 AM
    edit ICU Resource Utilization - Creatinine Tests What are the details? 2019-08-14 12:16:08 AM
    edit Nursing Workload What are the details? 2019-08-14 12:16:07 AM
    edit ICU Interfacility Transfer What are the details? 2019-08-14 12:16:06 AM
    edit Severity of illness What are the details? 2019-08-14 12:16:06 AM
    edit Over Census at Midnight What are the details? 2019-08-14 12:16:07 AM
    edit ICU Mortality What are the details? 2019-08-14 12:16:07 AM
    edit Delirium days What are the details? 2020-12-08 3:15:40 AM
    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. 2021-02-11 6:11:08 PM
    edit Requested TISS changes for the next version What is the intended use of these reports? 2020-10-23 8:15:43 PM
    edit Mortality and readmission report What is the Mortality and readmission report report? 2019-05-23 1:32:27 PM
    edit Quarterly report What is the Quarterly report report? 2019-05-23 1:31:56 PM
    edit Boarding Loc Which if any of Project_Borrow_arrive#Data_Integrity_Checks_.28SMW.29 will need to be moved over to this instead? 2021-04-06 9:09:46 PM
    edit Resource Use which others in Category:Indicators 2021-01-22 2:06:54 AM
    edit Night Time Discharges Why only to wards? How about to home? 2019-05-23 3:27:59 PM
    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) 2019-05-28 7:32:55 PM
    edit Check CCI CXR vs LOS would we not use Accept DtTm here? Because we could have CXRs on days before arrival... 2019-10-04 3:17:31 PM
    edit Function long LOS() Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry changed Service/Location to aggregate values for the whole stay in a program. The values used in s_dispo table for the longest likely LOS were filled with previous entries from the same program, but should likely be longer now, since an aggregate stay would on average be longer. Once we have some data with the new aggregate model we should update these values. 2021-01-15 6:03:38 PM
    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. 2020-12-15 4:41:27 PM
    edit Isolation, infectious Medicine report - need right link 2021-04-08 9:18:02 PM
    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. 2020-04-10 2:07:57 AM

    IT Access used

    Related Articles

    Related articles: