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 engineers & architects.

Back to Glossary

Domain

Pharmacy

NDC codes, dispensing, PBM, RxNorm and formulary management

1,921 pharmacy terms

Class III Recallcls3_rcl

The lowest-severity FDA recall classification, applied when a drug or device is unlikely to cause adverse health consequences but violates FDA regulations. Pharmacy systems and PBM drug master files record Class III recall status against affected NDC codes, supporting compliance documentation and inventory management without triggering immediate patient safety notification workflows.

Clinic PharmacyClinic

A pharmacy located within a medical clinic or physician office providing prescription dispensing and medication management services to clinic patients. Tracked in pharmacy network data systems by NCPDP provider ID and used in specialty pharmacy referral and drug utilization reporting.

Clinical PharmacyClinical

In EHR and healthcare operations, clinical pharmacy refers to pharmacy practice focused on direct patient care, medication therapy management, and optimizing therapeutic outcomes. Clinical pharmacists document interventions in EHR systems, support drug utilization review, participate in care team workflows, and generate data used in quality reporting and population health analytics.

Cold Chaincld_chn

A temperature-controlled pharmaceutical supply chain process governing storage and transport of biologics, vaccines, and refrigerated medications, tracked in pharmacy inventory and dispensing systems. Cold chain data elements include temperature logs, storage condition codes, and shipment records integrated with EHR and PBM drug management platforms.

Colorantclrnt

An inactive pharmaceutical ingredient added to medications for identification and differentiation purposes, catalogued in drug formulary databases, NDC records, and pharmacy dispensing systems. Colorant data supports allergy and inactive ingredient screening, formulary management, and medication safety workflows in PBM and EHR drug master files.

CompoundingCOMP

The pharmacy process of preparing individualized medications by combining, mixing, or altering active ingredients outside standard commercial manufacturing. Tracked in PBM and specialty pharmacy systems using NCPDP billing codes to manage clinical appropriateness, prior authorization, and formulary exception workflows.

Compounding Logcmpnd_log

A pharmacy system record documenting the preparation of custom medications, including ingredients, quantities, lot numbers, compounder identity, and beyond-use dates. Used in pharmacy management systems to ensure regulatory compliance and traceability of compounded drug products.

Compounding Pharmacycmpnd_pharm

In pharmacy and PBM systems, a compounding pharmacy is a licensed facility that prepares customized medication formulations tailored to individual patient needs not met by commercially available products. Claims for compounded drugs require specialized billing codes, are subject to enhanced prior authorization scrutiny, and are tracked separately in drug spend analytics.

ConcentrateCONC

A drug formulation descriptor used in pharmacy dispensing systems and formulary databases to identify medications requiring dilution prior to administration. The CONC designation appears in NDC drug master files, PBM drug tables, and clinical decision support systems to trigger pharmacist dilution alerts.

Concentrationconcn

The measurable strength of an active ingredient per unit volume or weight, stored in pharmacy dispensing systems, PBM drug databases, and EHR medication records. Concentration values expressed as mg/mL or percentage are critical for dose calculation logic and clinical decision support rule engines.

Continuing Pharmacy EducationCPE

Ongoing education required for pharmacists and pharmacy technicians to maintain licensure and stay current with advances in pharmacy practice. CPE credits are tracked through the NABP CPE Monitor system and reported to state boards of pharmacy for license renewal.

CopayCP

A fixed out-of-pocket amount a member pays at point of service, captured in EHR systems, claims adjudication platforms, and PBM systems. Copay values are defined in benefit plan configurations, applied during claims processing, and reported in remittance advice (835) and EOB documents for member cost-sharing tracking.

CreamCRM

A topical semisolid pharmaceutical dosage form containing active medication in an emulsion base, classified by route of administration in pharmacy dispensing, PBM formulary, and EHR medication management systems. Identified using NDC codes and documented in prescription records, medication history, and drug utilization review datasets.

Decongestantdcngstnt

A therapeutic drug class classification applied in EHR medication databases, pharmacy dispensing systems, and PBM formularies to agents that relieve nasal congestion by constricting blood vessels in nasal mucosa. Common examples include pseudoephedrine and phenylephrine, which are subject to purchase quantity tracking requirements under the Combat Methamphetamine Epidemic Act and flagged in pharmacy data systems accordingly.

Delayed ReleaseDR

A pharmaceutical formulation descriptor indicating a drug is designed to release its active ingredient after a specified delay post-ingestion, recorded in pharmacy dispensing and PBM systems. Used to differentiate drug products during formulary management, NDC classification, prior authorization, and medication therapy management workflows.

Deprescribingdeprscrb

A structured clinical process for tapering, discontinuing, or substituting medications deemed potentially harmful, duplicative, or no longer therapeutically necessary. Tracked in EHR medication reconciliation modules, PBM platforms, and pharmacy systems to reduce polypharmacy risk, particularly in geriatric populations.

DexamethasoneDex

A synthetic corticosteroid medication used to reduce inflammation and suppress immune response, commonly administered in inpatient and oncology settings. Referenced in pharmacy, EHR, and PBM systems using NDC or RxNorm codes; relevant to medication administration records, drug interaction checks, and formulary management workflows.

Dextrose 5% in WaterD5W

An intravenous solution containing 5% dextrose used for hydration and as a medication diluent in clinical settings. Represented in EHR pharmacy and medication administration systems via NDC codes; critical for IV fluid order management, nursing documentation, and charge capture in hospital billing workflows.

Dietary Supplementdiet_suppl

A product containing vitamins, minerals, herbs, or other nutritional substances documented in EHR medication lists, pharmacy benefit management systems, and PBM formulary databases. Data engineers use this classification to distinguish supplement records from prescription drugs in pharmacy claims pipelines and medication reconciliation datasets.

DiluteDIL

Pharmaceutical instruction or specimen condition flag indicating that a substance has been reduced in concentration, captured in pharmacy dispensing systems, lab information systems, and PBM adjudication records. Data engineers use this flag to filter dilute specimen results in lab analytics and support compounding or preparation logic in pharmacy data pipelines.

PreviousPage 5 of 97Next