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 rateopht_rt

Reimbursement or contracted fee amount applied to ophthalmology services, reflecting the per-unit price for eye care procedures such as fundus photography, optical coherence tomography, or surgical interventions. Used in claims adjudication and provider contract management.

ophthalmology ratingopht_rtg

Scored assessment value applied to an ophthalmological condition, treatment outcome, or clinical finding. Used to quantify disease severity such as diabetic retinopathy grading scales or visual impairment classifications, supporting standardized documentation and longitudinal outcome tracking.

ophthalmology ratioopht_ratio

Proportional measurement derived from ophthalmological assessments, such as the cup-to-disc ratio used in glaucoma evaluation or signal-to-noise ratios in diagnostic imaging. Used to standardize clinical comparisons across patient visits and support detection of progressive eye disease.

ophthalmology reasonopht_rsn

Descriptive text or coded explanation documenting the clinical justification for an ophthalmology visit, procedure, or treatment decision. Captures the presenting complaint or medical necessity rationale, such as sudden vision loss, floaters, or scheduled monitoring of a known retinal condition.

ophthalmology received dateopht_rcvd_dt

Date on which ophthalmology-related documentation, referral, test results, or claims were received by the processing entity. Used to measure turnaround times for diagnostic reports such as visual field tests or retinal imaging reads and to track referral workflow completion in eye care management.

ophthalmology referenceopht_ref

External identifier or pointer linking an ophthalmology record to a related document, prior encounter, referral source, or external system. Used to cross-reference diagnostic imaging studies, surgical reports, or optometry records that inform comprehensive eye care management.

ophthalmology resolution dateopht_resol_dt

Date on which an ophthalmological condition, episode of care, or active issue was documented as resolved or stable. Used to calculate the duration of eye conditions such as corneal ulcers, post-surgical inflammation, or acute angle-closure glaucoma episodes in clinical outcome tracking.

ophthalmology respirationopht_resp

Respiratory rate measurement recorded during an ophthalmology encounter as part of pre-procedural vital sign documentation. Relevant for monitoring patients prior to ophthalmic surgeries or sedation procedures where baseline respiratory status is required for anesthesia safety assessments.

ophthalmology resultopht_rslt

Outcome value from an ophthalmological diagnostic test, examination, or procedure, such as visual acuity measurement, intraocular pressure reading, or retinal imaging interpretation. Used to document clinical findings, track disease progression, and inform treatment decisions in eye care.

ophthalmology revisionopht_rev

Version or iteration number indicating that an ophthalmology record, treatment plan, or clinical document has been updated. Tracks amendments to surgical plans, corrected diagnostic reports, or modified prescription entries to maintain an accurate audit trail within eye care documentation systems.

ophthalmology riskopht_rsk

Assessed danger level associated with an ophthalmological condition, procedure, or patient profile, indicating likelihood of vision loss or surgical complications. Used in pre-operative evaluations for cataract or retinal surgeries and in population health programs targeting high-risk diabetic eye disease patients.

ophthalmology routeopht_rte

Administration pathway for ophthalmic medications or therapeutic agents, such as topical eye drops, intravitreal injection, periocular injection, or systemic oral delivery. Documents how treatments such as anti-VEGF agents, steroids, or antibiotics are delivered during ophthalmology encounters.

ophthalmology scoreopht_scr

Calculated numeric value summarizing the results of an ophthalmological assessment, such as a visual function index score, diabetic retinopathy severity scale, or dry eye symptom score. Used to standardize clinical severity classification and measure treatment response across ophthalmology patient populations.

ophthalmology sequenceopht_seq

Numeric ordering value assigned to eye care encounters, procedures, or diagnoses within a patient record. Used to distinguish multiple ophthalmology events in claims processing, clinical documentation, and longitudinal tracking of ocular conditions across visits.

ophthalmology severityopht_sev

Clinical rating indicating the seriousness of an ocular condition such as glaucoma, macular degeneration, or diabetic retinopathy. Used in eye care claims and clinical records to stratify disease progression, guide treatment planning, and support utilization management decisions.

ophthalmology sexopht_sex

Biological sex classification recorded for a patient receiving eye specialty care. Used in ophthalmology clinical data to support demographic analysis, identify sex-specific ocular disease prevalence patterns, and satisfy reporting requirements in claims and registry submissions.

ophthalmology sourceopht_src

Identifies the originating system, referral channel, or data feed from which an ophthalmology record was derived. Used to track whether eye care data came from claims, optical dispensing systems, clinical exam documentation, or external specialist referral networks.

ophthalmology start dateopht_start_dt

Calendar date marking the beginning of an ophthalmology treatment episode, condition onset, authorization period, or ocular procedure. Used in eye care claims and clinical records to establish service timelines, measure treatment duration, and support prior authorization workflows.

ophthalmology start timeopht_start_tm

Recorded time of day marking when an ophthalmology procedure or clinical encounter began. Used in surgical scheduling systems and operative documentation for eye procedures such as cataract surgery or laser treatments to track procedure duration and facility resource utilization.

ophthalmology stateopht_st

US state or territory associated with an ophthalmology encounter, facility, or patient address. Used in eye care claims and enrollment data to apply state-specific vision benefit rules, identify regional utilization patterns, and route claims to correct adjudication jurisdictions.

PreviousPage 466 of 806Next