Packages
Packages represent NDC-to-drug mappings with pricing data and historical price changes.
Overview
Packages provide a comprehensive view of how National Drug Codes (NDCs) map to specific drug products, along with associated pricing information and historical tracking of price changes over time.
Schema
| Column Name | Description | Tests |
|---|---|---|
ndc11 | The 11-digit National Drug Code (NDC) format, which uniquely identifies a specific drug package. Includes labeler code, product code, and package code. | unique, not_null (primary key) |
ndc9 | The 9-digit NDC format (first 9 digits of NDC11), representing the product level without package-specific information. | |
drug_id | RxNorm RXCUI for the drug associated with this NDC. Null if no RxNorm mapping exists for this NDC. | |
drug_name | The RxNorm drug name associated with this NDC. From the drugs model. | |
drug_type | RxNorm term type for the associated drug. From the drugs model. | |
is_brand | Boolean flag indicating if the associated drug is a brand product. From the drugs model. | |
brand_name | Brand name of the drug, if applicable. From the drugs model. | |
clinical_drug_id | Clinical product RXCUI associated with this NDC. From the drugs model. | |
clinical_drug_name | Clinical product name associated with this NDC. From the drugs model. | |
clinical_drug_type | Clinical product term type. From the drugs model. | |
nadac_per_unit | National Average Drug Acquisition Cost per unit. The pricing unit is specified in the pricing_unit field. | |
pricing_unit | Unit of measurement for the NADAC price. Typically 'ML' (milliliters), 'GM' (grams), or 'EA' (each). | |
price_start_date | The effective start date for this NADAC price. Indicates when this pricing became active. | |
price_end_date | The effective end date for this NADAC price. Indicates when this pricing was superseded by a new price. Null if this is the current price. | |
is_first_price | Boolean flag indicating if this is the first recorded NADAC price for this NDC. | |
is_last_price | Boolean flag indicating if this is the most recent NADAC price for this NDC. | |
dollar_change | Dollar amount change from the previous NADAC price to this price. Positive values indicate price increases, negative values indicate decreases. | |
percent_change | Percentage change from the previous NADAC price to this price. Positive values indicate price increases, negative values indicate decreases. | |
change_type | Indicator for price direction: 1 if the price increased, 0 if the price decreased. Useful for counting price increases over time. | |
active | Boolean flag indicating if the associated drug is currently active in RxNorm. From the drugs model. | |
prescribable | Boolean flag indicating if the associated drug is prescribable according to RxNorm. From the drugs model. |
Key Features
- NDC Mapping: Direct mapping between National Drug Codes and drug products
- Pricing Data: Current and historical pricing information for each package
- Price History: Track changes in pricing over time to understand market dynamics
- Product Association: Link packages to specific drug products and formulations
Use Cases
- Price tracking and analysis
- Market research and competitive analysis
- Inventory management
- Cost analysis and budgeting