In the Column List:
- P = Primary key
- M = Mandatory field
- F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)
- DV = Default value
Table AGT_I_SESS_STATE_HOUR
Description
This interval-based aggregate table provides a rollup of summarized agent session states. Rollups are derived primarily from the SM_RES_STATE_FACT table. Aggregation is performed along the TENANT, DATE_TIME, RESOURCE_, MEDIA_TYPE, and RESOURCE_GROUP_COMBINATION dimensions. The combination of keys to these dimensions uniquely identifies records in this table.
Durations for Not Ready and Wrap states are directly dependent on the configuration of the underlying Interaction Concentrator application that supplies data to Genesys Info Mart.
Note that this table is similar to AGT_I_MN_SESS_STATE_HOUR, but this aggregate table relies on SM_STATE_FACT, where AGT_I_MN_SESS_STATE_HOUR relies on SM_MEDIA_NEUTRAL_STATE_FACT.
The following columns and column descriptions apply to all AGT_I_SESS_STATE_* tables.
- This document shows table information because it is more informative than view information. However, directly querying tables is not supported; perform your queries on views.
- This document shows the HOUR structure for each table, as an example. For each table, the same structure is used for SUBHR through YEAR views.
- Where referenced, IRF resources include:
- Handling resources (such as self-service IVR ports, agents, or non-agent-associated DNs)
- Mediation resources (such as a non-self-service IVR ports, voice treatment ports, ACD queues, routing points, and so forth) where the interaction ends in mediation before being distributed to a handling resource.
- IRF is an abbreviation for the INTERACTION_RESOURCE_FACT table.
- MSF is an abbreviation for the MEDIATION_SEGMENT_FACT table.
Hint: For easiest viewing, open the downloaded CSV file in Excel and adjust settings for column widths, text wrapping, and so on as desired. Depending on your browser and other system settings, you might need to save the file to your desktop first.
Column List
| Column | Data Type | P | M | F | DV |
|---|---|---|---|---|---|
| AGR_SET_KEY | integer | X | |||
| DATE_TIME_KEY | integer | -1 | |||
| GROUP_COMBINATION_KEY | integer | -1 | |||
| RESOURCE_KEY | integer | X | -1 | ||
| TENANT_KEY | integer | X | -1 | ||
| MEDIA_TYPE_KEY | integer | X | -1 | ||
| ACTIVE_TIME | numeric(18,0) | ||||
| READY_TIME | numeric(18,0) | ||||
| NOT_READY_TIME | numeric(18,0) | ||||
| BUSY_TIME | numeric(18,0) | ||||
| WRAP_TIME | numeric(18,0) | ||||
| READY | numeric(18,0) | ||||
| NOT_READY | numeric(18,0) | ||||
| BUSY | numeric(18,0) | ||||
| WRAP | numeric(18,0) |
AGR_SET_KEY
The surrogate key that is used to join this aggregate table to the AGR_SET table.
DATE_TIME_KEY
The surrogate key that is used to join this aggregate table to the DATE_TIME dimension table to identify the calendar date and 15-minute interval that correspond to the start of the aggregated interval.
GROUP_COMBINATION_KEY
The surrogate key that is used to join records in this aggregate table to the RESOURCE_GROUP_COMBINATION dimension table to identify a specific combination of queue groups to which the queue was a member when the interaction entered the queue.
RESOURCE_KEY
The surrogate key that is used to join this aggregate table to the RESOURCE_ dimension table.
TENANT_KEY
The surrogate key that is used to join this aggregate table to the TENANT view to identify a specific tenant.
MEDIA_TYPE_KEY
The surrogate key that is used to join this aggregate table to the MEDIA_TYPE dimension table.
ACTIVE_TIME
The total amount of time, in seconds, between the beginning and end of this agent’s login session(s) on a particular media channel, irrespective of the intervals in which the resource session occurs. If an agent logs into multiple DNs, login duration is measured from the moment at which the agent logs in to the first DN to the moment at which the agent is no longer logged in to any DN. If the agent’s session was still active when the data was compiled, the agent’s session duration appears as null in the reports.
READY_TIME
The total amount of time, in seconds, that this agent was in the Ready state on a particular media channel.
NOT_READY_TIME
The total amount of time, in seconds, within the interval that this agent was in the NotReady state for a particular media channel (including Do Not Disturb duration, if configured) regardless of whether a reason was indicated.
BUSY_TIME
The total duration, in seconds, of all of interaction-processing activities including the time that is associated with requests for consultation that the agent received and excluding the time spent processing after-call work.
WRAP_TIME
The total amount of time, in seconds, within the interval that this agent spent in ACW state whether or not the reason for entering this state was related to an interaction.
READY
The total number of times within the interval that this agent was in the Ready state on a particular media channel.
NOT_READY
The total number of times within the interval that this agent was in the NotReady state on a particular media channel.
BUSY
The total number of times that this agent was in the Busy state within the interval in order to process interactions including consultations and excluding after-call work.
WRAP
The total number of times within the interval that this agent was in ACW state.