2. Input Layer
Here we document the Input Layer. The Input Layer is like the API for the Tuva Project. It's designed to accomodate both claims and clinical data sources. Once raw data sources (e.g. claims and medical records) are mapped to the Input Layer the rest of the Tuva Project runs automatically (i.e. core data model and all the data marts).
Click on any row in the data dictionaries below to expand the row and read a longer description with additional context about the column.
Claims Input
The Claims Input Layer is used for mapping data sources you would typically receive from a payer including medical and pharmacy claims, eligibility (also known as enrollment), and provider attribution data.
To use the Claims Input Layer tables, you must set the dbt variable claims_input_enabled to true.
eligibility
| Column Name | Data Type | Primary Key | Description |
|---|
medical_claim
| Column Name | Data Type | Primary Key | Description |
|---|
pharmacy_claim
| Column Name | Data Type | Primary Key | Description |
|---|
provider_attribution
To use the provider_attribution table, you must set the dbt variable provider_attribution_enabled to true.
| Column Name | Data Type | Primary Key | Description |
|---|
Clinical Input
The Clinical Input Layer is used for mapping clinical data sources, including EHR, HIE data via FHIR APIs, ADT messages, and lab results.
To use the Clinical Input Layer tables, you must set the dbt variable clinical_input_enabled to true.
appointment
| Column Name | Data Type | Primary Key | Description |
|---|
condition
| Column Name | Data Type | Primary Key | Description |
|---|
encounter
| Column Name | Data Type | Primary Key | Description |
|---|
lab_result
| Column Name | Data Type | Primary Key | Description |
|---|
immunization
| Column Name | Data Type | Primary Key | Description |
|---|
location
| Column Name | Data Type | Primary Key | Description |
|---|
medication
| Column Name | Data Type | Primary Key | Description |
|---|
observation
| Column Name | Data Type | Primary Key | Description |
|---|
patient
| Column Name | Data Type | Primary Key | Description |
|---|
practitioner
| Column Name | Data Type | Primary Key | Description |
|---|
procedure
| Column Name | Data Type | Primary Key | Description |
|---|