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 full nameger_full_nm

Contains the complete name of a geriatric patient, combining given name, middle name, and family surname as recorded in their clinical record. Used for formal identification in geriatric care documentation, legal forms, insurance submissions, and patient-facing communications within elderly care programs.

geriatric genderger_gndr

Records the gender identity or biological sex classification of a geriatric patient as documented in their clinical record. Used in geriatric care for sex-specific clinical screening protocols, risk stratification, hormone-related treatment planning, and demographic reporting within elderly population health programs.

geriatric glucoseger_gluc

Captures the measured blood glucose level for a geriatric patient, typically recorded in mg/dL from fasting or postprandial testing. Critical in elderly diabetes management and metabolic monitoring, where age-related hypoglycemia risk and atypical symptom presentation require closer glycemic surveillance and individualized care thresholds.

geriatric group numberger_grp_nbr

Records the insurance group number associated with a geriatric patient's health plan, used to identify the employer or plan group under which the elderly patient is covered. Supports eligibility verification, claims adjudication, and coordination of benefits for geriatric care services including Medicare supplemental plans.

geriatric hemoglobinger_hgb

Stores the measured hemoglobin concentration in a geriatric patient's blood, typically expressed in g/dL. Used to assess anemia prevalence and severity in elderly patients, where reduced hemoglobin levels are associated with increased frailty, cognitive decline risk, and higher hospitalization rates in geriatric care populations.

geriatric history present illnessger_hpi

Documents the clinician-recorded narrative describing a geriatric patient's current medical complaint, including symptom onset, duration, severity, and progression. Essential in geriatric assessments where atypical disease presentations in elderly patients require detailed HPI documentation to guide accurate differential diagnosis and care planning.

geriatric identifierger_id

A unique alphanumeric key assigned to a geriatric patient, provider, or care program record within EHR, Medicare Advantage, or long-term care data systems. Used as a primary or foreign key in data pipelines to link clinical encounters, claims, pharmacy records, and enrollment data for elderly populations.

geriatric indexger_idx

A positional or ranked numeric value within a geriatric data structure, such as an ordered list of comorbidities, assessments, or care episodes in EHR or Medicare claims systems. Used by data engineers for array traversal, record ordering, and sequence validation in geriatric population data pipelines.

geriatric indicatorger_ind

A boolean or coded field signaling the presence of a geriatric-specific condition, program eligibility, or clinical attribute within EHR, Medicare Advantage, or long-term care systems. Used in risk scoring models, quality measure calculations, and population segmentation for elderly patient data workflows.

geriatric instructionger_instr

Structured or free-text guidance associated with geriatric care protocols, medication regimens, or discharge plans within EHR and long-term care systems. Captured in clinical documentation tables and used by data engineers to support care plan analytics, regulatory compliance reporting, and elderly patient safety workflows.

geriatric keyger_key

Represents a system-generated or assigned lookup reference value used to uniquely identify and retrieve a geriatric patient record within clinical or administrative databases. Functions as the primary linkage key for joining geriatric demographic, clinical, and billing records across integrated healthcare data systems and warehouses.

geriatric labelger_lbl

Contains the human-readable display text used to represent a geriatric record, category, or data element within clinical user interfaces and reports. Supports clear communication in geriatric care workflows by providing standardized descriptive labels for care plans, assessments, diagnoses, and program classifications used in elderly patient management.

geriatric languageger_lang

Records the preferred spoken or written communication language of a geriatric patient, used to ensure appropriate interpreter services, translated materials, and culturally sensitive care delivery. Critical in elderly care settings where language barriers can significantly impact medication adherence, informed consent, and care plan comprehension.

geriatric last nameger_last_nm

Stores the family surname of a geriatric patient as recorded in their clinical record. Used for patient identification, demographic reporting, and record matching across geriatric care systems. Accurate surname capture is essential in elderly populations to distinguish patients with common given names and prevent medical record misidentification.

geriatric legal nameger_legal_nm

Records the officially registered full name of a geriatric patient as it appears on government-issued identification or legal documents. Used in geriatric care for insurance eligibility verification, Medicare and Medicaid enrollment, advanced directive documentation, and legal consent forms requiring exact name matching for elderly patients.

geriatric levelger_lvl

A hierarchical classification value representing the acuity, care intensity, or organizational tier of a geriatric patient or service within EHR, Medicare Advantage, and long-term care data systems. Used in risk stratification, reimbursement tier assignment, and multi-level care coordination data pipeline logic.

geriatric license numberger_lic_nbr

Captures the professional license identifier associated with a clinician or facility providing geriatric care services. Used to verify credentialing, validate scope of practice, and support regulatory compliance reporting for practitioners delivering specialized elderly care, including geriatricians, gerontological nurse practitioners, and long-term care facility operators.

geriatric marital statusger_mar_sts

Records the current marital or relationship status of a geriatric patient, such as married, widowed, divorced, or single. Used in geriatric care assessments to evaluate social support networks, caregiver availability, and psychosocial risk factors, as marital status significantly influences care planning, living arrangements, and mental health outcomes in elderly patients.

geriatric master identifierger_mstr_id

The enterprise-level unique identifier assigned to a geriatric patient record, enabling consistent identification and cross-system matching across EHR platforms, care coordination systems, and clinical data repositories serving elderly patient populations aged 65 and older.

geriatric maximumger_max

The upper threshold value defined within geriatric clinical protocols or assessments, such as maximum dosage limits, functional score ceilings, or care plan parameter boundaries specific to elderly patients with age-related physiological considerations and comorbidity profiles.

PreviousPage 278 of 806Next