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

drug claim datedrg_clm_dt

The calendar date on which a pharmacy claim for a specific drug was submitted to the payer or pharmacy benefit manager for adjudication. Used to establish processing timelines, validate formulary eligibility, and support audit and appeals workflows in pharmacy benefit management.

drug claim statusdrg_clm_sts

The current adjudication state of a pharmacy claim for a specific drug, such as paid, denied, pending, or reversed. Tracks the claim through the pharmacy benefit management adjudication cycle and supports identification of claims requiring resubmission, appeal, or manual review.

drug payment amountdrg_pmt_amt

The net dollar amount reimbursed by the insurer or pharmacy benefit manager for a dispensed drug claim after applying member cost-sharing, formulary pricing, and plan benefit limits. Used in pharmacy financial reconciliation and drug spend analytics across benefit plans.

drug payment statusdrg_pmt_sts

The current state of a reimbursement transaction for a pharmacy drug claim, indicating whether payment has been issued, is pending, has been withheld, or has been recouped. Supports financial reconciliation between pharmacy benefit managers, payers, and dispensing pharmacies.

duration adjustment amountdur_adj_amt

The dollar value applied to modify a claim when the billed treatment duration differs from the approved or covered period. Used in inpatient, behavioral health, or rehabilitation claims processing to reflect financial corrections tied to length-of-stay or therapy session duration changes.

duration claim datedur_clm_dt

The calendar date on which a claim associated with a specific treatment duration was submitted to the payer for adjudication. Used in inpatient or post-acute care claims to establish processing timelines and support coordination of benefits across concurrent payers.

duration claim statusdur_clm_sts

The current adjudication state of a claim tied to a specific treatment duration, such as approved, denied, pending medical review, or reversed. Tracks length-of-stay or therapy duration claims through payer review cycles, particularly in inpatient and rehabilitation benefit management.

duration deductible amountdur_ded_amt

The portion of a treatment duration claim applied toward a member's annual deductible before plan benefits activate. Used in inpatient, skilled nursing, or rehabilitation benefit administration to calculate member financial responsibility based on covered days or session counts.

duration payment amountdur_pmt_amt

The net dollar amount paid by the insurer for a claim associated with a specific treatment duration, after applying deductibles, coinsurance, and coverage limits tied to length of stay or number of therapy sessions. Used in inpatient and post-acute care financial reconciliation.

duration payment statusdur_pmt_sts

The current state of a payment transaction associated with a treatment duration claim, indicating whether reimbursement has been issued, is pending authorization, has been withheld, or recouped. Supports financial reconciliation for inpatient and post-acute care claims with time-based billing.

duration review systemsdur_ros

The clinical body systems evaluated during a patient encounter specifically in the context of determining or validating treatment duration medical necessity. Documents physiological systems assessed to support authorization decisions for length-of-stay approvals in inpatient or rehabilitation settings.

duration service datedur_svc_dt

The date on which a time-based treatment or therapy session was rendered to the patient, used to anchor duration claims to a specific point of care delivery. Validates coverage eligibility and establishes the service period in inpatient, rehabilitation, and post-acute care claims processing.

effective adjustment amounteff_adj_amt

The dollar value of a financial correction applied to a claim or payment transaction as of the coverage effective date. Captures post-adjudication modifications such as overpayment recoveries, coordination of benefits corrections, or contractual adjustments recorded in claims processing systems.

effective claim dateeff_clm_dt

The date a claim was submitted or recognized as valid relative to the member's coverage effective date. Used in claims adjudication to confirm services were rendered within an active benefit period and to validate timely filing compliance in payer processing systems.

effective claim statuseff_clm_sts

The adjudication state of a claim evaluated against the member's coverage effective date, indicating whether the claim is pending, approved, denied, or adjusted. Used in payer systems to track claims that fall within or outside active benefit coverage windows.

effective deductible amounteff_ded_amt

The dollar amount applied toward a member's deductible as of the coverage effective date. Represents the portion of allowed charges the member is responsible for before insurance benefits apply, tracked in claims and benefits administration systems for accumulator management.

effective payment amounteff_pmt_amt

The dollar value of a reimbursement disbursed to a provider or member corresponding to services covered under an active benefit period. Reflects the net payable amount after applying deductibles, copays, and contractual adjustments in claims payment processing systems.

effective payment statuseff_pmt_sts

The processing state of a reimbursement transaction tied to a member's active coverage period, indicating whether payment is pending, issued, voided, or recouped. Used in claims payment systems to monitor disbursement lifecycle and reconcile remittance activity.

effective review systemseff_ros

Documents the body systems reviewed during a clinical encounter that falls within an active coverage period. Captures which organ systems were examined to support medical necessity validation and ensure clinical documentation aligns with the member's coverage effective dates.

effective service dateeff_svc_dt

The date on which a covered healthcare service was rendered within an active benefit coverage period. Used in claims adjudication to validate that services align with enrollment effective dates and to trigger appropriate reimbursement under the applicable benefit plan.

PreviousPage 64 of 178Next