Agents

OBD_AEC_AgentStateMaster

ID

ID

int

(not null)

The ID of the logged-in agent.

AEId

AEId

int

The ID autogenerated by the application.

OBD_AEC_AgentStateMaster

AgentState

AgentState

varchar

(150) (null)

The logged-in agent state. For example, Idle, Talking, ACW, and so on.

OBD_AEC_AgentStateMaster

AgentStateARN

AgentStateARN

varchar

(250) (null)

The Amazon Resource Name (ARN) for the agent state.

OBD_AEC_AgentStateMaster

IsDeleted

IsDeleted

bit

(not null)

Specifies if the agent is deleted from the application.

OBD_AEC_AgentStateMaster

LastUpdatedDateTime

LastUpdatedDateTime

datetime

(not null)

The date and time this table was last accessed.

Routable

Routable

boolean

Specifies if the agent is in a Routable state.

OBD_AEC_AgentStateMaster

IsNotReady

IsNotReady

bit

(not null)

Specifies if the agent is in a Not Ready state.

OBD_AEC_AgentStateMaster

TenantID

TenantID

int

(null)

The Tenant ID auto-generated by the application when a new tenant is created.

OBD_AEC_AgentStateMaster

SubTenantID

SubTenantID

int

(null)

The Sub Tenant ID autogenerated by the application when a new tenant is created.

PlatformProviderID

PlatformProviderID

int

(null)

The Platform Provider ID as generated by the application.

AgentStateDialerID

AgentStateDialerID

int

(null)

The Agent State ID on the dialer.

DialerID

DialerID

int

(null)

The Dialer ID generated when configuring the application.

OBD_AgentSkills

CiscoCampaignID

CiscoCampaignID

int

(null)

The Cisco Campaign ID that the agent is mapped to.

OBD_AgentSkills

CampaignGroup

CampaignGroup

nvarchar

(128) (null)

The Campaign for this agent.

OBD_AgentSkills

SkillTargetID

SkillTargetID

int

(null)

The ID of the skill in the Cisco dialer

OBD_AgentSkills

SkillGroupEnterpriseName

SkillGroupEnterpriseName

nvarchar

(128) (null)

The Skill Name as per the Cisco dialer.

OBD_AgentSkills

AgentSkillTargetID

AgentSkillTargetID

int

(null)

This is the mapping of an agent to a specific skill on Cisco.

OBD_AgentSkills

PersonID

PersonID

nvarchar

(128) (null)

The ID is shown when an agent logs in to Cisco Finesse. This is related to AgentEnterpriseName.

OBD_AgentSkills

AgentEnterpriseName

AgentEnterpriseName

nvarchar

(256) (null)

The enterprise name of the agent. This name must be unique among all the services in the enterprise.

OBD_AgentSkills

ModifiedTime

ModifiedTime

datetime

(null)

The date and time this record was last updated.

OBD_AgentSkills

FirstName

FirstName

nvarchar

(64) (null)

The agent’s first name.

OBD_AgentSkills

LastName

LastName

nvarchar

(64) (null)

The agent’s last name.

OBD_AgentSkills

LoginName

LoginName

nvarchar

(256) (null)

The agent’s login name.

OBD_AgentSkills

IsClickerAgent

IsClickerAgent

bit

(not null)

Indicates whether the agent is clicker agent or not. True if the agent is a clicker agent; false if not a clicker agent.

OBD_AgentSkills

ContactURI

ContactURI

nvarchar

(256) (null)

Not in use.

OBD_AgentSkills

IsEmptyResponse

IsEmptyResponse

bit

(null)

Not in use.

OBD_AgentSkills

WorkSpaceId

WorkSpaceId

nvarchar

(64) (null)

The workflow SID mapped to this agent.

OBD_AgentSkills

WorkFlowSID

WorkFlowSID

nvarchar

(128) (null)

The workflow SID mapped to this agent.

OBD_AgentSkills

TenantID

TenantID

int

(null)

The Tenant ID auto-generated by the application when a new tenant is created.

OBD_AgentSkills

SubTenantID

SubTenantID

int

(null)

The Sub Tenant ID autogenerated by the application when a new tenant is created.

OBD_AgentSkills

DialerID

DialerID

int

(null)

The dialer that the application delivers contacts to.

OBD_AgentSkills

ISDELETED

ISDELETED

bit

(not null)

If an agent skill is not available on Campaign Manager Sync with Cisco, the agent skill is soft deleted in Campaign Manager. This is a flag to indicate if an agent skill is soft deleted.

SyncStatus

SyncStatus

nvarchar

The status of synchronization between the dialer and the application.

OBD_Twilio_Workers

ID

ID

int

(not null)

Identity column unique to each record.

OBD_Twilio_Workers

ProjectID

ProjectID

int

(not null)

ID of the Twilio Project.

OBD_Twilio_Workers

WorkSpaceId

WorkSpaceId

int

(not null)

The workspace ID mapped to this agent.

OBD_Twilio_Workers

WorkerName

WorkerName

nvarchar

(256) (null)

The logged-in worker name (agent name).

OBD_Twilio_Workers

WorkerSID

WorkerSID

nvarchar

(64) (not null)

The logged-in worker (agent) SID.

OBD_Twilio_Workers

ICMId

ICMId

int

(null)

Not in use

OBD_Twilio_Workers

TaggedFor

TaggedFor

nvarchar

(63) (null)

Not in use

OBD_Twilio_Workers

IsSkillUpdated

IsSkillUpdated

bit

(null)

Indicates if the skill mapped to this worker (agent) is updated/ changed. Values are 1 (Updated), 0 (Not Updated), and NULL.

OBD_Twilio_Workers

Skills

Skills

nvarchar

(max) (null)

The skills mapped to this worker (agent).

OBD_Twilio_Workers

TenantID

TenantID

int

(null)

The Tenant ID auto-generated by the application when a new tenant is created.

OBD_Twilio_Workers

SubTenantID

SubTenantID

int

(null)

The Sub Tenant ID autogenerated by the application when a new tenant is created.

OBD_AgentStatus

Id

Id

int

(not null)

Identity column unique to each record.

OBD_AgentStatus

AgentId

AgentId

nvarchar

(64) (null)

The logged-in agent ID.

OBD_AgentStatus

AgentState

AgentState

nvarchar

(32) (null)

The agent state such as Ready, Not Ready, and so on

OBD_AgentStatus

AccountNumber

AccountNumber

nvarchar

(30) (null)

It is a unique ID to identify a call attempt for a contact.

OBD_AgentStatus

CreatedTime

CreatedTime

datetime

(null)

The date and time the agent was added to the database.

OBD_AgentStatus

LastAccessed

LastAccessed

datetime

(null)

The date and time the record was last updated.

OBD_AgentStatus

TenantID

TenantID

int

(null)

The Tenant ID auto-generated by the application when a new tenant is created.

OBD_AgentStatus

SubTenantID

SubTenantID

int

(null)

The Sub Tenant ID autogenerated by the application when a new tenant is created.

OBD_AgentStatus

DialerID

DialerID

int

(null)

The dialer that the application delivers contacts to.

OBD_AgentLoginLogout_Details

Id

Id

int

(not null)

Identity column unique to each record.

OBD_AgentLoginLogout_Details

AgentId

AgentId

nvarchar

(64) (null)

The logged-in agent ID.

OBD_AgentLoginLogout_Details

LoginDateTime

LoginDateTime

datetime

(null)

The date and time the agent has logged in to the application.

OBD_AgentLoginLogout_Details

LogoutDateTime

LogoutDateTime

datetime

(null)

The date and time the agent has logged out of the application.

OBD_AgentLoginLogout_Details

DbDateTime

DbDateTime

datetime

(null)

The date and time this record is inserted into the database.

OBD_AgentLoginLogout_Details

Isprocessed

Isprocessed

int

(null)

This indicates whether the agent-event related record is to be processed and updated to the summary table.

OBD_AgentLoginLogout_Details

LastIterationDateTime

LastIterationDateTime

datetime

(null)

The date and time of the last iteration

OBD_AgentLoginLogout_Details

RecoveryKey

RecoveryKey

float

(null)

Not in use.

OBD_AgentLoginLogout_Details

TenantID

TenantID

int

(null)

The Tenant ID auto-generated by the application when a new tenant is created.