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 commentopht_cmt

Free-text narrative field capturing supplemental clinical notes, observations, or instructions associated with an ophthalmology encounter or record. Used by eye care clinicians to document details not captured in structured fields, such as patient-reported symptoms, treatment rationale, or follow-up instructions.

ophthalmology completed dateopht_cmpl_dt

The date on which an ophthalmology service, procedure, or treatment course was completed, such as the final session of a laser treatment series. Used in clinical and claims systems to track service delivery timelines, measure care gaps, and support ophthalmology outcome reporting.

ophthalmology confidential indicatoropht_conf_ind

A flag designating an ophthalmology record as confidential, restricting access to authorized users only. Applied in clinical systems when eye care records contain sensitive information, such as vision-related disability determinations or conditions linked to protected health status under applicable privacy regulations.

ophthalmology countopht_cnt

A numeric value representing the total number of ophthalmology encounters, procedures, diagnoses, or related records within a defined data set or time period. Used in clinical analytics and reporting systems to measure eye care service utilization, visit frequency, and population-level ophthalmology care trends.

ophthalmology countryopht_ctry

The country associated with an ophthalmology service location, patient address, or referring entity within eye care records. Used in administrative and clinical data systems to support international patient identification, cross-border care coordination, and geographic reporting for ophthalmology services.

ophthalmology created byopht_crtd_by

The username or system identifier of the individual or automated process that originally created an ophthalmology record in the clinical or administrative system. Used for audit trail purposes to track data entry accountability and support compliance reviews within eye care documentation workflows.

ophthalmology created dateopht_crtd_dt

The calendar date on which an ophthalmology record was first entered into the clinical or administrative system. Used to establish data provenance, support audit trails, and distinguish the record creation date from the actual ophthalmology service or encounter date in eye care data systems.

ophthalmology created timeopht_crtd_tm

The timestamp indicating the exact time an ophthalmology record was created in the clinical or administrative system. Combined with the created date to provide a precise audit trail for data entry, supporting compliance reviews and record integrity validation within eye care information systems.

ophthalmology creatinineopht_cr

The serum creatinine lab value recorded in association with an ophthalmology encounter, typically used when assessing renal function prior to contrast-enhanced imaging or evaluating systemic conditions such as diabetic nephropathy that have concurrent ocular manifestations requiring eye care monitoring.

ophthalmology dateopht_dt

The calendar date associated with an ophthalmology event, encounter, or service record, such as the date of an eye exam, retinal scan, or ophthalmic surgical procedure. Used in clinical and claims systems to establish service timelines and support longitudinal tracking of eye care delivery.

ophthalmology datetimeopht_dttm

The combined date and time value associated with an ophthalmology encounter, procedure, or data event. Used in clinical systems to precisely sequence eye care services, support scheduling workflows, and enable time-stamped audit trails for ophthalmology-related clinical and administrative records.

ophthalmology dea numberopht_dea_nbr

The Drug Enforcement Administration registration number associated with an ophthalmology provider authorized to prescribe controlled substances, such as topical anesthetics or sedatives used in ophthalmic procedures. Used to verify prescribing credentials and ensure regulatory compliance in eye care clinical records.

ophthalmology death dateopht_death_dt

The recorded date of death for a patient associated with an ophthalmology record. Used in clinical and population health data systems to close active eye care records, exclude deceased patients from outreach programs, and support longitudinal analysis of outcomes following ophthalmology diagnoses or treatments.

ophthalmology deleted dateopht_del_dt

The date an ophthalmology-related record was removed from active use in the eye care data system. Used in clinical data auditing to track when vision care records, referrals, or treatment entries were marked for deletion or purged from reporting datasets.

ophthalmology deleted indicatoropht_del_ind

A flag denoting whether an ophthalmology record has been logically removed from active eye care data. Supports data integrity by preserving historical vision care records while excluding them from current clinical reporting, referral tracking, and member benefit workflows.

ophthalmology descriptionopht_desc

A human-readable text field describing an ophthalmology service, diagnosis, or procedure within eye care records. Captures details such as vision condition type, surgical procedure name, or treatment category used in clinical documentation and specialty referral management.

ophthalmology detailopht_dtl

Supplementary clinical or administrative information associated with an ophthalmology encounter or service record. May include procedural notes, lens specifications, retinal findings, or diagnostic detail supporting eye care treatment planning and claims adjudication.

ophthalmology discharge dateopht_dsch_dt

The date a patient was discharged following an inpatient or outpatient ophthalmology procedure such as cataract surgery or retinal intervention. Used in claims processing, clinical episode tracking, and post-operative care coordination for eye care services.

ophthalmology due dateopht_due_dt

The date by which a scheduled ophthalmology service, follow-up exam, or vision care benefit action must occur. Supports care gap closure, member outreach scheduling, and preventive eye care compliance tracking within managed care and utilization management workflows.

ophthalmology durationopht_dur

The measured length of time associated with an ophthalmology procedure, treatment course, or clinical episode. Used in surgical scheduling, clinical outcome tracking, and operating room utilization reporting for eye care services such as laser therapy or ocular surgeries.

PreviousPage 462 of 806Next