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

    • 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 Materialized view for evaluation overview data Table Definition CREATE MATERIALIZED VIEW mvwevaluationoverview AS ( SELECT concat(evaldata.conversationid, '|', evaldata.evaluationid, '|', evaldata.evaluationformid) AS keyid, ...

    • public.vwtimeoffrequestdata

      Description See TimeOffRequestData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwtimeoffrequestdata AS ( SELECT tr.id, tr.userid, tr.isfulldayrequest, tr.status, tr.startdate, tr.notes, tr.timeoffduration, ...