the_tuva_project v0.15.3

What's Changed

🪲 Bug Fixes 🪲

• update input_layer__medical_claim.yml unique value count test so null… by @astern-et-al in #1081
• Removal of icd10_pcs_cms_ontology duplicate header row by @Nabin-Maitri in #1085
• Bug/person id crosswalk missing tuva last run by @Nabin-Maitri in #1090
• Update medical and pharmacy claim allowed amount checks by @krishyfishy in #1083
• Remove unsupported data type (databricks) by @krishyfishy in #1100
• fix: deduplicate source tables before joins in adhras_long by @chase-jones in #1087

Other Changes

• FIPS code missing for District of Columbia by @Nabin-Maitri in #1084
• Terminology/update icd 10 cm terminology set by @Nabin-Maitri in #1092
• Terminology/update icd 10 pcs terminology set by @Nabin-Maitri in #1093
• MDC and MS_DRG terminology data update by @BijayaShres in #1094
• Coderx weekly data update by @BijayaShres in #1095

New Contributors

• @astern-et-al made their first contribution in #1081

Full Changelog: v0.15.2...v0.15.3

the_tuva_project v0.15.2

What's Changed

🎉 Exciting New Features 🎉

• [Feature] add optional source input for quality measures mart by @sarah-tuva in #1060

🪲 Bug Fixes 🪲

• Databricks VARCHAR Data Type issue fix by @BijayaShres in #1061

Other Changes

• Removing diagnosis_code_voting by @gabecano4308 in #1055
• Adding coalesce to benchmark chronic condition features by @bradmontierth in #1062
• Providing correct variable on column type list wrapper by @chase-jones in #1072
• Data type should be sev 2 error level by @chase-jones in #1070
• Bug/undocumented fields in encounter table by @Nabin-Maitri in #1050
• Coderx weekly data by @BijayaShres in #1078
• updating ccs to latest year and updating joins to use year to join to… by @bradmontierth in #1069
• Terminology/update HCPCS_Level_II terminology by @Nabin-Maitri in #1074

Full Changelog: v0.15.1...v0.15.2

the_tuva_project v0.15.1

What's Changed

🪲 Bug Fixes 🪲

• fix: renamed the seed column names by @Nabin-Maitri in #1048
• Removing tests and duplicate file_date definitions by @tom-tuva in #1052
• [Bug] Add missing eligibility fields for docs by @sarah-tuva in #1039

Other Changes

• Prospective benchmarks by @bradmontierth in #1049
• Provider Terminology data update - September by @BijayaShres in #1054

Full Changelog: v0.15.0...v0.15.1

the_tuva_project v0.15.0

This is a minor release and includes breaking changes. See the below section "Critical Breaking Changes Summary" for more details and upgrade instructions.

What's Changed

🚨 Breaking Changes 🚨

• Minor release branch v0.15 by @sarah-tuva in #1000 includes the following PRs:
  • Add observation type seed and accepted values test by @krishyfishy in #975
  • State normalization pull through by @chase-jones in #1036
  • Terminology ms_drg_weights_los schema update by @BijayaShres in #896
  • Update data model for lab result by @sarah-tuva in #973
  • Immunization Table addition from Input to Core layer by @BijayaShres in #981
  • Add new clinical data model Appointment by @sarah-tuva in #1030
  • Addition of fields to the core.patient table by @Nabin-Maitri in #1032
  • Fix: Dx codes not flowing to core.condition when missing in terminology by @BijayaShres in #990
  • Fix: Procedure codes not flowing to core.procedure when missing in terminology by @BijayaShres in #1035
  • Add tests for PKs including data_source on claims tables by @davidshimamoto in #1018
  • ED Encounter Anchor Fix by @bradmontierth in #1031

🎉 Exciting New Features 🎉

• Update HCPCS code test, add threshold for PMPM by @krishyfishy in #1008
• Add claim type distribution check by @krishyfishy in #1028
• Updating claim types + adding test to check for claim type by @amartinson193 in #994
• Move some testing from older dqi into newer dqi by @ivy-tuva in #966
• Adding plan overlap test by @amartinson193 in #1006

🪲 Bug Fixes 🪲

• Point terminology meta configs to docs instead of GitHub by @krishyfishy in #1014
• Fixes inconsistent datatype for integration tests pharmacy_claim_seed by @davidshimamoto in #1025
• Removes date/datetime as options for "amount" field data types. by @davidshimamoto in #1027

Other Changes

• Update pull_request_template.md by @amartinson193 in #1007
• Add file date to med clms by @gabecano4308 in #1019
• Setting severity level to warn hcpcs_code input test by @chase-jones in #1033

New Contributors

• @gabecano4308 made their first contribution in #1019

Full Changelog: v0.14.18...v0.15.0

Critical Breaking Changes Summary

Required Actions:

1. Create 2 NEW input layer tables (required if clinical_enabled: true):

   • appointment (34 fields)
   • immunization (24 fields)

2. Add fields to EXISTING tables (required if claims_enabled: true OR clinical_enabled: true):

   • patient: Add name_suffix, middle_name, email, ethnicity
   • eligibility: Add name_suffix, middle_name, email, ethnicity

3. Update fields in the EXISTING table Lab Result (required if clinical_enabled: true):

   • rename fields:
     • source_code_type -> source_order_type
     • source_code -> source_order_code
     • source_description -> source_order_description
     • source_component -> source_component_code
     • normalized_code_type -> normalized_order_type
     • normalized_code -> normalized_order_code
     • normalized_description -> normalized_order_description
     • normalized_component -> normalized_component_code
     • result_date -> result_datetime (change data type to datetime)
     • collection_date -> collection_datetime (change data type to datetime)
   • add fields:
     • source_component_type
     • source_component_description
     • normalized_component_type
     • normalized_component_description
   • update custom mappings if using normalization mart

4. Expect pipeline warnings/errors from new data quality tests:

   • Many new tests added with warn and error severity
   • Fabric users: Tests previously disabled are now ENABLED
   • You may need to disable tests or fix data quality issues

See Docs for input layer changes.

Major Features:

• Appointment data
• Immunization/vaccine tracking (CVX codes)
• Lab Order/Component mapping
• Enhanced patient demographics
• Improved data quality framework (especially for Fabric)
• State normalization improvements

Important Clarifications:

• Fabric: Already supported, but now has comprehensive data quality tests enabled
• Bug fixes: Missing codes now properly flow to core tables

Migration Steps:

1. Update packages.yml to version 0.15.0 (or add a range version: [">=0.15.0","<0.16.0"])
2. Run dbt clean then dbt deps
3. If using clinical_enabled: true:
   i. Create new input models appointment and immunization and map your data or create empty tables
   ii. Update existing models lab_result and patient
4. If using claims_enabled: true, update existing model eligibility
5. Run dbt build --full-refresh
6. Review data_quality__testing_summary table
7. Fix/disable tests as needed
8. Verify downstream dependencies

the_tuva_project v0.14.18

What's Changed

🎉 Exciting New Features 🎉

• Inpatient merge logic by @bradmontierth in #965
• Add testing to check for overlap between medical claim / pharmacy claim and eligibility by @krishyfishy in #943

🪲 Bug Fixes 🪲

• Added try cast to prevent conversion errors by @thutuva in #968
• Fix duckdb seed loads to include the first row. by @davidshimamoto in #979
• Fixing typo by @amartinson193 in #982
• 970 | Creating de-duplication logic for patients in both claims and clinical by @chase-jones in #971
• Update accepted values on procedure code type by @krishyfishy in #997
• Add missing provider fields to dbt docs by @sarah-tuva in #999
• Add missing input layer fields by @krishyfishy in #1005

Other Changes

• Fixing data type inconsistency by @amartinson193 in #976
• Provider update for July 2025 by @sarah-tuva in #1011

Full Changelog: v0.14.17...v0.14.18

the_tuva_project v0.14.17

What's Changed

🎉 Exciting New Features 🎉

• Update LOINC terminology by @sarah-tuva in #961
• Load SVI Seed Data from S3 by @BijayaShres in #935

🪲 Bug Fixes 🪲

• Benchmarking fix by @bradmontierth in #963
• Fix apr_drg terminology by @utsavpaudel in #962

Other Changes

• Remove old docs folder by @sarah-tuva in #959

Full Changelog: v0.14.16...v0.14.17

the_tuva_project v0.14.16

What's Changed

🎉 Exciting New Features 🎉

• Coderx weekly data by @utsavpaudel in #934
• Adding risk adjusted benchmark mart by @bradmontierth in #938

🪲 Bug Fixes 🪲

• Change where exists to join criteria by @chase-jones in #950
• Fix PMPM Prep pk by @krishyfishy in #952
• Adjust metadata schema to account for target schema config. by @davidshimamoto in #955

Other Changes

• New terminologies data by @utsavpaudel in #944
• Updated Descriptions for Input Layer Data Dictionary by @ivy-tuva in #957

New Contributors

• @ivy-tuva made their first contribution in #957

Full Changelog: v0.14.15...v0.14.16

the_tuva_project v0.14.15

What's Changed

🎉 Exciting New Features 🎉

• 932 if encounters between claims and clinical datasets overlap ie adt both encounter get thrown out in readmissions by @chase-jones in #933
• Add enhancements for CI Testing data by @sarah-tuva in #929

🪲 Bug Fixes 🪲

• Fixing MDC value bug by @tom-tuva in #931

Other Changes

• Provider Terminology data update - June by @utsavpaudel in #939

Full Changelog: v0.14.14...v0.14.15

the_tuva_project v0.14.14

What's Changed

🎉 Exciting New Features 🎉

• Service encounter cleanup by @bradmontierth in #904
• Split SQL files to reduce memory load by @amartinson193 in #909
• Update elementary version by @chase-jones in #908
• Split SQL files to reduce memory load for claims by @amartinson193 in #910
• Bill type code multiple not sev 1 by @chase-jones in #922

🪲 Bug Fixes 🪲

• Fix uniqueness check on input_layer__eligibility to include member_id by @davidshimamoto in #905
• Make sure we only get ICD-10-PCS codes in CCSR long procedure category by @krishyfishy in #897

Other Changes

• Update description to match the databases we support by @chase-jones in #899
• fix 3 additional broken slack links by @jansenpa in #902
• HCPCS/CPT value set update for CMS HCC data mart by @utsavpaudel in #906

New Contributors

• @amartinson193 made their first contribution in #909

Full Changelog: v0.14.13...v0.14.14

the_tuva_project v0.14.13

What's Changed

🎉 Exciting New Features 🎉

• Add fhir_preprocessing data mart by @sarah-tuva in #863
• Add duckdb support to create_json_object macro by @sarah-tuva in #890

🪲 Bug Fixes 🪲

• Update revenue center code regex to handle more 4-char codes by @krishyfishy in #893
• Fix enrollment being exploded to row per member-month. Adjust testing on PK. by @davidshimamoto in #885

Other Changes

• Encounter optimization by @bradmontierth in #874

Full Changelog: v0.14.12...v0.14.13