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 ageopht_age

Records the patient age at the time of an ophthalmology encounter or diagnosis. Used in eye care clinical systems to guide age-appropriate screening protocols, support pediatric versus adult care differentiation, and enable age-stratified analysis of ocular disease prevalence and treatment outcomes.

ophthalmology allowed amountopht_alwd_amt

The maximum reimbursable dollar amount approved by the payer for an ophthalmology service or procedure under the patient's benefit plan. Used in claims adjudication to determine payment caps for eye care services including exams, surgeries, and vision correction procedures.

ophthalmology amountopht_amt

The monetary value associated with an ophthalmology transaction, service, or financial event within the eye care revenue cycle. Used in financial reporting and claims processing to track costs, reimbursements, and payment activity related to ophthalmic procedures and examinations.

ophthalmology approval statusopht_appr_sts

Indicates the authorization or approval state of an ophthalmology service request, referral, or prior authorization submission. Used in eye care utilization management to track whether procedures such as cataract surgery or specialty imaging have been approved, denied, or are pending review.

ophthalmology approved byopht_appr_by

Identifies the clinician, administrator, or system user who granted approval for an ophthalmology service, referral, or authorization request. Used in eye care audit trails and compliance reporting to document accountability for clinical and administrative decisions within ophthalmology workflows.

ophthalmology arrival timeopht_arrv_tm

The recorded time at which a patient arrived for a scheduled or unscheduled ophthalmology appointment or eye care encounter. Used in clinic operations reporting to measure wait times, assess scheduling efficiency, and monitor patient flow within ophthalmology departments.

ophthalmology arrived dateopht_arrv_dt

The calendar date on which a patient physically arrived for an ophthalmology service or eye care appointment. Used alongside arrival time in clinical scheduling and operations systems to track patient access metrics and support appointment adherence reporting for eye care services.

ophthalmology assessmentopht_asmt

The clinician's documented clinical evaluation of a patient's ocular health status during an ophthalmology encounter. Captures findings from eye exams, visual acuity tests, and diagnostic evaluations, forming the basis for diagnosis coding and treatment planning in eye care records.

ophthalmology balanceopht_bal

The remaining outstanding financial amount owed on an ophthalmology account after payments, adjustments, and insurance reimbursements have been applied. Used in eye care revenue cycle management to track patient and payer liability for ophthalmic services and facilitate collections.

ophthalmology billed amountopht_bill_amt

The total dollar amount invoiced by the ophthalmology provider for eye care services rendered before insurance adjudication or adjustments. Used in claims submission and revenue cycle reporting to establish the gross charge for ophthalmic procedures, exams, and related services.

ophthalmology birth dateopht_birth_dt

The patient's date of birth as recorded within the ophthalmology clinical or administrative record. Used to verify patient identity, calculate age at time of eye care encounter, determine eligibility for age-based screening programs, and support demographic analysis of ophthalmic populations.

ophthalmology blood pressureopht_bp

The systolic and diastolic arterial pressure measurement recorded during an ophthalmology encounter. Captured as a vital sign in eye care settings because hypertension is a key risk factor for conditions including hypertensive retinopathy, glaucoma, and diabetic eye disease requiring monitoring.

ophthalmology cancelled dateopht_cncl_dt

The date on which a scheduled ophthalmology appointment, procedure, or service was formally cancelled. Used in eye care scheduling and operations systems to track cancellation patterns, measure no-show rates, support slot reallocation, and analyze access barriers in ophthalmology practices.

ophthalmology categoryopht_cat

Classifies ophthalmology encounters or records into defined groupings such as medical eye exam, surgical procedure, diagnostic imaging, or contact lens fitting. Used in clinical data warehouses to segment eye care services for utilization analysis and specialty reporting.

ophthalmology charge amountopht_chrg_amt

The billed dollar amount associated with an ophthalmology service or procedure, such as cataract surgery, retinal imaging, or glaucoma treatment. Captured in claims and billing systems to support revenue cycle management, cost analysis, and ophthalmology service line financial reporting.

ophthalmology chief complaintopht_cc

The primary symptom or concern documented by the patient at the start of an ophthalmology encounter, such as blurred vision, eye pain, floaters, or redness. Recorded in clinical systems to guide diagnostic workup and support documentation of medical necessity for eye care services.

ophthalmology childopht_chld

Identifies a subordinate or dependent record linked to a parent ophthalmology record within a hierarchical data structure. Used in clinical systems to associate follow-up visits, sub-procedures, or related diagnostic findings to a primary ophthalmology encounter or condition record.

ophthalmology cityopht_city

The city name associated with an ophthalmology service location, patient address, or referring provider address within eye care records. Used in clinical and administrative systems to support geographic analysis, care access reporting, and patient demographic data management for ophthalmology services.

ophthalmology classopht_cls

The classification tier assigned to an ophthalmology record, encounter, or service, such as routine, urgent, or surgical. Used in clinical data systems to stratify eye care visits by acuity, service type, or care setting for operational planning and ophthalmology utilization reporting.

ophthalmology codeopht_cd

A standardized alphanumeric code identifying an ophthalmology diagnosis, procedure, or service, such as an ICD-10 diagnosis code for diabetic retinopathy or a CPT code for fundus photography. Used across clinical and claims systems to classify and track eye care encounters consistently.

PreviousPage 461 of 806Next