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

Claims

ICD-10, CPT, EDI 837/835, adjudication and remittance

3,545 claims terms

denial mobileden_mob

The mobile phone number of the member or claimant associated with a claim denial record. Used by payer member services and care management teams to facilitate outbound communication regarding denial notifications, appeal rights, and required follow-up actions.

denial modified byden_mod_by

The user identifier of the individual who last updated a claim denial record within the payer's adjudication or denial management system. Provides an audit trail supporting compliance, dispute resolution, and quality review of denial record changes and corrections.

denial modified dateden_mod_dt

The calendar date on which a claim denial record was most recently updated in the payer's adjudication or denial management system. Used to track record changes over time, support audit requirements, and monitor denial status transitions through the appeals and resolution process.

denial modified timeden_mod_tm

The timestamp indicating when a claim denial record was last updated in the payer's adjudication or denial management system. Combined with the modified date, this field supports precise audit trail tracking, system synchronization, and timeliness compliance monitoring for denial management workflows.

denial nameden_nm

The human-readable label or descriptive name assigned to a claim denial record or denial reason code. Used in claims adjudication and reporting systems to present denial information in a clear, standardized format for staff review, member communications, and denial trend analysis.

denial noteden_nt

Free-text annotation or explanatory comment associated with a claim denial record, capturing additional context about the denial reason, clinical review findings, or adjudication decisions. Used by payer staff to document denial rationale beyond standardized codes in claims management systems.

denial numberden_nbr

The unique reference number assigned to a specific claim denial record within the payer's adjudication system. Used to identify, track, and retrieve individual denial records across claims processing, appeals management, and provider dispute resolution workflows.

denial onset dateden_onset_dt

The date on which the condition, symptom, or clinical event began that is associated with a denied claim. Used in medical necessity reviews and appeals to evaluate whether the service denial aligns with clinical onset documentation submitted by the treating provider.

denial oxygen saturationden_o2sat

The blood oxygen level for a coverage rejection. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for denial management and reporting.

denial paid amountden_pd_amt

The dollar amount paid on a claim that was partially denied, reflecting any approved payment made despite the full or partial denial of billed charges. Used in claims financial reconciliation to distinguish between fully denied claims and partial payment adjudication outcomes.

denial paid dateden_pd_dt

The date on which a partial or full payment was issued in conjunction with a claims denial, such as a reduced reimbursement after adjudication. Used in revenue cycle management to reconcile denied claims with any associated payments and track financial resolution timelines.

denial parentden_prnt

The hierarchical reference linking a denial record to its originating or parent denial entry, used when a denial is a sub-component of a broader claim rejection. Supports denial management workflows by enabling tracking of related denials under a single parent transaction in claims processing systems.

denial payment amountden_pmt_amt

The dollar amount paid by the payer on a claim that was partially or fully denied, reflecting any approved reimbursement alongside the denial. Used in revenue cycle and accounts receivable reporting to reconcile expected versus actual reimbursement on adjudicated claims.

denial payment statusden_pmt_sts

Indicates the current payment processing state of a denied claim, such as pending, partially paid, or closed without payment. Used in revenue cycle management to monitor financial resolution of denied claims and prioritize appeal or write-off workflows in claims adjudication systems.

denial percentageden_pct

The calculated percentage of claims or billed charges denied by a payer within a specified period or category. Used in revenue cycle analytics to measure denial rates by payer, service type, or department, enabling organizations to identify trends and target denial prevention strategies.

denial periodden_prd

The date range or time interval associated with a claim denial, which may reflect the service period disputed or the window during which denial activity is measured. Used in revenue cycle reporting to analyze denial trends over defined periods and assess payer performance in claims adjudication.

denial phoneden_ph

The contact telephone number associated with the payer or department responsible for a claim denial, used by billing staff to initiate appeals or obtain clarification. Stored in denial management systems to streamline communication during the claim dispute and resolution process.

denial planden_pln

The health insurance plan under which a claim was submitted and subsequently denied, identifying the specific benefit plan governing the adjudication decision. Used in revenue cycle systems to analyze denial patterns by plan type and assess payer-specific denial policies affecting reimbursement.

denial policy numberden_pol_nbr

The insurance policy identifier associated with a denied claim, linking the denial back to the member's specific coverage policy. Used in claims and revenue cycle systems to verify coverage details, investigate denial root causes, and support appeal submissions to the appropriate payer.

denial preferred nameden_pref_nm

The user-friendly or standardized display label assigned to a denial category or denial reason code, used to present denial information in reporting interfaces and dashboards. Supports consistent terminology across revenue cycle and claims management systems when communicating denial data to billing staff.

PreviousPage 57 of 178Next