Overview 

This article provides information on the GlobalAttribute, Currency, GasUnit, and EmissionUnit tables, which are configured in the Global Settings page of the Sustainability Dashboard.

Information

• GlobalAttributes: The GlobalAttributes table stores many of the Global Settings values. It only contains one row.
  
  

  Column	Description
  GlobalAttributeId	The primary key.
  KwhEnergyCost	The cost of a kilowatt hour (kWh) in the selected currency.
  KwhEmission	The emissions of a kWh in the selected emission unit.
  EmissionUnitCar	The car equivalent of an emission unit.
  EmissionUnitTree	The tree equivalent of an emission unit.
  EmissionUnitGas	The gas equivalent of an emission unit.
  LastUpdateDate	The last date this table was updated.
  BaseAvgKwhCPU	The baseline average KwH draw for a CPU.
  BaseAvgKwhDisplay	The baseline average KwH draw for a monitor display.
  DefaultLocaleCode	The default local code.
  CurrencyId	The selected currency.
  EmissionUnitId	The selected emission unit.
  GasUnitId	The selected gas unit.

  
  
  
• Currency: This table holds the currencies that the dashboard costs can be stated in. It uses the ISO (International Organization for Standardization) Standard 4217 as the currencyId key.
  
  

  Column	Description
  CurrencyId	The ISO currency primary key.
  SortOrder	The order the currencies are presented in the dashboard Global Settings page.

  
  
  
• GasUnit: This table holds the gas units that the dashboard can be stated in.
  
  

  Column	Description
  GasUnitId	Gallon or litre.

  
  
  
• EmissionUnit: This table holds the emission units that the dashboard can be stated in.
  
  

  Column	Description
  EmissionUnitId	kg, lb, t, ton
  EmissionUnitName	kg (kilogram), lb (pound), metric tonne, ton (2,000 lb)