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 deleted dateger_del_dt

Date on which a geriatric record, encounter entry, or clinical document was marked for deletion or purged from the active dataset. Used in data governance, audit trail management, and record retention compliance workflows to document the lifecycle of geriatric patient information within clinical and administrative systems.

geriatric deleted indicatorger_del_ind

Boolean flag indicating that a geriatric record or encounter has been logically removed from active use within the clinical system. Enables soft-delete functionality, preserving historical geriatric data for audit and compliance purposes while excluding the record from operational reporting, billing, and active care management workflows.

geriatric descriptionger_desc

A free-text or coded textual field describing a geriatric care service, condition, or program element within EHR, long-term care, or Medicare claims systems. Used by data engineers to populate reference tables, care plan narratives, and specialty billing descriptors for elderly patient workflows.

geriatric detailger_dtl

Granular data attributes associated with a geriatric patient encounter, care plan, or claim record in EHR and Medicare systems. Captures supplemental clinical or administrative information such as functional assessments, ADL scores, or comorbidity specifics used in geriatric population analytics.

geriatric discharge dateger_dsch_dt

The calendar date on which an elderly patient is formally released from a geriatric care unit or facility. Captured in EHR and claims systems to calculate geriatric length of stay, coordinate post-acute care transitions, support CMS quality reporting, and trigger care management follow-up workflows.

geriatric due dateger_due_dt

Date by which a geriatric service, follow-up appointment, care plan review, or outstanding payment is required to be completed or received. Used in care coordination, chronic disease management, and revenue cycle workflows to trigger reminders, track overdue geriatric evaluations, and manage accounts receivable for elderly patient accounts.

geriatric durationger_dur

Measured time span of a geriatric encounter, treatment episode, therapy session, or clinical condition as documented in the elderly patient's record. Used to assess encounter complexity for billing purposes, evaluate rehabilitation progress, and analyze length of geriatric service utilization across care settings including inpatient and post-acute facilities.

geriatric emailger_eml

Electronic mail address associated with a geriatric patient, caregiver, or provider within EHR, care coordination, or member enrollment platforms. Used in Medicare Advantage and long-term care systems for outreach communications, care gap notifications, and patient engagement data workflows.

geriatric emergency indicatorger_emerg_ind

Boolean flag identifying that a geriatric encounter or clinical event was classified as an emergency requiring immediate intervention. Used to differentiate urgent geriatric presentations such as acute falls, delirium, or stroke from routine visits in claims data, clinical workflows, and quality reporting for elderly patient populations.

geriatric end dateger_end_dt

The date marking the conclusion of a geriatric care episode, authorization period, or program enrollment in EHR, Medicare claims, or long-term care systems. Used by data engineers to define record validity windows and support longitudinal geriatric cohort analysis and claims processing.

geriatric end timeger_end_tm

Timestamp recording the exact time at which a geriatric encounter, procedure, therapy session, or clinical activity was concluded. Used to calculate encounter duration, validate billing codes requiring time-based documentation, and support scheduling analytics for geriatric care programs and comprehensive multidisciplinary team assessments.

geriatric entered byger_ent_by

Identifies the user who entered or created the geriatric patient record in the clinical system. Used in audit trails to track data entry accountability, support compliance reviews, and maintain record integrity within EHR and geriatric care management workflows.

geriatric ethnicityger_ethn

Records the self-reported or assigned ethnic background of a geriatric patient, typically using standard classifications such as OMB categories. Used in geriatric care programs to support health equity reporting, population health analytics, and culturally appropriate care planning for elderly patients.

geriatric expiration dateger_exp_dt

The date after which a geriatric care authorization, benefit, or clinical protocol is no longer valid within Medicare Advantage, PBM, or long-term care data systems. Used to enforce eligibility boundaries during claims adjudication and care plan renewal workflows for elderly patient populations.

geriatric external identifierger_ext_id

Stores the unique identifier assigned to a geriatric patient by an external system, such as a referring hospital, state registry, or health information exchange. Enables cross-system patient matching, care coordination, and longitudinal tracking of elderly patients across disparate healthcare platforms.

geriatric faxger_fax

Records the facsimile number associated with a geriatric patient or their care facility, used for transmitting clinical documents, referral orders, and care summaries. Supports communication workflows in geriatric care coordination where electronic document exchange requires verified fax-based transmission.

geriatric feeger_fee

Captures the service charge billed or assessed for geriatric specialty care encounters, procedures, or programs. Used in billing workflows, cost tracking, and financial reporting specific to elderly patient care services, including memory care, fall prevention programs, and comprehensive geriatric assessments.

geriatric first nameger_first_nm

Stores the given name of a geriatric patient as recorded in their clinical record. Used for patient identification, demographic display, and communication in geriatric care settings. Supports accurate matching of elderly patients across EHR, scheduling, and care management systems to prevent identity errors.

geriatric flagger_flg

A binary indicator field used in EHR, Medicare claims, and member enrollment systems to designate records associated with geriatric patients or elderly care programs. Enables data engineers to filter populations aged 65 and older for quality reporting, risk stratification, and specialty analytics pipelines.

geriatric frequencyger_freq

Specifies the dosing or treatment schedule interval prescribed for a geriatric patient, such as daily, twice weekly, or as needed. Critical in elderly care management due to age-related pharmacokinetic changes and polypharmacy risks, supporting safe medication administration and care plan adherence monitoring.

PreviousPage 277 of 806Next