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

enrollment totalenrl_tot

The aggregate count or dollar amount representing the full sum of enrollment records within a defined population, plan, or reporting period. Used by health plans in actuarial, financial, and operational reporting to assess total membership size and associated premium or capitation obligations.

enrollment total countenrl_tot_cnt

The complete numerical count of enrollment records within a defined plan, product, employer group, or reporting period. Used in health plan membership reporting, premium reconciliation, and regulatory submissions to quantify the total number of covered members at a given point in time.

enrollment typeenrl_typ

A classification code identifying the nature of a member's health plan enrollment, such as new enrollment, open enrollment, special enrollment, COBRA, or Medicare. Used in eligibility systems to apply correct effective date rules, waiting periods, and benefit activation logic based on the enrollment category.

enrollment unitenrl_unt

The discrete unit of measure associated with an enrollment record, such as individual, family, employee plus spouse, or subscriber. Used in health plan billing and premium calculations to determine the correct rating tier and cost-sharing structure applied to a member's coverage.

enrollment updated dateenrl_upd_dt

The most recent date on which a member's enrollment record was modified in the health plan's eligibility system, reflecting changes such as address updates, coverage tier changes, or demographic corrections. Used to audit record maintenance activity and track retroactive eligibility adjustments.

enrollment urgencyenrl_urg

A classification indicating the priority or time-sensitivity level assigned to processing a member's enrollment transaction, such as standard, expedited, or emergency enrollment. Used in health plan operations to triage enrollment requests requiring immediate benefit activation, such as newborn or special enrollment period submissions.

enrollment valueenrl_val

A quantitative or categorical data point associated with a specific attribute within a member's health plan enrollment record, such as premium amount, coverage level, or benefit tier value. Used in eligibility and billing systems to capture variable enrollment attributes that drive plan rating and benefit configuration.

enrollment versionenrl_ver

Sequential version number assigned to a member enrollment record, incrementing each time the record is updated. Tracks changes to plan membership data over time, enabling downstream systems to identify and process the most current enrollment information while retaining historical versions for audit purposes.

enrollment zipenrl_zip

Five or nine digit postal code associated with a member's address at the time of health plan enrollment. Used in member eligibility verification, network adequacy analysis, and geographic risk stratification. May reflect residential, mailing, or employer address depending on enrollment source.

episode coinsurance amountepsd_coins_amt

Dollar amount representing the member's share of costs for all services rendered within a defined clinical episode of care, such as a joint replacement or maternity episode. Calculated as a percentage of allowed charges after the deductible is met, used in episode-based payment model reporting.

episode enrollment statusepsd_enrl_sts

Indicates whether a member was actively enrolled in a health plan during a specific episode of care. Used in episode-based payment analytics to confirm coverage continuity, attribute costs accurately, and ensure eligibility alignment when bundling claims across a defined clinical care period.

episode planepsd_pln

Identifies the health insurance plan under which a member was covered during a defined clinical episode of care. Used in episode-based payment programs to attribute costs, apply benefit structures, and reconcile payments across all services bundled within the episode period.

episode policy numberepsd_pol_nbr

Unique identifier for the insurance policy under which services were covered during a defined clinical episode of care. Used to link episode-level cost and utilization data back to the specific health plan contract, enabling accurate financial reconciliation and episode payment attribution.

equipment enrollment statusequip_enrl_sts

Indicates the active or inactive enrollment state of durable medical equipment within a health plan's covered benefits program. Used to verify whether specific DME items such as wheelchairs or ventilators are currently authorized under a member's plan at the time of a service request or claim adjudication.

evaluation coinsurance amounteval_coins_amt

Dollar amount representing the member's cost-sharing responsibility for a clinical evaluation or assessment service, such as a diagnostic workup or specialist consultation. Calculated as a percentage of the allowed amount after applicable deductibles are met, per the member's health plan benefit structure.

evaluation enrollment statuseval_enrl_sts

Indicates whether a member held active health plan enrollment at the time a clinical evaluation or diagnostic assessment was performed. Used in claims adjudication and utilization review to confirm eligibility, ensure proper benefit application, and support coverage determination workflows.

evaluation planeval_pln

Identifies the specific health insurance plan that provided coverage for a clinical evaluation or diagnostic assessment service. Used in claims processing and care management workflows to apply the correct benefit design, cost-sharing rules, and network requirements associated with the member's plan at time of service.

evaluation policy numbereval_pol_nbr

Unique policy identifier associated with the health plan coverage in effect when a clinical evaluation or diagnostic assessment was performed. Used to link evaluation claims to the correct insurance contract for adjudication, reporting, and financial reconciliation across payer and provider systems.

experience coinsurance amountexp_coins_amt

Dollar amount of member cost-sharing calculated from actual paid claims within a defined experience period, used in actuarial analysis and plan performance reporting. Reflects the aggregate or per-claim coinsurance obligations incurred by members and informs premium rate development and benefit design decisions.

experience enrollment statusexp_enrl_sts

Reflects a member's health plan enrollment state during a defined experience period used in actuarial, underwriting, or population health analyses. Confirms active or inactive coverage during the period under review, ensuring that claims and utilization data are correctly attributed to eligible enrolled members.

PreviousPage 69 of 142Next