Duplicate code G0503 in `terminology__hcpcs_level_2`

[donaldrauscher]

Describe the bug - Required I'm getting some duplicates in core__procedure table which are coming from a merge in core__stg_claims_procedure. Specifically, on line 535, there is a join against terminology__hcpcs_level_2. there is exactly once HCPCS code which has multiple rows in the table: G0503. this merge is creating multiple rows for those claim lines, one with a populated normalized_description field, one which is NULL.

Environment - Required

• Tuva project package version (e.g. 0.6.0): 0.7.17
• dbt version (e.g. 1.7): 1.7.10
• dbt type (e.g. dbt cloud or dbt CLI): CLI
• Data warehouse (e.g. Snowflake): Databricks

Expected behavior Either terminology__hcpcs_level_2 should be unique at the HCPCS code level. Or, in core__stg_claims_procedure, the join logic should be amended to prevent duplicates. I wasn't sure if Tuva team had preferred approach. Let me know and I can implement and submit a PR. Thanks!

Screenshots

[sarah-tuva]

Hi @donaldrauscher, thank you so much for bringing this to our attention. We're looking into it now.

[sarah-tuva]

Hi @donaldrauscher, I was able to track down the issue. There was a line-breaking character in the original source for this seed file. You were lucky to find the only code affected by this. 😉

It will be corrected in the next release, 0.8.5 which will be coming out tomorrow.

[sarah-tuva]

Version 0.8.5 was released today and included a fix for this bug.