SCD_MNEV_QST_VW

(SQL View)
 Index Back

SELECT BSQ.SCD_EVALUATION_ID , BSQ.SCD_SECTION_ID , BSQ.SCD_QUESTION_ID , BSQ.SCD_SEQ_NBR , BSQ.SCD_TEMPLATE_ID , BSQ.SCD_VERSION_NBR , BSQ.SCD_QUESTION_TEXT AS SCD_QST_NAME , BSQ.SCD_WEIGHT , BSQ.SCD_EVAL_WEIGHT , BSQ.SCD_SCORE , BSQ.SCD_WGT_SECT_SCORE , BSQ.SCD_WGT_OVER_SCORE M , NATBL.IS_APPLICABLE AS SCD_APPLICABLE_FLG , BSQ.SCD_QUEST_TYPE , NATBL.SCD_RESP_STATUS || KPITBL.SCD_RESP_STATUS FROM PS_SCD_BLD_SCT_QST BSQ LEFT JOIN ( SELECT Q.SCD_EVALUATION_ID , Q.SCD_SECTION_ID , q.scd_question_id ,CASE SUM(CASE WHEN Q.SCD_RATING_VALUE = -1 THEN 0 ELSE 1 END) WHEN 0 THEN 'N' ELSE 'Y' END IS_APPLICABLE ,CASE SUM(CASE WHEN scd_resp_status ='SU' THEN 1 ELSE 0 END) WHEN 0 THEN 'NE' ELSE 'SU' END SCD_RESP_STATUS FROM PS_SCD_USREVAL_SCT S INNER JOIN PS_SCD_USR_EVAL_HD H ON S.SCD_EVALUATION_ID = H.SCD_EVALUATION_ID AND S.SCD_EVALUATOR_ID = H.SCD_EVALUATOR_ID INNER JOIN PS_SCD_USREVAL_QST Q ON S.SCD_EVALUATION_ID = Q.SCD_EVALUATION_ID AND S.SCD_EVALUATOR_ID = Q.SCD_EVALUATOR_ID AND S.SCD_SECTION_ID = Q.SCD_SECTION_ID WHERE H.SCD_RESP_STATUS = 'SU' GROUP BY Q.SCD_EVALUATION_ID, Q.SCD_SECTION_ID, q.scd_question_id) NATBL ON NATBL.SCD_EVALUATION_ID=BSQ.SCD_EVALUATION_ID AND NATBL.SCD_SECTION_ID=BSQ.SCD_SECTION_ID AND NATBL.SCD_QUESTION_ID=BSQ.SCD_QUESTION_ID LEFT JOIN ( SELECT scd_evaluation_id ,scd_section_id ,scd_question_id , 'SU' AS SCD_RESP_STATUS FROM ps_scd_kpieval_qst WHERE SCD_KPIACCP_UPDTTM IS NOT NULL) kpitbl ON kpitbl.SCD_EVALUATION_ID=BSQ.SCD_EVALUATION_ID AND kpitbl.SCD_SECTION_ID=BSQ.SCD_SECTION_ID AND kpitbl.SCD_QUESTION_ID=BSQ.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_SEQ_NBR Number(5,0) INTEGER NOT NULL Sequence Number
5 SCD_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID
6 SCD_VERSION_NBR Number(5,0) INTEGER NOT NULL Version Number
7 SCD_QUESTION_TEXT Character(254) VARCHAR2(254) NOT NULL Question Text
8 SCD_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Weight
9 SCD_EVAL_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Evaluation Weight
10 SCD_SCORE Signed Number(11,6) DECIMAL(9,6) NOT NULL Scorecarding Score
11 SCD_WGT_SECT_SCORE Signed Number(11,6) DECIMAL(9,6) NOT NULL Weighted Section Score
12 SCD_WGT_OVER_SCORE Signed Number(11,6) DECIMAL(9,6) NOT NULL Weighted Overall Score
13 SCD_APPLICABLE_FLG Character(1) VARCHAR2(1) NOT NULL Not Applicable
14 SCD_QUEST_TYPE Character(2) VARCHAR2(2) NOT NULL Question Type
K=KPI
S=Subjective
15 SCD_RESP_STATUS Character(2) VARCHAR2(2) NOT NULL Evaluation Build Status
AL=All
DE=Declined
IP=In Process
NE=New
OM=Omitted
PE=Pending
SU=Submitted