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 ratinggrp_rtg

A numeric or tiered assessment score assigned to an employer group or insurance group, used in underwriting and premium calculation. Reflects actuarial risk factors such as claims experience, demographics, and industry classification to determine appropriate premium rates for the group's health plan.

group ratiogrp_ratio

A calculated proportional measure comparing an employer group's actual claims experience to expected claims costs, used in experience rating and renewal underwriting. Informs premium adjustments and credibility weighting when blending group-specific experience with manual rates during plan renewal cycles.

group reasongrp_rsn

A coded or free-text explanation documenting why a specific action, change, or event occurred for an employer group or benefit group. Commonly captures rationale for enrollment changes, coverage terminations, rate adjustments, or plan modifications within member enrollment and billing systems.

group received dategrp_rcvd_dt

The date on which documentation, enrollment files, or applications associated with an employer group were received by the health plan or benefits administrator. Used in enrollment processing workflows to track submission timeliness, effective date eligibility, and compliance with open enrollment deadlines.

group referencegrp_ref

An identifier or external pointer linking an employer group record to related documentation, contracts, or transactions across health plan administration systems. Used to cross-reference group accounts between enrollment platforms, billing systems, and broker management tools for reconciliation and audit purposes.

group resolution dategrp_resol_dt

The date on which an outstanding issue, dispute, or pending action associated with an employer group was formally resolved. Captured in health plan administration and member services systems to track case closure timelines for billing disputes, enrollment discrepancies, or appeals processing.

group respirationgrp_resp

A clinical vital sign field recording the respiratory rate measurement collected in a group care or population health context. Represents breaths per minute documented during patient encounters, used in chronic disease management programs, clinical data aggregation, and population-level health monitoring workflows.

group revisiongrp_rev

A sequential version or iteration number tracking changes made to an employer group's benefit plan, contract terms, or enrollment configuration. Used in health plan administration systems to maintain an auditable history of plan amendments, rate changes, and eligibility rule updates over time.

group riskgrp_rsk

An actuarial or clinical risk classification assigned to an employer group based on aggregate member health status, claims utilization history, and demographic factors. Used in underwriting, care management stratification, and value-based contract design to predict future healthcare expenditures for the enrolled population.

group routegrp_rte

Identifies the administrative or distribution pathway through which an employer group's enrollment data, premium payments, or plan communications are processed. May indicate direct billing channels, broker intermediary routes, or electronic data interchange pathways used in group benefits administration systems.

group scheduled dategrp_sched_dt

The planned calendar date for a scheduled event, renewal, or processing activity associated with an employer group account. Used in health plan administration to track open enrollment windows, contract renewal dates, eligibility file processing schedules, and benefit implementation timelines.

group scheduled timegrp_sched_tm

The specific time of day designated for a planned processing event, transmission, or administrative activity related to an employer group. Used alongside group scheduled date in enrollment and billing workflows to coordinate eligibility file exchanges, automated billing runs, and renewal processing tasks.

group scoregrp_scr

A composite numeric value calculated to represent an employer group's overall risk profile, wellness engagement level, or underwriting standing. Derived from weighted factors including claims utilization, member demographics, health risk assessment participation, and prior authorization patterns used in population health and actuarial analytics.

group sequencegrp_seq

A numeric ordering value that defines the positional rank or processing priority of a group record within a series of related transactions or enrollment records. Used in health plan batch processing, claims adjudication, and eligibility file handling to maintain correct record ordering and dependency chains.

group severitygrp_sev

A classification indicating the seriousness or intensity level of a condition, event, or risk factor associated with a member population or employer group. Used in population health management, case management prioritization, and clinical program stratification to allocate care coordination resources based on acuity levels.

group sexgrp_sex

The aggregated or individual biological sex classification of members within an employer group, used in actuarial analysis, underwriting, and population health reporting. Supports gender-specific utilization modeling, clinical program targeting, and compliance reporting under state and federal health equity regulations.

group sourcegrp_src

Identifies the originating system, channel, or entity from which an employer group's enrollment data, eligibility information, or plan details were received. Used in health plan data governance to track whether records originated from employer HR systems, broker submissions, EDI transactions, or manual entry processes.

group start dategrp_start_dt

The calendar date marking the beginning of an employer group's benefit plan coverage period in member enrollment and payer systems. Used alongside group end date to define the active coverage window for eligibility validation, claims adjudication, and PBM benefit application.

group start timegrp_start_tm

The specific time at which a group-level event, session, coverage period, or system process begins. Used in health plan administration and care management platforms to record the precise start of group benefit coverage windows, wellness program sessions, or scheduled batch processing jobs for employer group accounts.

group stategrp_st

The US state or territory associated with an employer group's primary business location or plan situs, used to determine applicable state insurance regulations, mandated benefits, and tax requirements. Drives regulatory compliance rules applied to the group's health plan design and member eligibility configurations.

PreviousPage 126 of 325Next