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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

group glucosegrp_gluc

The aggregated or individual blood glucose measurement recorded within a clinical or wellness program associated with a member group. Used in population health management, chronic disease tracking, and employer wellness program reporting to monitor diabetic risk across enrolled members.

group group numbergrp_grp_nbr

A nested or cross-referenced insurance group identifier that links a subgroup or division to a parent group in multi-tiered employer benefit structures. Used in eligibility verification, claims adjudication, and premium billing to accurately route and process group-level transactions.

group hemoglobingrp_hgb

The recorded hemoglobin measurement for members within a clinical or wellness program associated with a benefit group. Used in population health management and employer wellness reporting to monitor anemia risk, cardiovascular health, and overall hematological status across enrolled populations.

group identifiergrp_id

Unique system-generated or payer-assigned alphanumeric key that identifies an employer group or plan sponsor in EHR, claims, and PBM platforms. Used to associate members with contracted benefit structures and validate eligibility during claims adjudication and enrollment processing.

group indexgrp_idx

A sequential or ranked position value assigned to a benefit group record within a dataset or hierarchical structure in enrollment and billing systems. Used to order, sort, and navigate group records efficiently in premium processing, reporting, and data integration workflows.

group indicatorgrp_ind

A binary flag (yes/no or 1/0) in enrollment, claims, and PBM systems that designates whether a member, record, or transaction is associated with a specific employer group configuration, benefit tier, or plan sponsor category. Used for segmentation and adjudication routing.

group keygrp_key

A unique surrogate or natural key value assigned to a benefit group record that serves as the primary lookup reference across enrollment, billing, and claims systems. Used to join and reconcile group data across disparate healthcare data platforms and reporting environments.

group languagegrp_lang

The preferred spoken or written language associated with a benefit group or its primary contact, used to guide member communications and document translation in enrollment and customer service operations. Supports language access compliance and culturally appropriate health plan outreach.

group last namegrp_last_nm

The surname or family name of an individual associated with a benefit group, such as a group administrator or enrollee contact in member enrollment systems. Used in identity verification, correspondence generation, and group account management workflows.

group legal namegrp_legal_nm

The officially registered legal name of an employer group or benefit plan sponsor as recorded in government filings and insurance contracts. Used in regulatory submissions, plan documents, premium billing, and legal correspondence to accurately identify the contracting entity.

group levelgrp_lvl

The hierarchical tier or classification position assigned to a benefit group within a multi-level employer or insurance group structure. Used in benefit administration, premium rating, and reporting to distinguish between parent groups, subgroups, and divisions in complex account hierarchies.

group license numbergrp_lic_nbr

The regulatory license or registration number assigned to a benefit group, employer group, or plan sponsor by a state or federal authority. Used in compliance reporting, contract validation, and eligibility processing to confirm the group's authorization to offer or receive insurance benefits.

group marital statusgrp_mar_sts

The recorded marital or domestic partnership status of a member or contact associated with a benefit group in enrollment systems. Used to determine dependent eligibility, benefit tier classification, and premium calculations under group health plan rules and qualifying life event processing.

group master identifiergrp_mstr_id

The enterprise-level master identifier that uniquely and persistently identifies a benefit group across all systems within a health plan or benefits administration platform. Used to reconcile group records across enrollment, claims, billing, and analytics systems to eliminate duplication and ensure data integrity.

group maximumgrp_max

The upper limit value defined for a benefit group, such as maximum covered members, maximum benefit amount, or maximum premium contribution in group insurance contracts. Used in eligibility management, claims adjudication, and benefit plan configuration to enforce group-level coverage caps.

group medical record numbergrp_mrn

The medical record number assigned to a patient or member within a group clinical program or integrated care setting, linking clinical records to their associated benefit group in health plan or employer wellness systems. Used to coordinate care management, population health reporting, and clinical-financial data integration.

group middle namegrp_mid_nm

The middle name or initial associated with a benefit group or employer group record in member enrollment systems. Used to differentiate groups with similar names and ensure accurate identification across enrollment, billing, and eligibility verification workflows.

group minimumgrp_min

The lower threshold value defined for a benefit group, such as minimum enrolled members required to maintain group coverage eligibility or minimum contribution amounts. Used in underwriting and employer group contract management to enforce plan participation requirements.

group mobilegrp_mob

The mobile or cell phone number associated with a benefit group's administrative contact, employer group representative, or plan sponsor. Used in member enrollment and account management systems to facilitate direct communication regarding group plan changes, renewals, or billing inquiries.

group modified bygrp_mod_by

The unique identifier of the user or system process that last updated a benefit group record in the enrollment or plan administration system. Used in audit logging to track accountability for changes made to group demographics, plan assignments, or contract terms.

PreviousPage 124 of 325Next