FOCUS Specification Changelog

Full Changelog on GitHub

Table of Contents:
Version 1.1
Version 1.0
Version 1.0 Preview
Version 0.5
Columns History

Version 1.1

Announced November 7, 2024

Added:

• CapacityReservationId column
• CapacityReservationStatus column
• CommitmentDiscountQuantity column
• CommitmentDiscountUnit column
• ServiceSubcategory column
• SkuMeter column
• SkuPriceDetails column
• ProviderVersion metadata schema property

Changed:

• CommitmentDiscountId column updates:
  • Must be globally unique within the provider.
  • Should be a fully-qualified identifier.
• ConsumedQuantity column updates:
  • Must be null when CommitmentDiscountStatus is “Unused”.
• ConsumedUnit column updates:
  • Must be null when ChargeClass is not “Correction” and ChargeCategory is not “Usage”.
  • Must be null when ChargeClass is not “Correction” and ChargeCategory is “Usage” and CommitmentDiscountStatus is “Unused”.
  • May be null when ChargeCategory is “Usage” and ChargeClass is “Correction”.
• EffectiveCost column updates:
  • When CommitmentDiscountStatus is “Unused”, must be the difference between the used commitment discount amount and the portion of the total commitment discount purchase applicable for the charge period.
• PricingCategory column updates:
  • Must not be “Committed” when the charge is for a commitment discount purchase.
• SkuPriceId column updates:
  • SkuId can be used if the provider does not have a SkuPriceId but other requirements must be met.

Metadata updates:

• Must be provided in the defined metadata schema.
• Must be an object.
• Must not be null.
• Must include a reference to the schema of the data.
• Schema reference must not be in the FOCUS dataset itself.
• Must be an accurate and complete representation of the provided FOCUS dataset.
• Metadata implementation should be publicly documented.

SchemaId metadata schema property updates:

• Recommended to be a globally unique identifier (GUID) instead of a universally unique identifier (UUID) or SemVer version.

All 1.1 changes

Version 1.0

Announced June 20, 2024

Added:

• String handling attribute
• ChargeClass column
• CommitmentDiscountStatus column
• ContractedCost column
• ContractedUnitPrice column
• RegionId column
• RegionName column
• DataGenerator metadata property
• CreationDate metadata schema property
• FocusVersion metadata schema property
• SchemaId metadata schema property
• ColumnName metadata column definition property
• DataType metadata column definition property
• NumberScale metadata column definition property
• NumberPrecision metadata column definition property
• ProviderTagPrefix metadata column definition property
• StringEncoding metadata column definition property
• StringMaxLength metadata column definition property

Changed:

• Column naming convention attribute includes the following new provisions:
  • Column IDs should not exceed 50 characters.
  • Attribute renamed to Column naming and ordering to denote it also includes rules for column ordering.
• ChargeCategory column updates:
  • Added “Credit” value for credits and any applicable credit corrections. See added ChargeClass column.
  • Updated “Usage”, “Purchase”, and “Tax” to include refunds/corrections. See added ChargeClass column.
  • Updated “Adjustment” value to exclude credits and refunds.
• ChargeFrequency column updates:
  • Column is recommended and may not be present.
• CommitmentDiscountCategory column updates:
  • Column is conditional and only required when the provider supports commitment discounts.
• CommitmentDiscountId column updates:
  • Column is conditional and only required when the provider supports commitment discounts.
• CommitmentDiscountName column updates:
  • Column is conditional and only required when the provider supports commitment discounts.
• CommitmentDiscountType column updates:
  • Column is conditional and only required when the provider supports commitment discounts.
• ConsumedQuantity column updates:
  • Column renamed from UsageQuantity. It is now limited to ChargeType “Usage” rows.
  • Column is conditional and only required when the provider supports the measurement of usage.
  • Column must not be null when ChargeCategory is “Usage” and ChargeClass is not “Correction”.
• ConsumedUnit column updates:
  • Column renamed from UsageUnit. It is now limited to ChargeType “Usage” rows.
  • Column is conditional and only required when the provider supports the measurement of usage.
  • Column must not be null when ChargeCategory is “Usage” and ChargeClass is not “Correction”.
• EffectiveCost column updates:
  • Clarified that effective cost does not mix or “blend” costs across multiple charges.
  • Specified that in the case of a purchase charge paid to cover future eligible charges, the Effective Cost is set to 0.
• ListUnitPrice column updates:
  • Column is conditional and only required when the provider publishes a price list that excludes discounts.
  • Must not be null when ChargeClass is not “Correction” and ChargeCategory is “Usage” or “Purchase”.
  • Must be null when ChargeCategory is “Tax”.
• PricingCategory column updates:
  • Column is conditional and only required when the provider supports more than one pricing category value.
  • Changed “On-Demand” to “Standard”.
  • Changed “Commitment-Based” to “Committed”.
  • Must not be null when ChargeClass is not “Correction” and ChargeCategory is “Usage” or “Purchase”.
  • Must be null when ChargeCategory is “Tax”.
• PricingQuantity
  • Must not be null when ChargeClass is not “Correction” and ChargeCategory is “Usage” or “Purchase”.
  • Must be null when ChargeCategory is “Tax”.
• PricingUnit
  • Must not be null when ChargeClass is not “Correction” and ChargeCategory is “Usage” or “Purchase”.
  • Must be null when ChargeCategory is “Tax”.
• RegionId column updates:
  • Region column was renamed to RegionId when RegionName column was introduced
• ResourceId column updates:
  • Column is conditional and only required when the provider supports billing based on provisioned resource instances.
• ResourceName column updates:
  • Column is conditional and only required when the provider supports billing based on provisioned resource instances.
• ResourceType column updates:
  • Column is conditional and only required when the provider supports billing based on provisioned resource instances and supports multiple “types” of resources.
• SkuId column updates:
  • Column is conditional and only required when the provider publishes a SKU list.
  • Must not be null when ChargeClass is not “Correction” and ChargeCategory is “Usage” or “Purchase”.
  • Must be null when ChargeCategory is “Tax”.
• SkuPriceId column updates:
  • Column is conditional and only required when the provider publishes a SKU price list.
  • Must not be null when ChargeClass is not “Correction” and ChargeCategory is “Usage” or “Purchase”.
  • Must be null when ChargeCategory is “Tax”.
• SubAccountId column updates:
  • Column is conditional and only required when the provider supports a sub account construct.
• SubAccountName column updates:
  • Column is conditional and only required when the provider supports a sub account construct.
• Tags column updates:
  • Column is conditional and only required when the provider supports setting user- or provider-defined tags.
  • Tag keys that cannot have a value must use a boolean true as the tag value.

Fixed:

• CommitmentDiscountType column constraints were updated to show the column as required to align with the normative text.

Removed:

• ChargeSubcategory column – See ChargeCategory and ChargeClass columns

All 1.0 changes

Version 1.0 Preview

Announced November 15, 2023

Added:

• Discount handling attribute
• Key/value format attribute
• Numeric format attribute
• Unit format attribute
• ChargeDescription column
• ChargeFrequency column
• ChargeSubcategory column
• CommitmentDiscountCategory column
• CommitmentDiscountId column
• CommitmentDiscountName column
• CommitmentDiscountType column
• ListCost column
• ListUnitPrice column
• PricingCategory column
• PricingQuantity column
• PricingUnit column
• ResourceType column
• SkuId column
• SkuPriceId column
• Tags column
• UsageQuantity column
• UsageUnit column

Changed:

• Column naming convention attribute includes the following new provisions:
  • Columns with a Category suffix must be normalized.
  • External, custom columns can be added but must be prefixed by x_.
  • FOCUS columns must be listed before custom columns in the dataset.
  • Added “SKU” as an exception to the “no acronyms” rule. The display name is “SKU” and column ID is Sku.
• AmortizedCost column renamed to EffectiveCost
• ChargeType column renamed to ChargeCategory

All 1.0-preview changes

Version 0.5

Announced June 24, 2023

Added:

• Column naming convention attribute
• Currency code format attribute
• Date/time format attribute
• Null handling attribute
• AmortizedCost column
• AvailabilityZone column
• BilledCost column
• BillingAccountId column
• BillingAccountName column
• BillingCurrency column
• BillingPeriodEnd column
• BillingPeriodStart column
• ChargePeriodEnd column
• ChargePeriodStart column
• ChargeType column
• InvoiceIssuerName column
• ProviderName column
• PublisherName column
• Region column
• ResourceId column
• ResourceName column
• ServiceCategory column
• ServiceName column
• SubAccountId column
• SubAccountName column

All 0.5 changes

Columns History

This table maps the evolution of the specification, showcasing column introductions and updates from its initial version 0.5 to the comprehensive revisions in “1.0-preview”, “1.0” and beyond.