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

mortality deductible amountmort_ded_amt

The dollar amount applied toward a member's deductible for claims associated with a mortality event or end-of-life services. Used in health and life insurance claims processing to determine member financial liability before plan benefits apply to death-related medical or hospice service claims.

mortality payment amountmort_pmt_amt

The dollar amount disbursed by the health plan or insurer in connection with a mortality-related claim, including end-of-life care or death benefit payouts. Used in actuarial reporting and claims financial reconciliation to quantify plan expenditures associated with member mortality events.

mortality payment statusmort_pmt_sts

Indicates the current processing state of a payment tied to a mortality-related claim, such as pending, issued, or reversed. Used in life and health insurance claims workflows to monitor the payment lifecycle for death benefit disbursements and end-of-life service reimbursements.

mortality review systemsmort_ros

Documents the organ systems reviewed as part of a clinical or administrative assessment related to a patient mortality event. Used in mortality review committees, quality reporting, and clinical documentation to support cause-of-death coding, preventable mortality analysis, and regulatory compliance reporting.

mortality service datemort_svc_dt

The date on which a healthcare service was rendered in connection with a mortality event, including terminal care or hospice services. Used in claims processing and actuarial analysis to establish the timeline of end-of-life care, validate claim filing periods, and support mortality cohort reporting.

mri adjustment amountmri_adj_amt

The dollar amount added or subtracted to reconcile a claim payment for a magnetic resonance imaging procedure. Used in medical claims adjudication to reflect contractual write-offs, coordination of benefits corrections, or payment corrections applied to MRI diagnostic imaging service reimbursements.

mri claim datemri_clm_dt

The date on which a claim for a magnetic resonance imaging procedure was submitted to the health plan for adjudication. Used in medical claims processing to validate timely filing requirements, establish the billing timeline for diagnostic imaging services, and support MRI utilization reporting.

mri claim statusmri_clm_sts

Indicates the current adjudication state of a medical claim for a magnetic resonance imaging procedure, such as received, pending, approved, or denied. Used in claims processing workflows to track MRI imaging claims through review, medical necessity determination, and payment decision stages.

mri deductible amountmri_ded_amt

The dollar amount applied toward a member's annual deductible for a magnetic resonance imaging procedure claim. Used in medical claims adjudication to calculate member cost-sharing obligations for MRI diagnostic imaging services before health plan benefits are applied to the remaining balance.

mri payment amountmri_pmt_amt

The dollar amount reimbursed by the health plan to the rendering facility or clinician for a magnetic resonance imaging procedure. Used in medical claims financial reporting to track MRI imaging expenditures, evaluate diagnostic imaging utilization costs, and support radiology service contract analysis.

mri payment statusmri_pmt_sts

Indicates the current processing state of a payment for a magnetic resonance imaging procedure claim, such as pending, paid, denied, or reversed. Used in medical claims workflows to monitor MRI reimbursement lifecycle from adjudication through remittance to the imaging facility or ordering provider.

mri review systemsmri_ros

Documents the body systems evaluated or indicated for imaging during the clinical review of a magnetic resonance imaging order or result. Used in radiology reporting and utilization management to ensure MRI orders align with clinical indications, support prior authorization decisions, and meet medical necessity criteria.

mri service datemri_svc_dt

The calendar date on which a magnetic resonance imaging procedure was performed for a patient. Used in medical claims and clinical records to establish the episode of care timeline, support prior authorization validation, and enable radiology utilization analysis.

ndc claim datendc_clm_dt

The date a pharmacy or medical claim containing a National Drug Code was submitted to the payer for adjudication. Used in pharmacy benefit management systems to establish filing timelines, measure prompt pay compliance, and support drug utilization review across dispensing events.

ndc claim statusndc_clm_sts

The current adjudication state of a pharmacy or medical claim associated with a specific National Drug Code, such as paid, denied, pending, or reversed. Used in pharmacy claims processing to track claim lifecycle, identify adjudication errors, and support formulary and drug coverage audits.

ndc payment amountndc_pmt_amt

The dollar amount reimbursed to a pharmacy or provider for a drug identified by its National Drug Code on a pharmacy or medical claim. Reflects the negotiated rate after applying formulary pricing, ingredient cost, dispensing fees, and applicable member cost-sharing deductions.

ndc payment statusndc_pmt_sts

The current state of the reimbursement transaction for a drug claim identified by National Drug Code, indicating whether payment has been issued, withheld, reversed, or is pending. Used in pharmacy claims to reconcile remittance advice and monitor payer disbursement cycles.

nephrology adjustment amountneph_adj_amt

The dollar value of a post-adjudication modification applied to a nephrology specialty claim, such as a contractual adjustment, coordination of benefits reduction, or claims correction. Used in renal care billing workflows to reconcile expected versus actual reimbursement for kidney-related services.

nephrology claim dateneph_clm_dt

The date a medical claim for nephrology specialty services, such as dialysis, chronic kidney disease management, or renal consultations, was submitted to the payer. Used to track filing timelines, assess timely filing compliance, and support nephrology care episode analysis.

nephrology claim statusneph_clm_sts

The current adjudication state of a claim for nephrology specialty services, such as paid, denied, pended, or appealed. Used in renal care billing systems to monitor claim lifecycle, identify denial patterns, and manage appeals for kidney disease treatment reimbursement.

PreviousPage 85 of 178Next