tuva
tuva copied to clipboard
tuva-health
Main repo including core data model, data marts, reference data, terminology, and the clinical concept library
Similar to acute IP and ED.
Similar in nature to acute IP and ED.
**Describe the bug - Required** found duplicate keys in location and practitioner causing issues on joining back to core.encounter. we should have dbt checks for pk uniqueness on all tuva...
From a Tuva user: - We ideally want to run tuva on top of postgres. This is primarily to combine w/ our transactional db (and where our other reporting data...
**Describe the bug** Bug reported by someone on [Slack](https://thetuvaproject.slack.com/archives/C03DET9ETK3/p1714058682433489). They are not able to use the post-hook macro to load seeds from S3 into their Databricks warehouse. > Struggling a...
## Describe your changes This resolves #337 by adding two new columns to` cms_hcc.patient_risk_scores`: `member_months` and `payment_risk_score_weighted_by_months`. The member months are derived from the finanicial_pmpm mart, specifically financial_pmpm.member_months, utilizing payment...
**Is your feature request related to a problem? Please describe.** Background from research: > There are two ways of aggregating risk scores: one in which risk scores are weighted by...
**Describe the bug** The [terminology__code_type.csv](https://github.com/tuva-health/tuva/blob/main/seeds/terminology/terminology__code_type.csv) seed file contains two entries for hcpcs codes; however, most our connectors and mapping logic map codes to a one code type `hcpcs`. We need...
**Environment - REQUIRED** * Tuva project package version (e.g. 0.6.0): [">=0.8.0","
**Describe the bug** I get an error for the elation_connector file elation_stage__medication_fill.sql. `ambiguous column name 'DAYS_SUPPLY'` **To Reproduce** 1. Clone elation_connector repo, install dbt, add profiles.yml to connect to your...
Metadata
Owner
Metadata
Main repo including core data model, data marts, reference data, terminology, and the clinical concept library