Evaluation Question Group Detailed Data
CREATE VIEW vwevalquestiongroupdata AS (
SELECT concat(egd.evaluationformid, '|', egd.questiongroupid) 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
FROM evalquestiongroupdata egd
)| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| questiongroupfactkey | text | true | ||||
| keyid | varchar(50) | true | Primary Key | |||
| evaluationid | varchar(50) | true | Evaluation GUID | |||
| questiongroupid | varchar(50) | true | Evaluation Question Group Comments | |||
| totalscore | numeric(20,2) | true | Evaluation Question Group Total Score | |||
| maxtotalscore | numeric(20,2) | true | Evaluation Question Group Max Total Score | |||
| 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 | Evaluation Question Group Falled Kill Questions | |||
| comments | text | true | Evaluation Question Group Comments | |||
| updated | timestamp without time zone | true | Date Row Updated (UTC) |
| Name | Columns | Comment | Type |
|---|---|---|---|
| public.evalquestiongroupdata | 16 | Evaluation Question Group Detailed Data | BASE TABLE |