SCD_SECRM_VW

(SQL View)
 Index Back

Section Rating Models

Use to populate SCD_BLDEV_RATNG table

SELECT DISTINCT A.SCD_EVALUATION_ID , A.SCD_RATIN_MODEL_ID , B.SCD_SEQ_NBR , B.SCD_RATING_TEXT , B.SCD_RATING_VALUE , B.SCD_RATING_DESC FROM PS_SCD_BLD_SECTS A , PS_SCD_RATMOD_VALS B WHERE A.SCD_SECT_TYPE IN('S' ,'C') AND A.SCD_RATIN_MODEL_ID = B.SCD_RATIN_MODEL_ID UNION SELECT DISTINCT A.SCD_EVALUATION_ID , C.SCD_RATIN_MODEL_ID , D.SCD_SEQ_NBR , D.SCD_RATING_TEXT , D.SCD_RATING_VALUE , D.SCD_RATING_DESC FROM PS_SCD_BLD_SCT_QST A ,PS_SCD_QUESTIONS B ,PS_SCD_KPI_MAP_HDR C ,PS_SCD_RATMOD_VALS D WHERE A.SCD_QUEST_TYPE = 'K' AND A.SCD_QUESTION_ID = B.SCD_QUESTION_ID AND B.SCD_KPI_DEF_ID = C.SCD_KPI_DEF_ID AND C.SCD_KPI_MAP_METHOD = 'S' AND C.SCD_RATIN_MODEL_ID = D.SCD_RATIN_MODEL_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_RATIN_MODEL_ID Character(10) VARCHAR2(10) NOT NULL Rating Model ID
3 SCD_SEQ_NBR Number(5,0) INTEGER NOT NULL Sequence Number
4 SCD_RATING_TEXT Character(18) VARCHAR2(18) NOT NULL Scoring Text
5 SCD_RATING_VALUE Signed Number(4,0) DECIMAL(3) NOT NULL Scoring Value
6 SCD_RATING_DESC Character(254) VARCHAR2(254) NOT NULL Rating Description