Agents
- DarkLight
Agents
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Source Table | Column Name | Display Name | Data Type | Description | Platform |
|---|---|---|---|---|---|
OBD_AEC_AgentStateMaster | ID | ID | int (not null) | The ID of the logged-in agent. | Amazon Connect |
OBD_AEC_AgentStateMaster | AgentState | AgentState | varchar (150) (null) | The logged-in agent state. For example, Idle, Talking, ACW, and so on. | Amazon Connect |
OBD_AEC_AgentStateMaster | AgentStateARN | AgentStateARN | varchar (250) (null) | The Amazon Resource Name (ARN) for the agent state. | Amazon Connect |
OBD_AEC_AgentStateMaster | IsDeleted | IsDeleted | bit (not null) | Specifies if the agent is deleted from the application. | Amazon Connect |
OBD_AEC_AgentStateMaster | LastUpdatedDateTime | LastUpdatedDateTime | datetime (not null) | The date and time this table was last accessed. | Amazon Connect |
OBD_AEC_AgentStateMaster | IsNotReady | IsNotReady | bit (not null) | Specifies if the agent is in a Not Ready state. | Amazon Connect |
OBD_AEC_AgentStateMaster | TenantID | TenantID | int (null) | The Tenant ID auto-generated by the application when a new tenant is created. | Amazon Connect |
OBD_AEC_AgentStateMaster | SubTenantID | SubTenantID | int (null) | The Sub Tenant ID autogenerated by the application when a new tenant is created. | Amazon Connect |
OBD_AgentSkills | CiscoCampaignID | CiscoCampaignID | int (null) | The Cisco Campaign ID that the agent is mapped to. | Cisco CCE/ Cisco CCX/ Nice CXone |
OBD_AgentSkills | CampaignGroup | CampaignGroup | nvarchar (128) (null) | The Campaign for this agent. | Cisco CCE/ Cisco CCX/ Nice CXone |
OBD_AgentSkills | SkillTargetID | SkillTargetID | int (null) | The ID of the skill in the Cisco dialer | Cisco CCE/ Cisco CCX/ Nice CXone |
OBD_AgentSkills | SkillGroupEnterpriseName | SkillGroupEnterpriseName | nvarchar (128) (null) | The Skill Name as per the Cisco dialer. | Cisco CCE/ Cisco CCX/Nice CXone |
OBD_AgentSkills | AgentSkillTargetID | AgentSkillTargetID | int (null) | This is the mapping of an agent to a specific skill on Cisco. | Cisco CCE/ Cisco CCX/ Nice CXone |
OBD_AgentSkills | PersonID | PersonID | nvarchar (128) (null) | The ID is shown when an agent logs in to Cisco Finesse. This is related to AgentEnterpriseName. | Cisco CCE/ Cisco CCX/ Nice CXone |
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. | Cisco CCE/ Cisco CCX/ Nice CXone |
OBD_AgentSkills | ModifiedTime | ModifiedTime | datetime (null) | The date and time this record was last updated. | Cisco CCE/ Cisco CCX/ Nice CXone |
OBD_AgentSkills | FirstName | FirstName | nvarchar (64) (null) | The agent’s first name. | Cisco CCE/ Cisco CCX/ Nice CXone |
OBD_AgentSkills | LastName | LastName | nvarchar (64) (null) | The agent’s last name. | Cisco CCE/Cisco CCX/Nice CXone |
OBD_AgentSkills | LoginName | LoginName | nvarchar (256) (null) | The agent’s login name. | Cisco CCE/ Cisco CCX/ Nice CXone |
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. | Cisco CCE/ Cisco CCX/ Nice CXone |
OBD_AgentSkills | ContactURI | ContactURI | nvarchar (256) (null) | Not in use. | Cisco CCE/ Cisco CCX/ Nice CXone |
OBD_AgentSkills | IsEmptyResponse | IsEmptyResponse | bit (null) | Not in use. | Cisco CCE/ Cisco CCX/ Nice CXone |
OBD_AgentSkills | WorkSpaceId | WorkSpaceId | nvarchar (64) (null) | The workflow SID mapped to this agent. | Cisco CCE/ Cisco CCX/ Nice CXone |
OBD_AgentSkills | WorkFlowSID | WorkFlowSID | nvarchar (128) (null) | The workflow SID mapped to this agent. | Cisco CCE/ Cisco CCX/Nice CXone |
OBD_AgentSkills | TenantID | TenantID | int (null) | The Tenant ID auto-generated by the application when a new tenant is created. | Cisco CCE/ Cisco CCX/ Nice CXone |
OBD_AgentSkills | SubTenantID | SubTenantID | int (null) | The Sub Tenant ID autogenerated by the application when a new tenant is created. | Cisco CCE/ Cisco CCX/ Nice CXone |
OBD_AgentSkills | DialerID | DialerID | int (null) | The dialer that the application delivers contacts to. | Cisco CCE/ Cisco CCX/ Nice CXone |
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. | Cisco CCE/Cisco CCX/Nice CXone |
OBD_Twilio_Workers | ID | ID | int (not null) | Identity column unique to each record. | Twilio Flex |
OBD_Twilio_Workers | ProjectID | ProjectID | int (not null) | ID of the Twilio Project. | Twilio Flex |
OBD_Twilio_Workers | WorkSpaceId | WorkSpaceId | int (not null) | The workspace ID mapped to this agent. | Twilio Flex |
OBD_Twilio_Workers | WorkerName | WorkerName | nvarchar (256) (null) | The logged-in worker name (agent name). | Twilio Flex |
OBD_Twilio_Workers | WorkerSID | WorkerSID | nvarchar (64) (not null) | The logged-in worker (agent) SID. | Twilio Flex |
OBD_Twilio_Workers | ICMId | ICMId | int (null) | Not in use | Twilio Flex |
OBD_Twilio_Workers | TaggedFor | TaggedFor | nvarchar (63) (null) | Not in use | Twilio Flex |
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. | Twilio Flex |
OBD_Twilio_Workers | Skills | Skills | nvarchar (max) (null) | The skills mapped to this worker (agent). | Twilio Flex |
OBD_Twilio_Workers | TenantID | TenantID | int (null) | The Tenant ID auto-generated by the application when a new tenant is created. | Twilio Flex |
OBD_Twilio_Workers | SubTenantID | SubTenantID | int (null) | The Sub Tenant ID autogenerated by the application when a new tenant is created. | Twilio Flex |
OBD_AgentStatus | Id | Id | int (not null) | Identity column unique to each record. | Twilio Flex |
OBD_AgentStatus | AgentId | AgentId | nvarchar (64) (null) | The logged-in agent ID. | Twilio Flex |
OBD_AgentStatus | AgentState | AgentState | nvarchar (32) (null) | The agent state such as Ready, Not Ready, and so on | Twilio Flex |
OBD_AgentStatus | AccountNumber | AccountNumber | nvarchar (30) (null) | It is a unique ID to identify a call attempt for a contact. | Twilio Flex |
OBD_AgentStatus | CreatedTime | CreatedTime | datetime (null) | The date and time the agent was added to the database. | Twilio Flex |
OBD_AgentStatus | LastAccessed | LastAccessed | datetime (null) | The date and time the record was last updated. | Twilio Flex |
OBD_AgentStatus | TenantID | TenantID | int (null) | The Tenant ID auto-generated by the application when a new tenant is created. | Twilio Flex |
OBD_AgentStatus | SubTenantID | SubTenantID | int (null) | The Sub Tenant ID autogenerated by the application when a new tenant is created. | Twilio Flex |
OBD_AgentStatus | DialerID | DialerID | int (null) | The dialer that the application delivers contacts to. | Twilio Flex |
OBD_AgentLoginLogout_Details | Id | Id | int (not null) | Identity column unique to each record. | Twilio Flex |
OBD_AgentLoginLogout_Details | AgentId | AgentId | nvarchar (64) (null) | The logged-in agent ID. | Twilio Flex |
OBD_AgentLoginLogout_Details | LoginDateTime | LoginDateTime | datetime (null) | The date and time the agent has logged in to the application. | Twilio Flex |
OBD_AgentLoginLogout_Details | LogoutDateTime | LogoutDateTime | datetime (null) | The date and time the agent has logged out of the application. | Twilio Flex |
OBD_AgentLoginLogout_Details | DbDateTime | DbDateTime | datetime (null) | The date and time this record is inserted into the database. | Twilio Flex |
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. | Twilio Flex |
OBD_AgentLoginLogout_Details | LastIterationDateTime | LastIterationDateTime | datetime (null) | The date and time of the last iteration | Twilio Flex |
OBD_AgentLoginLogout_Details | RecoveryKey | RecoveryKey | float (null) | Not in use. | Twilio Flex |
OBD_AgentLoginLogout_Details | TenantID | TenantID | int (null) | The Tenant ID auto-generated by the application when a new tenant is created. | Twilio Flex |
OBD_AgentLoginLogout_Details | SubTenantID | SubTenantID | int (null) | The Sub Tenant ID autogenerated by the application when a new tenant is created. | Twilio Flex |
Note:
*All fields in the OBD_BSFTTeamList table are populated as XML values in one column of Teams.
Was this article helpful?