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.