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 end dateicd_end_dt

The date on which an ICD diagnostic or procedure code is no longer valid, active, or applicable to a patient encounter, episode of care, or code set version. Used to define the closure of a diagnosis period, the expiration of a code in an annual ICD update, or the resolution of a clinical condition.

icd end timeicd_end_tm

The specific time at which an encounter, procedure, or clinical event associated with an ICD code concluded. Used alongside the end date to provide precise temporal boundaries for ICD-coded procedures or diagnoses, supporting accurate duration calculations and intraday clinical event sequencing in data systems.

icd enrollment statusicd_enrl_sts

The health plan enrollment state of a member at the time an ICD diagnosis or procedure code was recorded on a claim or encounter. Used in eligibility verification, claims adjudication, and population health reporting to confirm active coverage for services associated with specific diagnosis codes.

icd entered byicd_ent_by

The identifier of the user, coder, or clinician who entered or assigned an ICD diagnostic or procedure code to an encounter or claim record. Used in audit trails, coding quality reviews, and compliance reporting to track accountability and source of diagnosis code assignments within clinical and billing systems.

icd ethnicityicd_ethn

The ethnicity classification associated with an ICD diagnosis code record, used in clinical data analysis to identify population health disparities, support epidemiological reporting, and meet federal demographic data collection requirements across disease registries and clinical data warehouses.

icd expiration dateicd_exp_dt

The date on which an ICD diagnosis or procedure code becomes invalid for use in medical billing, claims submission, or clinical documentation. Codes are versioned annually by CMS and WHO, and expired codes must be replaced with current equivalents to avoid claim rejections.

icd external identifiericd_ext_id

A reference identifier assigned by an external system, such as a payer, clearinghouse, or coding vendor, that maps to an ICD diagnosis or procedure code within the source system. Used to reconcile code records across interoperable platforms and health information exchanges.

icd faxicd_fax

The facsimile number associated with an entity linked to an ICD code record, such as a referring facility or coding organization. Used in clinical data workflows where fax transmission of diagnosis-related documentation is required for prior authorization or medical record exchange.

icd feeicd_fee

The service charge or reimbursement amount associated with an ICD diagnosis or procedure code, used in fee schedule management, claims adjudication, and cost analysis. Reflects payer-specific or contractual payment rates tied to a specific ICD code in billing systems.

icd first nameicd_first_nm

The given name of an individual, such as a patient or clinician, associated with an ICD code record in a clinical or administrative workflow. Used to display human-readable identity information alongside diagnosis or procedure code assignments in healthcare data systems.

icd flagicd_flg

A binary or categorical status marker applied to an ICD diagnosis or procedure code record to indicate a specific condition such as active or inactive status, exclusion from billing, presence of a coding alert, or applicability to a specific clinical guideline or quality measure.

icd frequencyicd_freq

The frequency attribute associated with an ICD code record, indicating how often a diagnosis or procedure is reported within a defined population or time period. Used in epidemiological analysis, utilization reporting, and clinical decision support systems to assess diagnosis patterns.

icd full nameicd_full_nm

The complete, unabbreviated description of an ICD diagnosis or procedure code as defined by the ICD coding classification system. Used in clinical documentation, reporting interfaces, and coding tools to present the full human-readable label for accurate code identification and selection.

icd gendericd_gndr

The sex or gender classification associated with an ICD code record, used to validate gender-specific diagnosis and procedure codes during claims editing, clinical coding audits, and population health reporting to ensure appropriate code assignment relative to patient demographics.

icd glucoseicd_gluc

The blood glucose measurement associated with a patient encounter linked to an ICD diagnosis code, typically relevant to diabetes-related ICD codes such as E11 or E10. Used in chronic disease management systems and clinical data warehouses to track metabolic indicators alongside diagnostic coding.

icd group numbericd_grp_nbr

The insurance group identifier associated with an ICD code record in a claims or enrollment context, used to link diagnosis codes to a specific member benefit group for adjudication, reporting, and population health stratification across payer and employer group health plans.

icd hemoglobinicd_hgb

The hemoglobin measurement recorded in association with an ICD diagnosis code, commonly used for anemia-related codes such as D50-D64 or diabetes management codes. Supports clinical data analysis and chronic condition monitoring in disease management and value-based care programs.

icd history present illnessicd_hpi

The narrative description of a patient's current medical condition as documented at the time of an encounter and associated with one or more ICD diagnosis codes. Used in clinical coding workflows to support accurate code selection and medical necessity documentation in health records.

icd identifiericd_id

The unique primary key value assigned to an ICD diagnosis or procedure code record within a healthcare data system. Used to reference, retrieve, and link ICD code records across clinical, billing, and analytical systems including claims processing platforms and data warehouses.

icd indexicd_idx

The positional sequence number assigned to an ICD code within a list of diagnosis or procedure codes on a claim or clinical encounter, such as primary, secondary, or tertiary diagnosis position. Determines code priority in claims adjudication, reimbursement calculations, and DRG assignment.

PreviousPage 310 of 806Next