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 balancesub_bal

The outstanding dollar amount remaining after payer reimbursement for a drug substitution transaction, representing the unpaid portion owed by the member or patient. Used in pharmacy billing and accounts receivable systems to track patient liability and facilitate collection for substituted medication costs.

substitution billed amountsub_bill_amt

The total dollar amount charged by the dispensing pharmacy for a substituted drug prior to payer adjudication or member cost-sharing adjustments. Used in pharmacy claims processing to establish the initial billing value for generic or therapeutic alternative medications dispensed in place of the original prescription.

substitution birth datesub_birth_dt

The date of birth of the patient for whom a drug substitution was dispensed. Used in pharmacy benefit management systems to verify member eligibility, apply age-specific formulary rules, and confirm that the substituted medication is clinically appropriate for the patient's demographic profile.

substitution blood pressuresub_bp

The recorded blood pressure reading of the patient at the time of or in association with a drug substitution event. Used in clinical and pharmacy systems to assess patient suitability for a substitute medication, particularly for cardiovascular or antihypertensive drug class substitutions requiring clinical monitoring.

substitution cancelled datesub_cncl_dt

The calendar date on which a drug substitution order or rule was cancelled within the pharmacy or benefit management system. Used to maintain an accurate audit trail of substitution lifecycle events and ensure that cancelled substitutions are no longer applied during prescription dispensing or claims adjudication.

substitution categorysub_cat

The classification grouping assigned to a drug substitution, such as generic equivalent, therapeutic alternative, or formulary step therapy. Used in pharmacy benefit management systems to organize substitution rules, apply appropriate adjudication logic, and report on substitution patterns across drug classes and member populations.

substitution charge amountsub_chrg_amt

The fee charged by the dispensing pharmacy for processing and dispensing a substituted medication, including the drug cost and any applicable dispensing fees. Used in pharmacy claims systems to capture the gross charge associated with a generic or therapeutic alternative before payer contract adjustments are applied.

substitution chief complaintsub_cc

The primary symptom or clinical reason documented when a pharmacy dispenses an alternative medication in place of the originally prescribed drug. Captured in pharmacy dispensing systems and medication management workflows to support therapeutic substitution decisions and clinical review.

substitution childsub_chld

Identifies the subordinate drug record in a parent-child substitution hierarchy within pharmacy systems, linking the dispensed alternative medication back to the originally prescribed drug. Used in formulary management and drug substitution tracking to maintain medication relationship integrity.

substitution citysub_city

The city or municipality associated with the pharmacy location or dispensing site where an alternative medication substitution was processed. Used in pharmacy claims and dispensing records to support geographic reporting, network analysis, and regulatory compliance for drug substitution activity.

substitution classsub_cls

The therapeutic or formulary classification tier assigned to an alternative medication dispensed as a substitution. Used in pharmacy benefit management to categorize substituted drugs by drug class, tier level, or therapeutic equivalence group for formulary reporting and cost analysis.

substitution codesub_cd

The standardized code identifying the type or reason for a medication substitution at point of dispensing, such as generic substitution or therapeutic interchange. Used in pharmacy claims processing and dispensing records to classify substitution events for auditing, reporting, and regulatory compliance.

substitution commentsub_cmt

Free-text notation entered by a pharmacist or clinician documenting the rationale, patient counseling details, or prescriber authorization associated with dispensing an alternative medication. Used in pharmacy dispensing systems to capture unstructured context supporting substitution decisions and clinical documentation.

substitution completed datesub_cmpl_dt

The calendar date on which a medication substitution was fully processed and dispensed to the patient. Recorded in pharmacy dispensing systems and claims data to track substitution workflow timelines, support medication adherence analysis, and verify fulfillment against the original prescription order.

substitution confidential indicatorsub_conf_ind

A flag designating that a medication substitution record contains sensitive or privacy-protected information requiring restricted access. Used in pharmacy and clinical systems to enforce data access controls, ensuring substitution details for sensitive drug categories such as mental health or reproductive medications are protected.

substitution countsub_cnt

The total number of medication substitution events recorded for a patient, drug, or prescription within a defined period. Used in pharmacy analytics and formulary management reporting to measure substitution frequency, evaluate generic conversion rates, and assess the impact of therapeutic interchange programs.

substitution countrysub_ctry

The country associated with the dispensing location or regulatory jurisdiction where a medication substitution was processed. Used in pharmacy and claims systems supporting multinational health programs to ensure substituted drugs comply with country-specific formulary rules and drug approval regulations.

substitution created bysub_crtd_by

The username or system identifier of the user who initiated the medication substitution record in the pharmacy or clinical system. Used for audit trail purposes in dispensing and formulary management workflows to establish accountability and support review of substitution authorization and data entry accuracy.

substitution created datesub_crtd_dt

The calendar date on which a medication substitution record was first created in the pharmacy or clinical information system. Used in dispensing workflows and audit reporting to establish record provenance, support substitution timeline analysis, and ensure data integrity across pharmacy management systems.

substitution created timesub_crtd_tm

The timestamp recording the exact time a medication substitution record was entered into the pharmacy or clinical system. Used alongside the created date in dispensing workflows to provide precise audit trail documentation, support workflow sequencing, and monitor substitution processing timeliness.

PreviousPage 257 of 325Next