FOCUS Specification

2.2.1 Description

FOCUS data should be consistent with the costs indicated on payable invoices. This is relevant to the total cost of the invoice, as well as the period of time the invoice covers.

2.2.2 Directly Dependent Columns

Billed Cost Billing Currency Billing Period End Billing Period Start Invoice ID

2.2.3 Supporting Columns

Provider Service Name

2.2.4 Example SQL Query

Example SQL Query

SELECT
  BillingPeriodStart,
  BillingPeriodEnd,
  InvoiceId,
  SUM(BilledCost)
FROM focus_data_table
GROUP BY
  BillingPeriodStart,
  BillingPeriodEnd,
  InvoiceId

2.2 Billed Cost and Invoice Alignment

2.2.1 Description

2.2.2 Directly Dependent Columns

2.2.3 Supporting Columns

2.2.4 Example SQL Query

Example SQL Query