Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Achilles Heel test for era building #196

Closed
schuemie opened this issue Jan 30, 2015 · 0 comments
Closed

Achilles Heel test for era building #196

schuemie opened this issue Jan 30, 2015 · 0 comments
Assignees
Labels
new check New DQ check to be added
Projects

Comments

@schuemie
Copy link
Member

There are currently no test for whether the era building went OK, even though it is easy to make mistakes there.

I'm currently using a simple test: I'm comparing the results of these two queries:

SELECT DISTINCT person_id, condition_concept_id FROM condition_occurrence;
SELECT DISTINCT person_id, condition_concept_id FROM condition_era;

and they should be identical. (It would be easy to test this through a join I guess). If that doesn't scale to bigger databases, at least we could count the number of people with a condition and compare those counts.
For drug_era we'd first need to map to ingredients, but otherwise it would be the same.

@fdefalco fdefalco transferred this issue from OHDSI/Achilles Jan 26, 2021
@fdefalco fdefalco self-assigned this Mar 15, 2021
@clairblacketer clairblacketer added the new check New DQ check to be added label Mar 2, 2022
@clairblacketer clairblacketer added this to New Checks in Version_2 Mar 10, 2022
Version_2 automation moved this from New Checks to Done Oct 11, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
new check New DQ check to be added
Projects
Version_2
  
Done
Development

No branches or pull requests

4 participants