mdatool
Healthcare Data Dictionary for the Modern Data Stack
LibraryBlogPricing
mdatool
mdatool

The healthcare data dictionary for dbt, Snowflake, Databricks, and BigQuery. 100,000+ ISO-11179 standard terms, free SQL tools, and AI data modeling.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator
  • Data Model Canvas

Library

  • Glossary
  • Guides
  • Blog

Company

  • About
  • Contact
  • Pricing

Account

  • Sign Up Free
  • Sign In
  • Upgrade to Pro
  • Dashboard

Legal

  • Privacy Policy
  • Terms of Service

© 2026 mdatool. All rights reserved.

Built for healthcare data teams.

Back to Glossary

Domain

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

history assessmenthx_asmt

The clinician's documented evaluation or diagnostic impression recorded during a historical patient encounter, capturing findings, differential diagnoses, or clinical judgments at that point in time. Used in longitudinal care documentation and retrospective clinical review of patient health events.

history balancehx_bal

The outstanding financial amount remaining on a historical account or claim after payments and adjustments have been applied. Used in revenue cycle management to track unresolved balances, support collections workflows, and perform retrospective financial reconciliation of past patient accounts.

history billed amounthx_bill_amt

The total charges submitted by a provider on a historical claim before any contractual adjustments, denials, or payments are applied. Used in retrospective cost analysis, claims auditing, and financial benchmarking to evaluate billing patterns and reimbursement rates over time.

history birth datehx_birth_dt

The patient's date of birth as recorded within a historical medical record or enrollment file. Used to verify patient identity, calculate age at the time of past clinical events, and support longitudinal cohort analysis across claims, enrollment, and clinical data systems.

history blood pressurehx_bp

Records a patient's arterial blood pressure measurement from a past clinical encounter, stored as systolic and diastolic values. Used in longitudinal patient health tracking to monitor cardiovascular trends, support chronic disease management, and inform clinical decision-making across care episodes.

history cancelled datehx_cncl_dt

Captures the date on which a previously scheduled or active medical service, order, or appointment was formally cancelled in the historical record. Used in clinical audit trails and utilization reporting to track service interruptions, no-shows, and care continuity gaps across patient encounters.

history categoryhx_cat

Classifies a past medical event into a defined grouping such as surgical history, family history, social history, or past illness. Used in clinical documentation systems to organize longitudinal patient records, support problem list management, and enable structured retrieval of historical health information.

history charge amounthx_chrg_amt

Records the gross billed charge associated with a past medical service or encounter before adjustments, contractual discounts, or payer reductions are applied. Used in revenue cycle and financial analytics to reconcile historical billing activity, identify charge trends, and support cost reporting.

history chief complainthx_cc

Documents the primary symptom, concern, or reason for care as reported by the patient during a past clinical encounter. Used in clinical documentation to establish historical context for diagnoses, support continuity of care, and enable retrospective analysis of presenting conditions across visits.

history childhx_chld

Identifies a subordinate or dependent record linked to a parent historical medical event, reflecting hierarchical relationships within clinical data structures. Used in EHR systems to associate related orders, diagnoses, or procedures under a parent encounter or episode of care for longitudinal tracking.

history cityhx_city

Records the municipality associated with a past medical event, typically reflecting the patient's residential city at the time of a prior encounter or enrollment period. Used in population health analytics, geographic utilization reporting, and retrospective member address history tracking across care timelines.

history classhx_cls

Denotes the classification tier assigned to a past medical event, such as inpatient, outpatient, emergency, or observation status. Used in clinical and administrative systems to categorize historical encounters for utilization review, reimbursement validation, and longitudinal care pattern analysis.

history codehx_cd

Stores a standardized code, such as ICD, CPT, or SNOMED, used to identify and classify a past medical event within clinical or administrative systems. Enables consistent cross-system referencing, retrospective reporting, and longitudinal tracking of diagnoses, procedures, or conditions in the patient record.

history coinsurance amounthx_coins_amt

Records the portion of a past medical service cost shared by the patient after the deductible was met, based on the applicable health plan benefit structure. Used in member financial history reporting, claims reconciliation, and retrospective analysis of out-of-pocket cost distribution across historical encounters.

history commenthx_cmt

Contains unstructured free-text notes or annotations associated with a past medical event, entered by clinicians or administrative staff at the time of the encounter. Used to capture contextual details not accommodated by coded fields, supporting clinical review, audit documentation, and care continuity.

history completed datehx_cmpl_dt

Records the date on which a past medical service, order, procedure, or care plan activity was marked as fully completed. Used in clinical workflow tracking, quality measure reporting, and retrospective analysis of care delivery timelines to assess treatment adherence and service fulfillment history.

history confidential indicatorhx_conf_ind

Flags a past medical event as containing sensitive or restricted information requiring limited access, such as behavioral health, substance use, or reproductive health records. Used in EHR access control and compliance workflows to enforce confidentiality protections under HIPAA and applicable state privacy regulations.

history copay amounthx_cpay_amt

Records the fixed out-of-pocket amount paid by the patient at the time of a past medical service, as defined by their health plan benefit structure. Used in member financial history reporting, claims reconciliation, and retrospective cost-sharing analysis across historical encounters and benefit periods.

history counthx_cnt

Represents the total number of occurrences of a specific past medical event type within a defined period or across the patient's longitudinal record. Used in clinical analytics, risk stratification, and utilization reporting to quantify historical event frequency and support population health management.

history countryhx_ctry

Records the nation associated with a past medical event, typically reflecting the country of patient residence or service delivery during a prior encounter. Used in international patient population reporting, geographic risk analysis, and retrospective member address history tracking across care and enrollment timelines.

PreviousPage 300 of 806Next