public.vwevalquestiondata
Description
See EvalQuestionData: View for evaluation question data with
additional details
Table Definition
CREATE VIEW vwevalquestiondata AS (
SELECT DISTINCT eq.evaluationid,
eq.questionid,
eq.answerid,
eq.score,
ed.questionanswervalue,
eq.markedna,
eq.failedkillquestions,
eq.comments,
ed.evaluationformid,
ed.evaluationname,
ed.questiongroupid,
ed.questiongroupname,
ed.questiontext,
ed.questionhelptext,
ed.quesiontype,
ed.questionanwserid,
ed.questionanswertext,
cd.divisionid
FROM (((evalquestiondata eq
LEFT JOIN evaldetails ed ON ((((ed.evaluationformid)::text = (eq.evaluationformid)::text) AND ((ed.questiongroupid)::text = (eq.questiongroupid)::text) AND ((ed.questionid)::text = (eq.questionid)::text) AND ((ed.questionanwserid)::text = (eq.answerid)::text))))
LEFT JOIN evaldata eda ON (((eda.evaluationid)::text = (eq.evaluationid)::text)))
LEFT JOIN convsummarydata cd ON (((cd.conversationid)::text = (eda.conversationid)::text)))
)
Columns
evaluationid |
varchar(50) |
|
true |
|
|
Evaluation GUID |
questionid |
varchar(50) |
|
true |
|
|
Question GUID |
answerid |
varchar(50) |
|
true |
|
|
Answer GUID |
score |
numeric(20,2) |
|
true |
|
|
Score |
questionanswervalue |
numeric(20,2) |
|
true |
|
|
Question Answer Value |
markedna |
bit(1) |
|
true |
|
|
Marked Not Applicable |
failedkillquestions |
bit(1) |
|
true |
|
|
Failed Kill Questions |
comments |
text |
|
true |
|
|
Comments |
evaluationformid |
varchar(50) |
|
true |
|
|
Evaluation Form GUID |
evaluationname |
varchar(200) |
|
true |
|
|
Evaluation Name |
questiongroupid |
varchar(50) |
|
true |
|
|
Question Group GUID |
questiongroupname |
varchar(200) |
|
true |
|
|
Question Group Name |
questiontext |
varchar(400) |
|
true |
|
|
Question Text |
questionhelptext |
text |
|
true |
|
|
Question Help Text |
quesiontype |
varchar(50) |
|
true |
|
|
Question Type |
questionanwserid |
varchar(50) |
|
true |
|
|
Question Answer GUID |
questionanswertext |
varchar(200) |
|
true |
|
|
Question Answer Text |
divisionid |
varchar(50) |
|
true |
|
|
Division GUID |
Referenced Tables
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 ...