Input Layer
The Input Layer is like the API for the Tuva data model. Once raw data sources (e.g. claims and medical records) are mapped to the Input Layer code automatically transforms that data into the Tuva data model (i.e. core data model and all the data marts).
The Input Layer is designed to accomodate both claims and clinical data sources.
Claims Input
eligibility
The eligibility table includes information about a patient's health insurance coverage and demographics (note: we use the word patient as a synonym for member). Every claims dataset should include some sort of eligibility data, otherwise it's impossible to calculate member months, which are needed to calculate measures like PMPM. Each record in the table is intended to represent a unique eligibility (i.e. enrollment) span for a patient with a specific health plan.
Primary Key:
- patient_id
- plan
- enrollment_start_date
- enrollment_end_date
| Column | Data Type | Description | Terminology |
|---|
medical_claim
The medical_claim table contains information on healthcare services and supplies provided to patients, billed by providers, and paid for by health insurers. It includes information on the provider who rendered the service, the amount paid for the service by the health insurer, and the underlying reason for the service (i.e. diagnosis). Each record in the table is intended to represent a unique claim line.
Primary Key:
- claim_id
- claim_line_number
Foreign Keys:
- patient_id
- member_id
| Column | Data Type | Description | Terminology |
|---|
pharmacy_claim
The pharmacy_claim table includes information about retail and specialty drug prescriptions that have been filled by a patient, billed by a pharmacy, and paid by an insurer. Each record in the table is intended to represent a unique claim line.
Primary Key:
- claim_id
- claim_line_number
Foreign Keys:
- patient_id
- member_id
| Column | Data Type | Description | Terminology |
|---|
Clinical Input
condition
The condition table contains information related to medical conditions patients have, including problems and billable diagnosis codes. Each record in the table is intended to document the occurrence of a unique condition for a specific patient at a specific point in time.
Primary Key:
- condition_id
Foreign Keys:
- patient_id
- encounter_id
| Column | Data Type | Description | Terminology |
|---|
encounter
The encounter table contains information about patients visits (i.e. encounters). This includes office visits from clinical sources. Each record in the encounter table is intended to represent a unique patient visit with a healthcare provider of a unique type (e.g. acute inpatient).
Primary Key:
- encounter_id
Foreign Keys:
- patient_id
| Column | Data Type | Description | Terminology |
|---|
lab_result
The lab result table contains information about lab test results, including the LOINC code and description, units, reference range, and result. Each record in the table is intended to represent a unique lab result.
Primary Key:
- lab_result_id
Foreign Keys:
- patient_id
- encounter_id
| Column | Data Type | Description | Terminology |
|---|
location
The location table contains information on practice and facility locations where patients receive medical care. Each record in the table is intended to represent a unique location.
Primary Keys:
- location_id
| Column | Data Type | Description | Terminology |
|---|
medication
The medication table contains information on medications ordered and/or administered during a patient encounter. Each record in the table is intended to represent a unique order or administration of a medication to a patient.
Primary Key:
- medication_id
Foreign Keys:
- patient_id
- encounter_id
| Column | Data Type | Description | Terminology |
|---|
observation
The observation table contains information on measurements other than lab tests e.g. blood pressure, height, and weight. Each record in the table is intended to represent a unique observation.
Primary Keys:
- observation_id
Foreign Keys:
- patient_id
- encounter_id
| Column | Data Type | Description | Terminology |
|---|
patient
The patient table contains demographic and geographic information on patients. Each record in the table is intended to represent a unique patient.
Primary Key:
- patient_id
| Column | Data Type | Description | Terminology |
|---|
practitioner
The practitioner table contains information on the providers in the dataset (e.g. physicians, physicians assistants, etc.). Each record in the table is intended to represent a unique provider.
Primary Key:
- practitioner_id
| Column | Data Type | Description | Terminology |
|---|
procedure
The procedure table contains information on procedures that were performed on patients in the dataset. Each record in the table is intended to represent a unique procedure performed on a unique patient by a unique provider at a unique time.
Primary Key:
- procedure_id
Foreign Keys:
- patient_id
- encounter_id
- practitioner_id
| Column | Data Type | Description | Terminology |
|---|