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

Member

Enrollment, eligibility, demographics and plan attribution

2,833 member terms

payer allowed amountpyr_alwd_amt

The maximum dollar amount an insurance payer has contractually agreed to reimburse for a specific covered service. Derived from payer fee schedules and used in claims adjudication to calculate patient cost-sharing obligations such as copays, coinsurance, and deductible responsibilities.

payer amountpyr_amt

The total dollar amount remitted or expected from an insurance payer for a given claim or set of claims. Captured during claims adjudication and payment posting to reconcile reimbursements against billed charges and track payer-specific payment patterns across service lines.

payer approval statuspyr_appr_sts

The authorization state assigned by an insurance payer to a submitted claim or prior authorization request, indicating whether the service has been approved, denied, pended, or requires additional clinical documentation before reimbursement processing can proceed.

payer approved bypyr_appr_by

The name or identifier of the individual or system within the insurance payer organization that authorized a claim, prior authorization, or contract amendment. Captured in claims and utilization management workflows to support audit trails and dispute resolution processes.

payer arrival timepyr_arrv_tm

The timestamp recording when an insurance payer's electronic transaction, such as an 837 claim file or eligibility response, was received by the healthcare organization's clearinghouse or billing system. Used to track transaction processing timelines and measure payer connectivity performance.

payer arrived datepyr_arrv_dt

The calendar date on which an insurance payer's electronic transaction or paper remittance was received by the healthcare organization's billing or claims processing system. Used to calculate claim turnaround time and measure compliance with payer contractual processing commitments.

payer assessmentpyr_asmt

An internal evaluation of an insurance payer's performance, financial stability, or contractual compliance conducted by the healthcare organization. Captures qualitative and quantitative findings used in payer contract negotiations, network management decisions, and revenue cycle performance reviews.

payer balancepyr_bal

The outstanding dollar amount remaining owed by an insurance payer on adjudicated claims after partial payments or adjustments have been applied. Tracked in accounts receivable systems to manage follow-up workflows, identify underpayments, and support payer-specific collection activities.

payer billed amountpyr_bill_amt

The gross dollar amount submitted to an insurance payer on a claim before contractual adjustments, denials, or patient cost-sharing are applied. Represents charges based on the provider's standard fee schedule and serves as the starting point for claims adjudication and payment reconciliation.

payer birth datepyr_birth_dt

The date on which an insurance payer entity was officially established, licensed, or entered into a contractual relationship with the healthcare organization. Used in payer master data management to track entity longevity, contract anniversary dates, and regulatory compliance timelines.

payer blood pressurepyr_bp

A data element that appears misassigned to the payer domain; blood pressure is a clinical vital sign measured in patients, not insurance entities. This field likely results from a data model error and should be reviewed for correct entity association and remapped to the appropriate patient clinical record.

payer cancelled datepyr_cncl_dt

The date on which an insurance payer's contract, participation agreement, or specific plan product was formally terminated or cancelled within the healthcare organization's payer master file. Used to enforce billing eligibility rules and prevent claims submission to inactive payer agreements.

payer categorypyr_cat

A classification code grouping an insurance payer into a defined segment such as commercial, Medicare, Medicaid, managed care, or self-pay. Used in revenue cycle management, financial reporting, and contract analysis to segment reimbursement performance and benchmark payer-specific metrics.

payer charge amountpyr_chrg_amt

The specific dollar amount charged to an insurance payer for a rendered service line on a claim, reflecting the provider's fee schedule rate for that procedure. Used in claims adjudication to determine contractual write-offs and calculate the net reimbursement expected from the payer.

payer chief complaintpyr_cc

A data element that appears misassigned to the payer domain; chief complaint is a clinical data point documented by patients, not insurance entities. This field likely results from a data model mapping error and should be reviewed for correct entity association and remapped to the patient encounter record.

payer childpyr_chld

A subordinate insurance payer entity linked to a parent payer in a hierarchical payer master structure. Represents subsidiary plans, regional affiliates, or delegated entities under a primary payer umbrella, used in claims routing, contract management, and payer hierarchy reporting to correctly attribute reimbursements.

payer citypyr_city

The city portion of the mailing or physical address for an insurance company or health plan. Used in claims processing, payer master files, and remittance routing to accurately direct correspondence, electronic transactions, and paper EOBs to the correct payer location.

payer classpyr_cls

A categorical grouping assigned to an insurance company or health plan that distinguishes payer types such as commercial, Medicare, Medicaid, or self-pay. Used in claims adjudication, contract management, and reimbursement analysis to apply correct billing rules and fee schedules.

payer codepyr_cd

A unique alphanumeric identifier assigned to an insurance company or health plan within billing and claims systems. Used to route electronic claims via EDI 837 transactions, match remittance advice, and link payer-specific adjudication rules across revenue cycle management platforms.

payer coinsurance amountpyr_coins_amt

The dollar amount an insurance company or health plan is responsible for paying as its share of coinsurance on a claim after the deductible is met. Captured during claims adjudication to reconcile expected versus actual payer payments and calculate remaining member liability.

PreviousPage 103 of 142Next