- Source
- FOCUS use-case SQL
- Status
- Not in v1.0 sample
- Results
- Not run
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
ChargeClass is null on every row of the v1.0 sample, so there are no 'Correction' charges to report for any billing period.
Review the original SQL below and the required columns before using a newer FOCUS dataset.
Original FOCUS SQL
SELECT
ServiceProviderName,
BillingAccountId,
ServiceCategory,
SubAccountId,
SubAccountName,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
AND ChargeClass = 'Correction'
GROUP BY
ServiceProviderName,
BillingAccountId,
SubAccountId,
SubAccountName,
ServiceCategory