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 indexopht_idx

A numeric positional value used to sequence or rank ophthalmology records, diagnoses, or procedures within a patient's eye care encounter. Supports ordered retrieval and display of multiple ocular findings, lens measurements, or treatment episodes in clinical and administrative systems.

ophthalmology indicatoropht_ind

A flag or boolean value that denotes the presence, absence, or status of a specific condition or attribute within an ophthalmology record. Used in eye care workflows to signal clinical findings such as glaucoma risk, retinal pathology, or referral status for downstream processing and reporting.

ophthalmology instructionopht_instr

Guidance text associated with ophthalmology care, including post-operative eye drop regimens, pre-procedure preparation steps, or patient education directives for conditions such as cataracts or glaucoma. Captured in clinical documentation to ensure consistent delivery of eye care instructions across visits.

ophthalmology keyopht_key

A reference value used to uniquely identify and cross-link ophthalmology records across clinical and administrative data systems. Serves as a lookup reference connecting eye care encounter data, diagnostic results, procedure codes, and billing records within integrated health information environments.

ophthalmology labelopht_lbl

The display text assigned to an ophthalmology data element, code, or classification used in eye care systems. Provides human-readable descriptions for ocular procedure types, diagnosis categories, lens parameters, or referral statuses presented in clinical interfaces and reporting dashboards.

ophthalmology languageopht_lang

The preferred spoken or written communication language of the patient receiving ophthalmology services. Used in eye care scheduling, patient education, and clinical documentation to ensure appropriate language resources and interpreter services are provided during ocular exams and surgical consultations.

ophthalmology last nameopht_last_nm

The family surname of the patient or provider associated with an ophthalmology record. Used in eye care scheduling, clinical documentation, and referral management to identify individuals in a human-readable format and support accurate matching across ocular health records and billing systems.

ophthalmology legal nameopht_legal_nm

The officially registered name of the patient or provider as it appears on government-issued identification, used in ophthalmology clinical and administrative records. Ensures accuracy in eye care surgical consent forms, insurance claims, credentialing, and compliance documentation requiring verified identity.

ophthalmology levelopht_lvl

The hierarchy or severity level assigned to an ophthalmology condition, procedure, or data element. Used in eye care systems to classify disease severity such as diabetic retinopathy staging, glaucoma progression levels, or evaluation and management coding tiers for ophthalmology encounters and billing.

ophthalmology license numberopht_lic_nbr

The state-issued professional license identifier for an ophthalmologist or optometrist providing eye care services. Used in credentialing, provider enrollment, claims submission, and regulatory compliance to verify that eye care practitioners meet licensure requirements within their practice jurisdiction.

ophthalmology marital statusopht_mar_sts

The marital or relationship status of the patient receiving ophthalmology services. Captured during eye care registration and used in demographic reporting, insurance coordination of benefits determination, and social history documentation within ophthalmology clinical and administrative records.

ophthalmology master identifieropht_mstr_id

The enterprise-level master identifier that uniquely represents an ophthalmology patient across all eye care facilities and health system encounters. Supports record linkage, deduplication, and longitudinal tracking of ocular health history including surgeries, prescriptions, and diagnostic imaging across disparate systems.

ophthalmology maximumopht_max

The upper threshold or maximum allowable value for a measured parameter in ophthalmology data, such as intraocular pressure limits, lens power range, or benefit coverage caps for eye care services. Used in clinical decision support and utilization management to flag values exceeding defined ocular care boundaries.

ophthalmology medical record numberopht_mrn

Unique patient identifier assigned within an ophthalmology practice or eye care department, used to link clinical records such as vision exams, retinal imaging, glaucoma assessments, and surgical histories to a specific patient across eye care encounters.

ophthalmology middle nameopht_mid_nm

Middle name or initial of a patient or clinician associated with ophthalmology records, used to disambiguate individuals with similar names during eye care registration, referral processing, and clinical documentation within eye specialty systems.

ophthalmology minimumopht_min

Lower threshold value used in ophthalmology clinical measurements or reporting ranges, such as minimum intraocular pressure readings, minimum visual acuity scores, or minimum dosage thresholds for ocular medications in eye care treatment protocols.

ophthalmology mobileopht_mob

Mobile phone number associated with a patient or contact in ophthalmology records, used for appointment reminders, post-surgical follow-up communications, and urgent notifications related to eye care treatment or diagnostic results.

ophthalmology modified byopht_mod_by

Username or system identifier of the user who last updated an ophthalmology record, supporting audit trail requirements and accountability for changes made to eye care clinical documentation, prescriptions, or diagnostic findings.

ophthalmology modified dateopht_mod_dt

Calendar date on which an ophthalmology record was most recently updated, used to track changes to eye care clinical documentation including diagnosis updates, treatment plan revisions, or corrections to visual acuity and examination findings.

ophthalmology modified timeopht_mod_tm

Timestamp indicating the exact time an ophthalmology record was last modified, providing granular audit trail detail for eye care clinical workflows where time-sensitive updates to diagnoses, prescriptions, or surgical notes are required.

PreviousPage 464 of 806Next