public.mvwevaluationoverview

public.mvwevaluationoverview

Description

Backward compatibility alias for vwEvaluationOverview - DEPRECATED: Use vwEvaluationOverview instead

Table Definition 
CREATE VIEW mvwevaluationoverview AS (
 SELECT vwevaluationoverview.keyid,
    vwevaluationoverview.conversationid,
    vwevaluationoverview."Title Conv",
    vwevaluationoverview.evaluationid,
    vwevaluationoverview."Title Eval",
    vwevaluationoverview.iscalibration,
    vwevaluationoverview.evaluationformid,
    vwevaluationoverview.evaluatorid,
    vwevaluationoverview."Title Evaluator",
    vwevaluationoverview.userid,
    vwevaluationoverview.status,
    vwevaluationoverview.totalscore,
    vwevaluationoverview.totalcriticalscore,
    vwevaluationoverview.totalnoncriticalscore,
    vwevaluationoverview.agenthasread,
    vwevaluationoverview.releasedate,
    vwevaluationoverview.releasedateltc,
    vwevaluationoverview.releasedateusrtz,
    vwevaluationoverview.assigneddate,
    vwevaluationoverview.assigneddateltc,
    vwevaluationoverview."Agent Name",
    vwevaluationoverview."Agent Dept",
    vwevaluationoverview."Agent Manager Id",
    vwevaluationoverview."Agent Manager Name",
    vwevaluationoverview."Agent Div",
    vwevaluationoverview."Evaluator Name",
    vwevaluationoverview."Evaluator Manager Id",
    vwevaluationoverview."Evaluator Manager Name",
    vwevaluationoverview.convstartdate,
    vwevaluationoverview.convenddate,
    vwevaluationoverview.average_score,
    vwevaluationoverview.over80,
    vwevaluationoverview.queuename,
    vwevaluationoverview.mediatype
   FROM vwevaluationoverview
)

Columns

Name Type Default Nullable Children Parents Comment
keyid text true
conversationid varchar(50) true
Title Conv text true
evaluationid varchar(50) true
Title Eval text true
iscalibration boolean true
evaluationformid varchar(50) true
evaluatorid varchar(50) true
Title Evaluator text true
userid varchar(50) true
status varchar(20) true
totalscore numeric(20,2) true
totalcriticalscore numeric(20,2) true
totalnoncriticalscore numeric(20,2) true
agenthasread boolean true
releasedate timestamp without time zone true
releasedateltc timestamp without time zone true
releasedateusrtz timestamp without time zone true
assigneddate timestamp without time zone true
assigneddateltc timestamp without time zone true
Agent Name varchar(200) true
Agent Dept varchar(200) true
Agent Manager Id varchar(50) true
Agent Manager Name varchar(200) true
Agent Div varchar(50) true
Evaluator Name varchar(200) true
Evaluator Manager Id varchar(50) true
Evaluator Manager Name varchar(200) true
convstartdate timestamp without time zone true
convenddate timestamp without time zone true
average_score integer true
over80 integer true
queuename varchar(255) true
mediatype varchar(50) true

Referenced Tables

Name Columns Comment Type
public.vwevaluationoverview 34 View for evaluation overview data (converted from materialized view) VIEW

    • Related Articles

    • public.participantattributesdynamic

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

    • public.convvoicetopicdetaildata

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

    • public.evalquestiondata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false evaluationid varchar(50) false evaluationformid varchar(50) false questiongroupid varchar(50) true questionid varchar(50) true answerid varchar(50) true ...

    • public.evaldata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) false evaluationid varchar(50) false calibrationid varchar(50) true evaluationformid varchar(50) true evaluatorid varchar(50) ...

    • public.userpresencedetaileddata

      Description User Presence Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false Primary Key userid varchar(50) true Agent GUID starttime timestamp without time zone false Start Time (UTC) starttimeltc ...