vFACT_AGENTACTIVITIES
Definition
Contact Center Agent data about state changes of all channels. Every agent event from the login to the logout including all state changes between creates a new record for every channel.
Data Repository: Agent Activity Record (AAR)
API: Get Agent Activities (REST) /agents/activities
Original field description
This documentation is available from external source: AAR Data Dictionary
b+s specific fields or modifications
| Field name | Type | Description |
|---|---|---|
| channelsPerType | int | Number of channels of each channel type an agent has for this agent session |
| channelsPerUser | int | Total number of channels an agent has for this agent session |
| direction | varchar(7) | Indicates whether the task is inbound, outbound or outdial |
| loginDuration | bigint | Calculated time span from the logout event back to the login event in milliseconds |
| origid | nvarchar(50) | A UUID that identifies an agent. |
| stateDuration | bigint | Calculated time from start to end time of an event in milliseconds |
| totalDuration | bigint | Calculated time from start to end time for events that are not running in parallel with other events in milliseconds |
| UserType | varchar(5) | User type for agent activity is always = 'Agent' |
note
Surrogate keys (integer) of the datamart are used for tenant (org), user, team, site, date and time fields.