Agent Activity
    • Dark
      Light

    Agent Activity

    • Dark
      Light

    Article summary

    Source Table

    Column Name

    Display Name

    Data Type

    Description

    Amazon Connect

    Amazon SCV

    Twilio Flex

    UJET

    Cisco CCE

    Cisco CCX

    Five9 VCC

    RPT_AEAgentActivity

    AgentID

    AgentID

    nvarchar

    (50) (null)

    The name of the agent is logged into the database with every state change.

    ✔️

    ✔️

    ✔️

    ✔️

    ✖️

    ✖️

    ✖️

    RPT_AEAgentActivity

    AgentState

    Agent State

    nvarchar

    (100) (null)

    The agent state, such as Ready or Not Ready, and so on, represents the various states that can occur.

    ✔️

    ✔️

    ✔️

    ✔️

    ✖️

    ✖️

    ✖️

    RPT_AEAgentActivity

    ACTIVITYDATE

    ACTIVITYDATE

    varchar

    (30) (null)

    It displays the date and time of the activity.

    ✔️

    ✔️

    ✔️

    ✔️

    ✖️

    ✖️

    ✖️

    RPT_AEAgentActivity

    InsertedTime

    Inserted Time

    datetime

    (null)

    It displays the date and time when state of the agent change is inserted into the database.

    ✔️

    ✔️

    ✔️

    ✔️

    ✖️

    ✖️

    ✖️

    RPT_AEAgentActivity

    LCMKey

    LCMKey

    nvarchar

    (60) (null)

    It consists of ContactID, ModeID, CampaignKey, ContactRetries, ModeRetries, TimeZoneID, and TenantID separated by a delimiter.

    ✔️

    ✔️

    ✔️

    ✔️

    ✖️

    ✖️

    ✖️

    RPT_AEAgentActivity

    BlendingState

    Blending State

    varchar

    (10) (null)

    The blending state of the agent is whether it is Inbound or Outbound.

    ✔️

    ✔️

    ✔️

    ✔️

    ✖️

    ✖️

    ✖️

    RPT_AEAgentActivity

    STARTTIME

    STARTTIME

    datetime

    (null)

    It displays the starting date and time of the activity.

    ✔️

    ✔️

    ✔️

    ✔️

    ✖️

    ✖️

    ✖️

    RPT_AEAgentActivity

    ENDTIME

    ENDTIME

    datetime

    (null)

    It displays the completion date and time of the activity.

    ✔️

    ✔️

    ✔️

    ✔️

    ✖️

    ✖️

    ✖️

    RPT_AEAgentActivity

    DURATIONINSECONDS

    DURATIONINSECONDS

    int

    (null)

    It displays the duration of the activity.

    ✔️

    ✔️

    ✔️

    ✔️

    ✖️

    ✖️

    ✖️

    RPT_AEAgentActivity

    ISINCALL

    ISINCALL

    int

    (not null)

    It indicates whether the activity is currently in a call.

    ✔️

    ✔️

    ✔️

    ✔️

    ✖️

    ✖️

    ✖️

    RPT_AEAgentActivity

    TENANTID

    TENANTID

    bigint

    (null)

    It is the Tenant ID.

    ✔️

    ✔️

    ✔️

    ✔️

    ✖️

    ✖️

    ✖️

    RPT_AEAgentActivity

    SUBTENANTID

    SUBTENANTID

    bigint

    (null)

    It is the Sub Tenant ID.

    ✔️

    ✔️

    ✔️

    ✔️

    ✖️

    ✖️

    ✖️


    Was this article helpful?

    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.
    ESC

    Eddy AI, facilitating knowledge discovery through conversational intelligence