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

coverage entered bycov_ent_by

The identifier of the user, system, or operator who created or submitted the insurance coverage record in the enrollment or eligibility management system. Used for audit trail purposes to track data entry accountability, detect keying errors, and support compliance reviews of enrollment transactions.

coverage ethnicitycov_ethn

The self-reported or assigned ethnicity of the individual associated with an insurance coverage record, such as the subscriber or dependent. Used in member enrollment and population health systems to support HEDIS reporting, health equity analysis, and regulatory demographic compliance requirements.

coverage expiration datecov_exp_dt

The date on which an insurance coverage period officially ends and benefits are no longer valid. Used in member enrollment and claims adjudication systems to reject claims submitted after the coverage term, trigger renewal workflows, and calculate COBRA or continuation coverage eligibility windows.

coverage external identifiercov_ext_id

A unique identifier assigned by an external system, trading partner, or employer group to reference an insurance coverage record. Used in enrollment and eligibility data exchanges to reconcile coverage records across payer systems, clearinghouses, and employer benefits platforms using standard EDI transactions.

coverage faxcov_fax

The facsimile telephone number associated with an insurance coverage record, typically for the policyholder, employer group contact, or benefits administrator. Used in enrollment systems to route coverage verification requests, prior authorization documents, and eligibility correspondence requiring physical transmission.

coverage feecov_fee

The premium amount or periodic charge assessed for maintaining an insurance coverage plan, attributed to the subscriber, employer group, or both. Used in member billing and enrollment systems to calculate payment obligations, apply employer contributions, and reconcile premium receivables against active coverage records.

coverage first namecov_first_nm

The given name of the primary insured individual or subscriber associated with an insurance coverage record. Used in member enrollment systems to populate eligibility files, verify identity during claims processing, generate member ID cards, and match coverage records to patient demographics.

coverage flagcov_flg

A binary or coded indicator on an insurance coverage record that signals a specific condition, exception, or processing rule, such as coordination of benefits priority, Medicare secondary payer status, or COBRA election. Used in claims adjudication and enrollment systems to modify standard benefit processing logic.

coverage frequencycov_freq

The recurring interval at which a benefit service, premium payment, or coverage-related event occurs, such as monthly premium billing cycles or annual benefit maximums resets. Used in member enrollment and billing systems to schedule payment collection and track cumulative benefit utilization limits.

coverage full namecov_full_nm

The complete legal name of the subscriber or policyholder associated with an insurance coverage record, combining given, middle, and family name components. Used in enrollment systems for identity verification, member correspondence, eligibility file generation, and matching coverage records to claims and clinical data.

coverage gendercov_gndr

The gender designation recorded on an insurance coverage record for the subscriber or insured individual. Used in member enrollment systems to support claims adjudication for gender-specific benefits, actuarial risk classification, HEDIS measure stratification, and regulatory demographic reporting requirements.

coverage glucosecov_gluc

A blood glucose measurement value captured in the context of a member's coverage record, typically used in disease management or value-based care programs to track diabetic members. Used to assess health risk, trigger care management outreach, and support quality metric reporting tied to insurance benefit programs.

coverage group numbercov_grp_nbr

The unique identifier assigned to an employer group, association, or plan sponsor under which a member's insurance coverage is issued. Used in enrollment and claims systems to apply group-specific benefit structures, coordinate employer contributions, and route eligibility transactions via EDI 834 enrollment files.

coverage hemoglobincov_hgb

The hemoglobin lab value recorded in association with a member's insurance coverage record, used to support clinical eligibility determinations, care management programs, or coverage decisions tied to specific medical conditions such as anemia or dialysis-related benefits.

coverage identifiercov_id

A system-generated unique key assigned to a specific coverage record within member enrollment, payer, or benefits administration databases. Used as a primary or foreign key to link coverage data across eligibility, claims, and plan configuration tables in EHR, PBM, and payer data systems.

coverage indexcov_idx

A numeric position or sequence value assigned to a member's insurance coverage record when multiple coverages exist, enabling ordered retrieval and processing of primary, secondary, or tertiary insurance plans within enrollment and claims adjudication systems.

coverage indicatorcov_ind

A binary yes/no or true/false flag stored in member enrollment, benefits, or claims systems to denote whether a specific coverage type, benefit, or service category is applicable to a member or plan. Used in eligibility determination, benefits configuration, and claims routing logic across payer and PBM platforms.

coverage instructioncov_instr

Free-text or coded guidance associated with a member's insurance coverage record that specifies special handling rules, benefit exceptions, referral requirements, or plan-specific processing directives used during claims adjudication or member services workflows.

coverage keycov_key

A surrogate or natural lookup identifier assigned to an insurance coverage record, used to join coverage data across enrollment, claims, and eligibility systems without relying on member-facing identifiers such as subscriber ID or policy number.

coverage languagecov_lang

The preferred spoken or written language associated with an insured member's coverage record, used to route member communications, explanation of benefits documents, and care management outreach in the member's primary language per CMS and state mandate requirements.

PreviousPage 38 of 142Next