Core Data Model
The core data model is the foundation of the Tuva data model. It contains foundational concepts upon which higher-level data marts are created. The core data model is similar to the Input Layer, but contains several important transformations. Some examples include:
- Standard terminologies are normalized
- Claims are grouped into encounters and assigned service categories
- Conditions and procedures are pivoted out into "long" tables
condition
A condition is any sort of symptom, problem, complaint, admitting diagnosis, or billing diagnosis as reported by the patient, a clinician, or as otherwise generated (e.g. by the billing process). Key ancillary data related to condition includes the date it was reported, it's rank (i.e. primary or secondary), and whether or not it was present during admission for an acute inpatient encounter.
Conditions can only be generated during encounters (i.e. every condition must have an encounter_id).
Primary Keys:
- condition_id
Foreign Keys:
- patient_id
- encounter_id
| Column | Data Type | Description | Terminology |
|---|
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.
Primary Keys:
- patient_id
- member_id
- enrollment_start_date
- enrollment_end_date
| Column | Data Type | Description | Terminology |
|---|
encounter
The encounter table is intended to store information that represents a unique patient interaction with the healthcare system. It's intended to be synonymous with a healthcare visit (e.g. hospital admission, office visit, etc.). All healthcare analytics use cases involving utilization require an encounter concept. Not only is it important to know about each unique encounter a patient has with the healthcare system, but it's also important to know the type of visit (e.g. acute inpatient, ED, office visit, inpatient rehab, etc.), the start and end dates for the visit, the total amount paid for the visit, and other pieces of information about the visit. The encounter table stores all of this important information in a single table.
Primary Keys:
- 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.
Primary Keys:
- 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.
Primary Keys:
- location_id
| 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).
The medical_claim table in core has been enhanced with concepts like service category and encounter that are useful for analytics.
Primary Keys:
- claim_id
- claim_line_number
Foreign Keys:
- patient_id
- member_id
- encounter_id
| Column | Data Type | Description | Terminology |
|---|
medication
The medication table contains information on medications ordered and/or administered during a patient encounter.
Primary Keys:
- 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.
Primary Keys:
- observation_id
Foreign Keys:
- patient_id
- encounter_id
| Column | Data Type | Description | Terminology |
|---|
patient
The patient table describes the attributes of a patient that are unchanging over time (e.g. biological sex, birth date, etc.). The vast majority of healthcare analytics use cases involve analyzing things that happen to patients, so it's critical to have a clean patient table that contains this information.
Primary Keys:
- patient_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. The pharmacy_claim table is at the claim-line grain.
Primary Keys:
- claim_id
- claim_line_number
Foreign Keys:
- patient_id
- member_id
| Column | Data Type | Description | Terminology |
|---|
practitioner
The practitioner table includes information about individual practitioners (e.g. physicians) and organizations.
Primary Keys:
- practitioner_id
| Column | Data Type | Description | Terminology |
|---|
procedure
Procedures are treatments performed by clinicians for patients to help manage or alleviate conditions. Important ancillary data related to procedures includes the date performed and the performing clinician. Common procedure codes include ICD-10-PCS and HCPCS.
Primary Keys:
- procedure_id
Foreign Keys:
- patient_id
- encounter_id
- practitioner_id
| Column | Data Type | Description | Terminology |
|---|