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 end timepmt_end_tm

The timestamp marking the conclusion of a healthcare payment processing cycle or transaction window. Used in payment batch processing, claims adjudication workflows, and financial system logging to establish the end boundary of a payment run for reconciliation purposes.

payment enrollment statuspmt_enrl_sts

The health plan enrollment state of a member at the time a payment transaction is processed, such as active, terminated, or suspended. Used during claims adjudication to verify coverage eligibility and ensure payments are only issued for services rendered within valid enrollment periods.

payment entered bypmt_ent_by

The user ID of the individual who manually keyed or submitted a healthcare payment record into the financial or claims system. Maintains accountability for manual payment entry, supporting internal audit controls and error investigation workflows in payer financial operations.

payment ethnicitypmt_ethn

The ethnicity of the member or patient associated with a healthcare payment record, used for demographic analysis and health equity reporting. Supports population health stratification and regulatory compliance reporting by linking payment data to member demographic attributes in payer systems.

payment expirationpmt_exp

The date on which a healthcare payment record or payment authorization expires in a payer system. Used in claims payment management to identify expired payment authorizations, voided checks, and unclaimed payments requiring reissuance or escheatment to state authorities.

payment expiration datepmt_exp_dt

The date after which a payment authorization, contract rate, or payment instrument is no longer valid in healthcare billing or payer systems. Data engineers use this field to enforce payment validity windows, expire stale transactions, and trigger renewal workflows in claims processing pipelines.

payment external identifierpmt_ext_id

The reference ID assigned by an external system to uniquely identify a payment transaction. Used to reconcile and track payments across payer, provider, and clearinghouse systems, enabling cross-platform payment matching in claims adjudication and remittance processing workflows.

payment faxpmt_fax

The facsimile number associated with the payee or payment recipient in a financial transaction. Used in healthcare billing and remittance workflows to route paper-based payment documentation, remittance advice, or explanation of benefits to the correct recipient contact point.

payment feepmt_fee

The service charge or administrative fee applied to a healthcare financial transaction. Captures costs such as processing fees, transaction surcharges, or clearinghouse fees assessed during claims payment, remittance, or electronic funds transfer processing between payers and payees.

payment first namepmt_first_nm

The given name of the individual associated with a payment transaction, typically the payee, claimant, or authorized recipient. Used in healthcare billing systems to verify payee identity and ensure accurate routing of reimbursements, refunds, or member-directed payments.

payment flagpmt_flg

A binary or categorical status indicator on a payment record in healthcare billing or claims systems, denoting conditions such as denied, adjusted, voided, or pended. Data engineers use payment flags to filter transaction sets, trigger downstream workflows, and categorize payment statuses in financial reporting.

payment frequencypmt_freq

The recurring interval at which payments are issued in a healthcare financial arrangement. Defines the schedule for premium payments, capitation disbursements, annuity-based settlements, or installment reimbursements between payers, providers, or members in managed care and claims systems.

payment full namepmt_full_nm

The complete name of the individual or entity receiving a healthcare payment, combining first, middle, and last name components. Used in billing and remittance systems to validate payee identity and ensure accurate disbursement of claim reimbursements, refunds, or benefit payments.

payment genderpmt_gndr

The gender designation associated with the individual linked to a healthcare payment transaction, typically the member or claimant. Used in payment reconciliation and eligibility verification workflows to confirm payee identity and match payment records against member enrollment data.

payment glucosepmt_gluc

The blood glucose measurement captured in the context of a healthcare payment or reimbursement transaction, typically tied to diabetic care billing. Used to support value-based payment arrangements where clinical lab results such as glucose levels drive quality incentive payments or care management reimbursements.

payment group numberpmt_grp_nbr

The insurance group identifier linked to a healthcare payment transaction. Used in claims adjudication and remittance processing to associate a payment with a specific employer group plan, enabling accurate allocation of reimbursements and financial reporting at the group benefit level.

payment hemoglobinpmt_hgb

The hemoglobin lab value associated with a healthcare payment transaction, typically used in value-based reimbursement models. Captures HbA1c or hemoglobin measurements that trigger quality-based incentive payments or risk-adjusted reimbursements tied to clinical outcome thresholds in managed care contracts.

payment history present illnesspmt_hpi

The clinical narrative describing a patient's current condition as documented in relation to a healthcare payment or billing event. Used in claims and prior authorization workflows where the history of present illness supports medical necessity determinations that directly affect payment approval and reimbursement amounts.

payment identifierpmt_id

A system-generated unique identifier assigned to a specific healthcare payment transaction in a payer financial system. Used as the primary key for payment records in claims data warehouses and referenced in remittance advice, payment reconciliation, and financial audit trails.

payment indexpmt_idx

A positional or sequential identifier assigned to a payment record within a transaction set in healthcare billing or claims systems. Data engineers use this field to maintain sort order, de-duplicate payment records, and uniquely reference transactions when joining payment data across multiple source system tables.

PreviousPage 102 of 178Next