2.16 Verification, Comparison, and Fluctuation Tracking of Unit Prices
2.16.1 Description
When a provider supports unit pricing concepts, FOCUS allows practitioners to:
- Verify that the correct List Unit Prices and Contracted Unit Prices are applied.
- Compare applied Contracted Unit Prices across different billing accounts and with applied List Unit Prices at specific points in time.
- Track fluctuations in unit prices over time.
2.16.2 Directly Dependent Columns
2.16.3 Supporting Columns
2.16.4 Example SQL Query
Example SQL Query
SELECT DISTINCT
SkuId,
SkuPriceId,
SkuPriceDetails,
BillingPeriodId,
ChargePeriodStart,
ChargePeriodEnd,
BillingCurrency,
ListUnitPrice,
ContractedUnitPrice
FROM focus_data_table
WHERE
SkuPriceId = ?
AND ChargePeriodStart >= ?
AND ChargePeriodEnd < ?