2.15 Service Categorization
2.15.1 Description
FOCUS provides a structure for categorizing services based on their core functions. By classifying services into high-level categories and more granular subcategories, practitioners can organize costs according to functional areas. This standardized categorization provides data that practitioners can use in their cost management processes and decision making.
2.15.2 Directly Dependent Columns
2.15.3 Supporting Columns
2.15.4 Example SQL Query
Example SQL Query
SELECT
BillingPeriodStart,
BillingPeriodEnd,
ProviderName,
ServiceCategory,
ServiceSubcategory,
ServiceName,
BillingCurrency,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? and BillingPeriodEnd < ?
GROUP BY
BillingPeriodStart,
BillingPeriodEnd,
ProviderName,
ServiceCategory,
ServiceSubcategory,
ServiceName,
BillingCurrency