tuva icon indicating copy to clipboard operation
tuva copied to clipboard

PK, Medical Claim Basic Dates & Medical Claim Patient_ID data quality checks

Open hunter-muse opened this issue 4 months ago • 0 comments

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 & Patient_ID checks look at the Medical Claim core data model.

How has this been tested?

I ran this code in Snowflake using the CMS_SYNTHETIC._TUVA_CLAIMS data tables.

Reviewer focus

Please review if these checks pass the data quality needs, and if they pass the SQL standards that Tuva has.

Checklist before requesting a review

  • [x] I have added at least one Github label to this PR (bug, enhancement, breaking change,...)
  • [ ] 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

hunter-muse avatar Oct 03 '24 18:10 hunter-muse