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 typeicd_typ

The classification indicating whether an ICD code belongs to the diagnosis category ICD-10-CM or procedure category ICD-10-PCS, and whether it represents a principal, secondary, or external cause code. Used in claims processing and clinical documentation to ensure correct code set application and billing accuracy.

icd uniticd_unt

The unit of measure or single countable item associated with a procedure or service linked to an ICD code, such as hours, sessions, or encounters. Used in claims data to quantify the volume of coded services rendered and validate reimbursement calculations against contracted rates.

icd updated dateicd_upd_dt

The most recent date on which an ICD diagnosis or procedure code record was modified within a healthcare data system, used to track coding corrections, clinical documentation amendments, and code set version updates for audit compliance and data quality monitoring across claims and clinical platforms.

icd urgencyicd_urg

The clinical urgency or time-sensitivity level assigned to an encounter associated with an ICD diagnosis code, such as emergent, urgent, or elective. Used in claims processing and utilization management to validate appropriate level of care, authorize services, and support medical necessity review for coded diagnoses.

icd valueicd_val

The specific ICD diagnosis or procedure code value assigned to a patient encounter or claim record. Represents the alphanumeric code from ICD-9 or ICD-10 classification systems used for clinical documentation, medical billing, and epidemiological tracking across healthcare data systems.

icd versionicd_ver

Identifies which edition of the International Classification of Diseases coding system was used to assign a diagnosis or procedure code. Critical for claims adjudication and clinical data interpretation, distinguishing between ICD-9-CM, ICD-10-CM, and ICD-10-PCS code sets applied to patient records.

icd zipicd_zip

The postal code associated with an ICD-coded diagnosis or procedure record, typically representing the geographic location of the treating facility or patient residence. Used in population health analytics to identify regional disease prevalence and healthcare utilization patterns across geographic areas.

imaging account numberimg_acct_nbr

A unique alphanumeric identifier assigned to a patient's radiology or diagnostic imaging encounter within the imaging management system. Links imaging studies such as X-rays, MRIs, CT scans, and ultrasounds to billing records, patient demographics, and clinical documentation across healthcare systems.

imaging active indicatorimg_actv_ind

A binary flag denoting whether a diagnostic imaging order, study, or associated record is currently active within the radiology information system. Used to filter valid imaging records from cancelled, voided, or expired entries during reporting, worklist management, and clinical decision support workflows.

imaging active statusimg_actv_sts

Describes the current operational state of a diagnostic imaging record, study, or order within radiology workflows. Status values may include active, inactive, pending, or archived, enabling radiology departments and health systems to manage imaging lifecycle from order creation through final report delivery.

imaging addressimg_addr

The physical location or facility address associated with a diagnostic imaging service, such as radiology or MRI centers. Captured in EHR, claims, and radiology information systems to support provider network validation, claims adjudication, care coordination, and geographic utilization analysis across imaging service sites.

imaging adjustment amountimg_adj_amt

The monetary value applied to modify the original billed charge for a diagnostic imaging service, reflecting contractual write-offs, payer-negotiated discounts, or billing corrections. Used in revenue cycle management to reconcile imaging charges against actual reimbursement received from payers or patients.

imaging admission dateimg_admn_dt

The calendar date on which a patient was admitted to a facility in association with a diagnostic imaging service episode. Recorded in EHR, RIS, and claims systems to establish imaging service timelines, support prior authorization validation, and calculate length of stay for imaging-related inpatient encounters.

imaging ageimg_age

The patient's age in years at the time a diagnostic imaging study was performed or ordered. Used in radiology workflows and population health analytics to apply age-appropriate clinical protocols, assess radiation exposure considerations, and stratify imaging utilization across patient demographic cohorts.

imaging allowed amountimg_alwd_amt

The maximum dollar amount a health plan or payer will reimburse for a specific diagnostic imaging service based on contracted fee schedules or Medicare rates. Serves as the basis for calculating patient cost-sharing obligations such as copayments, coinsurance, and deductibles applied to radiology claims.

imaging amountimg_amt

The monetary value representing the billed, allowed, or paid charge associated with a diagnostic imaging service. Captured in claims, RIS, and billing systems to support imaging cost analysis, claims adjudication, contractual payment reconciliation, and radiology department financial reporting across payer and provider platforms.

imaging approval statusimg_appr_sts

Indicates whether a diagnostic imaging order or procedure has received prior authorization from the patient's health plan. Tracks the payer review outcome for imaging requests, capturing states such as approved, denied, pending, or not required, to ensure reimbursement eligibility before study performance.

imaging approved byimg_appr_by

Identifies the clinician, radiologist, or administrative user who authorized a diagnostic imaging order, prior authorization request, or final report within the radiology information system. Supports audit trail requirements, accountability tracking, and compliance documentation for imaging governance and accreditation purposes.

imaging arrival timeimg_arrv_tm

The recorded timestamp indicating when a patient physically arrived at the radiology department or imaging center for a scheduled or urgent diagnostic study. Used to calculate patient wait times, measure departmental throughput efficiency, and support operational performance benchmarking in imaging facilities.

imaging arrived dateimg_arrv_dt

The calendar date on which a patient arrived at the radiology department or imaging center for a diagnostic study. Used in conjunction with scheduled appointment dates to calculate patient access metrics, no-show rates, and scheduling compliance for radiology operations and quality reporting.

PreviousPage 315 of 806Next