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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

substitution creatininesub_cr

The serum creatinine laboratory value recorded in the context of a medication substitution, used to assess renal function when selecting an alternative drug. Captured in clinical and pharmacy systems to support dose adjustment decisions for renally cleared medications during therapeutic substitution processes.

substitution datesub_dt

The calendar date on which an alternative medication was dispensed or authorized as a substitution for the originally prescribed drug. Recorded in pharmacy dispensing and claims systems to support substitution tracking, adherence monitoring, and formulary compliance reporting across benefit periods.

substitution datetimesub_dttm

The combined date and time value recording the precise moment a medication substitution event was processed or documented in the pharmacy system. Used in dispensing records and pharmacy claims to enable accurate chronological sequencing of substitution events and support operational and clinical audit workflows.

substitution dea numbersub_dea_nbr

The Drug Enforcement Administration registration number associated with the prescriber or dispensing pharmacy involved in a controlled substance medication substitution. Used in pharmacy dispensing records to validate prescriber authority and ensure regulatory compliance when processing substitutions for Schedule II through V drugs.

substitution death datesub_death_dt

The recorded date of death for a patient associated with a medication substitution record, used to close open substitution orders and update dispensing records accordingly. Captured in pharmacy and clinical systems to ensure medication management workflows are terminated and compliance reporting reflects accurate patient status.

substitution deleted datesub_del_dt

The calendar date on which a medication substitution record was marked as deleted or removed from active pharmacy dispensing records. Used in data management and audit workflows to track record lifecycle, support data reconciliation, and maintain a complete history of substitution record changes within pharmacy systems.

substitution deleted indicatorsub_del_ind

A flag identifying that a medication substitution record has been logically deleted or voided in the pharmacy system without physical removal from the database. Used in pharmacy data management to preserve historical integrity while excluding inactive substitution records from active dispensing workflows and formulary reporting.

substitution descriptionsub_desc

Human-readable text label describing a dispensed drug substitution event, such as a generic-for-brand swap or therapeutic equivalent. Used in pharmacy claims and medication management systems to document the rationale or nature of the substitution applied at point of dispensing.

substitution detailsub_dtl

Granular clinical or administrative information capturing the specifics of a medication substitution, including the original drug, the dispensed alternative, substitution type code, and any pharmacist or prescriber notes. Used in pharmacy dispensing records and claims adjudication workflows.

substitution due datesub_due_dt

The date by which a pending medication substitution action must be resolved, reviewed, or fulfilled. Used in pharmacy workflow queues and prior authorization processes to track time-sensitive substitution decisions requiring prescriber approval or formulary exception resolution.

substitution durationsub_dur

The length of time a medication substitution remains in effect, expressed in days, weeks, or months. Used in pharmacy benefit management and clinical medication records to define how long the alternative drug is authorized before reassessment or reversion to the original prescribed therapy.

substitution effective datesub_eff_dt

The calendar date on which a medication substitution becomes active and the alternative drug may be dispensed in place of the originally prescribed medication. Used in formulary management, pharmacy claims, and prior authorization records to establish when the substitution is clinically and administratively valid.

substitution emailsub_eml

The electronic mail address associated with a party involved in a medication substitution transaction, such as the prescribing clinician, pharmacist, or patient contact. Used in pharmacy communication workflows to send substitution notifications, confirmations, or prescriber approval requests.

substitution end datesub_end_dt

The calendar date on which an authorized medication substitution expires and the patient must revert to the originally prescribed drug or obtain a new substitution authorization. Used in pharmacy benefit management and claims systems to enforce formulary substitution term limits.

substitution end timesub_end_tm

The specific timestamp marking the conclusion of a medication substitution authorization period, providing hour and minute precision beyond end date alone. Used in inpatient pharmacy systems and automated dispensing workflows where time-bound substitution controls are enforced at the order level.

substitution entered bysub_ent_by

The identifier of the pharmacist, technician, or clinical user who recorded the medication substitution in the dispensing or clinical system. Used in pharmacy audit trails and compliance reporting to attribute substitution decisions to a specific credentialed user for accountability and regulatory review.

substitution ethnicitysub_ethn

The ethnicity classification of the patient receiving a substituted medication, captured to support population health analytics and health equity reporting. Used in pharmacy and clinical data warehouses to analyze substitution patterns across demographic groups and identify potential disparities in formulary substitution rates.

substitution expiration datesub_exp_dt

The date after which a medication substitution authorization is no longer valid and cannot be applied to new prescription fills. Used in pharmacy benefit management systems to enforce time-limited formulary exceptions and ensure that substitution approvals are periodically reviewed by the prescriber or plan.

substitution external identifiersub_ext_id

A reference identifier assigned by an external system, such as a PBM, clearinghouse, or formulary management platform, to uniquely identify a medication substitution record across multiple healthcare systems. Used for cross-system reconciliation of substitution transactions in pharmacy claims and benefit adjudication.

substitution faxsub_fax

The facsimile number used to transmit medication substitution notifications or prescriber approval requests between pharmacies, prescribing offices, and benefit managers. Used in pharmacy dispensing workflows where electronic prescribing is unavailable and paper-based substitution authorization processes are required.

PreviousPage 258 of 325Next