public.vwevalquestiongroupdata

public.vwevalquestiongroupdata

Description

One row per scored question group in an evaluation, with achieved and maximum group scores

Table Definition 
CREATE VIEW vwevalquestiongroupdata AS (
 SELECT (((egd.evaluationformid)::text || '|'::text) || (egd.questiongroupid)::text) AS questiongroupfactkey,
    egd.keyid,
    egd.evaluationid,
    egd.questiongroupid,
    egd.totalscore,
    egd.maxtotalscore,
    egd.markedna,
    egd.totalcriticalscore,
    egd.maxtotalcriticalscore,
    egd.totalnoncriticalscore,
    egd.maxtotalnoncriticalscore,
    egd.totalscoreunweighted,
    egd.maxtotalscoreunweighted,
    egd.failedkillquestions,
    egd.comments,
    egd.updated,
    egd.evaluationformid
   FROM evalquestiongroupdata egd
)

Columns

Name Type Default Nullable Children Parents Comment
questiongroupfactkey text true Evaluation form GUID and question group GUID separated by |
keyid varchar(50) true Primary Key
evaluationid varchar(50) true Evaluation GUID
questiongroupid varchar(50) true Question group GUID within the evaluation form
totalscore numeric(20,2) true Achieved score for this question group in this evaluation
maxtotalscore numeric(20,2) true Maximum possible score for this question group in this evaluation
markedna bit(1) true Evaluation Question Group Marked Not Applicable (True/False)
totalcriticalscore numeric(20,2) true Evaluation Question Group Total Critical Score
maxtotalcriticalscore numeric(20,2) true Evaluation Question Group Total Max Critical Score
totalnoncriticalscore numeric(20,2) true Evaluation Question Group Total Non Critical Score
maxtotalnoncriticalscore numeric(20,2) true Evaluation Question GroupTotal Max Non Critical Score
totalscoreunweighted numeric(20,2) true Evaluation Question Group Total Score Un-Weighted
maxtotalscoreunweighted numeric(20,2) true Evaluation Question Group Max Total Score Un-Weighted
failedkillquestions bit(1) true Whether a kill question failed in the evaluation
comments text true Evaluation Question Group Comments
updated timestamp without time zone true Date Row Updated (UTC)
evaluationformid varchar(50) true Evaluation form GUID; first part of questiongroupfactkey

Referenced Tables

Name Columns Comment Type
public.evalquestiongroupdata 16 Evaluation Question Group Detailed Data BASE TABLE

    • Related Articles

    • README

      Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...

    • public.evalquestiondata

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

    • public.participantattributesdynamic

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

    • public.hoursblockdata

      Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false userid varchar(50) true startdate timestamp without time zone true startdateltc timestamp without time zone true enddate timestamp without time zone true enddateltc ...

    • public.userinteractionpresencedetaileddata

      Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false userid varchar(50) true starttime timestamp without time zone false starttimeltc timestamp without time zone true endtime timestamp without time zone true endtimeltc ...