Equipment State History

Overview

The Equipment State History table records time-in-state information for every member of the Equipment group, for each 15-minute interval of time. This table includes time in each Equipment state, time in each Availability State, and time in each combination of Equipment/Availability state. For more information on the Equipement states, see the People Settings topic.

For more general information on People Statistics Tables, see the People Statistics Tables topic.

Rows

This table adds one row per member of the Equipment group, every 15 minutes.

Columns

  • Equipment - This column records the id of the Equipment object on this row.
  • StartTime - This column records the time at the start of each 15 minute interval.
  • Equipment States - The table contains one of these columns for each of the Equipment States specified in the PeopleSettings object. Each column shows the total time (in seconds) the object has spent in that state since the interval began.
  • Availability States - The table contains one of these columns for each of the Availability states (Available, Acquired, Unavailable). Each column shows the total time (in seconds) the object has spent in that state since the interval begain.
  • Combined States - The table contains one of these columns for each unique combination of Equipment state and Availability state. For example, Idle_Available is a different state than Idle_Acquired. Each column shows the total time (in seconds) the object has spent in that combination of states since the interval begain.
  • Duration - This column records the total time spent in the interval to date.
  • StateUtilization - This column shows the utilization of the object for the interval, based on the Equipment states.
  • AvailabilityUtilization - This column shows the utilization of the object for the interval, based on the Availability states.
  • CombinedUtilization - This column shows the utilization of the object for the interval, based on the combination of Equipment and Availability states.

Value Changes

The Equipment and StartTime columns are set when the row is added. All other columns show the current value, if the interval has not ended, or the final value for the interval if it has ended.

Warmup Behavior

At the warmup time, this table will remove the rows corresponding to completed intervals. All columns (except the Equipment column) are reset as if the interval started over. However, the interval timing will continue to be based on the model start time.