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

beneficiary pricebenf_prc

The cost amount associated with coverage or a specific benefit for an insurance beneficiary, such as a premium, copay, or benefit cost allocation. Used in health plan financial systems for billing, member cost-sharing calculations, and benefit design administration.

beneficiary primary indicatorbenf_prim_ind

A flag designating whether an individual is the primary beneficiary under an insurance coverage plan, as opposed to a secondary or contingent beneficiary. Used in member enrollment and claims systems to determine payment priority and coordinate benefits across multiple coverage arrangements.

beneficiary prioritybenf_prty

Numeric or coded ranking that determines the order of importance or processing precedence for a health insurance beneficiary. Used in member enrollment and claims adjudication to manage coordination of benefits, triage workflows, and coverage hierarchies across payers.

beneficiary quantitybenf_qty

Numeric count representing the number of units, services, or items associated with a health insurance beneficiary record. Used in claims processing and member enrollment to track service utilization volumes, such as days of supply, units of service, or covered dependent counts.

beneficiary racebenf_race

Racial classification self-reported or recorded for a health insurance beneficiary, aligned with OMB standards. Used in member enrollment, HEDIS reporting, and health equity analytics to identify disparities in care access, quality outcomes, and population health management programs.

beneficiary rangebenf_rng

The defined minimum and maximum value boundaries applicable to a health insurance beneficiary, such as eligible age bands, income thresholds, or coverage limits. Used in member enrollment eligibility determination, benefit plan design, and population segmentation for managed care programs.

beneficiary ratebenf_rt

The monetary or unit rate assigned to a health insurance beneficiary for premium calculation, cost-sharing determination, or capitation payment. Used in member enrollment and billing systems to compute premium amounts, copay structures, and per-member-per-month payment values.

beneficiary ratingbenf_rtg

A scored or tiered assessment value assigned to a health insurance beneficiary based on actuarial factors such as age, health status, or risk profile. Used in underwriting, premium rate setting, and risk adjustment models to determine appropriate coverage costs and plan pricing.

beneficiary ratiobenf_ratio

A proportional value expressing the relationship between a health insurance beneficiary metric and a reference population or benchmark, such as cost-per-member ratios. Used in actuarial analysis, population health reporting, and managed care performance measurement to assess utilization trends.

beneficiary reasonbenf_rsn

A coded or free-text explanation documenting why a specific action, status change, or determination was made for a health insurance beneficiary. Used in member enrollment, claims adjudication, and care management workflows to record justifications for coverage decisions or eligibility modifications.

beneficiary received datebenf_rcvd_dt

The calendar date on which information, documentation, or an enrollment request for a health insurance beneficiary was received by the payer or administrator. Used in member enrollment and claims processing to establish receipt timestamps for compliance tracking and response deadline calculations.

beneficiary referencebenf_ref

An external identifier or pointer linking a health insurance beneficiary record to related documents, systems, or transactions, such as a prior authorization number or enrollment application ID. Used in member enrollment and claims systems to cross-reference records across payer platforms and clearinghouses.

beneficiary resolution datebenf_resol_dt

The date on which an open issue, dispute, appeal, or eligibility discrepancy for a health insurance beneficiary was formally resolved or closed. Used in member enrollment and claims adjudication workflows to track case closure timelines and ensure regulatory compliance with response deadlines.

beneficiary resultbenf_rslt

The outcome or finding associated with a process, assessment, or transaction completed for a health insurance beneficiary, such as an eligibility determination, risk score calculation, or care gap closure. Used in member management and population health analytics to record and track beneficiary-level outcomes.

beneficiary review systemsbenf_ros

Documents the body systems reviewed during a clinical encounter for an insurance coverage recipient, such as a Medicare or Medicaid enrollee. Used in medical record documentation to capture review of systems findings that support diagnosis coding and care management decisions.

beneficiary revisionbenf_rev

A versioned update or amendment made to a health insurance beneficiary record, reflecting changes to enrollment data, coverage details, or demographic information. Used in member enrollment systems to maintain an audit trail of record modifications, supporting regulatory compliance and historical data integrity.

beneficiary riskbenf_rsk

A quantified or categorized assessment of the health, financial, or operational risk associated with a health insurance beneficiary. Used in risk stratification models, care management programs, and actuarial analyses to identify high-risk members, allocate care resources, and inform risk adjustment submissions.

beneficiary routebenf_rte

The designated administrative or care pathway assigned to a health insurance beneficiary, such as a medication administration route or care management program track. Used in pharmacy claims and care coordination workflows to document how services are delivered and ensure appropriate benefit application.

beneficiary scheduled datebenf_sched_dt

The calendar date on which a service, appointment, or administrative event is planned for a health insurance beneficiary. Used in member care management, utilization management, and claims preprocessing to coordinate service delivery timing and track compliance with preventive care or chronic disease management schedules.

beneficiary scheduled timebenf_sched_tm

The specific time of day at which a service, appointment, or event is planned for a health insurance beneficiary. Used in care management and utilization management workflows alongside the scheduled date to enable precise appointment coordination and resource allocation for member services.

PreviousPage 10 of 142Next