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

disorder enrollment statusdsrd_enrl_sts

Indicates whether a member diagnosed with a specific disorder is actively enrolled in a disease management program or specialty benefit plan designed to address that condition. Reflects current program participation state such as active, pending, or disenrolled, used to coordinate care and validate coverage for disorder-related services.

document coinsurance amountdoc_coins_amt

The member's cost-sharing dollar amount associated with clinical documentation services such as diagnostic reports, imaging interpretations, or pathology reads billed on a claim. Calculated by applying the member's plan coinsurance rate to the allowed amount for the documented service after the deductible threshold has been satisfied.

document enrollment statusdoc_enrl_sts

Reflects whether a specific clinical or administrative document type, such as a care plan or authorization record, is in an active, pending, or closed status within the health plan or care management system. Used to manage document lifecycle workflows and ensure current documents are applied during utilization review and claims adjudication.

document plandoc_pln

The structured care or administrative plan captured within a clinical document, detailing intended treatments, follow-up actions, referrals, or coverage decisions. Used in care coordination and utilization management to align clinical decisions with documented patient care goals and ensure continuity across encounters and health systems.

document policy numberdoc_pol_nbr

The insurance policy identifier linked to a clinical or administrative document, associating the document with the member's specific health plan contract. Used during claims adjudication and authorization workflows to ensure the correct policy terms, benefits, and coverage rules are applied when processing document-associated service requests.

dose coinsurance amountdose_coins_amt

The member's shared cost responsibility for a specific medication dose under their pharmacy benefit plan. Represents the fixed or percentage-based out-of-pocket amount owed by the member at the time a prescribed dose is dispensed, as captured in pharmacy claims or adjudication records.

dose enrollment statusdose_enrl_sts

Indicates whether a member is actively enrolled in a benefit program that covers a specific medication dose, such as a specialty drug program or patient assistance plan. Used in pharmacy benefit management systems to determine coverage eligibility at the dose level during claims adjudication.

dose plandose_pln

Identifies the specific pharmacy or medical benefit plan under which a particular medication dose is covered. Links a dispensed dose to the corresponding insurance plan structure, enabling accurate benefit application, formulary checks, and cost-sharing calculations during pharmacy claims processing.

dose policy numberdose_pol_nbr

The unique insurance policy identifier associated with the coverage plan governing a specific medication dose. Used in pharmacy claims and benefit administration systems to link a dispensed dose to the correct member policy, ensuring accurate adjudication and reimbursement processing.

duration coinsurance amountdur_coins_amt

The member's shared cost obligation calculated across a defined treatment duration period, such as a course of therapy or benefit period. Captured in medical or pharmacy claims to reflect cumulative or period-specific cost-sharing amounts tied to a continuous treatment timeframe.

duration enrollment statusdur_enrl_sts

Indicates whether a member maintains active enrollment in a benefit plan throughout a defined treatment duration period. Used in member enrollment and claims systems to verify continuous coverage during a course of treatment, affecting benefit eligibility and cost-sharing calculations.

duration plandur_pln

Identifies the benefit plan associated with coverage over a defined treatment duration period. Used in claims and enrollment systems to link a treatment course or therapy period to the applicable insurance plan, supporting benefit limit tracking and cost-sharing calculations across the duration.

duration policy numberdur_pol_nbr

The insurance policy identifier linked to coverage for a specified treatment duration period. Used in claims and member enrollment systems to associate a continuous course of care or therapy period with the correct policy, supporting accurate benefit adjudication and longitudinal claims tracking.

effective enrollment statuseff_enrl_sts

Indicates the current enrollment state of a member as of their coverage effective date. Used in member enrollment systems to confirm whether coverage has been activated, is pending, or has lapsed, directly affecting benefit eligibility verification and claims adjudication decisions at the plan start date.

eligibility account numberelig_acct_nbr

The unique account identifier assigned to a member or subscriber within the health plan's enrollment system. Used to associate eligibility records with the correct billing or group account, supporting benefit verification, premium billing, and coordination of coverage across member enrollment and claims systems.

eligibility active indicatorelig_actv_ind

A flag indicating whether a member's health plan coverage is currently active at the time of a benefit verification or claims inquiry. Used in member enrollment and eligibility systems to provide a binary active or inactive status, supporting real-time eligibility checks and claims adjudication.

eligibility active statuselig_actv_sts

Describes the current activity state of a member's health plan enrollment, indicating whether coverage is active, suspended, terminated, or pending. Used in member enrollment systems to track and communicate the precise coverage state for benefit verification, claims adjudication, and plan administration workflows.

eligibility addresselig_addr

The residential or mailing address associated with a member's eligibility record in the health plan enrollment system. Used to validate member identity during benefit verification, route correspondence, determine network availability, and support coordination of care across insurance and claims administration workflows.

eligibility adjustment amountelig_adj_amt

A monetary value representing a correction or modification applied to a member's eligibility-related financial record, such as a premium adjustment or retroactive coverage change. Captured in enrollment and billing systems to reflect changes in cost-sharing obligations or benefit entitlements resulting from eligibility updates.

eligibility ageelig_age

The member's calculated age as recorded in the health plan eligibility file, used to determine benefit entitlements, apply age-based plan rules, and validate coverage criteria. Critical in enrollment and claims systems for applying age-dependent cost-sharing tiers, dependent coverage limits, and Medicare coordination rules.

PreviousPage 53 of 142Next