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: March 2026 March 2026 Version v3.59.0 - March 19, 2026 New Features Adds detailed OAuth usage ...

    • 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, ...