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 feesub_fee

The charge assessed for processing or dispensing a substituted medication, which may differ from the original drug cost due to generic pricing, formulary tier differences, or dispensing fees. Used in pharmacy claims adjudication and remittance processing to accurately calculate member cost-share and plan liability.

substitution first namesub_first_nm

The given name of the individual associated with a medication substitution record, typically the patient receiving the substituted drug. Used in pharmacy dispensing systems and member enrollment records to accurately identify the correct patient when processing and documenting substitution transactions.

substitution flagsub_flg

A binary or coded indicator denoting whether a medication substitution was applied to a prescription fill, and in some implementations whether prescriber authorization was obtained. Used in pharmacy claims data and dispensing records to distinguish original fills from substituted dispenses for auditing and formulary compliance reporting.

substitution frequencysub_freq

The dosing interval or administration schedule associated with the substituted medication, such as once daily or twice weekly. Used in pharmacy dispensing and clinical medication records to ensure that the alternative drug's prescribed frequency is accurately captured and transmitted to downstream clinical and billing systems.

substitution full namesub_full_nm

The complete name of the substituted medication, including drug name, strength, and dosage form, or the full name of the patient associated with the substitution record. Used in pharmacy dispensing labels, claims documentation, and patient medication histories to provide unambiguous identification of the dispensed alternative.

substitution gendersub_gndr

The biological sex or gender identity of the patient receiving a substituted medication, captured to support clinical appropriateness checks and demographic analytics. Used in pharmacy data warehouses and population health systems to assess substitution patterns by gender and ensure formulary alternatives are clinically suitable.

substitution glucosesub_gluc

The blood glucose measurement recorded in association with a medication substitution event, particularly relevant when substituting diabetes medications such as insulin or oral hypoglycemics. Used in clinical pharmacy and chronic disease management programs to assess whether the substituted drug maintains adequate glycemic control for the patient.

substitution group numbersub_grp_nbr

Identifies the insurance group associated with a dispensed drug substitution, typically a generic replacing a brand-name medication. Used in pharmacy claims processing to link substituted prescriptions to the correct benefit group for adjudication and reimbursement tracking.

substitution hemoglobinsub_hgb

Records the hemoglobin lab value associated with a drug substitution event, particularly relevant when therapeutic substitutions involve medications affecting blood counts or anemia treatment. Used in clinical workflows to document baseline or monitoring values tied to the substituted therapy.

substitution identifiersub_id

Unique system-generated or assigned identifier for a drug substitution transaction, such as when a generic is dispensed in place of a brand-name prescription. Used in pharmacy and claims systems to track, audit, and reconcile substitution events across dispensing and billing workflows.

substitution indexsub_idx

Numeric position value indicating the sequence or ordering of a drug substitution record within a set of related substitution events. Used in pharmacy data systems to maintain ordered references when multiple substitutions occur within a prescription fill or therapy episode.

substitution indicatorsub_ind

Boolean flag that signals whether a drug substitution occurred at the point of dispensing, such as a pharmacist substituting a generic for a brand-name medication. Used in pharmacy claims and dispensing records to identify substituted fills for formulary compliance, reporting, and reimbursement validation.

substitution instructionsub_instr

Free-text or coded guidance associated with a drug substitution, documenting the rationale, prescriber authorization, or dispensing notes related to replacing one medication with another. Used in pharmacy records to capture clinical or administrative direction governing the substitution decision.

substitution keysub_key

Primary lookup reference value used to retrieve and link drug substitution records across pharmacy and claims data systems. Serves as the relational key connecting substitution transactions to associated prescription, member, and formulary records for processing and reporting purposes.

substitution languagesub_lang

Records the preferred or applicable language associated with a substitution record, such as the language used in patient-facing substitution notices or counseling documentation. Relevant in pharmacy workflows where regulatory requirements mandate written notification of generic dispensing in the member's preferred language.

substitution last namesub_last_nm

Captures the family surname associated with a substitution record, typically referencing the patient or member for whom a drug substitution was made. Used in pharmacy dispensing and claims systems to link substitution transactions to the correct individual for identification and audit purposes.

substitution legal namesub_legal_nm

The official registered name associated with a substitution record, used to formally identify the individual for whom a drug substitution was processed. Referenced in pharmacy and claims workflows where legal identification is required for documentation, compliance, or prior authorization records.

substitution levelsub_lvl

Indicates the hierarchical tier or classification of a drug substitution, such as whether the substitution is a generic equivalent, therapeutic alternative, or formulary exception. Used in pharmacy benefit management to categorize substitutions for formulary enforcement, cost management, and clinical review workflows.

substitution license numbersub_lic_nbr

Records the professional license number of the pharmacist or prescriber associated with authorizing or processing a drug substitution. Used in pharmacy dispensing records and regulatory reporting to document credentialed accountability for substitution decisions made at the point of dispensing.

substitution marital statussub_mar_sts

Captures the marital status of the member or patient associated with a substitution record. Used in member enrollment and pharmacy benefit contexts where demographic data accompanies substitution records for population health reporting, eligibility validation, or coordination of benefits determinations.

PreviousPage 259 of 325Next