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

payment notepmt_nt

Free-text or coded annotation attached to a financial transaction in EHR billing, claims adjudication, or remittance systems. Captures adjuster remarks, denial explanations, or manual override rationale, used by data engineers for payment reconciliation and audit reporting.

payment numberpmt_nbr

The operational business number assigned to a healthcare payment transaction for external reference and provider communication. Distinct from internal payment surrogate keys used in data warehouse systems. Used on remittance advice and provider payment reports for payment identification and reconciliation.

payment onset datepmt_onset_dt

The date on which the condition or episode of care originated, captured in the context of a payment transaction to support claims adjudication and medical necessity validation. Used in revenue cycle systems to align payment records with the clinical timeline when payers require onset information for reimbursement.

payment oxygen saturationpmt_o2sat

The blood oxygen saturation level recorded in association with a payment transaction, typically captured when clinical documentation is required to support medical necessity for reimbursement. Used in revenue cycle workflows to attach supporting clinical data to claims for payer adjudication and audit purposes.

payment paid amountpmt_pd_amt

The actual dollar amount received and posted for a payment transaction, reflecting the sum remitted by a payer, patient, or guarantor. Used in accounts receivable and revenue cycle systems to track cash receipts, reconcile claims against expected reimbursement, and calculate remaining patient balances.

payment paid datepmt_pd_dt

The date on which a payment was received and posted to a patient account or claim in the billing system. Used in revenue cycle management to track cash flow, measure days in accounts receivable, reconcile remittance advice, and report on the timeliness of payer and patient payments.

payment parentpmt_prnt

Reference to a higher-level payment record in a hierarchical claims or billing structure, linking child adjustments or sub-payments to their originating transaction. Used in EHR and claims systems to maintain payment lineage and support accurate financial rollup reporting.

payment payment amountpmt_pmt_amt

The total dollar value of a specific payment transaction applied to a claim or patient account, which may represent an insurance remittance, patient payment, or adjustment. Used in revenue cycle systems to record the exact sum posted during payment processing and support financial reconciliation.

payment payment statuspmt_pmt_sts

The current processing state of a payment transaction, such as pending, posted, reversed, or denied. Used in revenue cycle management and accounts receivable systems to track the lifecycle of payments, prioritize follow-up actions, and report on outstanding balances and cash posting completion.

payment percentpmt_pct

The percentage of the allowed amount paid by a health insurance plan for a covered healthcare service after applicable cost sharing. Used in claims adjudication and benefit configuration to calculate payer responsibility based on coinsurance levels defined in the member benefit plan.

payment periodpmt_prd

Defined time span during which a financial transaction is valid, applicable, or expected, as used in capitation, premium billing, or claims payment cycles. Found in payer, PBM, and member enrollment systems to align payment posting with correct fiscal or service periods.

payment phonepmt_ph

Telephone number associated with a payment entity, such as a payer, provider, or billing contact, stored in claims or remittance records. Used by data engineers in provider master data management and payer contract systems to route payment inquiries and resolve discrepancies.

payment planpmt_pln

Structured agreement in EHR or patient billing systems allowing a patient to pay an outstanding balance in scheduled installments. Contains payment schedule, installment amounts, due dates, and terms; used by data engineers to track receivables and forecast patient revenue collection.

payment policy numberpmt_pol_nbr

The insurance policy number associated with a payment transaction, identifying the specific coverage plan under which a claim was adjudicated and remittance was issued. Used in revenue cycle systems to link payments to the correct payer contract and verify that reimbursement aligns with the applicable plan terms.

payment preferred namepmt_pref_nm

The preferred or chosen name of the patient or guarantor associated with a payment transaction, used to personalize billing correspondence and payment communications. Supports accurate identification during payment posting and improves patient experience in billing and customer service interactions.

payment previouspmt_prev

A reference to the prior payment amount or payment record associated with a healthcare claim. Used in claims adjustment workflows to compare original and adjusted payment amounts, track payment reversals, and calculate net payment changes in claims financial reconciliation.

payment pricepmt_prc

The established charge or cost value for a service associated with a payment transaction, representing the billed amount before contractual adjustments or payer discounts. Used in revenue cycle systems to compare expected reimbursement against the chargemaster rate and calculate contractual write-offs during payment reconciliation.

payment primary indicatorpmt_prim_ind

A flag designating whether a payment transaction is associated with the primary payer responsible for first adjudication of a claim. Used in revenue cycle systems to coordinate benefits correctly, ensuring the primary insurer is billed first and subsequent payments from secondary payers are applied in the correct sequence.

payment prioritypmt_prty

Ranked importance assigned to a payment transaction determining processing order in claims adjudication or accounts payable systems. Used in payer and EHR billing platforms to sequence multiple payments, coordinate benefits, or manage coordination of benefits (COB) logic in data pipelines.

payment procedure datepmt_proc_dt

The date on which a clinical procedure or service was performed, captured in association with a payment transaction to validate timely filing and support claims adjudication. Used in revenue cycle systems to confirm that payment postings correspond to services rendered within the applicable payer's coverage period.

PreviousPage 104 of 178Next