Agent Status History

Agent Status History

contactcentredb.agentstatushistory

Description

Columns

Name Type Default Nullable Children Parents Comment
AgentARN varchar(255) false
Timestamp timestamp without time zone false
UserName varchar(255) true
Queue varchar(255) true
RoutingProfile varchar(255) true
Status varchar(255) true
Channel varchar(255) true
ContactId varchar(255) true
InitiationMethod varchar(255) true
ContactState varchar(255) true
db_last_updated timestamp without time zone true
UserShortName varchar true

Constraints

Name Type Definition
pk_agentstatushistory PRIMARY KEY PRIMARY KEY (“AgentARN”, “Timestamp”)

Indexes

Name Definition
pk_agentstatushistory CREATE UNIQUE INDEX pk_agentstatushistory ON contactcentredb.agentstatushistory USING btree (“AgentARN”, “Timestamp”)

Generated by tbls


    • Related Articles

    • Agent Status

      contactcentredb.agentstatus Description Columns Name Type Default Nullable Children Parents Comment AgentARN varchar(255) false UserName varchar(255) true Queue varchar(255) true RoutingProfile varchar(255) true Timestamp timestamp without time zone ...

    • public.partsumm_agent

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true conversationstartdate timestamp without time zone false conversationstartdateltc timestamp without time zone true ...

    • Release Notes

      Customer Science releases regular updates to our Genesys Adapter and associated CXiaaS offerings. Please review to understand our current releases: December 2025 December 2025 Version v3.57.1 - December 12, 2025 Improvements Bot reporting now ...

    • public.vwsurveydata

      Description Survey Data View Table Definition CREATE VIEW vwsurveydata AS ( SELECT surveydata.surveyid, surveydata.conversationid, surveydata.surveyformid, surveydata.surveyname, surveydata.agentid, agent.name AS agentname, agent.department AS ...

    • public.mvwevaluationoverview

      Description Backward compatibility alias for vwEvaluationOverview - DEPRECATED: Use vwEvaluationOverview instead Table Definition CREATE VIEW mvwevaluationoverview AS ( SELECT vwevaluationoverview.keyid, vwevaluationoverview.conversationid, ...