SCD_DRDN_SCT_VW(SQL View) |
Index Back |
|---|
| SELECT A.SCD_EVALUATION_ID ,A.SCD_EVALUATOR_ID ,A.SCD_SECTION_ID ,C.SCD_SECTION_NAME ,C.SCD_SEQ_NBR ,A.SCD_SCORE ,C.SCD_WEIGHT ,A.SCD_WGT_OVER_SCORE ,CASE WHEN B.SCD_AVG_SCORE IS NULL THEN 0 ELSE B.SCD_AVG_SCORE END AS SCD_AVG_SCORE ,CASE WHEN B.SCD_AVG_WGT_OVER_SCORE IS NULL THEN 0 ELSE B.SCD_AVG_WGT_OVER_SCORE END AS SCD_AVG_WGT_OVER_SCORE ,A.SELECT_FLAG FROM PS_SCD_BLD_SECTS C INNER JOIN PS_SCD_USREVAL_SCT A ON C.SCD_EVALUATION_ID=A.SCD_EVALUATION_ID AND C.SCD_SECTION_ID=A.SCD_SECTION_ID LEFT JOIN ( SELECT US.SCD_EVALUATION_ID ,US.SCD_SECTION_ID ,AVG(US.SCD_SCORE) AS SCD_AVG_SCORE ,AVG(US.SCD_WGT_OVER_SCORE) SCD_AVG_WGT_OVER_SCORE 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 WHERE UH.SCD_RESP_STATUS = 'SU' AND US.SELECT_FLAG = 'Y' AND EXISTS ( SELECT 'x' FROM PS_SCD_USREVAL_QST Q WHERE Q.SCD_EVALUATION_ID = US.SCD_EVALUATION_ID AND Q.SCD_SECTION_ID = US.SCD_SECTION_ID AND Q.SCD_EVALUATOR_ID = US.SCD_EVALUATOR_ID AND Q.SCD_RATING_VALUE >= 0 ) GROUP BY US.SCD_EVALUATION_ID ,US.SCD_SECTION_ID ) B ON A.SCD_EVALUATION_ID = B.SCD_EVALUATION_ID AND A.SCD_SECTION_ID = B.SCD_SECTION_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_EVALUATOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Evaluator ID |
| 3 | SCD_SECTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Section ID |
| 4 | SCD_SECTION_NAME | Character(30) | VARCHAR2(30) NOT NULL | Section Name |
| 5 | SCD_SEQ_NBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 6 | SCD_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Scorecarding Score |
| 7 | SCD_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Weight |
| 8 | SCD_WGT_OVER_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Weighted Overall Score |
| 9 | SCD_AVG_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Average Score |
| 10 | SCD_AVGWGT_SCT_SCR | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Average Section Score |
| 11 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes |