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

ophthalmology emailopht_eml

The electronic mail address associated with an ophthalmology contact, such as a referring eye care specialist or optometry practice. Used in care coordination communications, referral management, and clinical correspondence routing within eye care networks.

ophthalmology emergency indicatoropht_emerg_ind

A flag identifying whether an ophthalmology encounter was classified as an emergency, such as acute angle-closure glaucoma or traumatic eye injury. Used in claims triage, authorization workflows, and utilization review to prioritize urgent eye care cases.

ophthalmology end dateopht_end_dt

The date marking the conclusion of an ophthalmology treatment plan, authorization period, or vision care benefit interval. Used in utilization management, care plan tracking, and benefit eligibility verification for eye care services rendered to members or patients.

ophthalmology end timeopht_end_tm

The specific time at which an ophthalmology procedure or clinical encounter concluded. Used in surgical scheduling systems, operating room logs, and clinical documentation to calculate procedure duration and support resource planning for eye care facilities.

ophthalmology entered byopht_ent_by

The identifier of the user or system that created or submitted an ophthalmology record within the eye care data system. Supports audit trails, data quality reviews, and accountability tracking for clinical entries related to vision care encounters and referrals.

ophthalmology ethnicityopht_ethn

The self-reported or administratively recorded ethnicity of a patient receiving ophthalmology services. Used in population health analytics, eye disease disparity research, and HEDIS reporting to monitor equitable access to vision care and ocular disease screening.

ophthalmology expiration dateopht_exp_dt

The date on which an ophthalmology authorization, referral, or vision care benefit period becomes invalid. Used in prior authorization management and claims adjudication to determine whether eye care services were rendered within the approved coverage window.

ophthalmology external identifieropht_ext_id

A unique reference identifier assigned by an external system, such as a vision benefits vendor or referral network, to an ophthalmology record. Enables cross-system data reconciliation between health plan platforms, eye care specialty systems, and claims processing environments.

ophthalmology faxopht_fax

The facsimile number associated with an ophthalmology contact, practice, or eye care facility. Used in referral transmission, prior authorization communication, and clinical record exchange between primary care providers and ophthalmology specialty offices.

ophthalmology feeopht_fee

The billed or allowed charge amount associated with an ophthalmology service or eye care procedure. Used in claims adjudication, fee schedule validation, and cost analysis for vision care services such as refractive surgery, retinal exams, or contact lens fittings.

ophthalmology first nameopht_first_nm

The given name of a patient, clinician, or contact associated with an ophthalmology record. Used in member identification, appointment scheduling, referral matching, and clinical correspondence within eye care and vision benefit administration systems.

ophthalmology flagopht_flg

A binary indicator used to mark a specific condition, exception, or status on an ophthalmology record. May signal a care gap, high-risk diagnosis such as diabetic retinopathy, prior authorization requirement, or quality measure relevance within eye care data workflows.

ophthalmology frequencyopht_freq

The prescribed or recommended interval at which an ophthalmology service, eye examination, or ocular treatment should occur. Used in care management protocols, vision benefit utilization tracking, and clinical guidelines for conditions such as glaucoma or macular degeneration monitoring.

ophthalmology full nameopht_full_nm

The complete name of the ophthalmology patient, provider, or facility involved in eye specialty care encounters. Used in clinical documentation, referral records, and ophthalmology visit reporting to display identity in a human-readable format across eye care systems.

ophthalmology genderopht_gndr

The sex or gender classification of the patient receiving ophthalmology services. Captured during eye care registration and used in clinical documentation, demographic reporting, and population health analytics specific to ocular disease prevalence and treatment outcomes by sex.

ophthalmology glucoseopht_gluc

The blood glucose measurement recorded during an ophthalmology encounter. Diabetic retinopathy screening and management require glucose monitoring, as elevated blood sugar levels are directly linked to ocular complications including macular edema and vision loss in eye care clinical workflows.

ophthalmology group numberopht_grp_nbr

The insurance group identifier associated with the patient's health plan at the time of an ophthalmology visit. Used during claims submission and eligibility verification to link eye care services to the correct benefit group for billing and reimbursement processing.

ophthalmology hemoglobinopht_hgb

The hemoglobin measurement recorded in the context of an ophthalmology encounter. Relevant to eye care management as anemia and hemoglobin abnormalities can affect retinal health and are monitored alongside ocular conditions such as diabetic retinopathy and hypertensive retinopathy.

ophthalmology history present illnessopht_hpi

The structured narrative documenting the patient's current ocular complaint as recorded during an ophthalmology encounter. Captures onset, duration, severity, and progression of eye symptoms such as vision changes, pain, or floaters to guide diagnostic and treatment decisions in eye specialty care.

ophthalmology identifieropht_id

The unique identifier assigned to an ophthalmology patient, encounter, or record within eye specialty care systems. Used to track and link ocular visits, diagnostic imaging, surgical procedures, and clinical documentation across ophthalmology departments and health information systems.

PreviousPage 463 of 806Next