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 modified dategrp_mod_dt

The calendar date on which a benefit group record was most recently updated in the enrollment or plan administration system. Used in audit trails and data governance processes to track when changes to group demographics, plan configurations, or contract terms occurred.

group modified timegrp_mod_tm

The timestamp indicating the exact time a benefit group record was last updated in the enrollment or plan administration system. Combined with the modified date, this field supports precise audit logging and change tracking for group plan and contract record management.

group namegrp_nm

The human-readable display name of an employer group or plan sponsor as stored in member enrollment, EHR, and PBM systems. Used in reporting, member ID cards, explanation of benefits documents, and eligibility verification interfaces to identify the sponsoring organization.

group numbergrp_nbr

The unique identifier assigned to an employer group or plan sponsor by a health plan or PBM, used across claims, enrollment, and pharmacy systems to link members to their contracted benefits. Appears on member ID cards and is required for eligibility verification and claims adjudication.

group onset dategrp_onset_dt

The date on which a condition, episode, or benefit period began for members within a defined group. Used in clinical and claims data to establish the start of a diagnosis or treatment period, supporting coordination of benefits and utilization management reporting.

group oxygen saturationgrp_o2sat

The aggregated or recorded blood oxygen saturation measurement for members within a clinical group or care management cohort. Used in population health management and chronic disease monitoring programs to track respiratory health metrics across enrolled member groups.

group paid amountgrp_pd_amt

The total dollar amount paid by the insurance group, employer plan sponsor, or payer on behalf of members within a defined benefit group. Used in claims adjudication and financial reporting to track group-level expenditures against plan funding and budget allocations.

group paid dategrp_pd_dt

The date on which a payment was issued by or on behalf of a benefit group, such as an employer plan sponsor's premium payment to the payer. Used in premium billing, accounts receivable, and cash reconciliation workflows to confirm timely group payment and maintain coverage continuity.

group parentgrp_prnt

The identifier or name of the parent entity in a hierarchical group structure, such as a parent employer group that sponsors multiple subsidiary benefit groups. Used in enrollment and account management systems to manage multi-level group relationships and consolidated reporting.

group percentagegrp_pct

A numeric percentage value associated with an employer group in benefits administration, PBM, or claims systems. Commonly represents cost-sharing ratios, employer contribution rates, or benefit allocation percentages applied during plan configuration or financial settlement calculations.

group periodgrp_prd

The defined time interval associated with a benefit group's coverage, contract, or performance measurement cycle, such as a plan year or billing period. Used in enrollment, claims, and financial reporting to scope data and calculations to the relevant group coverage window.

group phonegrp_ph

The primary telephone number associated with a benefit group's administrative contact or employer group plan sponsor. Used in member enrollment and account management systems to facilitate communication regarding plan administration, billing, eligibility inquiries, and group renewals.

group preferred namegrp_pref_nm

The designated display name that an employer group or benefit group prefers to use in member communications, plan documents, and administrative portals. This name may differ from the official legal entity name and is used to support accurate and recognizable group identification in enrollment systems.

group pricegrp_prc

The negotiated or contracted cost amount associated with a benefit group's plan, product, or service tier. Used in employer group sales, underwriting, and premium billing processes to establish and track the rate charged to the group for coverage based on plan design and enrollment size.

group primary indicatorgrp_prim_ind

A flag denoting whether a benefit group record is the primary or preferred group association for a member, account, or plan configuration. Used in enrollment and eligibility systems to establish the primary payer group for coordination of benefits and claims adjudication purposes.

group prioritygrp_prty

A numeric or categorical ranking assigned to a benefit group that determines its order of precedence in processes such as coordination of benefits, care management outreach, or claims adjudication. Used in payer systems to resolve conflicts when a member belongs to multiple group plans.

group pulsegrp_pulse

The aggregated or recorded heart rate measurement captured for members within a clinical group or care management cohort. Used in population health and chronic disease management programs to monitor cardiovascular health metrics and identify members requiring clinical intervention or follow-up.

group quantitygrp_qty

A numeric quantity value associated with an employer group in benefits, PBM, or enrollment systems. May represent the number of enrolled members, benefit units, dispensed prescription quantities under a group contract, or aggregate transaction counts used in financial reconciliation and reporting.

group racegrp_race

The racial or ethnic classification associated with members within a benefit group or clinical cohort, collected for population health reporting and health equity analysis. Used in HEDIS, quality, and demographic reporting to identify disparities in care access and outcomes across member populations.

group rategrp_rt

The per-unit or per-member premium rate negotiated for a benefit group based on plan design, demographic factors, and enrollment size. Used in employer group underwriting, premium billing, and actuarial reporting to calculate total group premiums and evaluate plan pricing performance.

PreviousPage 125 of 325Next