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

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

geriatric typeger_typ

Classifies a geriatric specialty record, encounter, or service into a defined category such as cognitive assessment, fall prevention, palliative care, or long-term care management. Used in EHR and claims systems to organize elderly patient data for clinical reporting, quality measurement, and care coordination workflows.

geriatric updated dateger_upd_dt

The most recent date on which a geriatric patient record, care plan, assessment, or clinical document was modified or refreshed in the healthcare system. Supports audit trails, version control, and care team synchronization to ensure all providers reference current clinical information for elderly patients.

geriatric urgencyger_urg

A classification indicating the time-sensitivity level of a geriatric referral, intervention, or clinical need, such as routine, urgent, or emergent. Guides triage prioritization for elderly patients who may have limited physiological reserve and are at elevated risk of rapid deterioration without timely clinical response.

geriatric valueger_val

Stores a specific measured data point within geriatric specialty data, such as a clinical assessment score, functional status rating, or cost figure for elderly patient care. Referenced in EHR, claims, and population health systems to support risk stratification, outcomes measurement, and geriatric program evaluation.

geriatric versionger_ver

The sequential version number assigned to a geriatric care plan, clinical protocol, assessment tool, or regulatory submission document. Ensures traceability of iterative changes made to elderly patient care management records and supports compliance with documentation standards in geriatric care programs.

geriatric zipger_zip

The postal code associated with a geriatric care facility or specialty practice location. Used in population health analytics to identify geographic concentrations of elderly patients, map access to senior care services, and support age-specific health program planning.

group active indicatorgrp_actv_ind

A binary flag indicating whether an employer or insurance group is currently active within the member enrollment system. Used to filter eligible groups for billing, premium collection, and benefits administration, distinguishing active groups from terminated or suspended accounts.

group active statusgrp_actv_sts

A categorical status value representing the current enrollment lifecycle state of an employer or insurance group, such as Active, Suspended, or Terminated. Used in member eligibility verification, premium billing workflows, and group contract management within health plan systems.

group admission dategrp_admn_dt

The date on which a group of patients was collectively admitted, typically in a batch claims or institutional encounter context. Used in inpatient claims processing to establish the start of a covered episode and calculate length of stay for grouped encounter billing records.

group discharge dategrp_dsch_dt

The date on which a grouped set of patients or a batch institutional encounter was discharged. Used in inpatient claims adjudication to define the end of a covered episode, calculate total length of stay, and trigger final billing and reimbursement processing.

group emergency indicatorgrp_emerg_ind

A flag identifying whether a grouped encounter or batch of claims involves emergency services. Used in claims adjudication to apply appropriate emergency reimbursement rates, bypass prior authorization requirements, and ensure compliance with emergency care coverage mandates.

group history present illnessgrp_hpi

A narrative text field capturing the collective history of present illness documented across a group encounter or shared clinical visit. Used in clinical documentation systems to record the onset, duration, and progression of conditions affecting multiple patients seen together in a group therapy or shared medical appointment setting.

group instructiongrp_instr

Textual guidance or directives associated with an employer or insurance group, specifying plan rules, benefit limitations, or administrative procedures. Used in health plan configuration and member services to communicate group-specific eligibility requirements, enrollment instructions, and coverage conditions.

group labelgrp_lbl

A descriptive display name or identifier assigned to an employer group or insurance plan group within a health plan enrollment system. Used in member portals, reporting dashboards, and benefits administration interfaces to present group information in a human-readable format.

group notegrp_nt

A free-text annotation associated with an employer group or insurance group record in a health plan enrollment or billing system. Used to capture administrative comments, special handling instructions, contract exceptions, or historical context relevant to the group's account management.

group procedure dategrp_proc_dt

The date on which a procedure was performed across a grouped set of claims or encounters in a batch submission. Used in claims processing to establish the service date for adjudication, apply timely filing rules, and coordinate benefits across multiple payers for grouped institutional or professional claims.

group rangegrp_rng

The defined minimum and maximum boundaries applied to a group-level data element, such as eligible age bands, premium tiers, or enrollment size thresholds. Used in health plan underwriting, rating, and eligibility configuration to determine which employer groups qualify for specific benefit products or pricing structures.

group resultgrp_rslt

The aggregate outcome or collective measurement derived from a group-level clinical or administrative process, such as population health screening results or batch lab processing outcomes. Used in value-based care programs and quality reporting to assess performance across attributed patient populations.

group surgery dategrp_surg_dt

The date on which surgical procedures were performed for a grouped set of claims or encounters submitted in batch. Used in inpatient and outpatient claims adjudication to validate service timing, apply surgical global period rules, and coordinate facility and professional billing for grouped operative encounters.

guarantor active indicatorguar_actv_ind

A binary flag indicating whether a guarantor, the party financially responsible for patient account balances, is currently active in the patient accounting system. Used in revenue cycle management to determine eligibility for billing, payment plan enrollment, and collections activity on outstanding balances.

PreviousPage 282 of 806Next