I spoke with several people at the symposium about drill down feature of Achilles Heel but wanted to post this to the forum as well. (and start a general Achilles thread)
Some EMIF Achilles users and prior requests asked for ability to see (even be given SQL) to fix a given Heel error.
Note that this already is in current version 1.3. Just the web viewer of Achilles outputs has not caught-up.
The file above (is a preparation for ‘Within-Atlas’-Achilles-Web) feature that allows for drill downs. Note that not all drill downs are “in scope”. Only those that don’t require patient level data (no PHI is involved). (in CSV of type Achilles). For ETL developers, the file will contain (in the future Achilles version 1.4) also SQL that allows drill PHI level drill downs. (e.g., for the purpose of tuning ETL (or marking/documenting source data errors).
Also, notice that any Heel rule may have zero, one or multiple drill downs.
Data Quality in Sentinel model include Vital Sign data quality checks.
I implemented some of them in Achilles Heel but I would like to make sure I capture the correct concepts.
For example, Sentinel DQ check ID 248 looks at Ht, Wt, and BP.
Create Level 2 flags for invalid conversions (CheckID=248);
Check conversion from orig_result to ms_result_n;
proc format;
value Mcf
1 = “Ht, Wt, Dia, Sys all present”
2 = "Sys missing, all others present"
3 = "Dia missing, all others present"
4 = "Wt missing, all others present"
5 = "Ht missing, all others present"
6 = "Sys and Dia missing, Tt and Wt present"
7 = "Wt and Sys missing, Ht and Dia present"
8 = "Wt and Dia missing, Ht and Sys present"
9 = "Ht and Sys missing, Wt and Dia present"
10 = "Ht and Dia missing, Wt and Sys present"
11 = "Ht and Wt missing, Sys and Dia present"
Figure below shows one sample OMOP dataset concepts for those.
If you have EHR data outpatient measurements, which concepts do YOU use in your data? (otherwise, be prepared to get a notification from Achilles Heel until you submit your “favorite” concept_ids for those as reply here)
An update on the weight concept: I did an internal survey of several sites on how they capture weight. The implementation of sentinel DQ checks will focus on weight (since there is the best use case; drug dosing importance). The plan is to implement a DQ check for the following concept:
Hey Vojtech, Is there any way we can touch base next week? I’d like to get caught up on where things are and how I can get involved with this given the complementary work I’ll be doing with the FDA/IQVIA.
