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 master identifierstdy_mstr_id

The enterprise-level master identifier assigned to a diagnostic imaging examination to uniquely identify it across all healthcare systems, including PACS, RIS, and EHR platforms. Enables consistent cross-system tracking, deduplication, and longitudinal imaging history management for a patient.

study maximumstdy_max

The upper limit value associated with a measurable parameter captured during a diagnostic imaging examination, such as maximum pixel intensity, maximum slice thickness, or an upper threshold for a quantitative imaging metric. Used in radiology analytics and quality control workflows.

study middle namestdy_mid_nm

The patient's middle name or initial as recorded on a diagnostic imaging examination order. Used in PACS and RIS systems to support accurate patient identity matching, reduce duplicate records, and ensure imaging studies are correctly linked to the patient's master health record.

study minimumstdy_min

The lower limit value associated with a measurable parameter captured during a diagnostic imaging examination, such as minimum pixel intensity or a lower threshold for a quantitative imaging metric. Used in radiology analytics, protocol validation, and imaging quality control workflows.

study mobilestdy_mob

The patient's mobile phone number recorded in association with a diagnostic imaging examination. Used in radiology and scheduling workflows to send appointment reminders, communicate results notifications, and facilitate patient outreach related to the imaging study.

study modified bystdy_mod_by

The system user identifier of the individual who last updated a diagnostic imaging examination record in the RIS, PACS, or clinical data system. Used for audit trail purposes to track data stewardship, enforce accountability, and support compliance with imaging data governance policies.

study modified datestdy_mod_dt

The calendar date on which a diagnostic imaging examination record was last updated in the RIS, PACS, or clinical data system. Used in audit logging and data governance workflows to track changes to study metadata, report amendments, or patient demographic corrections.

study modified timestdy_mod_tm

The precise time at which a diagnostic imaging examination record was last updated in the RIS, PACS, or clinical data system. Used alongside the modified date in audit trail workflows to provide a complete timestamp for tracking study record changes, report revisions, or corrections.

study namestdy_nm

The descriptive display label assigned to a diagnostic imaging examination, identifying the type and scope of the imaging performed, such as X-Ray Lumbar Spine or Ultrasound Abdomen Complete. Used in RIS, PACS, and EHR systems for study identification, worklist display, and reporting.

study notestdy_nt

Free-text annotation or clinical remark associated with a diagnostic imaging examination, recorded by radiologists, technologists, or ordering clinicians in the RIS or PACS. Captures additional clinical context, protocol deviations, patient preparation notes, or follow-up recommendations relevant to the study.

study numberstdy_nbr

The unique reference number assigned to a diagnostic imaging examination within the RIS or PACS. Used to identify and track the study across radiology workflows, link the imaging order to results, and support billing, scheduling, and downstream clinical data integration.

study onset datestdy_onset_dt

The date on which the clinical symptoms or condition prompting a diagnostic imaging examination were first observed or reported by the patient. Captured in radiology ordering workflows to provide clinical context, support diagnostic interpretation, and inform urgency classification of the imaging study.

study oxygen saturationstdy_o2sat

The patient's blood oxygen saturation level recorded at the time of a diagnostic imaging examination, typically expressed as a percentage. Captured as a clinical vital sign in imaging workflows to monitor patient safety, particularly during contrast administration, sedation, or interventional radiology procedures.

study paid amountstdy_pd_amt

The total dollar amount paid for a diagnostic imaging examination, recorded in radiology information systems and claims data. Captures reimbursement from payers, patient payments, or adjustments applied to the study's billed charges after contractual discounts.

study paid datestdy_pd_dt

The calendar date on which payment was received or posted for a diagnostic imaging examination. Used in radiology billing and revenue cycle management to track payment timelines, reconcile accounts receivable, and measure days-to-payment performance metrics.

study parentstdy_prnt

The identifier of the higher-level imaging study or order to which a subordinate study belongs, establishing a hierarchical relationship in radiology information systems. Used to link series, sub-studies, or related procedures to a primary diagnostic imaging order.

study percentagestdy_pct

A calculated ratio expressed as a percentage associated with a diagnostic imaging examination, such as completion rate, reimbursement rate relative to billed charges, or protocol adherence. Used in radiology analytics and financial reporting to evaluate study-level performance metrics.

study periodstdy_prd

The defined time interval during which a diagnostic imaging examination or associated clinical research study is conducted. Captures the start and end boundaries of imaging protocols, longitudinal scan schedules, or radiology department reporting windows used for operational analysis.

study phonestdy_ph

The telephone contact number associated with a diagnostic imaging examination, typically referencing the ordering facility, reading radiologist group, or patient contact for scheduling and results communication within radiology information and order management systems.

study preferred namestdy_pref_nm

The standardized or user-facing display name assigned to a diagnostic imaging examination within radiology information systems. Used to present study descriptions in a consistent, human-readable format across worklists, patient portals, reports, and clinical data interfaces.

PreviousPage 678 of 806Next