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

plan group numberpln_grp_nbr

The unique numeric or alphanumeric identifier assigned to an employer or sponsor group under a health benefit plan. Used in member enrollment, claims processing, and insurance billing to link individual members to their sponsoring group contract and determine applicable coverage terms and negotiated rates.

plan hemoglobinpln_hgb

The hemoglobin level threshold or reference value associated with a health benefit plan's clinical eligibility criteria, commonly used in disease management or prior authorization programs. Supports utilization management workflows where hemoglobin values determine covered service eligibility or qualify members for specific benefit programs.

plan identifierpln_id

Unique alphanumeric key assigned to a specific health plan offering within a carrier or administrator's system. Used across EHR, claims, PBM, and member enrollment platforms to link eligibility records, benefit configurations, and adjudication rules to the correct plan.

plan indexpln_idx

Numeric positional value assigned to a health plan within an ordered benefit coverage structure or plan hierarchy. Used in enrollment and claims systems to sequence multiple plan offerings, support array-based data models, and facilitate plan selection logic in downstream processing.

plan indicatorpln_ind

Binary yes/no flag denoting a specific attribute or condition applicable to a health plan record. Used in member enrollment, claims, and PBM systems to drive conditional processing logic, benefit rule application, and eligibility determination in integration and reporting workflows.

plan instructionpln_instr

Structured guidance text associated with a health plan that directs administrative or clinical processing behaviors. Referenced in enrollment, claims, and PBM platforms to communicate special handling requirements, authorization rules, or coordination of benefits procedures to downstream systems.

plan keypln_key

The surrogate or natural key used to uniquely identify a health benefit plan record within a data warehouse or enrollment system. Serves as the primary reference value for joining plan attributes across member enrollment, claims, and benefits administration tables in healthcare information systems.

plan languagepln_lang

The preferred or designated language associated with a health benefit plan for member communications, evidence of coverage documents, and customer service interactions. Used in member enrollment and benefits administration to ensure regulatory-compliant, language-appropriate materials are delivered to members under the plan.

plan last namepln_last_nm

The surname or family name of the individual associated with a health benefit plan record, typically the primary subscriber or enrollee. Used in member enrollment and eligibility verification systems to identify and match plan holders to their coverage records during claims adjudication and benefits administration.

plan legal namepln_legal_nm

The officially registered legal name of a health benefit plan or sponsoring entity as recorded in regulatory filings and plan documents. Used in member enrollment, benefits administration, and compliance reporting to ensure accurate identification of the plan in contracts, regulatory submissions, and member-facing materials.

plan levelpln_lvl

Attribute designating the tier or hierarchy position of a health plan within a utilization management structure, such as individual, family, or group. Used in reporting, integration layers, and analytics to segment utilization data and apply appropriate benefit calculations across enrollment systems.

plan license numberpln_lic_nbr

The regulatory license or certificate of authority number assigned to a health benefit plan by a state insurance department or federal agency. Used in benefits administration and compliance reporting to verify that the plan is authorized to offer coverage in specific jurisdictions and to track regulatory standing.

plan marital statuspln_mar_sts

The marital status of the primary subscriber or enrollee associated with a health benefit plan record. Used in member enrollment and benefits administration to determine dependent eligibility, coordinate spousal coverage, and apply applicable plan rules governing family tier enrollment and premium contribution calculations.

plan master identifierpln_mstr_id

The enterprise-level master identifier that uniquely and persistently identifies a health benefit plan across all systems within an organization's data ecosystem. Used in member enrollment and claims administration to reconcile plan records across source systems, avoid duplication, and maintain a single authoritative reference for the plan.

plan maximumpln_max

The upper limit on a benefit, cost-sharing amount, or covered service quantity defined within a health benefit plan. Used in claims adjudication and benefits administration to enforce out-of-pocket maximums, annual benefit caps, and utilization limits, ensuring that payments and member liability do not exceed contracted plan thresholds.

plan medical record numberpln_mrn

The medical record number associated with a member or subscriber linked to a health benefit plan, used to cross-reference clinical records with enrollment and coverage data. Supports care coordination and utilization management by connecting claims and enrollment information to the member's clinical history within healthcare information systems.

plan middle namepln_mid_nm

The middle name or initial of the primary subscriber or enrollee associated with a health benefit plan record. Used in member enrollment and eligibility verification to disambiguate members with similar names, ensure accurate identity matching, and support complete legal name display in plan documents and member communications.

plan minimumpln_min

The lower threshold or floor value defined within a health benefit plan for a covered service, benefit amount, or cost-sharing requirement. Used in claims adjudication and benefits administration to enforce minimum benefit guarantees, deductible floors, and utilization thresholds that must be met before plan coverage is triggered.

plan mobilepln_mob

The mobile phone number associated with the primary subscriber or enrollee of a health benefit plan, used for member outreach and communication. Used in member enrollment and benefits administration to support SMS notifications, two-factor authentication, care management alerts, and regulatory-required member communications related to coverage and claims.

plan modified bypln_mod_by

The identifier of the user, system, or process that most recently updated a health benefit plan record in the enrollment or benefits administration system. Used in data governance and audit tracking to maintain an accountable change history, supporting compliance reviews and troubleshooting of plan configuration or enrollment record discrepancies.

PreviousPage 113 of 142Next