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)

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.mvwevaluationquestiondata
Description Materialized view for evaluation question data Table Definition CREATE MATERIALIZED VIEW mvwevaluationquestiondata AS ( SELECT DISTINCT eq.keyid, eq.evaluationid, eq.questionid, eq.answerid, eq.score, ed.questionanswervalue, eq.markedna, ...
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.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, ...
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 ...