public.evaldetails

Description

Evaluation Lookup Data

Name	Type	Nullable	Comment
id	varchar(200)	false	Primary Key
evaluationid	varchar(50)	true	Evaluation Form GUID (Historical column name - this actually contains the form ID, not the evaluation ID)
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
questiongrouptohighest	bit(1)	true	Question Group To Highest (True/False)
questiongrouptona	bit(1)	true	Question Group Not Applicable (True/False)
questiongroupwieght	numeric(20,2)	true	Question Group Wieght
questiongroupmanwieght	bit(1)	true	Question Group Man Weight
questionid	varchar(50)	true	Question Answer Value
questiontext	varchar(400)	true	Question Text
questionhelptext	text	true	Question Help Text
quesiontype	varchar(50)	true	Question Type
questionnaenabled	bit(1)	true	Question Enabled (True/False)
questioncommentsreq	bit(1)	true	Question Comments Required (True/False
questioniskill	bit(1)	true	Question Is a Kill Question (True/False)
questioniscritical	bit(1)	true
questionanwserid	varchar(50)	true	Question Answer GUID
questionanswertext	varchar(200)	true	Question Answer Text
questionanswervalue	numeric(20,2)	true	Question Value
updated	timestamp without time zone	true	Date Row Updated (UTC)

Name	Type	Definition
evaldetails_pkey	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
evaldetails_pkey	CREATE UNIQUE INDEX evaldetails_pkey ON public.evaldetails USING btree (id)
evaldetailsformsid	CREATE INDEX evaldetailsformsid ON public.evaldetails USING btree (evaluationformid)
evaldetails_questiongroupid_idx	CREATE INDEX evaldetails_questiongroupid_idx ON public.evaldetails USING btree (questiongroupid)
evaldetails_composite_idx	CREATE INDEX evaldetails_composite_idx ON public.evaldetails USING btree (evaluationformid, questiongroupid, questionid, questionanwserid)

Related Articles
public.vwevaldetails
Description See EvalDetails- Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwevaldetails AS ( SELECT evaldetails.id, evaldetails.evaluationid, evaldetails.evaluationformid, evaldetails.evaluationname, ...
public.vwevaluationgroupdata
Description View for evaluation group data (converted from table) Table Definition CREATE VIEW vwevaluationgroupdata AS ( SELECT egd.keyid, egd.evaluationid, egd.questiongroupid, ( SELECT ed.questiongroupname FROM evaldetails ed WHERE ...
public.vwevaldata
Description See Evaluation Data Table Definition CREATE VIEW vwevaldata AS ( SELECT DISTINCT ed.keyid, ed.agenthasread, ed.assigneddate, ed.assigneddateltc, ed.conversationid, ed.evaluationformid, ed.evaluationid, ed.evaluatorid, ed.releasedate, ...
public.vwevaluationquestiondata
Description View for evaluation question data (converted from materialized view) Table Definition CREATE VIEW vwevaluationquestiondata AS ( SELECT DISTINCT eq.keyid, eq.evaluationid, eq.questionid, eq.answerid, eq.score, ed.questionanswervalue, ...
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, ...