Add group by to summary wide table to ensure one record per patient.
Refactor measure-specific long tables to denominator grain.
Add dbt utils union function to summary long and include join to core.patient to ensure every patient has a record in this table regardless of qualifying for a measure.
How has this been tested?
Ran dbt build and validated output.
Reviewer focus
Please summarize the specific items you’d like the reviewer(s) to look into.
Checklist before requesting a review
[x] I have added at least one Github label to this PR (bug, enhancement, breaking change,...)
Describe your changes
How has this been tested?
Ran
dbt build
and validated output.Reviewer focus
Please summarize the specific items you’d like the reviewer(s) to look into.
Checklist before requesting a review
tuva_last_run
to the final outputPackage release checklist
dbt_project.yml
(Optional) Gif of how this PR makes you feel
Loom link