One row per scored question group in an evaluation, with achieved and maximum group scores
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
)| 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 |
| Name | Columns | Comment | Type |
|---|---|---|---|
| public.evalquestiongroupdata | 16 | Evaluation Question Group Detailed Data | BASE TABLE |