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

geriatric effective dateger_eff_dt

The date on which a geriatric care plan, benefit coverage, or clinical protocol becomes active within Medicare Advantage, long-term care, or EHR systems. Used to validate record applicability during claims adjudication, eligibility checks, and longitudinal geriatric care data processing.

geriatric scheduled dateger_sched_dt

The calendar date on which a geriatric medicine appointment, assessment, or care management visit is planned for an elderly patient. Used in scheduling systems to coordinate multidisciplinary geriatric evaluations, cognitive assessments, fall risk screenings, and care transitions for older adult populations.

geriatric scheduled timeger_sched_tm

The clock time at which a geriatric medicine appointment or comprehensive geriatric assessment is scheduled to begin. Used in clinical scheduling systems to allocate sufficient appointment duration for elderly patients requiring complex evaluations, medication reviews, and functional assessments across multiple care domains.

geriatric street addressger_st_addr

The street-level address of the geriatric medicine clinic, memory care center, or senior health facility where care is delivered to elderly patients. Used in patient outreach, referral coordination, and claims processing to identify the physical location of geriatric specialty services and long-term care planning visits.

geriatric unitger_unt

Standardized unit of measure used in clinical data systems to quantify assessments, services, or interventions specific to geriatric specialty care. Applied in EHR and claims data to support care plan documentation, functional assessments, and long-term care billing workflows for elderly populations.

group addressgrp_addr

The physical mailing or location address associated with an employer group or health plan sponsor group in member enrollment records. Used in group benefits administration to route plan documents, billing statements, and renewal communications to the correct employer or group policyholder responsible for the insurance contract.

group agegrp_age

The age of an employer group or plan sponsor, typically measured in years since the group's inception or first enrollment date with a health plan. Used in underwriting, risk stratification, and group renewals to assess plan maturity, claims experience stability, and long-term cost trend analysis for group benefit contracts.

group allowed amountgrp_alwd_amt

The maximum dollar amount a health plan will reimburse for a covered service rendered to members within a specific employer group, based on contracted rates. Used in claims adjudication to calculate plan payment, member cost-sharing obligations, and to reconcile billed charges against negotiated fee schedules for group benefit plans.

group amountgrp_amt

Monetary value associated with a defined group entity in healthcare claims, member enrollment, or PBM systems. Represents financial figures such as group-level premiums, capitation payments, or negotiated contract amounts used in plan administration and financial reporting workflows.

group approval statusgrp_appr_sts

Indicates the current authorization state of an insurance or benefits group record, such as pending, approved, or rejected. Used in member enrollment and benefits administration systems to control whether a group's coverage and plan configurations are active and eligible for claims processing.

group approved bygrp_appr_by

Captures the identifier or name of the user or administrator who authorized an insurance or benefits group record. Used in enrollment and benefits administration audit trails to maintain accountability and compliance when group coverage terms or plan configurations are approved.

group arrival timegrp_arrv_tm

Records the time at which a patient or member group arrived at a healthcare facility for a scheduled or unscheduled encounter. Used in scheduling, patient flow, and operational reporting systems to measure wait times, throughput, and facility capacity management.

group arrived dategrp_arrv_dt

Records the calendar date on which a patient or member group was registered as arrived at a healthcare facility. Used in scheduling, patient flow, and operational analytics to track appointment adherence, no-show rates, and encounter initiation timelines.

group assessmentgrp_asmt

Contains the clinical evaluation narrative or structured findings documented for a group encounter or shared care session. Used in EHR and clinical documentation systems to record diagnostic impressions, group therapy evaluations, or collective health screenings performed across multiple participants.

group balancegrp_bal

Represents the outstanding financial amount owed by or attributed to an insurance or benefits group after payments and adjustments have been applied. Used in healthcare billing and accounts receivable systems to track unpaid obligations at the group level for premium billing or claims reconciliation.

group billed amountgrp_bill_amt

Captures the total dollar amount invoiced to an insurance or benefits group for services rendered during a specific billing period. Used in claims processing and premium billing systems to establish the initial charge before contractual adjustments, payments, or discounts are applied.

group birth dategrp_birth_dt

Records the date of birth associated with a member within a group enrollment context, used to determine age-based eligibility, dependent coverage rules, and premium tier calculations. Referenced in member enrollment and benefits administration systems for compliance with plan terms and regulatory requirements.

group blood pressuregrp_bp

Records the systolic and diastolic arterial pressure measurement captured during a group clinical encounter or population health screening event. Used in EHR and public health systems to document and monitor cardiovascular health metrics across a defined patient cohort or group care session.

group cancelled dategrp_cncl_dt

Records the date on which an insurance or benefits group's coverage, enrollment, or scheduled service was formally cancelled. Used in member enrollment and billing systems to mark the termination point for coverage calculations, claims adjudication eligibility, and retroactive adjustment processing.

group categorygrp_cat

Classifies an insurance or benefits group into a defined segment such as employer group, association, individual market, or government plan. Used in enrollment and benefits administration systems to apply appropriate plan rules, rating structures, regulatory requirements, and reporting hierarchies.

PreviousPage 121 of 325Next