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 keypyr_key

Surrogate or natural key value used to uniquely reference an insurance payer record within a data warehouse or claims processing system. Serves as the primary join field linking payer attributes across claims, eligibility, remittance, and contract management tables.

payer languagepyr_lang

Preferred or required communication language associated with an insurance payer, used to ensure that explanation of benefits documents, remittance advice, and member communications are generated and transmitted in the correct language per payer contract requirements.

payer last namepyr_last_nm

Surname of an individual acting as a responsible payer or guarantor for healthcare services, recorded in billing and accounts receivable systems to identify the person financially responsible when the payer is a private individual rather than an insurance organization.

payer legal namepyr_legal_nm

Officially registered business or legal name of an insurance company as recognized by state insurance regulators. Used in contract management, claims remittance, and EDI transaction sets to ensure accurate identification of the payer entity in financial and regulatory submissions.

payer levelpyr_lvl

Hierarchical classification indicating an insurance payer's position within a parent-subsidiary structure or coordination of benefits order, such as primary, secondary, or tertiary. Critical in claims adjudication for determining correct billing sequence and liability assignment.

payer license numberpyr_lic_nbr

State-issued license number granted to an insurance company authorizing it to operate as a health plan within a given jurisdiction. Used in regulatory reporting, contract credentialing, and claims validation to confirm the payer is legally authorized to administer benefits.

payer marital statuspyr_mar_sts

Marital status of an individual guarantor or responsible party recorded as the payer for healthcare services. Used in billing and eligibility systems to support dependent coverage verification, coordination of benefits determinations, and accurate claims submission for self-pay accounts.

payer master identifierpyr_mstr_id

Enterprise-level unique identifier assigned to an insurance payer within a master data management system, enabling consistent cross-system identification of the payer across claims, eligibility, remittance, and contract platforms regardless of source system-specific payer codes.

payer maximumpyr_max

Upper benefit limit associated with an insurance payer's plan, representing the maximum allowable dollar amount or service quantity the payer will reimburse within a defined period. Used in claims adjudication and utilization management to enforce plan benefit boundaries.

payer medical record numberpyr_mrn

Medical record number assigned to a patient that is referenced by or cross-walked to a specific insurance payer's member identifier, enabling reconciliation between provider clinical records and payer enrollment data during claims submission and eligibility verification.

payer middle namepyr_mid_nm

Middle name or initial of an individual acting as the responsible payer or guarantor for healthcare services. Captured in billing and accounts receivable systems to support accurate identity matching and disambiguation when processing self-pay or guarantor-based payment accounts.

payer minimumpyr_min

Lower threshold value associated with an insurance payer's benefit plan, representing the minimum allowable amount before benefits apply, such as a deductible floor or minimum reimbursable charge. Used in claims adjudication logic to determine payer financial responsibility.

payer mobilepyr_mob

Mobile phone number of an insurance payer contact or individual guarantor, stored in billing and claims management systems to facilitate direct communication regarding outstanding balances, authorization requests, claims status inquiries, and payment arrangements.

payer modified bypyr_mod_by

Username or system identifier of the user or automated process that last updated a payer record in the claims or enrollment system. Supports audit trail requirements, data governance reviews, and change management tracking for insurance payer configuration and contract data.

payer modified datepyr_mod_dt

Calendar date on which an insurance payer record was most recently updated in the source system. Used in data reconciliation, audit logging, and incremental ETL processes to identify payer configuration or contract changes that require downstream claims or enrollment reprocessing.

payer modified timepyr_mod_tm

Timestamp indicating the exact time an insurance payer record was last updated, used alongside the modified date to support precise audit trail logging, change-data-capture processes, and conflict resolution when multiple updates to a payer record occur within the same calendar date.

payer notepyr_nt

Free-text annotation associated with an insurance payer record in claims or member enrollment systems. Captures special billing instructions, coverage exceptions, coordination of benefits details, or administrative comments relevant to processing claims with that payer.

payer numberpyr_nbr

Unique numeric or alphanumeric identifier assigned to an insurance company within claims processing and billing systems. Used to route electronic claims, verify eligibility, and reconcile remittance advice across clearinghouses, practice management, and revenue cycle platforms.

payer onset datepyr_onset_dt

Date on which a payer's coverage responsibility or coordination of benefits obligation began for a member. Used in claims adjudication to determine which insurance plan is primary and to establish liability windows for billing and retroactive eligibility scenarios.

payer oxygen saturationpyr_o2sat

Appears to be a data mapping error. Oxygen saturation is a clinical vital sign measure of blood oxygen levels and has no valid definition in the context of an insurance payer entity. This field requires review and reclassification in the data dictionary.

PreviousPage 106 of 142Next