the_tuva_project v0.18.0

This is the stable release for 0.18.0

What's Changed

🚨 Breaking Changes 🚨

• [BREAKING CHANGE] 1203 update facility id to facility npi by @chase-jones in #1262
• [Breaking Change] 1270 add 9 nullable columns to core eligibility for cms risk adjustment part cd aca esrd by @chase-jones in #1271

Other Changes

• Switch CI to run/build command routing by @aneiderhiser in #1276
• Reorganize core platform docs and model folders by @aneiderhiser in #1278
• Update getting started DuckDB demo runbook by @aneiderhiser in #1279
• Update CMS HCC Not Null Test from Error to Warning by @amartinson193 in #1284
• Add DoltHub seed publish flow and versioned S3 loading by @aneiderhiser in #1287
• Add official Tuva maintainers docs page by @aneiderhiser in #1308
• Add data quality summary models by @aneiderhiser in #1312
• Recover missing PR changes dropped after #1312 by @aneiderhiser in #1313
• Refactor data quality models and connector guidance by @aneiderhiser in #1316
• Update data quality models and seed assets by @aneiderhiser in #1317
• Refresh integration seed pins and provider widths by @aneiderhiser in #1322
• Bump version to 0.18.0 by @aneiderhiser in #1326

Full Changelog: v0.17.1...v0.18.0

the_tuva_project v0.18.0-rc

This is the release candidate for 0.18.0

What's Changed

🚨 Breaking Changes 🚨

• [BREAKING CHANGE] 1203 update facility id to facility npi by @chase-jones in #1262
• [Breaking Change] 1270 add 9 nullable columns to core eligibility for cms risk adjustment part cd aca esrd by @chase-jones in #1271

Other Changes

• Switch CI to run/build command routing by @aneiderhiser in #1276
• Reorganize core platform docs and model folders by @aneiderhiser in #1278
• Update getting started DuckDB demo runbook by @aneiderhiser in #1279
• Update CMS HCC Not Null Test from Error to Warning by @amartinson193 in #1284
• Add DoltHub seed publish flow and versioned S3 loading by @aneiderhiser in #1287
• Add official Tuva maintainers docs page by @aneiderhiser in #1308
• Add data quality summary models by @aneiderhiser in #1312
• Recover missing PR changes dropped after #1312 by @aneiderhiser in #1313
• Refactor data quality models and connector guidance by @aneiderhiser in #1316
• Update data quality models and seed assets by @aneiderhiser in #1317
• Refresh integration seed pins and provider widths by @aneiderhiser in #1322
• Bump version to 0.18.0 by @aneiderhiser in #1326

Full Changelog: v0.17.1...v0.18.0

the_tuva_project v0.17.2

Highlights

• Tuva Data Assets on DoltHub: Tuva data assets are now organized as 6 versioned databases on DoltHub: terminology, value sets, reference data, provider data, concept library, and synthetic data. DoltHub is now the release source of truth, while S3, GCS, and Azure Blob remain the distribution layer used by the existing seed-loading macros.
• Versioned Seed Releases: Package seeds and synthetic integration-test inputs now load from versioned release artifacts that have been copied to S3/Azure/GCS from DoltHub. Releases can be controlled with tuva_seed_version, per-database overrides via tuva_seed_versions, and storage overrides via tuva_seed_buckets.
• CI Improvements: CI now uses dbt-style command routing instead of alias-style commands. For example, /ci dbt build --full-refresh runs across all 6 warehouses, while /ci snowflake dbt run or /ci redshift dbt run --select core__medical_claim target specific warehouses and selections.
• Docs in the Tuva Repo: The docs site now lives in the tuva repo under docs, which keeps docs closer to the code and metadata they describe.

Input Layer

• No net new breaking input-layer contract changes relative to v0.17.1.
• Input-layer YAML definitions now include clearer mapping_instructions and required_for_data_marts metadata.

Data Mart Updates

• CMS-HCC Institutional Logic: institutional_status is now derived from long_term_institutional_flag, improving institutional classification in CMS-HCC workflows.

Bug Fixes

• BigQuery Seed Loading: BigQuery now handles both empty-string nulls and \N null markers in release-backed CSV artifacts.
• DuckDB Provider Attribution: Fixed a DuckDB planner issue affecting provider attribution workflows.

Miscellaneous

• integration_tests is Synthetic-Only: integration_tests now runs only against published synthetic datasets, with small as the default size and large also available.
• Header-Only Synthetic Seed Files: Local CSVs in integration_tests/seeds are now header-only; dbt seed hydrates them from published versioned synthetic artifacts.
• Seed Publishing Tooling: Added scripts to publish DoltHub-backed seed releases to S3 and mirror them to GCS and Azure.

the_tuva_project v0.17.2-rc

Highlights

• Tuva Data Assets on DoltHub: Tuva data assets are now organized as 6 versioned databases on DoltHub: terminology, value sets, reference data, provider data, concept library, and synthetic data. DoltHub is now the release source of truth, while S3, GCS, and Azure Blob remain the distribution layer used by the existing seed-loading macros.
• Versioned Seed Releases: Package seeds and synthetic integration-test inputs now load from versioned release artifacts that have been copied to S3/Azure/GCS from DoltHub. Releases can be controlled with tuva_seed_version, per-database overrides via tuva_seed_versions, and storage overrides via tuva_seed_buckets.
• CI Improvements: CI now uses dbt-style command routing instead of alias-style commands. For example, /ci dbt build --full-refresh runs across all 6 warehouses, while /ci snowflake dbt run or /ci redshift dbt run --select core__medical_claim target specific warehouses and selections.
• Docs in the Tuva Repo: The docs site now lives in the tuva repo under docs, which keeps docs closer to the code and metadata they describe.

Input Layer

• No net new breaking input-layer contract changes relative to v0.17.1.
• Input-layer YAML definitions now include clearer mapping_instructions and required_for_data_marts metadata.

Data Mart Updates

• CMS-HCC Institutional Logic: institutional_status is now derived from long_term_institutional_flag, improving institutional classification in CMS-HCC workflows.

Bug Fixes

• BigQuery Seed Loading: BigQuery now handles both empty-string nulls and \N null markers in release-backed CSV artifacts.
• DuckDB Provider Attribution: Fixed a DuckDB planner issue affecting provider attribution workflows.

Miscellaneous

• integration_tests is Synthetic-Only: integration_tests now runs only against published synthetic datasets, with small as the default size and large also available.
• Header-Only Synthetic Seed Files: Local CSVs in integration_tests/seeds are now header-only; dbt seed hydrates them from published versioned synthetic artifacts.
• Seed Publishing Tooling: Added scripts to publish DoltHub-backed seed releases to S3 and mirror them to GCS and Azure.

the_tuva_project v0.17.1

What's Changed

🎉 Exciting New Features 🎉

• Add SNPNE (SNP New Enrollee) scoring model support by @chase-jones in #1254

🪲 Bug Fixes 🪲

• Fix typo: desription → description in intermediate_models.yml by @chase-jones in #1224
• Exclude New Enrollees from disease factor scoring by @chase-jones in #1223
• Implement V28 heart interaction patch zero CC223 when isolated by @chase-jones in #1222
• Add reason column to hcc_recapture__int_all_hccs uniqueness test by @chase-jones in #1258
• Fix OREC=2 (ESRD) members under 65 incorrectly assigned Aged model by @chase-jones in #1265
• Gate disabled interaction factors by DISABL flag by @chase-jones in #1268

Other Changes

• Agent Update by @aneiderhiser in #1208
• Remove legacy HEDIS marts and integration test artifacts by @aneiderhiser in #1209
• updated docs by @aneiderhiser in #1210
• Fix/extension columns claims-only guard & core model enabled config by @rabee05 in #1213
• Update Missing Model from the HCC Suspecting Models Documentation by @andreas-homeward in #1215
• Adding warning for missing/blank facility NPI fields by @andreas-homeward in #1217
• Add deterministic Tuva dev workflow + outside PR bridge mode by @aneiderhiser in #1227
• Add per-database concurrency groups to CI workflows to prevent conflicts by @chase-jones in #1229
• [outside-pr 1219] [Bug Fix] add data_source to exclude list for unpivot in data_quality__readmissions by @aneiderhiser in #1228
• Cast tuva_last_run to timestamp in core__stg_claims_pharmacy_claim by @chase-jones in #1230
• Filter CMS-HCC eligibility staging to Medicare records only (#1145) by @chase-jones in #1233
• Handle empty pharmacy/medical claim tables in plan overlap test by @chase-jones in #1231
• Update cms_hcc__cpt_hcpcs seed file to copy prior year by @andreas-homeward in #1218
• Strip decimal points from ICD codes before DQI terminology lookups by @chase-jones in #1232
• Include source_code_type in procedure_id to prevent PK violations (#1114) by @chase-jones in #1238
• Include source_code_type in condition_id to prevent PK violations (#1110) by @chase-jones in #1239
• Fix OREC/disabled model classification per CMS SAS DISABL/ORIGDS logic (#1002) by @chase-jones in #1240
• Remove ESRD enrollment_status override that excludes OREC=2/3 members by @chase-jones in #1242
• Relax disease/interaction/hcc-count factor seed joins for institutional model by @chase-jones in #1243
• Convert latitude and longitude columns from float to numeric by @chase-jones in #1241
• Add dbt variable reference documentation to README by @chase-jones in #1245
• Skip seed population check for non-build dbt commands by @chase-jones in #1247
• 866 dqi test for diagnosis codes were not unique at the claim header level by @chase-jones in #1244
• 923 align los calculation with cms definition by @chase-jones in #1246
• Preserve file_date as timestamp instead of casting to date by @chase-jones in #1249
• Add ICD-9-CM normalization to core conditions staging model by @chase-jones in #1252
• Defer monthly collection date expansion in eligible conditions by @chase-jones in #1253
• Accept CDT dental codes (Dxxxx) in DQI HCPCS validation by @chase-jones in #1248
• Add 3-mode PR CI with Snowflake-small default and /ci mode commands by @aneiderhiser in #1260
• Add ingest_datetime to core.medical_claim and core.pharmacy_claim by @chase-jones in #1263
• Fix duplicate CI runs by dispatching mode changes by @aneiderhiser in #1266
• Bump dbt package version to 0.17.1 by @aneiderhiser in #1273

New Contributors

• @andreas-homeward made their first contribution in #1215

Full Changelog: v0.17.0...v0.17.1

the_tuva_project v0.17.0

What's Changed

• Feature/add extension column pass-through support for core models by @rabee05 in #1191
• Fix observation staging for claims-only logic by @sarahmcmorgan in #1199

New Contributors

• @rabee05 made their first contribution in #1191

Full Changelog: v0.16.2...v0.17.0

the_tuva_project v0.16.2

What's Changed

Improvements

• HCC Conditions: Updated conditions to capture previously missing diagnosis by @amartinson193 in #1175
• CI Updates: Completely revamped CI by @aneiderhiser in #1193

🪲 Bug Fixes 🪲

• Fixed numeric min for hierarchy top-level by @bradmontierth in #1194
• Fixed Redshift / Snowflake Discrepancy by @aneiderhiser in #1197

Full Changelog: v0.16.1...v0.16.2

the_tuva_project v0.16.1

What's Changed

Other Changes

• Create the HCC Recapture Mart by @amartinson193 in #1190
• updated version number to 0.16.1 by @aneiderhiser in #1192

Full Changelog: v0.16.0...v0.16.1

the_tuva_project v0.16.0

What's Changed

🚨 Breaking Changes 🚨

• Update test criteria for warn_if_null_percentage_above_zero by @krishyfishy in #1178
• Refactor encounters__combined_claim_line_crosswalk by @krishyfishy in #1169
• Update project to require dbt version >=1.10.0 by @krishyfishy in #1183

🎉 Feature Enhancements 🎉

• Add payer column to cms hcc by @amartinson193 in #1121
• Performance improvements for claims_enrollment__member_months by @krishyfishy in #1163
• CMS-HCC Mart Accuracy Improvement by @amartinson193 in #1173
• Add data_source to key tables of interest by @krishyfishy in #1157
• added hedis measures output mart by @aneiderhiser in #1180

🪲 Bug Fixes 🪲

• 1165 redshift error failed to find conversion function from unknown to character varying by @chase-jones in #1166
• Pull through patient ID on core__medication by @krishyfishy in #1182

Other Changes

• Updates to Input Layer and Core YML Files by @aneiderhiser in #1149
• Coderabbit config for open source by @chase-jones in #1167
• removed claims_expanded and renamed provider_attribution by @aneiderhiser in #1176
• Minor fixes by @aneiderhiser in #1188
• Duckdb semantic layer by @jansenpa in #1171
• Updated Tuva Package Version Number to 0.16.0 by @aneiderhiser in #1189

Critical Breaking Changes Summary

Required Actions:

1. Add fields to EXISTING tables (required if claims_enabled: true):

   • eligibility: Add hospice_flag, institutional_snp_flag, long_term_institutional_flag, enrollment_status

2. Upgrade dbt to 1.10.0

Full Changelog: v0.15.5...v0.16.0

the_tuva_project v0.15.5

What's Changed

🎉 Exciting New Features 🎉

• Check disable dbt invocation elementary variable by @chase-jones in #1132
• Add file name to core.medical_claim, core.pharmacy_claim, core.eligibility by @krishyfishy in #1144
• updates to outside contributor CI by @chase-jones in #1148
• Officially support Databricks by @chase-jones in #1141
• Official support of Duckdb by @chase-jones in #1142
• AWS Athena Compatibility Updates by @sah129 in #1146

🪲 Bug Fixes 🪲

• Change dbt-data-reliability revision to v0.18.4 by @chase-jones in #1155

Other Changes

• Redshift Serverless ci testing by @chase-jones in #1125
• Update CI to use Redshift Serverless by @chase-jones in #1130

Full Changelog: v0.15.4...v0.15.5