- Source
- FOCUS use-case SQL
- Status
- Not in v1.0 sample
- Results
- Not run
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
The sample contains no ChargeClass = 'Correction' rows (ChargeClass is null throughout), so corrections to previously invoiced billing periods cannot be reported by subaccount.
Review the original SQL below and the required columns before using a newer FOCUS dataset.
Original FOCUS SQL
SELECT
ProviderName,
BillingAccountId,
ServiceCategory,
SubAccountId,
SubAccountName,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
AND ChargeClass = 'Correction'
GROUP BY
ProviderName,
BillingAccountId,
SubAccountId,
SubAccountName,
ServiceCategory