tuva
tuva copied to clipboard
Main repo including core data model, data marts, reference data, terminology, and the clinical concept library
https://www.loom.com/share/dbbf66134d254606b334707cdcc444e6?sid=724b6c39-2bd8-4e50-a265-d9bccb063b84
**Is your feature request related to a problem? Please describe.** This measure includes four submission criteria. Criteria 1-3 were implemented in PR #492. Criteria #4 was not able to be...
**Is your feature request related to a problem? Please describe.** In many analytical contexts, users want to bring fields outside the standard data model for slicing and dicing downstream: -...
## Describe your changes Added 3 data quality tests to the core models. The PK model checks the uniqueness of primary keys across core data models. The Basic Dates &...
## Describe your changes Added provider attribution input layer table ## How has this been tested? Tested locally with synthetic provider attribution data. ## Reviewer focus Please summarize the specific...
## Describe your changes Implemented Quality Measure ADH-Diabetes: Medication Adherence for Diabetes according to the [specification document](https://www.cms.gov/files/document/2024-star-ratings-technical-notes.pdf#page=98). ## How has this been tested? Ran `dbt build` against Snowflake and BigQuery....
## Describe your changes Please include a summary of any changes. Added two new models for data quality: - claim count by date field - diagnosis and procedure analysis Resolves...
Add the following models (fully defined [here](https://docs.google.com/spreadsheets/d/14Khu7jwslLFRqwrfKf6QSPUt5pzkwCmpn8jskACOBJ8/edit?gid=1671764009#gid=1671764009)): - Count of distinct claims by year-month for each date field - This table is the count of distinct claims that have these...
## Describe your changes Implemented Medication Adherence for Hypertension (ADH-RAS) based on [CMS Star Documentation](https://www.cms.gov/files/document/2024-star-ratings-technical-notes.pdf#page=101). ## How has this been tested? `dbt build` has been run for **Snowflake** and **BigQuery**....