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

Enterprise-level master identifier used to uniquely identify a substitution record across multiple systems and data domains within a healthcare organization. Enables consistent matching and deduplication of substitution transactions in pharmacy, claims, and clinical data integration workflows.

substitution maximumsub_max

Defines the upper threshold value applicable to a drug substitution, such as the maximum allowable quantity, dosage, or cost associated with a substituted medication under a pharmacy benefit plan. Used in claims adjudication and formulary management to enforce substitution benefit limits.

substitution medical record numbersub_mrn

The patient medical record number linked to a drug substitution event, used to associate the substitution transaction with the individual's clinical record. Enables pharmacy and clinical data systems to connect substitution history to the broader patient record for care coordination and medication management.

substitution middle namesub_mid_nm

Captures the middle name or initial of the patient or member associated with a drug substitution record. Used in pharmacy dispensing and claims systems to support full name identification, reduce member matching errors, and ensure accurate attribution of substitution transactions.

substitution minimumsub_min

Defines the lower threshold value applicable to a drug substitution, such as the minimum quantity or dosage required for a substituted medication to qualify under a pharmacy benefit. Used in formulary management and claims adjudication to enforce benefit eligibility rules for substituted drugs.

substitution mobilesub_mob

Records the mobile phone number of the patient or member associated with a drug substitution record. Used in pharmacy workflows to facilitate outreach regarding substitution notifications, prior authorization status updates, or patient counseling related to dispensed drug substitutions.

substitution modified bysub_mod_by

Identifies the user or system that last updated a drug substitution record, providing an audit trail for changes made to substitution data. Used in pharmacy and claims data governance workflows to maintain accountability and support compliance reviews of substitution record modifications.

substitution modified datesub_mod_dt

The calendar date when a drug substitution record was last updated in the pharmacy system. Tracks when a substituted medication's details, such as the replacement drug, dosage, or dispensing instructions, were most recently changed by pharmacy staff.

substitution modified timesub_mod_tm

The timestamp indicating when a drug substitution record was last modified in the pharmacy dispensing system. Used alongside the modified date to create a precise audit trail of changes made to substituted medication records by pharmacists or clinical staff.

substitution namesub_nm

The display name of the substitute drug dispensed in place of the originally prescribed medication. Used in pharmacy systems to identify the alternative drug selected, typically reflecting the generic or therapeutic equivalent approved under formulary substitution policies.

substitution notesub_nt

Free-text annotation entered by pharmacy or clinical staff explaining the rationale or details behind a drug substitution. May document formulary restrictions, patient allergies, therapeutic equivalence justification, or prescriber approval when a dispensed drug differs from what was originally prescribed.

substitution numbersub_nbr

A unique numeric identifier assigned to a drug substitution transaction within the pharmacy or claims system. Used to track and reference a specific instance where a dispensed medication differs from the prescribed drug, enabling auditing and reporting across pharmacy and adjudication systems.

substitution onset datesub_onset_dt

The date on which a drug substitution became effective for a patient's therapy. Recorded in pharmacy systems to document when a patient began receiving a substitute medication, supporting continuity of care tracking and formulary compliance reporting across prescription fill history.

substitution oxygen saturationsub_o2sat

The patient's blood oxygen saturation level recorded in association with a medication substitution event. Captured in clinical settings to document the patient's respiratory status at the time a drug change was made, particularly relevant for substitutions involving respiratory or cardiac medications.

substitution paid amountsub_pd_amt

The dollar amount paid by the payer or patient for a substituted drug dispensed in place of the originally prescribed medication. Used in pharmacy claims adjudication to reflect actual reimbursement for the dispensed substitute, which may differ from the cost of the originally prescribed drug.

substitution paid datesub_pd_dt

The date on which payment was processed for a drug substitution claim. Recorded in pharmacy billing and claims systems to track when reimbursement was issued for a substituted medication, supporting accounts receivable reconciliation and adjudication audit workflows.

substitution parentsub_prnt

The reference to the original prescribed drug or parent medication record from which a substitution was derived. Used in pharmacy systems to link a dispensed substitute back to its originating prescription, maintaining a traceable relationship between the prescribed and dispensed medications.

substitution percentagesub_pct

The percentage value associated with a drug substitution, such as the generic substitution rate within a formulary or the proportion of a compound medication replaced by an alternative ingredient. Used in pharmacy analytics to measure formulary compliance and substitution program effectiveness.

substitution periodsub_prd

The defined duration during which a drug substitution is authorized or active for a patient. Recorded in pharmacy and formulary management systems to indicate how long the substitute medication is approved for dispensing before requiring prescriber review or a new authorization.

substitution phonesub_ph

The telephone number associated with the contact responsible for authorizing or coordinating a drug substitution, such as the prescribing clinician or pharmacy benefit manager. Used to facilitate communication between pharmacy staff and the prescriber when substitution approval or clarification is required.

PreviousPage 260 of 325Next