RY_SVY_E_QAW_VW

(SQL View)
 Index Back

EE Element Question Answer

Element Question Answer value ratings view. Used for Score Bracketing. Ordered by Element ID

SELECT A.DIALOG_ID , A.RY_MD_ID , CASE WHEN B.RY_MD_ELEM_ID > 0 THEN B.RY_MD_ELEM_ID ELSE 0 END , B.RY_ELEM_TYPE , C.RY_QUESTION_WEIGHT , C.RY_ELEM_WEIGHT_Y , C.RY_ELEM_WEIGHT_N , D.RY_ANSWER_WEIGHT FROM PS_RYEDOC A LEFT OUTER JOIN PS_RYEMDATA_ELEM B ON A.RY_MD_ID = B.RY_MD_ID AND B.RY_ELEM_TYPE IN ('Single Choice' , 'Rating Choice' , 'Multiple Choice' , 'Boolean') LEFT OUTER JOIN PS_RYEDOC_ELEM_PR C ON B.RY_MD_ELEM_ID = C.RY_MD_ELEM_ID LEFT OUTER JOIN PS_RYEDOC_ELEM_CH D ON B.RY_MD_ELEM_ID = D.RY_MD_ELEM_ID WHERE B.RY_ELEM_TYPE > ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.
2 RY_MD_ID Number(18,0) DECIMAL(18) NOT NULL Metadata ID - Dialog document metadata table
3 RY_MD_ELEM_ID Number(18,0) DECIMAL(18) NOT NULL Metadata Element ID - Dialog Document
4 RY_ELEM_TYPE Character(20) VARCHAR2(20) NOT NULL Element Type - Dialog Document
5 RY_QUESTION_WEIGHT Signed Number(3,0) DECIMAL(2) NOT NULL Survey Document quesion weight
6 RY_ELEM_WEIGHT_Y Signed Number(3,0) DECIMAL(2) NOT NULL Weight value for booleam element Yes.
7 RY_ELEM_WEIGHT_N Signed Number(3,0) DECIMAL(2) NOT NULL Weight value for booleam element No.
8 RY_ANSWER_WEIGHT Signed Number(3,0) DECIMAL(2) NOT NULL Survey Document answer weight