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 rangeicd_rng

The defined span of ICD diagnosis codes that fall within a clinical category, code grouping, or acceptable value set. Used in clinical decision support rules, quality measure specifications, and payer reimbursement policies to identify diagnoses that qualify for specific care pathways or coverage determinations.

icd rateicd_rt

The unit-level reimbursement or occurrence rate associated with an ICD diagnosis code, such as per-member-per-month rates for chronic conditions or contracted payment rates tied to specific diagnoses. Used in actuarial modeling, value-based care contracts, and diagnosis-based payment rate analysis.

icd ratingicd_rtg

A scored or tiered assessment value associated with an ICD diagnosis code, such as a clinical severity rating, risk score, or quality performance rating linked to a specific condition. Used in risk adjustment models, utilization management, and population health stratification based on documented diagnoses.

icd ratioicd_ratio

A comparative proportional value calculated in relation to ICD diagnosis codes, such as the ratio of a specific diagnosis to total encounters, comorbidity ratios, or cost-to-claim ratios attributed to a coded condition. Used in population health analytics and payer reporting to benchmark diagnosis-level performance.

icd reasonicd_rsn

Descriptive text explaining why a specific ICD diagnosis code was assigned to a patient encounter, claim, or clinical record. Captures the clinical justification or narrative context supporting the diagnosis classification, used in utilization review and coding audits.

icd received dateicd_rcvd_dt

The date on which an ICD-coded diagnosis record, referral, or clinical document was received by the processing entity. Used in claims adjudication and care management workflows to track submission timeliness and establish processing timelines for diagnosis-related transactions.

icd referenceicd_ref

An external identifier or pointer linking an ICD diagnosis code to a related document, encounter, authorization, or external system record. Enables cross-referencing between diagnosis codes and supporting clinical documentation, prior authorizations, or claims records in healthcare data systems.

icd resolution dateicd_resol_dt

The date on which a diagnosed condition associated with an ICD code was resolved, closed, or marked inactive in the clinical or claims record. Used in chronic disease management, care coordination, and longitudinal patient health tracking to define the end of a condition episode.

icd respirationicd_resp

The respiratory rate or breathing assessment value recorded in association with an ICD-coded diagnosis or clinical encounter. Captures a vital sign measurement used to support clinical diagnosis coding, severity classification, and acuity scoring for inpatient or emergency care records.

icd resulticd_rslt

The clinical outcome or test result value associated with an ICD-coded diagnosis, procedure, or diagnostic encounter. Used to document findings that support or follow from a specific diagnosis code, linking laboratory, imaging, or clinical assessment outcomes to the coded condition.

icd review systemsicd_ros

Documents the review of body systems conducted during a clinical encounter and linked to ICD diagnosis coding. Captures which organ systems were evaluated as part of the history and physical, supporting medical decision-making complexity levels and accurate diagnosis code assignment.

icd revisionicd_rev

Identifies the version or update iteration of an ICD code assignment, reflecting corrections or updates made to a diagnosis code after initial entry. Tracks coding amendments in claims reprocessing, clinical documentation improvement, and audit workflows where diagnosis codes are reclassified.

icd riskicd_rsk

A risk level or stratification score associated with an ICD-coded diagnosis, indicating the clinical or financial danger level assigned to a patient condition. Used in population health management, risk adjustment models, and care management programs to prioritize patient interventions.

icd routeicd_rte

Specifies the administration pathway or care route associated with an ICD-coded encounter or treatment, such as inpatient, outpatient, or emergency. Used to contextualize how care was delivered in relation to the coded diagnosis, supporting claims processing and care pathway analysis.

icd scheduled dateicd_sched_dt

The planned date on which a clinical encounter, procedure, or service associated with an ICD diagnosis code is scheduled to occur. Used in appointment management, pre-authorization workflows, and care coordination systems to track anticipated service delivery for coded conditions.

icd scheduled timeicd_sched_tm

The planned time of day for a clinical encounter or procedure linked to an ICD diagnosis code. Used alongside the scheduled date in appointment scheduling systems, surgical planning workflows, and care coordination records to establish the precise timing of diagnosis-related services.

icd scoreicd_scr

A calculated numeric rating derived from or associated with an ICD-coded diagnosis, such as a risk score, severity index, or hierarchical condition category value. Used in risk adjustment, quality measurement, and clinical decision support to quantify the impact of a coded diagnosis.

icd sequenceicd_seq

A numeric value indicating the ordered position of an ICD diagnosis code within a claim, encounter, or clinical record. Determines principal versus secondary diagnosis ranking, which drives reimbursement logic, DRG assignment, and reporting hierarchies in claims and clinical data systems.

icd service dateicd_svc_dt

The date on which a clinical service, procedure, or encounter associated with an ICD diagnosis code was actually delivered to the patient. A critical field in claims adjudication, quality reporting, and longitudinal care tracking used to establish when diagnosis-coded care occurred.

icd severityicd_sev

Indicates the clinical seriousness or acuity level of a condition represented by an ICD diagnosis code. Used in severity of illness scoring, DRG refinement, risk stratification models, and quality reporting to differentiate mild, moderate, and severe presentations of a diagnosed condition.

PreviousPage 313 of 806Next