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 charge amountgrp_chrg_amt

Represents the gross dollar amount charged for services or premiums associated with a specific benefits or insurance group before any negotiated discounts, capitation adjustments, or payments are applied. Used in healthcare billing and claims systems for revenue cycle tracking and financial reporting.

group chief complaintgrp_cc

Documents the primary symptom or reason for visit reported at a group clinical encounter such as a group therapy session or shared health screening. Used in clinical documentation and EHR systems to guide assessment, treatment planning, and coding for group-based services.

group childgrp_chld

Identifies a subordinate group record within a hierarchical benefits or enrollment structure, where one group is nested under a parent group. Used in member enrollment and plan administration systems to manage complex organizational structures, multi-site employer accounts, and tiered coverage arrangements.

group citygrp_city

Stores the municipality name associated with the mailing or physical address of an insurance or benefits group, such as an employer group or plan sponsor. Used in enrollment, billing, and regulatory reporting systems for geographic segmentation, tax jurisdiction determination, and correspondence routing.

group classgrp_cls

Designates the classification tier assigned to an insurance or benefits group, such as small group, large group, or self-funded, used to determine applicable regulatory requirements, rating methodologies, and benefit structures. Referenced in enrollment and underwriting systems for plan configuration and compliance reporting.

group codegrp_cd

Alphanumeric identifier assigned to a defined employer, plan sponsor, or benefit group in member enrollment, claims, and PBM systems. Used to associate members with specific coverage tiers, benefit structures, and contractual arrangements for eligibility verification and adjudication processing.

group commentgrp_cmt

Contains free-text notes or annotations entered by administrators or clinical staff regarding a specific insurance group, enrollment action, or group encounter. Used in benefits administration and care management systems to capture contextual details that do not fit structured data fields, supporting audit and operational workflows.

group completed dategrp_cmpl_dt

Records the date on which a group-level service, enrollment transaction, or administrative workflow was fully completed. Used in scheduling, benefits administration, and care management systems to mark task closure, calculate turnaround times, and trigger downstream processes such as billing or eligibility activation.

group confidential indicatorgrp_conf_ind

A flag that designates a group record or associated data as confidential, restricting access to authorized users only. Used in member enrollment and benefits administration systems to protect sensitive group information such as behavioral health coverage, legal arrangements, or proprietary employer contract terms.

group countgrp_cnt

Numeric count of entities associated with a specific employer group or plan sponsor in member enrollment and benefits administration systems. Used in PBM and EHR platforms to track member volume, subgroup totals, or benefit tier populations within a group contract.

group countrygrp_ctry

Stores the country name or code associated with the address of an insurance or benefits group, such as an international employer group or multinational plan sponsor. Used in enrollment and regulatory reporting systems to support geographic segmentation, cross-border coverage rules, and international compliance requirements.

group created bygrp_crtd_by

Identifies the username or system account responsible for creating the employer group record in the health plan or benefits administration system. Used in audit trails to track data entry accountability and troubleshoot enrollment configuration issues across group management workflows.

group created dategrp_crtd_dt

Records the calendar date when an employer group record was first established in the health plan or benefits administration system. Used for auditing group setup timelines, tracking enrollment cycles, and reconciling group effective dates against contract start dates in member eligibility systems.

group created timegrp_crtd_tm

Records the exact timestamp when an employer group record was first established in the health plan or benefits administration system. Used alongside the created date to sequence batch processing events, resolve duplicate group records, and maintain precise audit logs in enrollment systems.

group creatininegrp_cr

Captures the serum creatinine measurement for a cohort or patient group, used as a key biomarker for assessing kidney function and chronic kidney disease staging. Aggregated at the group level in population health and care management programs to identify members requiring nephrology intervention or medication adjustment.

group dategrp_dt

Stores a general-purpose calendar date associated with an employer group record in a health plan or benefits administration system. Contextual meaning varies by use case but typically relates to key contract milestones, reporting periods, or group-level transaction dates within enrollment or billing workflows.

group datetimegrp_dttm

Stores a combined date and time value associated with an employer group event or transaction in a health plan or benefits administration system. Used to precisely timestamp group-level actions such as eligibility updates, plan changes, or system-generated enrollment transactions for sequencing and audit purposes.

group dea numbergrp_dea_nbr

Stores the Drug Enforcement Administration registration number assigned to a prescribing group practice or clinical entity authorized to prescribe controlled substances. Used in pharmacy claims processing and prescription validation to verify legitimate controlled substance prescribing authority at the group practice level.

group death dategrp_death_dt

Records the dissolution or termination date of an employer group in the health plan system, analogous to a death date for the group entity. Used to close out active member enrollments, halt premium billing, and trigger COBRA or continuation coverage notifications in benefits administration workflows.

group deleted dategrp_del_dt

Records the date on which an employer group record was logically removed or inactivated in the health plan or benefits administration system. Used in data governance and audit processes to track when groups were retired, supporting historical reporting and compliance with record retention policies.

PreviousPage 122 of 325Next