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 indicatorpmt_ind

A binary yes or no flag associated with a healthcare payment transaction indicating the presence or absence of a specific payment characteristic. Used in claims payment data warehouses to capture boolean payment attributes such as coordination of benefits indicator or electronic payment indicator.

payment instructionpmt_instr

Directive text or coded guidance attached to a payment transaction in healthcare billing or payer systems, specifying handling rules such as withhold application, coordination of benefits sequencing, or EFT routing. Data engineers parse this field to automate payment routing logic and enforce contractual payment terms.

payment keypmt_key

The primary or surrogate key used to uniquely identify a payment record within a healthcare financial system. Serves as the core lookup reference for joining payment data across claims, remittance, and accounts receivable tables in data warehouses and revenue cycle management platforms.

payment labelpmt_lbl

The descriptive display text assigned to a payment transaction or payment type in a healthcare financial system. Used in remittance advice, billing statements, and reporting dashboards to present human-readable identifiers that categorize payment records such as capitation, fee-for-service, or incentive payments.

payment languagepmt_lang

The preferred written or spoken language of the individual associated with a healthcare payment transaction. Used to ensure remittance advice, billing statements, and payment-related communications are delivered in the member's or payee's preferred language, supporting health equity and compliance requirements.

payment last namepmt_last_nm

The family surname of the individual associated with a healthcare payment transaction, typically the payee, claimant, or benefit recipient. Used in billing and remittance systems alongside first name to authenticate payee identity and accurately route claim reimbursements or member-directed payments.

payment legal namepmt_legal_nm

The officially registered legal name of the entity or individual designated to receive a healthcare payment. Used in claims disbursement and revenue cycle management to ensure payments are issued under the correct legal identity, satisfying regulatory compliance and contractual payee verification requirements.

payment levelpmt_lvl

Hierarchy position of a financial transaction within claims or remittance data, distinguishing claim-level, service-line-level, or adjustment-level payments. Used in EHR, claims, and PBM systems to route and reconcile payments accurately across processing tiers.

payment license numberpmt_lic_nbr

The professional or business license identifier associated with a payee in a healthcare payment transaction. Used in provider reimbursement workflows to verify credentialing status and ensure payments are issued only to licensed entities, supporting fraud prevention and regulatory compliance in claims processing.

payment marital statuspmt_mar_sts

The marital status of the individual associated with a healthcare payment transaction, typically a member or claimant. Used in coordination of benefits determinations and eligibility verification to identify spousal coverage dependencies that may affect payment liability allocation between primary and secondary payers.

payment master identifierpmt_mstr_id

The enterprise-level master identifier that uniquely links a payment record across multiple systems within a healthcare organization. Used in revenue cycle and data integration workflows to consolidate payment data from disparate claims, billing, and remittance platforms into a single authoritative payment record.

payment maximumpmt_max

The upper limit on the amount that can be paid within a healthcare financial transaction or benefit period. Used in claims adjudication to enforce plan-level payment caps, out-of-pocket maximums, or fee schedule ceilings, ensuring reimbursements do not exceed contractually or regulatorily defined thresholds.

payment medical record numberpmt_mrn

The patient medical record number associated with a payment transaction, linking the financial record to the corresponding clinical encounter. Used in revenue cycle management to reconcile payments against patient accounts and validate that remittances correspond to the correct patient and service.

payment middle namepmt_mid_nm

The middle name or initial of the individual associated with a payment transaction, used to disambiguate patients or guarantors with similar names during payment posting. Supports accurate matching of remittance records to patient accounts in billing and accounts receivable workflows.

payment minimumpmt_min

The minimum allowable payment amount accepted for a financial transaction, such as the floor value for a payment plan installment or minimum copay collected at point of service. Used in revenue cycle systems to enforce payment thresholds and validate transaction amounts during posting.

payment mobilepmt_mob

The mobile phone number associated with the payer or guarantor responsible for a payment transaction. Used in healthcare billing systems to send payment notifications, reminders, or SMS confirmations, and to support patient outreach efforts in accounts receivable and collections workflows.

payment modified bypmt_mod_by

The user identifier of the individual who last updated a payment transaction record in the billing or accounts receivable system. Used for audit trail purposes to track changes to payment postings, adjustments, or reversals and ensure accountability in revenue cycle operations.

payment modified datepmt_mod_dt

Timestamp recording the most recent update to a payment record in claims, EHR, or billing systems. Critical for data engineers performing incremental ETL loads, audit trails, and detecting retroactive adjustments in remittance or accounts receivable workflows.

payment modified timepmt_mod_tm

The timestamp recording when a payment transaction record was most recently updated in the billing or accounts receivable system. Used to maintain an audit trail of changes to payment postings, adjustments, or corrections, supporting reconciliation and compliance in revenue cycle management.

payment namepmt_nm

The display name or label associated with a healthcare payment transaction in a data system. Used for reporting, user interface display, and financial reconciliation to provide a human-readable identifier for payment records in healthcare claims and remittance systems.

PreviousPage 103 of 178Next