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

policy hemoglobinpol_hgb

The recorded hemoglobin level of a policyholder, typically captured during underwriting or health risk assessment for an insurance coverage agreement. Used in population health and underwriting systems to evaluate anemia or other hematological conditions that may influence coverage or risk classification.

policy identifierpol_id

A unique alphanumeric key assigned to an insurance policy record within claims, enrollment, and EHR systems, used to link member coverage data across PBM, billing, and adjudication platforms and serve as the primary reference for policy-level queries, integrations, and reporting workflows.

policy indexpol_idx

A numeric positional value assigned to an insurance policy record within a dataset or coverage hierarchy, used in enrollment and claims systems to sequence multiple policy records for a member, support array-based processing in integration payloads, and maintain ordered policy referencing in downstream analytics.

policy indicatorpol_ind

A yes/no or boolean field denoting a specific condition or attribute of an insurance policy, such as active status, primary coverage designation, or exclusion applicability, used in claims adjudication, PBM, and enrollment systems to drive conditional processing rules and benefit determination logic.

policy instructionpol_instr

Directive or guidance text associated with an insurance coverage agreement that specifies handling rules, processing notes, or special conditions, used in claims, enrollment, and EHR systems to communicate policy-specific requirements to downstream processors, customer service teams, and integration workflows.

policy keypol_key

The unique primary or surrogate key used to identify and retrieve an insurance coverage agreement record within an enrollment or benefits administration database. Serves as the core reference value for linking policy data across member, claims, billing, and eligibility system tables.

policy languagepol_lang

The preferred spoken or written language of the primary policyholder associated with an insurance coverage agreement. Used in member enrollment systems to route communications, EOBs, and plan documents in the member's preferred language, supporting CMS language access compliance requirements.

policy last namepol_last_nm

The family surname of the primary policyholder as recorded on an insurance coverage agreement. Used in member enrollment systems for identity verification, eligibility inquiry matching, correspondence generation, and accurate linking of member records across health plan administrative platforms.

policy legal namepol_legal_nm

The officially registered legal name of the primary policyholder as it appears on government-issued identification and binding insurance coverage agreement documents. Used in enrollment and compliance systems to ensure accurate identity representation for regulatory filings and legal correspondence.

policy levelpol_lvl

A hierarchical classification value indicating the position of an insurance policy within a coverage structure, such as individual, family, or group level, used in enrollment, claims, and PBM systems to apply correct benefit limits, cost-sharing rules, and coordination of benefits logic during adjudication.

policy license numberpol_lic_nbr

The professional or state-issued license number associated with a policyholder or insured entity on an insurance coverage agreement. Used in enrollment and credentialing systems to verify regulatory compliance, particularly for professional liability or occupational coverage policy types.

policy marital statuspol_mar_sts

The recorded marital status of the primary policyholder on an insurance coverage agreement, such as single, married, divorced, or widowed. Used in member enrollment systems to determine dependent eligibility, coordinate benefits with spousal coverage, and support demographic reporting requirements.

policy master identifierpol_mstr_id

The enterprise-level unique identifier assigned to an insurance coverage agreement, enabling consistent tracking and linkage of the policy record across member enrollment, claims processing, billing, and eligibility verification systems throughout the health plan lifecycle.

policy maximumpol_max

The maximum dollar amount or service limit an insurance coverage agreement will pay for covered benefits within a defined period, such as an annual out-of-pocket maximum or lifetime benefit cap, used in claims adjudication and member cost-sharing calculations.

policy medical record numberpol_mrn

The medical record number associated with the primary insured or subscriber on an insurance coverage agreement, used to link the policy record to clinical encounter and treatment history data across health plan and provider data systems.

policy middle namepol_mid_nm

The middle name or initial of the policyholder or primary subscriber on an insurance coverage agreement, used in member identity matching, eligibility verification, and coordination of benefits to distinguish individuals with similar first and last names.

policy minimumpol_min

The minimum dollar amount or service threshold defined within an insurance coverage agreement, such as a minimum deductible or floor benefit value, used in premium rating, benefit plan configuration, and claims adjudication processing rules.

policy mobilepol_mob

The mobile phone number associated with the policyholder or primary subscriber on an insurance coverage agreement, used for member outreach, enrollment communications, claims status notifications, and two-factor authentication in health plan portals.

policy modified bypol_mod_by

The user identifier of the individual or system that last updated the insurance coverage agreement record, supporting audit trail requirements, change management workflows, and data governance accountability within member enrollment and policy administration systems.

policy modified datepol_mod_dt

The date on which an insurance policy record was most recently updated in the source system, used in EHR, enrollment, and claims platforms to support change data capture, audit trail maintenance, incremental ETL processing, and downstream reporting of policy amendment activity.

PreviousPage 120 of 142Next