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

icd assessmenticd_asmt

The clinical evaluation narrative or structured finding associated with an ICD diagnosis or procedure code, documenting the provider's interpretation of the patient's condition. Used in clinical documentation, care management, and coding workflows to support accurate ICD code assignment and clinical decision-making.

icd balanceicd_bal

The outstanding financial amount remaining unpaid on a claim or patient account associated with an ICD diagnosis or procedure code after payments and adjustments have been applied. Used in revenue cycle management to track accounts receivable, patient responsibility balances, and collections activity.

icd billed amounticd_bill_amt

The total dollar amount charged by a provider for a service associated with an ICD diagnosis or procedure code, as submitted on a claim to the payer. Represents the provider's gross charge prior to contractual adjustments, payer reductions, or patient cost-sharing calculations during claims adjudication.

icd birth dateicd_birth_dt

The date of birth of the patient associated with an ICD-coded encounter or claim record. Used to calculate patient age at time of service, support demographic analysis, verify member identity during claims adjudication, and enable age-stratified reporting of disease prevalence and treatment outcomes.

icd blood pressureicd_bp

Systolic and diastolic arterial pressure reading documented alongside an ICD diagnosis code in clinical records. Links vital sign measurements to specific diagnoses, supporting chronic disease management tracking for conditions like hypertension (ICD I10) and cardiovascular disorders.

icd cancelled dateicd_cncl_dt

Date on which an ICD diagnosis code assignment was voided or withdrawn from a patient record or claim. Used in clinical coding workflows to maintain audit trails when diagnoses are retracted due to coding errors, updated clinical findings, or claim adjudication corrections.

icd categoryicd_cat

Broad classification grouping assigned to an ICD diagnosis code, representing the disease family or clinical domain such as infectious diseases, neoplasms, or circulatory conditions. Supports population health analytics, clinical reporting, and hierarchical disease classification across healthcare data systems.

icd charge amounticd_chrg_amt

Billed charge amount associated with a healthcare encounter where a specific ICD diagnosis code was assigned. Captured on medical claims to reflect the provider's standard fee for services rendered under that diagnosis, prior to payer adjudication and contractual adjustments.

icd chief complainticd_cc

Primary symptom or clinical concern reported by the patient that prompted the encounter, linked to the resulting ICD diagnosis code assignment. Supports clinical documentation integrity by connecting the patient's presenting complaint to the coded diagnosis in EHR and claims workflows.

icd childicd_chld

Subordinate ICD diagnosis code within a parent-child hierarchical classification structure, representing a more specific clinical condition beneath a broader category code. Used in ICD code set navigation, clinical decision support, and diagnosis grouping logic across healthcare data systems.

icd cityicd_city

Municipality name associated with the location where a patient's ICD-coded diagnosis was recorded or treated. Used in epidemiological surveillance, public health reporting, and geographic disease tracking to identify regional prevalence patterns across healthcare populations.

icd classicd_cls

Classification tier assigned to an ICD diagnosis code indicating its position within the ICD coding hierarchy, such as chapter, block, or category level. Supports hierarchical code navigation, clinical grouping logic, and reporting frameworks in healthcare data warehouses and analytics systems.

icd codeicd_cd

Standardized alphanumeric diagnosis code from the International Classification of Diseases coding system (ICD-9 or ICD-10-CM) assigned to document a patient's clinical condition. Used across medical claims, EHR documentation, and clinical data systems to classify diagnoses for billing, reporting, and care management.

icd coinsurance amounticd_coins_amt

Patient's shared cost liability calculated as a percentage of the allowed amount for a claim where a specific ICD diagnosis code was assigned. Applied after the deductible is met, representing the member's out-of-pocket responsibility following health plan adjudication of the associated medical claim.

icd commenticd_cmt

Free-text notation or clinical remark appended to an ICD diagnosis code record, providing supplemental context about the diagnosis, coding rationale, or clinical circumstances. Supports coding audit documentation, clinical clarification workflows, and dispute resolution in healthcare data management systems.

icd completed dateicd_cmpl_dt

Date on which the clinical encounter, procedure, or treatment associated with an ICD diagnosis code was fully completed and documented. Used to establish episode-of-care timelines, support claims adjudication accuracy, and track diagnosis resolution within clinical and administrative health systems.

icd confidential indicatoricd_conf_ind

Flag designating that an ICD diagnosis code record contains sensitive clinical information requiring restricted access, such as mental health, substance use, or HIV-related diagnoses. Governs data visibility and disclosure rules in compliance with HIPAA privacy regulations and applicable state confidentiality statutes.

icd copay amounticd_cpay_amt

Fixed out-of-pocket dollar amount owed by the patient at the time of service for an encounter associated with a specific ICD diagnosis code. Defined by the member's health plan benefit structure and applied during claims adjudication regardless of the total allowed amount for the service.

icd costicd_cst

Total expense value attributed to the treatment or management of a condition identified by a specific ICD diagnosis code, encompassing provider reimbursement, facility fees, and ancillary services. Used in cost-of-care analysis, disease burden modeling, and healthcare financial reporting across payer and provider systems.

icd counticd_cnt

Total number of times a specific ICD diagnosis code appears within a defined dataset, patient record, or reporting period. Used in population health analytics, disease prevalence measurement, utilization management, and quality reporting to quantify the frequency of documented clinical conditions across healthcare populations.

PreviousPage 308 of 806Next