Agent Status

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 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_agentstatus PRIMARY KEY PRIMARY KEY (“AgentARN”)

Indexes

Name Definition
pk_agentstatus CREATE UNIQUE INDEX pk_agentstatus ON contactcentredb.agentstatus USING btree (“AgentARN”)

Generated by tbls


    • Related Articles

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

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

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

    • public.vwevaluationoverview

      Description View for evaluation overview data (converted from materialized view) Table Definition CREATE VIEW vwevaluationoverview AS ( SELECT concat(evaldata.conversationid, '|', evaldata.evaluationid, '|', evaldata.evaluationformid) AS keyid, ...