Understand the billing account or sub account entity

This query uses the ProviderName column. ProviderName is deprecated in v1.3 and will be removed in v1.4.

FOCUS Versions

v1.2

Context

List all billing and sub-accounts with charges in the period, showing provider, account ID, name, and type. This list allows practitioners to map entity hierarchies and allocate costs.

FOCUS SQL Query

SELECT DISTINCT
    ProviderName,
    BillingAccountID,
    BillingAccountName,
    BillingAccountType
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?