Thanks for flagging - I wonder if this is due to the fact that some people in your CDM have multiple rows in the DEATH table. Looking at the SQL for this check, the denominator uses a WHERE clause to limit the condition rows to those for persons with a death record; however, the numerator joins conditions directly to the death table, which will cause fanning if a person has multiple death records. This should be fixed; I will file an issue in GitHub.
Interestingly, it seems that there’s an active discussion ongoing re: whether or not we should allow multiple records per person in the death table. The CDM docs do currently say “A person can have up to one record” though.
I found it is hard to understand whether DQ checks are included in verification or validation. Is there a way to filter the validation check and verification check?
The UI doesn’t have a filter for this at the moment. You can look this up for each check in the Check Descriptions file (kahnContext
column).