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 sexicd_sex

The biological sex of the patient associated with an ICD-coded diagnosis record, used to validate sex-specific diagnosis codes and ensure coding accuracy. Supports claim edits that flag ICD codes inconsistent with the patient's sex, preventing billing errors and improving data integrity.

icd sourceicd_src

Identifies the originating system, document, or clinical encounter from which an ICD diagnosis code was derived or submitted. Tracks whether the code originated from a claim, lab result, clinical note, or external referral, supporting data provenance and diagnosis coding audit trails.

icd start dateicd_start_dt

The date on which a condition represented by an ICD diagnosis code was first identified, documented, or became active in the patient record. Used in chronic condition tracking, episode-of-care analysis, and claims processing to establish the onset of a diagnosis-coded health condition.

icd start timeicd_start_tm

The time of day at which a condition, encounter, or event associated with an ICD diagnosis code began. Used in inpatient clinical documentation, emergency care records, and surgical event tracking to establish the precise onset timestamp for diagnosis-coded conditions or procedures.

icd stateicd_st

The US state or Canadian province associated with an ICD diagnosis or procedure code record, used in claims processing and clinical reporting to establish geographic jurisdiction for coding compliance, reimbursement rules, and regional disease surveillance tracking.

icd statusicd_sts

The active, inactive, or deprecated status of an ICD diagnosis or procedure code within a coding system. Indicates whether the code is currently valid for claim submission under ICD-10-CM or ICD-10-PCS guidelines, or has been replaced by an updated code in a newer fiscal year release.

icd street addressicd_st_addr

The street-level address associated with an ICD-coded encounter or facility record, used in claims data to identify the physical location where a diagnosed condition was treated or a coded procedure was performed for billing and auditing purposes.

icd strengthicd_str

The drug concentration or dosage strength linked to an ICD diagnosis code in pharmacy or clinical records, supporting medication management workflows where a diagnosed condition drives a specific therapeutic dosage, used in clinical decision support and treatment protocol tracking.

icd subtotalicd_subtot

A partial aggregate sum of charges, units, or occurrences associated with a specific ICD diagnosis or procedure code grouping, used in claims analytics and cost reporting to summarize reimbursement activity before applying adjustments, denials, or contractual discounts at final reconciliation.

icd surgery dateicd_surg_dt

The calendar date on which a surgical procedure associated with a specific ICD procedure code was performed, used in inpatient and outpatient claims to establish medical necessity timelines, coordinate benefits, and validate coding accuracy against operative reports in clinical documentation.

icd system identifiericd_sys_id

A unique system-generated key assigned to an ICD diagnosis or procedure code record within a healthcare data platform, enabling consistent cross-system tracking of coded clinical events across EHR, claims, and data warehouse environments for audit trails and integration workflows.

icd targeticd_tgt

The intended destination system, code set version, or mapping endpoint for an ICD diagnosis or procedure code, used during ICD code crosswalks, version migrations such as ICD-9 to ICD-10 transitions, and interoperability workflows where coded clinical data is routed between systems.

icd taxonomy codeicd_tax_cd

The National Uniform Claim Committee taxonomy code linked to a provider associated with an ICD-coded claim, identifying the clinical specialty or provider type responsible for the diagnosis or procedure, used in claims adjudication to validate scope of practice and reimbursement eligibility.

icd temperatureicd_temp

A recorded body temperature measurement associated with an ICD-coded clinical encounter, used in inpatient and emergency settings to document vital sign data that supports diagnosis coding accuracy, medical necessity determination, and severity of illness classification in claims and clinical records.

icd termination dateicd_term_dt

The date on which an ICD diagnosis or procedure code was officially retired or made invalid for claim submission, marking the end of its approved use in a given code year. Used in code set management to enforce billing compliance and prevent submission of outdated codes.

icd timeicd_tm

The specific time of day recorded for a clinical event associated with an ICD diagnosis or procedure code, used in inpatient encounters, emergency department records, and surgical logs to establish precise event sequencing for coding accuracy and medical record documentation compliance.

icd timestampicd_ts

The combined date and time value capturing when an ICD diagnosis or procedure code was assigned, modified, or transmitted within a healthcare system, providing an auditable record for coding workflow compliance, claim submission timeliness, and data lineage tracking across clinical platforms.

icd titleicd_ttl

The official WHO or CMS-designated description or full text title of an ICD diagnosis or procedure code, used in clinical documentation, remittance advice, and reporting to provide human-readable context for a coded condition or procedure beyond the numeric or alphanumeric code value.

icd totalicd_tot

The complete aggregate sum of charges, units, or claim lines associated with an ICD diagnosis or procedure code across a defined reporting period, used in healthcare financial analytics, payer reporting, and utilization management to measure the full cost impact of specific coded conditions.

icd total counticd_tot_cnt

The cumulative number of times a specific ICD diagnosis or procedure code appears across claims, encounters, or patient records within a defined dataset, used in population health analytics, utilization reporting, and disease prevalence studies to measure coding frequency and burden of illness.

PreviousPage 314 of 806Next