Back to search

Extemporaneous Compounding

extemp_cmpnd
pharmacy
Updated 5/16/2026

Definition

The preparation of a customized medication by a licensed pharmacist in response to a specific patient prescription not available as a commercial product. Tracked in pharmacy dispensing and PBM systems using compound claim transaction codes, requiring special pricing logic, NDC placeholder values, and manual review workflows during adjudication.

Standard Abbreviation

extemp_cmpnd

Category

pharmacy

Database Usage

-- Example column naming
CREATE TABLE claims (
  clm_id VARCHAR(50),
  extemp_cmpnd VARCHAR(100),  -- Extemporaneous Compounding (max 100 chars)
  ...
);

-- Example in SELECT
SELECT
  clm_id,
  extemp_cmpnd as extemporaneous_compounding
FROM claims;

Common uses in healthcare data

  • PBM claims adjudication and drug utilization review
  • Controlled substance monitoring and DEA compliance
  • Pharmacy data warehouse and ETL pipeline design
  • Prior authorization and step therapy workflows
  • Medicare Part D reporting and CMS submissions

Example database column name

ISO-11179 snake_case standard

-- Recommended column name
extemp_cmpnd

-- Example DDL
CREATE TABLE healthcare_data (
  record_id   VARCHAR(50)   NOT NULL,
  extemp_cmpnd VARCHAR(100),  -- Extemporaneous Compounding (max 100 chars)
  created_dt  TIMESTAMP     NOT NULL DEFAULT NOW()
);

Column names follow the ISO-11179 naming convention: lowercase, underscore-separated, using the standard abbreviation as a prefix where applicable.

Looking for more healthcare terms?

Browse our complete library of 100,000+ standardized healthcare data terms

Browse All Terms