Medicare BCDA Connector

🔗  Docs

Check out our docs to learn about the project and how you can use it.

🧰  What does this repo do?

The Medicare BCDA Connector is a dbt package that maps Medicare BCDA claims data to the Tuva claims data model which then makes it simple to run the entire Tuva Project.

🔌 Database Support

• BigQuery
• Redshift
• Snowflake
  
  

✅  Quickstart Guide

Step 1: Import package

Import the package by adding it to your packages.yml. Click this link to see an example.

Step 2: Set vars

Add two vars to your project.yml:

• bcda_coverage_file_prefix: your-string-here
  • This var contains a string that matches the text before the date in your coverage file.
• claims_enabled: true
  • This allows you to run The Tuva Project.
    
    

Step 3: Configure Data Source

Add models to your project to select all the data from these tables:

• coverage
• coverage_extension
• explanationofbenefit
• explanationofbenefit_benefitbalance_0_financial
• explanationofbenefit_careteam
• explanationofbenefit_diagnosis
• explanationofbenefit_extension
• explanationofbenefit_item_0_adjudication
• explanationofbenefit_item_0_extension
• explanationofbenefit_procedure
• explanationofbenefit_supportinginfo
• patient
• patient_identifier
  
  

🤝 Join our community!

Join our growing community of healthcare data practitioners on Slack!