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

Gross charge posted for geriatric specialty services before payer adjustments, contractual discounts, or patient cost-sharing reductions are applied. Used in revenue cycle reporting to track the standard fee-schedule value of geriatric encounters, assessments, and care management services prior to claim adjudication.

geriatric chief complaintger_cc

Primary symptom or concern reported by an elderly patient at the initiation of a geriatric encounter, documented in the patient's own words. Commonly includes complaints such as falls, memory loss, functional decline, or polypharmacy concerns, and drives the clinical evaluation pathway for geriatric workups.

geriatric childger_chld

ger_chld identifies a subordinate entity linked to a parent geriatric record within hierarchical EHR or care management data models. Used in LTSS, care plan, and authorization systems to represent dependent service lines, sub-encounters, or related records nested under a primary geriatric patient or program record structure.

geriatric cityger_city

Municipality of residence or service delivery location associated with an elderly patient's geriatric care record. Used in population health analytics, social determinants of health assessments, and geographic access reporting to evaluate geriatric service availability and transportation barriers for aging patients.

geriatric classger_cls

ger_cls stores the classification tier assigned to a geriatric patient, service, or benefit category within EHR, claims, and member management systems. Used to differentiate care levels such as skilled nursing, custodial, or community-based services, supporting LTSS program enrollment logic, benefit limit enforcement, and geriatric care reporting workflows.

geriatric codeger_cd

ger_cd stores a standardized classification value such as an ICD-10, HCPCS, or program-specific code associated with geriatric care services in EHR, claims, and LTSS systems. Used to identify service types, diagnoses, or care program categories in adjudication edits, quality reporting, and elderly population analytics pipelines.

geriatric commentger_cmt

ger_cmt stores free-text notations associated with geriatric patient records, authorizations, or service encounters in EHR, care management, and claims systems. Used by care coordinators and data engineers to capture clinical context, override justifications, or workflow notes that support LTSS decision-making, audit trails, and geriatric care documentation requirements.

geriatric completed dateger_cmpl_dt

Date on which a geriatric service, evaluation, or care plan was fully completed and documented. Used to measure care delivery timelines, track compliance with geriatric follow-up protocols, and calculate time-to-completion metrics for comprehensive geriatric assessments and post-acute care transitions.

geriatric confidential indicatorger_conf_ind

Boolean flag designating that a geriatric patient's record or specific clinical information is subject to enhanced privacy protections. Restricts access to sensitive geriatric data such as cognitive impairment diagnoses, guardianship status, or behavioral health findings within EHR role-based access control systems.

geriatric contactger_cntct

ger_cntct stores the communication details for a geriatric patient, caregiver, or facility within EHR, member enrollment, and care management systems. Used to facilitate outreach for care coordination, LTSS service delivery, care plan follow-up, and emergency notifications, supporting data quality validation of phone, email, and address fields.

geriatric countger_cnt

Tracks the total number of occurrences, encounters, or patient records associated with geriatric specialty care for patients typically aged 65 and older. Used in EHR analytics, claims data, and population health platforms to monitor care utilization, resource allocation, and quality measure performance for elderly populations.

geriatric countryger_ctry

Country of residence or citizenship associated with an elderly patient's geriatric care record. Used in demographic reporting, international patient coordination, and cross-border care management workflows to ensure appropriate documentation standards, language support, and regulatory compliance for geriatric patients.

geriatric created byger_crtd_by

Unique identifier of the clinical user, system, or application that initially created the geriatric record or encounter entry. Supports audit trail requirements, accountability tracking, and data provenance for geriatric documentation, ensuring compliance with medical record integrity and HIPAA audit control standards.

geriatric created dateger_crtd_dt

Timestamp recording when a geriatric patient record was first entered into EHR or claims systems. Critical for auditing data lineage in elderly care workflows, including long-term care facilities, Medicare Advantage plans, and geriatric specialty billing platforms.

geriatric created timeger_crtd_tm

Timestamp recording the exact date and time at which a geriatric record, encounter, or clinical document was first entered into the system. Used for audit logging, workflow sequencing, and data integrity validation to establish the chronological baseline of geriatric patient documentation within clinical information systems.

geriatric creatinineger_cr

Serum creatinine laboratory value measured in elderly patients to assess kidney function and glomerular filtration rate. Particularly significant in geriatric care for monitoring age-related renal decline, adjusting medication dosing for renally-cleared drugs, and detecting acute kidney injury in aging patients with reduced baseline muscle mass.

geriatric dateger_dt

A calendar date value associated with a geriatric care event or record, used across EHR, Medicare claims, and long-term care systems to anchor clinical encounters, assessments, or administrative transactions specific to elderly patient populations aged 65 and older.

geriatric datetimeger_dttm

A combined date and time stamp for geriatric care events recorded in EHR, Medicare Advantage, or long-term care data systems. Enables precise sequencing of clinical encounters, medication administration, and care plan updates for elderly patient populations in data pipelines.

geriatric dea numberger_dea_nbr

Drug Enforcement Administration registration number assigned to a clinician authorized to prescribe controlled substances within geriatric care settings. Captured in prescribing records to validate legal authority for controlled medication orders, particularly relevant for pain management and psychiatric medications commonly used in elderly patient populations.

geriatric death dateger_death_dt

The recorded date of death for a geriatric patient, sourced from EHR, Medicare claims, or Social Security Death Index feeds. Used in mortality analytics, care quality reporting, and member disenrollment processing within Medicare Advantage and long-term care data systems.

PreviousPage 276 of 806Next