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

study datetimestdy_dttm

The combined date and time at which an imaging examination was performed, recorded as a single timestamp in the radiology information system or PACS. Used for precise sequencing of imaging events, workflow analysis, turnaround time measurement, and correlation with clinical documentation.

study dea numberstdy_dea_nbr

The Drug Enforcement Administration registration number associated with a prescribing clinician linked to an imaging study, typically relevant when sedation or contrast premedication is ordered. Used to validate prescriber credentials and ensure regulatory compliance in imaging workflows involving controlled substances.

study death datestdy_death_dt

The date of death for the patient associated with an imaging study. Used in radiology and clinical data systems to flag deceased patient records, halt pending imaging orders, support mortality reporting, and ensure appropriate handling of posthumous imaging data in downstream analytics.

study deleted datestdy_del_dt

The calendar date on which an imaging study record was marked as deleted in the radiology information system or PACS. Used for audit trail maintenance, data governance, and compliance purposes, preserving a historical record of when studies were removed without permanent destruction of the metadata.

study deleted indicatorstdy_del_ind

A flag indicating whether an imaging study record has been logically removed from active use in the radiology information system or PACS. Used to filter deleted studies from clinical workflows and reporting while retaining the record for audit, compliance, and historical data reconciliation purposes.

study descriptionstdy_desc

A human-readable text description of an imaging examination, typically derived from the order or DICOM header, such as CT Chest with Contrast or MRI Brain without and with Contrast. Used in radiology workflows to identify study type, guide technologist protocols, and populate imaging reports and patient records.

study detailstdy_dtl

Supplementary information captured about an imaging examination beyond standard structured fields, including acquisition parameters, special instructions, clinical indications, or procedure notes. Used in radiology information systems to provide technologists and radiologists with additional context needed for accurate image acquisition and interpretation.

study discharge datestdy_dsch_dt

The date on which the patient associated with an imaging study was discharged from an inpatient or observation encounter. Used in radiology and hospital information systems to correlate imaging timing with hospitalization, support length-of-stay analysis, and reconcile inpatient imaging orders with clinical discharge workflows.

study due datestdy_due_dt

The target date by which an imaging study is expected to be completed, interpreted, or reported. Used in radiology workflow management systems to prioritize pending studies, monitor turnaround time compliance, and trigger escalation alerts when imaging examinations approach or exceed expected completion deadlines.

study durationstdy_dur

The total elapsed time from the start to the completion of an imaging examination, typically measured in minutes. Used in radiology operations and scheduling systems to assess scanner utilization, optimize appointment slot planning, benchmark modality performance, and support staffing and resource allocation decisions.

study emailstdy_eml

The electronic mail address associated with the ordering clinician, patient, or contact linked to an imaging study. Used in radiology information systems to facilitate result notifications, study sharing, report delivery, and communication with referring providers or patients regarding imaging findings and follow-up recommendations.

study emergency indicatorstdy_emerg_ind

A flag designating an imaging study as emergent or stat, requiring immediate prioritization in the radiology workflow. Used in PACS and radiology information systems to route urgent studies to available radiologists, trigger escalation protocols, and ensure critical findings are communicated within clinically required timeframes.

study end datestdy_end_dt

The date on which an imaging examination was completed or the associated imaging study period concluded. Used in radiology information systems to calculate study duration, measure workflow turnaround times, close open orders, and support reporting on imaging throughput and departmental operational performance.

study end timestdy_end_tm

The timestamp recording when a diagnostic imaging examination was completed, captured in DICOM or RIS systems. Used to calculate total study duration, technologist workload metrics, and radiology workflow efficiency reporting across imaging departments.

study entered bystdy_ent_by

The username or system identifier of the staff member who entered the imaging study record into the radiology information system (RIS) or PACS. Used for audit trail tracking, data quality accountability, and workflow management in diagnostic imaging departments.

study ethnicitystdy_ethn

The patient's self-reported or assigned ethnic background associated with an imaging study record. Used to support demographic analysis, health equity reporting, and population-based research on imaging utilization patterns across diverse patient populations.

study expiration datestdy_exp_dt

The date after which an imaging study order, authorization, or associated protocol is no longer considered valid for scheduling or execution. Used to enforce insurance authorization windows, manage standing imaging orders, and ensure regulatory compliance in radiology workflows.

study external identifierstdy_ext_id

A reference identifier assigned by an external system, such as a referring hospital, health information exchange, or third-party imaging center, that links an imaging study to records outside the local PACS or RIS. Enables cross-system study reconciliation and interoperability.

study faxstdy_fax

The facsimile number associated with the ordering provider, referring facility, or imaging center linked to a diagnostic study. Used to route radiology reports, imaging results, and prior authorization confirmations to the appropriate clinical or administrative destination.

study feestdy_fee

The charge amount assessed for performing a diagnostic imaging examination, recorded at the study level for billing and revenue cycle processing. Used in claims generation, patient cost estimation, and financial reconciliation between imaging departments and payers.

PreviousPage 676 of 806Next