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 countryicd_ctry

Nation identifier associated with the geographic origin or treatment location linked to an ICD diagnosis code record. Relevant in international patient care coordination, cross-border claims processing, and global epidemiological reporting where disease classification and country of service must be captured together.

icd created byicd_crtd_by

Unique identifier of the user, clinician, or system that originally entered an ICD diagnosis code record into the healthcare data system. Supports coding audit trails, accountability tracking, and compliance review by establishing authorship of diagnosis assignments in EHR and clinical data warehouse environments.

icd created dateicd_crtd_dt

Calendar date on which an ICD diagnosis code record was first entered into the healthcare data system. Establishes the administrative creation timestamp for audit trail purposes, distinguishing when the code was recorded from the clinical encounter date or diagnosis onset date in clinical and claims systems.

icd created timeicd_crtd_tm

Timestamp indicating the exact time an ICD diagnosis code record was initially entered into the healthcare data system. Used alongside the created date to provide precise audit trail documentation, supporting coding compliance reviews, system integration logging, and data provenance tracking in clinical data environments.

icd creatinineicd_cr

Creatinine lab value recorded in conjunction with an ICD diagnostic code, used to assess renal function and support diagnosis coding accuracy. Links laboratory results to specific disease classifications in clinical data systems for chronic kidney disease and related condition tracking.

icd dateicd_dt

The calendar date on which an ICD diagnostic or procedure code was assigned, recorded, or submitted on a healthcare claim or clinical encounter. Used to establish the temporal context of a diagnosis within claims processing, medical records, and longitudinal patient history reporting.

icd datetimeicd_dttm

The precise date and time stamp at which an ICD diagnostic or procedure code was recorded or applied during a clinical encounter. Captures both date and time components to support accurate sequencing of diagnoses within inpatient, outpatient, and emergency care event timelines.

icd dea numbericd_dea_nbr

The Drug Enforcement Administration registration number associated with a prescribing clinician linked to an ICD-coded encounter. Used to connect controlled substance prescriptions to specific diagnoses, supporting compliance tracking, prescription monitoring programs, and substance-related diagnosis audit workflows.

icd death dateicd_death_dt

The recorded date of patient death as it relates to an ICD cause-of-death code assignment. Used in mortality reporting, vital statistics, and clinical data analysis to link the specific ICD-10 or ICD-11 underlying cause or contributing condition code to the date of death event.

icd deductible amounticd_ded_amt

The dollar amount applied toward a member's deductible on a claim containing a specific ICD diagnosis code. Used in claims adjudication and financial reporting to track patient cost-sharing obligations associated with particular diagnoses or disease categories within a health plan benefit structure.

icd deleted dateicd_del_dt

The date on which an ICD diagnostic or procedure code record was flagged for deletion or removed from an active encounter, claim, or clinical record. Used in data governance and audit trails to track when diagnosis codes were retracted, corrected, or voided in healthcare information systems.

icd deleted indicatoricd_del_ind

A flag indicating whether an ICD diagnostic or procedure code has been deleted, voided, or marked inactive on a claim or clinical record. Used during claims adjudication and data reconciliation to distinguish valid active diagnosis codes from those that were retracted or corrected after initial submission.

icd descriptionicd_desc

The full human-readable text description corresponding to an ICD diagnostic or procedure code, as defined by the official ICD code set. Used in clinical documentation, claims display, reporting interfaces, and analytics to provide meaningful context alongside numeric or alphanumeric ICD code values.

icd detailicd_dtl

Supplementary clinical or administrative detail associated with an ICD diagnostic or procedure code on an encounter or claim. May include specificity qualifiers, laterality, episode type, or additional context that further describes the nature and circumstances of the coded diagnosis or procedure.

icd discharge dateicd_dsch_dt

The date a patient was discharged from an inpatient or facility setting as recorded in association with ICD diagnosis and procedure codes on a claim. Used in inpatient claims processing, DRG assignment, length-of-stay calculations, and hospital readmission reporting and analysis.

icd due dateicd_due_dt

The date by which a claim or encounter containing ICD diagnosis codes must be submitted, adjudicated, or resolved. Used in claims management workflows to track filing deadlines, timely filing requirements, and payer-specific submission windows tied to ICD-coded healthcare services.

icd durationicd_dur

The length of time associated with a condition, episode of care, or procedure linked to an ICD diagnostic or procedure code. Used in clinical analytics, disease management programs, and utilization reporting to measure the span of a diagnosis from onset or admission through resolution or discharge.

icd effective dateicd_eff_dt

The date on which an ICD diagnostic or procedure code becomes active and valid for use in claims submission or clinical documentation. Reflects the official implementation dates of ICD code set updates, ensuring that diagnosis and procedure codes are applied within their designated validity periods.

icd emailicd_eml

The electronic mail address associated with a contact, clinician, or entity linked to an ICD-coded encounter or claim record. Used in administrative workflows to route diagnosis-related correspondence, coding queries, or clinical documentation requests to the appropriate responsible party in healthcare operations.

icd emergency indicatoricd_emerg_ind

A flag denoting whether an encounter associated with an ICD diagnosis code was classified as an emergency or urgent care visit. Used in claims processing and utilization management to differentiate emergency department encounters from scheduled visits, affecting reimbursement rates and quality metric calculations.

PreviousPage 309 of 806Next