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