Statistician

From CCMDB Wiki

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.

36

 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.
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 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)
26 October 2018 17:15:27Ttenbergen
Check brain dead across encounters
  • Could not be an ICU transfer due to lack of space? (Tina)
    • Even though due to lack of space, code 874 should appear in acquired slot if there is a next encounter. (Julie)
      • That would imply that we would not move a braindead person that isn’t going to become an Organ Donor at the next destination. Is that so? I can see where someone who is 524 once will stay that, but I wonder about the 874 implication. (Tina) Ttenbergen 14:12, 2012 November 5 (EST)

Now that we have Known data errors we could implement this. Any error found would need to be followed up and either corrected or added to known errors. Putting into potential changes. Ttenbergen 10:59, 2015 June 25 (CDT)


In ICd10 this one includes live donors, so it may no longer be usable for this purpose; can we set it to not feasible?
27 October 2018 05:43:25Ttenbergen
Correcting Person IDs
  • Do we need to change this process? If so we likely need a section in Changing PHINs


  • When we talked about this 2018 November 7 it seemed like this might not be OK after all, and that we have handed out this data as if this number never changes.
7 November 2018 20:43:19Ttenbergen
Check trach vs TISS
  • Do we wan to include CCI Tracheostomy creation? If so how?
  • Do Julie or Pagasa already run checks for this? If so, what are DIC_coding, DIC_app?
27 October 2018 05:46:15Ttenbergen
Notes field 9 November 2018 03:59:11Ttenbergen
Changing PHINs
  • does that ever happen, and how do we deal with it?


  • Pagasa, are there other things you do in this case? Probably change for other encounters if not just a typo. Anything else? Ttenbergen 11:55, 2017 September 18 (CDT)


  • How about if a person's insurance status changes or they move in or out of Province? Should we change those PHINs? If we wanted to keep the same person_ID for different PHINs we would need to remove the first step in Generate Person IDs that blows away Person_IDs for duplicate PHINs. but: if we remove that step we will no longer make sure that the scenario of multiple PHINs per Person_ID doesn't happen accidentally.
7 November 2018 21:07:06Ttenbergen
NDC VAP AcqDX but NoVAP DateinTMPV2
  • in ICD10 we will have Dx Date available; do we wan to change this check to include that?


Was there a reason we didn't move this into ccmdb, or was that just a ball dropped? We'd need to review with ICD10 anyway...

  • Needs ICD10 added, and likely be moved to CCMDB.mdb.


  • If a sputum culture is no longer a defining feature of VAP, then is collecting the date of one in QA Infection VAP really reasonable in the first place? If it is not then this check can go away. See discussion at QA Infection VAP, just flagging it here.
31 October 2018 22:08:49Ttenbergen
NDC VAP unacceptable date
  • in ICD10 we will have Dx Date available; do we wan to change this check to include that?


Was there a reason we didn't move this into ccmdb, or was that just a ball dropped? We'd need to review with ICD10 anyway...

  • Needs ICD10 added, and likely be moved to CCMDB.mdb.


  • If a sputum culture is no longer a defining feature of VAP, then is collecting the date of one in QA Infection VAP really reasonable in the first place? If it is not then this check can go away. See discussion at QA Infection VAP, just flagging it here.
31 October 2018 23:35:09Ttenbergen
NDC VAP No AcqDX but VAP DateinTMPV2Was there a reason we didn't move this into ccmdb, or was that just a ball dropped? We'd need to review with ICD10 anyway...
  • Needs ICD10 added, and likely be moved to CCMDB.mdb.


  • in ICD10 we will have Dx Date available; do we want to change this check to include that?


  • If a sputum culture is no longer a defining feature of VAP, then is collecting the date of one in QA Infection VAP really reasonable in the first place? If it is not then this check can go away. See discussion at QA Infection VAP, just flagging it here.
31 October 2018 22:08:33Ttenbergen
NDC CLI unacceptable date
  • Is there a reason we are doing this at Pagasa's end rather than in CCMDB.mdb?


  • In ICD10 we will have Dx Date. Does that change how we want this query?
7 November 2018 00:29:20Ttenbergen
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:53Trish Ostryzniuk
S ICD10 Block Dxs table
  • There had been talk of you and Allan using these blocks; will you use them? If not we likely have no use for them and I will take them out. Ttenbergen 15:49, 2018 October 30 (CDT)
30 October 2018 20:49:48Ttenbergen
S ICD10 Blocks table
  • There had been talk of you and Allan using these blocks; will you use them? If not we likely have no use for them and I will take them out. Ttenbergen 15:49, 2018 October 30 (CDT)
30 October 2018 20:49:54Ttenbergen
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)
27 September 2018 21:26:24Ttenbergen
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?
9 November 2018 02:32:12Ttenbergen
Check VAP vs TISS ventilated 6 November 2018 23:49:53Ttenbergen
Check Function Panelling admit transfer same 14 November 2018 19:51:19JMojica
Chronic dependence on mechanical ventilator

absolute NEED for that, than I am to say that if you have THIS code, you should definitely NOT also have Respiratory failure (insufficiency) NOS, acute.

    • Defined check that Allan requested, but, Julie, how do you feel about the others?
27 October 2018 05:15:56Ttenbergen
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?
7 November 2018 00:50:27Ttenbergen
NDC Pacemaker acquired wo TISS
  • will this check still make sense and still be wanted in CCI/ICD10? If so, what is the check?
31 October 2018 23:35:06Ttenbergen
NDC Pacemaker TISS wo acquired
  • will this check still make sense and still be wanted in CCI/ICD10? If so, what is the check?
31 October 2018 23:35:03Ttenbergen
Trach Task
  • This task will no longer be collected once we move to ICD10/CCI. There are codes there, CCI Tracheostomy creation and ICD10 Tracheostomy, has one, Tracheostomy care and various tracheostomy complications. Will we want to move this data over or just keep it separate? Ttenbergen 19:26, 2018 October 25 (CDT)
30 October 2018 03:14:47Ttenbergen
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)
Do we need to make provision for any of the following in this cross check, or do we need other cross checks for them?
14 November 2018 17:51:24JMojica
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.
There are instructions relating to some of the pages in :Category:Awaiting/delayed transfer; consistency with this page needs to be confirmed.
How does Chronic Health Facility fit into this?
There was talk about compating Postal Codes to known PCH Postal Codes. Since these might Includes:ude 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.
27 October 2018 05:08:33Ttenbergen
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)25 September 2018 16:18:10Ttenbergen
Septic ShockI 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)25 September 2018 16:17:57Ttenbergen
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)
  • 27 October 2018 02:50:00Ttenbergen
    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:29Ttenbergen
    Check drugs vs TISSIs this being done in CFE or SAS at this point? Ttenbergen 20:04, 2018 October 26 (CDT)27 October 2018 01:04:59Ttenbergen
    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)14 November 2018 16:10:47Ttenbergen
    Check organ donors must be deadMight 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?27 October 2018 03:42:53Ttenbergen
    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:15Ttenbergen
    Check must have awaiting code if TransferReady DtTm and Dispo DtTm are on different daysOur definition for Transfer Delay uses a different threshold until it's considered a delay. Will that cause reporting inconsistencies?27 October 2018 04:58:05Ttenbergen
    Check Isolation Px vs Isolation DxWhen we move to CCI, Isolation-Task will be replaced by Isolation, infectious. Will this check make sense in that context and do we want to pursue it at that time?28 October 2018 20:04:33Ttenbergen
    Query s tmp QAInf LT 48 hrs after admitelsewhere we wrongly listed that we have a cross check that the date in tmp is checked/mandatory. This check currently doesn't test for mandatory date. Should it? The instructions in QA Infection CLI, QA Infection VAP make it look like it would be mandatory. Ttenbergen 10:35, 2018 September 25 (CDT)26 October 2018 20:52:29Ttenbergen
    Encephalopathy, septic or metabolicq
  • Does this category include hepatic encephalopathy--LKolesar 10:36, 2018 July 26 (CDT)
    • AG REPLY -- NO. For that use one of the above
      • Julie, this will mean losing the detail that encephalopathy was present. Does that matter to you at the data request end? Ttenbergen 15:36, 2018 September 6 (CDT)
  • 6 September 2018 20:36:11Ttenbergen


    Related Articles

    Related articles: