Overview

This article provides information on the ComponentStateDaySum and ComponentStateHourSum tables.

Information

• ComponentStateDaySum: This table is used by the Sustainability Dashboard to correlate data between administrative groups, business units, and locations.
  
• The data is summarized to the day for the primary key. This table is populated by the summarization process and should not be modified.
  
  

  Column	Description
  dateHourId	The date key.
  businessUnitId	The business unit key (the CollectionId on the Collection table).
  deviceFamilyId	The device family key. Possible device families include PC, Mac, Phone, Switch, Router, AccessPoint, Interface, Service, and Unknown.
  componentTypeId	The component type key. Possible component types include CPU, Display, EnergyWise, and User.
  componentStateId	The component state key. Possible component states include Active, On, Off, Idle, Suspend, Unknown, Hibernate, EnergyWisePowerLevel(0 - 10), and Database24HrEvent.
  durationHour	The duration measured in hours.
  KwH	The kWh consumed (the sum of the time a device spends in a state multiplied by the watts that state consumes).
  energyCost	The costs of the kWh consumed. EnergyCost is a factor of kWh, which can change by time (peak load costs can be different than non-peak).
  emission	The emissions for the kWh consumed.
  baselineHourlyConsumption	The expected baseline.

• ComponentStateHourSum: This table is used by the Administrator Console for Operational Hours reports. The data is summarized to the hour for the primary key.
  
  This table is populated by the summarization process and should not be modified.
  
  

  Column	Description
  dateHourId	The date plus hour key.
  groupId	The administrative group key.
  policyId	The policy key.
  deviceFamilyId	The device family key. Possible device families include PC, Mac, Phone, Switch, Router, AccessPoint, Interface, Service, and Unknown.
  componentTypeId	The component type key. Possible component types include CPU, Display, EnergyWise, User.
  componentStateId	The component state key. Possible component states include Active, On, Off, Idle, Suspend, Unknown, Hibernate, EnergyWisePowerLevel 0 - 10, and Database24HrEvent.
  durationHour	The duration measured in hours.
  KwH	The kWh consumed (the sum of the time a device spends in a state multiplied by the watts that state consumes).
  energyCost	The costs of the kWh consumed. EnergyCost is a factor of kWh.
  Emission	The emissions for the kWh consumed.
  baselineHourlyConsumption	The expected baseline for hours.