tuva

tuva copied to clipboard

**Describe the bug** I think effectively, the pattern for loading to everything except snowflake from s3/gcs is s3://{uri}/{patten}}.* where snowflake is s3://{uri}.*/{patten}}.* this makes it so if we add another...

tuvaforrest

**Describe the bug** A community member is having [trouble](https://thetuvaproject.slack.com/archives/C03DET9ETK3/p1714656528015309) in postgres wtih the try_to_cast_date() function, and can't override it with a dispatch macro. I think its because we don't give...

tuvaforrest

**Describe the bug** financial_pmpm in redshift (and likely postgres) is not building individual member months for pharmacy, only grouping all spend under a null member month financial_pmpm__patient_spend_with_service_categories.sql has [this](https://github.com/tuva-health/tuva/blob/f3a8866d3dadea7b4daf62126139a4e2a62ee174/models/financial_pmpm/intermediate/financial_pmpm__patient_spend_with_service_categories.sql#L41) line....

tuvaforrest

**Is your feature request related to a problem? Please describe.** The [CMMI-HCC risk adjustment model](https://www.cms.gov/files/document/aco-reach-py2024-risk-adjustment.pdf) applies to the High Needs ACO REACH population. >In ACO REACH, risk adjustment is used...

sarah-tuva

**Is your feature request related to a problem? Please describe.** CMS is transitioning from v24 to v28 over the next two years. Orgs will be running both models until payment...

sarah-tuva

Rename name in dbt_project.yml to Tuva

1

Let's start referring to Tuva repo (previously named the Tuva Project) as Tuva. The repo was already renamed a few weeks ago. The broader name the Tuva Project will continue...

aneiderhiser

thetuvaproject.com pulls from dbt docs from the Tuva Project. It's a pain to manually generate the docs and move them to the correct folders every time we do a PR...

aneiderhiser

Spike: Investigate new synthetic medicare claims dataset

1

This new dataset could be great for demoing the Tuva Project. We should investigate whether this is the case, by loading it into Snowflake and assessing if it has the...

aneiderhiser

aneiderhiser

The `long_procedure_category` table in the CCSR data mart is missing the foreign key `claim_id`. It only has `encounter_id` which is only populated for certain encounter types.

sarah-tuva