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

debit notedb_nt

A free-text annotation attached to a debit balance on a healthcare account, capturing relevant billing actions, disputes, payment arrangements, or collection activity history. Used by revenue cycle staff to document account management decisions and maintain a detailed audit trail of balance resolution efforts.

debit procedure datedb_proc_dt

The date on which the clinical procedure generating a debit charge was performed. Used in healthcare revenue cycle management to establish claim filing timelines, validate service dates against payer authorization windows, and support accurate charge capture reconciliation within the billing workflow.

debit rangedb_rng

The minimum and maximum value span defining acceptable limits for a charge or amount owed on a healthcare account. Used in billing and revenue cycle management to flag transactions outside expected thresholds for auditing, claims adjudication, and financial reconciliation.

debit resultdb_rslt

The outcome of processing a charge or amount owed against a patient account or claim. Captures whether the debit was successfully applied, rejected, or adjusted during billing cycle processing, supporting revenue cycle management and accounts receivable reconciliation workflows.

debit routedb_rte

The designated processing pathway through which a charge or debit amount is directed within the billing or revenue cycle system. Determines how the financial transaction is routed across payers, cost centers, or billing departments for proper allocation and accounts receivable tracking.

debit strengthdb_str

The magnitude or relative weight assigned to a charge or debit entry within a healthcare billing system. Used in revenue cycle management to prioritize or rank outstanding debits during accounts receivable processing, collections workflows, or financial reconciliation across payers and cost centers.

debit surgery datedb_surg_dt

The calendar date on which a surgical procedure was performed, associated with a specific charge or debit entry on a patient account. Used in hospital billing and revenue cycle workflows to link operative charges to the correct service date for claims submission and financial reconciliation.

deductible admission dateded_admn_dt

The inpatient hospital admission date tied to a deductible accumulation event in claims processing systems. Used by payers and EHR platforms to determine which benefit period or deductible year applies when calculating member cost-sharing obligations for inpatient stays.

deductible discharge dateded_dsch_dt

The hospital discharge date associated with an inpatient stay linked to a deductible accumulation record in claims processing systems. Used by payers and EHR platforms to finalize cost-sharing calculations, close inpatient claim episodes, and correctly attribute deductible amounts to the appropriate benefit period.

deductible emergency indicatorded_emerg_ind

A flag identifying whether a deductible obligation is associated with an emergency service encounter. Used in claims adjudication to apply emergency-specific cost-sharing rules, ensuring the correct member deductible accumulation and benefit calculation under health plan contracts.

deductible history present illnessded_hpi

The narrative description of a member's current illness or condition as it relates to a deductible determination on a health insurance claim. Used in utilization management and claims review to assess medical necessity when evaluating deductible applicability and benefit eligibility decisions.

deductible labelded_lbl

The descriptive display text identifying the specific type of deductible applied to a member's health insurance plan, such as individual, family, or in-network deductible. Used in member enrollment systems and explanation of benefits documents to clearly communicate cost-sharing obligations.

deductible procedure dateded_proc_dt

The calendar date on which a medical procedure was performed, used to determine whether the associated charge applies to a member's deductible accumulation within the correct benefit period. Critical in claims adjudication to align service dates with plan year deductible tracking.

deductible rangeded_rng

The minimum and maximum threshold values defining a member's deductible band within benefit plan configuration in payer, PBM, and enrollment systems. Used to segment member populations for cost-sharing analytics, accumulator tracking, and plan design reporting across individual and family tiers.

deductible resultded_rslt

The outcome value produced after evaluating a member's deductible accumulation against their plan threshold in claims adjudication or PBM systems. Indicates whether the deductible has been met, partially satisfied, or remains outstanding for a given benefit period.

deductible surgery dateded_surg_dt

The calendar date on which a surgical procedure was performed, used to attribute operative charges to the correct plan year deductible accumulation period. Applied in claims adjudication and member cost-sharing calculations to ensure accurate deductible tracking under health insurance benefits.

denial admission dateden_admn_dt

The date a member was admitted to a facility for an inpatient stay that was subsequently denied coverage by the health plan. Used in claims denial management and appeals processing to establish the service timeline and support medical necessity reviews or utilization management determinations.

denial discharge dateden_dsch_dt

The date a member was discharged from a facility for an inpatient stay subject to a coverage denial. Used in claims denial management and appeals workflows to define the episode of care timeframe, supporting medical necessity reviews and payer-level utilization management decisions.

denial labelden_lbl

The descriptive display text identifying the specific reason or category of a coverage denial issued by a health plan. Used in claims adjudication and denial management workflows to communicate the basis for non-payment, supporting provider appeals and member explanation of benefits documentation.

denial procedure dateden_proc_dt

The calendar date on which a medical procedure was performed that is the subject of a coverage denial. Used in claims denial management and appeals processing to establish service timing, assess benefit period applicability, and support medical necessity determinations during payer review.

PreviousPage 151 of 806Next