New Quality Measure: Medication Adherence for Diabetes

[utsavpaudel]

Describe your changes

Implemented Quality Measure ADH-Diabetes: Medication Adherence for Diabetes according to the specification document.

How has this been tested?

Ran dbt build against Snowflake and BigQuery. Additionally, a validation document has been prepared to manually test models output in tuva_synthetic db

Reviewer focus

Since days_supply field is null across pharmacy_claim table in synthetic data, logic has been drafted with assumption that multiple refills of same prescription are not filled simultaneously, but around/after the end of existing fill. Please verify on real data.

Checklist before requesting a review

• [ ] I have added at least one Github label to this PR (bug, enhancement, breaking change,...)
• [x] My code follows style guidelines
• [x] (New models) YAML files are categorized by sub folder and models listed in alphabetical order
• [x] (New models) I have added a config to each new model to enable it for claims and/or clinical data
• [x] (New models) I have added the variable tuva_last_run to the final output
• [ ] (Optional) I have recorded a Loom to explain this PR

Package release checklist

• [ ] I have updated dbt docs
• [ ] I have updated the version number in the dbt_project.yml

(Optional) Gif of how this PR makes you feel

Loom link

[github-actions[bot]]

Workflow has finished with the following statuses:

• Snowflake: success

• Snowflake: success

• Snowflake: success

• Redshift: failure

• Redshift: skipped

• Redshift: skipped

• BigQuery: failure

• BigQuery: skipped

• BigQuery: skipped

[github-actions[bot]]

Workflow has finished with the following statuses:

• Snowflake: success

• Snowflake: success

• Snowflake: success

• Redshift: failure

• Redshift: skipped

• Redshift: skipped

• BigQuery: failure

• BigQuery: skipped

• BigQuery: skipped

[github-actions[bot]]

Workflow has finished with the following statuses:

• Snowflake: success

• Snowflake: success

• Snowflake: success

• Redshift: failure

• Redshift: skipped

• Redshift: skipped

• BigQuery: success

• BigQuery: success

• BigQuery: success

[github-actions[bot]]

Workflow has finished with the following statuses:

• Snowflake: success

• Snowflake: success

• Snowflake: success

• Redshift: success

• Redshift: success

• Redshift: success

• BigQuery: success

• BigQuery: success

• BigQuery: success

[thutuva]

@utsavpaudel Thank you for making those changes. CI testing has passed so I will merge your PR into main. Great work!

CC @sarah-tuva