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

physical policy numberpe_pol_nbr

The unique policy identifier associated with a member's health insurance coverage for physical examination services. Referenced during claims submission and eligibility verification to confirm active coverage, apply correct benefit rules, and link physical exam claims to the appropriate insurance contract.

plan active indicatorpln_actv_ind

A binary flag indicating whether a health benefit plan is currently active and available for member enrollment or claims processing. Used in plan management systems to control eligibility determinations, prevent claims adjudication against terminated plans, and support enrollment system validations.

plan active statuspln_actv_sts

Describes the current operational state of a health benefit plan, such as active, suspended, or terminated. Used in member enrollment and claims systems to determine whether a plan can accept new enrollments, process claims, or must be transitioned to a replacement plan during open enrollment periods.

plan agepln_age

The number of years a health benefit plan has been in existence since its effective date. Used in actuarial analysis, contract management, and benefit plan administration to assess plan maturity, evaluate historical cost trends, and inform decisions about plan renewal or restructuring.

plan allowed amountpln_alwd_amt

The maximum dollar amount a health insurance plan will reimburse for a covered service under a specific benefit plan, as determined by contracted rates or fee schedules. This figure drives claims adjudication calculations, including member cost-sharing obligations such as deductibles and coinsurance.

plan amountpln_amt

Monetary value associated with a specific health benefit plan, representing figures such as premium amounts, plan-level cost-sharing limits, or benefit maximums stored in enrollment and payer administration systems. Used during claims adjudication, financial reconciliation, and member cost calculation workflows across EHR, PBM, and payer platforms.

plan approval statuspln_appr_sts

Indicates the current regulatory or internal authorization state of a health benefit plan, such as pending review, approved, or rejected. Used in plan management workflows to track whether a plan has received necessary sign-off from compliance, actuarial, or regulatory bodies before becoming available for member enrollment.

plan approved bypln_appr_by

Identifies the individual or role responsible for authorizing a health benefit plan for use in member enrollment or claims processing. Captured as part of the plan governance audit trail to ensure accountability, support compliance reviews, and document plan approval workflows within benefit administration systems.

plan arrival timepln_arrv_tm

Records the timestamp at which plan-related documentation or a plan change request was received in the benefits administration or enrollment system. Used to establish processing timelines, support audit trails, and ensure plan updates or new plan submissions are handled within required service level windows.

plan arrived datepln_arrv_dt

The calendar date on which plan documentation, a plan change request, or a new plan submission was received by the benefit administration system. Used to establish effective dating, prioritize processing queues, and ensure compliance with regulatory deadlines governing health plan approvals and enrollment updates.

plan assessmentpln_asmt

A structured evaluation of a health benefit plan's performance, cost efficiency, and member utilization patterns. Used by actuarial and benefit design teams to analyze plan effectiveness, identify cost drivers, and inform decisions about plan modifications, renewals, or discontinuation during annual benefit planning cycles.

plan balancepln_bal

Outstanding monetary amount remaining against a benefit plan's allowed maximum, accumulator, or financial obligation within payer and enrollment systems. Tracks remaining deductible, out-of-pocket, or benefit limits in real time during claims adjudication. Critical for accumulator management, cost-sharing calculations, and member financial reporting in downstream analytics pipelines.

plan billed amountpln_bill_amt

The total dollar amount submitted by a provider on a claim for services rendered to a member enrolled in a specific health benefit plan. This amount precedes adjudication and is compared against the plan's allowed amount schedule to determine reimbursement, member cost-sharing, and any contractual adjustments.

plan birth datepln_birth_dt

Date of origination or effective establishment of a health benefit plan within payer administration and enrollment systems, distinct from member date of birth. Used to calculate plan tenure, apply grandfathered plan rules under ACA compliance logic, and support historical benefit configuration tracking during 834 transaction processing and plan-level audits.

plan blood pressurepln_bp

A clinical vital sign value recorded within a plan-associated health assessment or wellness program, capturing a member's systolic and diastolic arterial pressure readings. Used in population health management and care coordination programs tied to specific benefit plans that include chronic disease monitoring or preventive care initiatives.

plan cancelled datepln_cncl_dt

The specific date on which a health benefit plan was formally terminated or cancelled, making it unavailable for new enrollments or claims adjudication. Used in plan administration systems to enforce benefit end dates, trigger member transition workflows, and maintain accurate historical records of plan lifecycle events.

plan categorypln_cat

Classification label assigned to a health benefit plan within eligibility and enrollment systems, such as HMO, PPO, HDHP, or EPO. Used to apply plan-specific adjudication rules, benefit structures, and network configurations. Data engineers reference this field during 834 file processing, payer integrations, and downstream analytics segmentation across healthcare platforms.

plan charge amountpln_chrg_amt

The gross service charge associated with a health benefit plan, representing the total fee assessed before any adjustments, discounts, or cost-sharing are applied. Referenced during claims adjudication to calculate contractual write-offs, member liability, and plan reimbursement amounts based on applicable fee schedules and benefit structures.

plan chief complaintpln_cc

The primary health concern or symptom reported by a member during a clinical encounter that is linked to a specific benefit plan's care management or utilization review workflow. Used to initiate prior authorization reviews, case management referrals, or population health interventions aligned with the member's enrolled plan benefits.

plan childpln_chld

Subordinate plan entity linked to a parent plan within a hierarchical benefit structure in payer administration and enrollment systems. Represents sub-plans or benefit subsets that inherit or override parent plan configurations. Used during claims adjudication, eligibility determination, and plan hierarchy traversal in data integration and downstream reporting workflows.

PreviousPage 110 of 142Next