CoreAuraPharmacy Financial Intelligence
DIR Fee Tracking and Forecasting
Organize historical DIR activity, evaluate payer-specific patterns, and estimate potential exposure using the pharmacy’s own operating data.
A Paid Claim Does Not Always Reveal the Final Margin
CoreAuraPharmacy does not eliminate DIR fees. It gives pharmacies a clearer way to document, evaluate, and anticipate their effect.
At the time of adjudication, a prescription may appear to have an acceptable reimbursement. Retroactive adjustments can arrive 90 to 180 days later, changing the actual financial result after the prescription has already been dispensed.
Depending on the payer, contract, and applicable performance measurements, these adjustments can materially reduce the original reimbursement. Without an organized record of previous activity, pharmacies may have limited visibility into whether a claim will remain profitable after later adjustments.
That uncertainty affects more than financial reporting. It can influence network participation, service decisions, operating stability, and a pharmacy’s ability to continue serving its patients.
How the System Works
Tracking History. Evaluating What May Come Next.
The DIR Fee Tracking and Forecasting system combines two connected functions: structured historical documentation and data-informed exposure forecasting.
Build a Clear History of DIR Activity
Each DIR fee notification can be documented with the information needed to evaluate when the adjustment occurred, what it affected, and how it changed the pharmacy’s actual reimbursement.
- Fee information: amount, classification, and payer identity
- Relevant dates: notification date and applicable service period
- Claim connection: linkage to the associated claim and pharmacy location
- Financial comparison: gross reimbursement compared with the result after adjustment
- Fee categories: performance-based, network, administrative, and other fee types
- Organizational context: records associated with the appropriate pharmacy organization and location
Estimate Potential Exposure Using Available Data
The forecasting process reviews historical DIR activity for the selected payer and pharmacy location. It uses that history to calculate an estimated DIR percentage and potential adjustment amount for a current claim.
- Forecast inputs: payer, drug NDC, claim amount, and pharmacy location
- Historical baseline: average DIR percentage calculated from available prior records
- Recent activity: the most recent 30 days can receive additional weight
- Minimum recent data: recent-trend weighting is used when at least three applicable data points are available
- Long-term fallback: when recent data is limited, the historical average provides the forecasting basis
- Estimated result: potential DIR exposure expressed as a percentage and estimated adjustment amount
Risk Classification
The system organizes estimated exposure into four risk levels. Each classification reflects the predicted DIR percentage calculated from the pharmacy’s available historical data.
Low
The available data indicates comparatively limited DIR exposure for the selected payer, claim, and pharmacy location.
Medium
The forecast indicates moderate exposure that should be considered when reviewing expected reimbursement and claim margin.
High
Historical patterns suggest significant potential margin reduction and warrant closer financial evaluation.
Critical
Estimated exposure may place the claim at substantial risk of becoming financially unfavorable after the adjustment.
Confidence Scoring
Forecast confidence reflects the amount and recency of the historical data supporting the estimate. This helps prevent limited information from being presented with false precision.
Payer Intelligence
Identify Patterns Behind the Adjustments
Individual DIR records become more useful when viewed together. CoreAuraPharmacy organizes historical activity so pharmacy teams can evaluate how adjustment behavior differs across payers, fee types, time periods, and locations.
Fee-Type Frequency and Amount
The system groups DIR activity by fee classification and evaluates both frequency and average amount. This helps reveal which types of adjustments appear most often for each payer.
Adjustment Timing
By comparing the original service date with the notification date, the system calculates the average delay associated with a payer’s DIR activity and makes recurring timing patterns easier to see.
Recent Trends Compared With History
Recent DIR percentages are compared with longer-term historical averages. This shows whether recorded exposure is remaining consistent, declining, or increasing over time.
Protected Access
Security and Data Isolation
DIR information is separated by organization and pharmacy location. Layered access controls determine who may use the capability and which records each authorized user may retrieve.
Pharmacy-Level Authorization
Access guards restrict the DIR capability to appropriately authorized pharmacy users before organization or location records can be requested.
Organization-Level Validation
The system validates the user’s relationship with the organization through the applicable OrganizationUser record or recognized primary contact relationship.
Location-Level Filtering
Results are limited to pharmacy locations the user is permitted to access. This prevents DIR information from being returned across unrelated organizations or unauthorized locations.
Location Ownership Is Checked First
Before returning a forecast, the system verifies that the supplied location identifier belongs to an organization the requesting user is authorized to access.
Missing Records Do Not Expose System Details
Record queries use safe empty results when applicable data is absent. Organization-access checks also handle missing relationship records without returning internal errors or unrelated information.
Operational Value
Clinical and Financial Impact
Better visibility gives pharmacy leaders more context when evaluating reimbursement, payer relationships, service decisions, and long-term operating stability.
The purpose of the system is foresight: turning delayed DIR activity into organized information that can support earlier evaluation.
By documenting historical adjustments and comparing payer-specific patterns, pharmacy teams can better understand the difference between the reimbursement shown at adjudication and the financial result after later DIR activity.
That information supports more informed conversations about contracts, payer participation, claim performance, operating margins, and the services a pharmacy can sustainably provide to its patients.
Bring Greater Visibility to DIR Activity
Talk with the CoreAuraLogix team about how DIR fee tracking and forecasting can fit within your pharmacy’s broader financial and operational environment.
Schedule a Pharmacy ConsultationDIR Fee Tracking & Forecasting System – Technical Overview
The Problem We’re Solving
We’re not solving DIR fees. We’re exposing them so pharmacies can fight back with data instead of hope.
PBMs have weaponized DIR fees to systematically extract profit from independent pharmacies while creating an illusion of fair reimbursement at point of sale. When a pharmacy processes a prescription, the initial adjudication shows a seemingly acceptable reimbursement. The pharmacist counsels the patient, dispenses the medication, and the claim status reads “paid.” But 90 to 180 days later, the PBM sends a retroactive clawback notice, reclaiming 8% to 30% of that original payment through obscure “performance metrics” that were never disclosed upfront.
This creates a financial time bomb. Pharmacies cannot predict their true profitability at the moment of service. They’re forced to accept claims blind, not knowing if a seemingly profitable prescription will become underwater months later. The result is pharmacies either stop serving certain payers entirely, limiting patient access, or absorb losses that push them toward closure. Patients lose access to care, and pharmacists are forced into impossible decisions about which prescriptions they can afford to fill.
We built this system because pharmacies deserve visibility into the actual economics of their business before PBMs retroactively rewrite the deal.
Technical Architecture
The DIR Fee Tracking system operates across two core components: historical data tracking and predictive forecasting, both secured with organization-level data isolation.
Historical DIR Fee Tracking (DIRFee Entity)
Every DIR fee notification from a PBM is captured with complete metadata: the fee amount, fee type classification, payer identity, notification date, the service period being clawed back, and linkage to the specific pharmacy location and original claim. This creates a full audit trail of PBM behavior over time. The system tracks gross sales versus actual net reimbursement after DIR adjustments, exposing the true margin erosion. Fee types are categorized (performance-based, network fees, administrative) to identify which PBM tactics are most aggressive.
The data model links DIR fees to PharmacyLocation records, which are associated with Organization entities. This ensures pharmacies only see their own DIR fee history, not competitors’ data. Organization-level isolation is enforced at the data access layer through OrganizationUser relationships, preventing cross-tenant data leakage.
Predictive DIR Fee Forecasting (forecastDIRFees Function)
The forecasting engine analyzes historical DIR patterns to predict future clawback exposure on currently paid claims. When invoked with a payer name, drug NDC, claim amount, and location ID, the system retrieves all historical DIR fees for that specific payer at that location. It calculates the average DIR fee percentage across all historical claims, then weights recent data more heavily by comparing the last 30 days of DIR activity against the full historical average.
The prediction algorithm uses recent trend data if at least three data points exist within the last month, otherwise it defaults to the long-term average. This adaptive approach accounts for PBMs changing their clawback aggressiveness over time. The predicted DIR fee is calculated as a percentage of the current claim amount, giving pharmacies a real-time estimate of what will actually be clawed back later.
Risk Classification
The system assigns risk levels based on predicted DIR exposure:
- Critical: 25%+ DIR fees (claim will likely be net-negative after clawback)
- High: 15-24% DIR fees (significant margin erosion)
- Medium: 8-14% DIR fees (moderate clawback exposure)
- Low: <8% DIR fees (minimal impact)
Confidence scoring accounts for data volume. High confidence requires at least 10 historical DIR events and 3 recent data points. Medium confidence requires 5 historical events. Low confidence is assigned when historical data is sparse. This prevents false precision when predicting from limited information.
Payer-Specific Pattern Analysis
The system identifies common fee types by frequency and average amount, exposing which PBM tactics are most prevalent for each payer. It calculates the average delay between service date and DIR notification date, showing pharmacies the typical clawback timeline. Trend analysis compares recent DIR percentages against historical averages to flag when PBMs are increasing clawback aggression.
Security & Data Isolation
Access control operates at three levels. First, vertical-level guards restrict DIR tracking to pharmacy-licensed users only. Second, organization-level access is enforced by validating that the requesting user has OrganizationUser relationships or is listed as the primary contact for the organization that owns the target PharmacyLocation. Third, location-level filtering ensures users only retrieve DIR fee data for locations they have explicit access to. The forecasting function verifies that the provided location_id belongs to an organization the user can access before returning any predictions.
All entity queries default to empty arrays if null, preventing null reference errors. The organization access check is wrapped in try-catch to gracefully handle missing OrganizationUser records without exposing system errors to the client.
Clinical & Financial Impact
This system gives pharmacies the one thing PBMs don’t want them to have: foresight. By exposing DIR clawback patterns before they happen, pharmacies can make informed decisions about which prescriptions are actually profitable, which payers are predatory, and when to negotiate better contracts or drop networks entirely. It shifts power back to the dispensing pharmacist, who can now see through the PBM’s accounting manipulation in real-time instead of discovering losses months later when it’s too late to act.