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 medical record numberger_mrn

The facility-assigned medical record number uniquely identifying an elderly patient within a geriatric care setting or health system, used to link clinical encounters, care assessments, discharge summaries, and longitudinal health history across inpatient and outpatient geriatric services.

geriatric middle nameger_mid_nm

The middle name or initial of an elderly patient enrolled in geriatric care services, used for accurate identity verification, duplicate record resolution, and demographic matching across care coordination platforms serving older adult populations.

geriatric minimumger_min

The lower threshold value defined within geriatric clinical protocols or assessments, such as minimum functional scores, dosage floors, or care plan parameter boundaries that account for the heightened sensitivity and reduced physiological reserve common in elderly patient populations.

geriatric mobileger_mob

The mobile phone number associated with an elderly patient or their designated caregiver, used to facilitate appointment reminders, care coordination outreach, telehealth access, and emergency contact communication within geriatric care management programs.

geriatric modified byger_mod_by

The system user identifier of the clinician, care coordinator, or administrative staff member who last updated a geriatric patient record, supporting audit trail requirements, data governance compliance, and accountability tracking within geriatric care documentation workflows.

geriatric modified dateger_mod_dt

The most recent date on which a geriatric patient record was updated in EHR, Medicare claims, or long-term care data systems. Used by data engineers to identify record changes, trigger incremental data loads, and maintain audit trails for elderly patient clinical and administrative data pipelines.

geriatric modified timeger_mod_tm

The timestamp recording when a geriatric patient record was most recently updated, supporting data integrity auditing, change history tracking, and regulatory compliance across clinical documentation systems managing care for elderly patient populations.

geriatric nameger_nm

The display label or textual identifier for a geriatric patient, provider specialty, care program, or reference value within EHR, Medicare Advantage, and long-term care data systems. Used to populate lookup tables, user-facing reports, and data mappings in elderly care analytics and claims processing workflows.

geriatric noteger_nt

Free-text annotation field capturing clinical observations, care plan details, or administrative remarks specific to geriatric patient encounters. Used in EHR systems, care management platforms, and post-acute facility records to document age-related conditions, functional assessments, and multidisciplinary care coordination notes for elderly populations.

geriatric numberger_nbr

Numeric reference identifier assigned to geriatric-specific records, episodes of care, or program enrollments within healthcare data systems. Used in EHR, care management, and claims platforms to uniquely quantify and track geriatric service events, provider assignments, or care plan elements for patients typically aged 65 and older.

geriatric onset dateger_onset_dt

The date on which symptoms, a diagnosed condition, or a clinical event first appeared in an elderly patient, used to establish disease timelines, support geriatric syndrome assessments, and inform care planning for age-related conditions such as dementia, frailty, or fall-related injuries.

geriatric oxygen saturationger_o2sat

The peripheral blood oxygen saturation percentage measured for an elderly patient, typically via pulse oximetry, used to monitor respiratory status, assess hypoxia risk, and guide clinical interventions in geriatric care settings where pulmonary function may be compromised by age or comorbidities.

geriatric paid amountger_pd_amt

The total dollar amount reimbursed or paid for geriatric care services rendered, including Medicare, Medicaid, or supplemental insurance payments, used in claims adjudication, revenue cycle management, and financial reporting for elderly patient service lines.

geriatric paid dateger_pd_dt

The date on which payment was issued for geriatric care services, used in claims processing, accounts receivable reconciliation, and financial reporting workflows to track reimbursement timelines from Medicare, Medicaid, or private payers for elderly patient care.

geriatric parentger_prnt

Hierarchical relationship field identifying the superior or parent record to which a geriatric data element belongs, such as a primary diagnosis grouping, parent care episode, or master program enrollment. Used in EHR and care management systems to maintain relational integrity across geriatric service lines and care coordination hierarchies.

geriatric percentageger_pct

Ratio or proportional value representing geriatric-specific metrics such as functional decline rates, medication adherence percentages, or population health measures for elderly patients. Used in analytics platforms, care management systems, and quality reporting tools to benchmark and monitor outcomes across geriatric care programs and provider panels.

geriatric periodger_prd

Defined time span or duration associated with a geriatric care episode, program enrollment, or treatment interval for elderly patients. Used in EHR, claims, and care management systems to establish authorization windows, care plan durations, post-acute stay lengths, and reporting periods specific to geriatric service delivery and outcomes tracking.

geriatric phoneger_ph

Telephone contact number associated with a geriatric patient, caregiver, geriatric specialty provider, or care coordination program. Used in EHR, member enrollment, and care management platforms to facilitate outreach, appointment scheduling, and care coordination communications for elderly populations receiving geriatric-specific healthcare services.

geriatric preferred nameger_pref_nm

The name by which an elderly patient prefers to be addressed during care interactions, distinct from their legal name, used to personalize patient communications, improve engagement, and support dignity-centered care practices within geriatric care settings.

geriatric priceger_prc

The billed or contracted cost amount associated with geriatric care services, procedures, or care plan components, used in pricing analytics, Medicare reimbursement modeling, and cost management reporting for elderly patient care programs and service lines.

PreviousPage 279 of 806Next