Please include a summary of any changes.
Updated the where clause in cms_hcc__int_members to include all members that had eligibility during the relevant time period. It had previously excluded members that had enrollment spanning beyond the payment or collection year (i.e., they had multiple years of uninterrupted enrollment).
How has this been tested?
Please describe the tests you ran to verify your changes. Provide instructions or code to reproduce output.
Locally using dbt run
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
Please include a summary of any changes. Updated the where clause in cms_hcc__int_members to include all members that had eligibility during the relevant time period. It had previously excluded members that had enrollment spanning beyond the payment or collection year (i.e., they had multiple years of uninterrupted enrollment).
How has this been tested?
Please describe the tests you ran to verify your changes. Provide instructions or code to reproduce output. Locally using dbt run
Reviewer focus
Please summarize the specific items you’d like the reviewer(s) to look into.
Checklist before requesting a review
tuva_last_runto the final outputPackage release checklist
dbt_project.yml(Optional) Gif of how this PR makes you feel
Loom link