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 descriptionpln_desc

Human-readable text describing a health plan's key attributes, including coverage type, network designation, and benefit structure. Used in EHR, member enrollment, and PBM systems to display plan details in member-facing portals and carrier feeds.

plan detailpln_dtl

Granular benefit coverage attributes for a specific health plan, including deductibles, copays, coinsurance, and network tiers. Referenced in claims adjudication, member enrollment platforms, and PBM systems to apply correct benefit rules during processing.

plan due datepln_due_dt

The date by which a premium payment, enrollment action, or administrative requirement associated with a health benefit plan must be completed. Used in billing and member enrollment systems to trigger payment reminders, assess late fees, and manage coverage continuation or termination workflows.

plan durationpln_dur

The total length of time a health benefit plan remains active, measured from its effective start date to its termination date. Used in member enrollment and benefits administration systems to manage coverage periods, calculate prorated premiums, and determine eligibility windows for covered services.

plan emailpln_eml

Electronic mail address associated with a health plan, used for carrier communications, member notifications, and administrative correspondence. Stored in enrollment and plan master data systems, and referenced in automated EDI transaction workflows and member outreach pipelines.

plan end datepln_end_dt

The calendar date marking the conclusion of a health plan's active benefit period for enrolled members. Used in member enrollment, claims adjudication, and EHR systems to terminate eligibility, enforce coverage boundaries, and trigger renewal or termination workflows.

plan end timepln_end_tm

The specific time of day at which a benefit plan's coverage or an associated administrative session concludes. Used in enrollment and benefits administration systems alongside the plan end date to establish precise coverage boundaries and support accurate eligibility determination at the time of service.

plan enrollment statuspln_enrl_sts

The current state of a member's enrollment in a health benefit plan, indicating whether coverage is active, pending, terminated, suspended, or in another defined state. Drives eligibility verification, claims adjudication, and member communication workflows throughout the insurance administration lifecycle.

plan entered bypln_ent_by

The username or identifier of the staff member or system process that manually keyed or imported the benefit plan record into the health insurance administration system. Captured for audit trail purposes, quality review, and accountability in data entry workflows supporting member enrollment operations.

plan ethnicitypln_ethn

The self-reported ethnic background of a member associated with a health benefit plan record. Collected during enrollment to support population health reporting, health equity analysis, and regulatory compliance with federal requirements for demographic data collection in healthcare coverage programs.

plan expiration datepln_exp_dt

The date after which a health plan's benefit structure is no longer valid for claims processing or member enrollment. Used in PBM, claims, and eligibility systems to reject out-of-period transactions and initiate plan renewal or replacement record creation.

plan external identifierpln_ext_id

A unique reference code assigned by an external system, trading partner, or regulatory body to identify a health benefit plan across organizational boundaries. Used in data exchange, claims processing, and enrollment transactions to maintain consistent plan identification when interfacing with clearinghouses, employers, or government agencies.

plan faxpln_fax

The facsimile telephone number associated with a health benefit plan's administrative office or sponsoring entity. Used in insurance administration systems to route correspondence, prior authorization requests, claims documentation, and other plan-related communications requiring secure document transmission between parties.

plan feepln_fee

The administrative or service charge assessed in connection with establishing, modifying, or maintaining a health benefit plan. Captured in insurance billing systems to account for non-premium revenue, track cost components of plan administration, and ensure accurate financial reporting across the plan lifecycle.

plan first namepln_first_nm

The given or first name component of a contact person, plan sponsor, or named individual associated with a health benefit plan record. Used in insurance administration and enrollment systems to personalize communications, identify responsible parties, and support accurate member or account-level identification.

plan flagpln_flg

Boolean indicator used within compliance workflows to mark a health plan for special processing, exclusion, or review in healthcare data systems. Referenced in regulatory reporting pipelines, downstream analytics, and integration layers to filter or route plan-level data appropriately.

plan frequencypln_freq

The frequency interval associated with a health benefit plan, such as annual, monthly, or per-episode limits on covered services. Used in member enrollment and benefits administration to define how often covered services, benefits, or cost-sharing resets are applied within a plan period.

plan full namepln_full_nm

The complete, unabbreviated name of a health insurance or benefit plan as it appears in enrollment systems and member-facing documents. Used in member enrollment, claims processing, and benefits administration to clearly identify the plan in communications, reporting, and regulatory filings.

plan genderpln_gndr

The gender eligibility designation associated with a health benefit plan, indicating whether the plan is restricted to a specific sex or is open to all members. Used in member enrollment and benefits administration to enforce eligibility criteria and ensure appropriate benefit assignment during plan enrollment.

plan glucosepln_gluc

The blood glucose threshold or reference value associated with a health benefit plan's clinical criteria, often used in disease management or utilization management programs. Supports care management workflows where glucose levels determine eligibility for specific covered services or wellness benefit tiers.

PreviousPage 112 of 142Next