Location State History

Overview

The Location State History table records time-in-state information for every member of the Locations group, for each 15-minute interval of time. This table includes time in each Location state, time in each Availability State, and time in each combination of Location/Availability state. For more information on the Location 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 Locations group, every 15 minutes.

Columns

  • Location - This column records the id of the Location object on this row.
  • StartTime - This column records the time at the start of each 15 minute interval.
  • Location States - The table contains one of these columns for each of the Location 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 Location 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 Location 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 Location and Availability states.

Value Changes

The Location 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 Location column) are reset as if the interval started over. However, the interval timing will continue to be based on the model start time.