SCD_DEVR_SCT_VW

(SQL View)
 Index Back

Evaluator Section Result

Drill-down for Evaluator Section Result

SELECT A.SCD_EVALUATION_ID ,A.SCD_SECTION_ID ,A.SCD_QUESTION_ID ,A.SCD_EVALUATOR_ID ,C.SCD_SEQ_NBR ,C.SCD_QUESTION_TEXT ,A.SCD_SCORE , ( CASE WHEN B.SCD_AVG_SCORE IS NULL THEN 0 ELSE B.SCD_AVG_SCORE END ) AS SCD_AVG_SCORE ,C.SCD_WEIGHT ,C.SCD_WGT_SECT_SCORE , ( CASE WHEN B.SCD_AVGWGT_SCT_SCR IS NULL THEN 0 ELSE B.SCD_AVGWGT_SCT_SCR END ) AS SCD_AVGWGT_SCT_SCR ,C.SCD_EVAL_WEIGHT ,A.SCD_WGT_OVER_SCORE , ( CASE WHEN B.SCD_AVGWGT_OVR_SCR IS NULL THEN 0 ELSE B.SCD_AVGWGT_OVR_SCR END ) AS SCD_AVGWGT_OVR_SCR , ( CASE WHEN A.SCD_RATING_VALUE < 0 THEN 'N' ELSE D.SELECT_FLAG END ) SELECT_FLAG FROM PS_SCD_USREVAL_QST A INNER JOIN PS_SCD_BLD_SCT_QST C ON A.SCD_EVALUATION_ID=C.SCD_EVALUATION_ID AND A.SCD_SECTION_ID=C.SCD_SECTION_ID AND A.SCD_QUESTION_ID = C.SCD_QUESTION_ID INNER JOIN PS_SCD_USREVAL_SCT D ON D.SCD_EVALUATION_ID = A.SCD_EVALUATION_ID AND D.SCD_SECTION_ID = A.SCD_SECTION_ID AND D.SCD_EVALUATOR_ID = A.SCD_EVALUATOR_ID LEFT JOIN ( SELECT UQ.SCD_EVALUATION_ID ,UQ.SCD_SECTION_ID ,UQ.SCD_QUESTION_ID ,AVG(UQ.SCD_SCORE) AS SCD_AVG_SCORE ,AVG(UQ.SCD_WGT_SECT_SCORE) AS SCD_AVGWGT_SCT_SCR ,AVG(UQ.SCD_WGT_OVER_SCORE) SCD_AVGWGT_OVR_SCR FROM PS_SCD_USREVAL_SCT US INNER JOIN PS_SCD_USR_EVAL_HD UH ON US.SCD_EVALUATION_ID = UH.SCD_EVALUATION_ID AND US.SCD_EVALUATOR_ID = UH.SCD_EVALUATOR_ID INNER JOIN PS_SCD_USREVAL_QST UQ ON UQ.SCD_EVALUATION_ID = US.SCD_EVALUATION_ID AND UQ.SCD_EVALUATOR_ID = US.SCD_EVALUATOR_ID AND UQ.SCD_SECTION_ID = US.SCD_SECTION_ID WHERE UH.SCD_RESP_STATUS = 'SU' AND US.SELECT_FLAG = 'Y' AND UQ.SCD_RATING_VALUE >= 0 GROUP BY UQ.SCD_EVALUATION_ID ,UQ.SCD_SECTION_ID ,UQ.SCD_QUESTION_ID ) B ON A.SCD_EVALUATION_ID = B.SCD_EVALUATION_ID AND A.SCD_SECTION_ID = B.SCD_SECTION_ID AND A.SCD_QUESTION_ID = B.SCD_QUESTION_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCD_EVALUATION_ID Character(10) VARCHAR2(10) NOT NULL Evaluation ID
2 SCD_SECTION_ID Character(10) VARCHAR2(10) NOT NULL Section ID
3 SCD_QUESTION_ID Character(10) VARCHAR2(10) NOT NULL Question ID
4 SCD_EVALUATOR_ID Character(30) VARCHAR2(30) NOT NULL Evaluator ID
5 SCD_SEQ_NBR Number(5,0) INTEGER NOT NULL Sequence Number
6 SCD_QUESTION_TEXT Character(254) VARCHAR2(254) NOT NULL Question Text
7 SCD_SCORE Signed Number(11,6) DECIMAL(9,6) NOT NULL Scorecarding Score
8 SCD_AVG_SCORE Signed Number(11,6) DECIMAL(9,6) NOT NULL Average Score
9 SCD_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Weight
10 SCD_WGT_SECT_SCORE Signed Number(11,6) DECIMAL(9,6) NOT NULL Weighted Section Score
11 SCD_AVGWGT_SCT_SCR Signed Number(11,6) DECIMAL(9,6) NOT NULL Average Section Score
12 SCD_EVAL_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Evaluation Weight
13 SCD_WGT_OVER_SCORE Signed Number(11,6) DECIMAL(9,6) NOT NULL Weighted Overall Score
14 SCD_AVGWGT_OVR_SCR Signed Number(11,6) DECIMAL(9,6) NOT NULL Average Score
15 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
N=No
Y=Yes