Location State History

Overview

The Location State History table records information about each state change for every member of the Location group. It includes information about the Location States as well as the Availability states. For more information about the Location States, see the People Settings topic.

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

Rows

In general, this table adds a row any time a member of the Location group changes state (either the Location's state profile or the Availability profile). However, if a state changes in 0 time, the new state information will overwrite the old state information. In this way, the table does not record 0 time state changes.

Every 15 minutes (900 seconds), this table will add rows for each object, as though each object had changed state at this time. This makes it easier to categorize each state by when the state occurred.

Columns

  • Location - This column records the id of the Location object on this row.
  • StartTime - This column records the time the Location object entered the state.
  • EndTime - This column records the time the Location object left the state.
  • Duration - This column records the number of sections the Location object was in the state.
  • Location States - The table contains one of these columns for each of the Location States specified in the PeopleSettings object. The value of the column indicates whether the Location object was in the state for this column for the duration of the row.
  • Available/Acquired/Unavailable - These columns indicate whether the Location object was available, acquired, or unavailable for the duration of the row.
  • StateUtilized - This column indicates whether the Location object was in a utilized state.
  • StateExcluded - This column indicates whether the Location object was in an excluded state.
  • AvailabilityUtilized - This column indicates whether the Location object was utilized, according to their availability.
  • AvailabilityExcluded - This column indicates whether the Location object was excluded, according to their availability.
  • Utilized - This column indicates whether the Location object was utilized, according to both their States and Availability. If either was utilized, this will be a 1.
  • Excluded - This column indicates whether the Location object was ecluded, according to both their States and Availability. If etierh was excluded, this will be a 1.

Value Changes

The End Time and Duration columns continuosly increase as long as the state remains the same. All other values are set when the row is added.

Warmup Behavior

At the warmup time, this table will remove the rows corresponding to complete requests. For the remaining rows, the EndTime and Duration values will also be reset, as if the Location object had entered the given state at the warmup time.