The Staff State History table records time-in-state information
for every member of the Staff group, for each 15-minute interval of time.
This table includes time in each Staff state, time in each Availability State, and
time in each combination of Staff/Availability state.
For more information on the Staff 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 Staff group, every 15 minutes.
Columns
Staff - This column records
the id of the Staff object on this row.
StartTime - This column
records the time at the start of each 15 minute interval.
Staff States - The table
contains one of these columns for each of the Staff 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 Staff 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 Staff 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 Staff and Availability states.
Value Changes
The Staff 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 Staff column) are reset as if the interval
started over. However, the interval timing will continue
to be based on the model start time.