SCD_SECRM_LVW

(SQL View)
 Index Back

Lang Section Rating Models

Use to popiulate SCD_BLDEVRA_LNG

SELECT DISTINCT A.SCD_EVALUATION_ID , B.SCD_RATIN_MODEL_ID , A.LANGUAGE_CD , C.SCD_SEQ_NBR , C.SCD_RATING_TEXT , C.SCD_RATING_DESC FROM PS_SCD_BLDSCT_LNG A , PS_SCD_BLD_SECTS B ,PS_SCD_RM_VALS_LNG C WHERE B.SCD_SECT_TYPE IN('S' ,'C') AND A.SCD_EVALUATION_ID = B.SCD_EVALUATION_ID AND A.SCD_SECTION_ID = B.SCD_SECTION_ID AND B.SCD_RATIN_MODEL_ID = C.SCD_RATIN_MODEL_ID AND A.LANGUAGE_CD = C.LANGUAGE_CD UNION SELECT DISTINCT A.SCD_EVALUATION_ID , D.SCD_RATIN_MODEL_ID , A.LANGUAGE_CD , E.SCD_SEQ_NBR , E.SCD_RATING_TEXT , E.SCD_RATING_DESC FROM PS_SCD_BLDQST_LNG A ,PS_SCD_BLD_SCT_QST B ,PS_SCD_QUESTIONS C ,PS_SCD_KPI_MAP_HDR D ,PS_SCD_RM_VALS_LNG E WHERE 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 AND B.SCD_QUEST_TYPE = 'K' AND B.SCD_QUESTION_ID = C.SCD_QUESTION_ID AND C.SCD_KPI_DEF_ID = D.SCD_KPI_DEF_ID AND D.SCD_KPI_MAP_METHOD = 'S' AND D.SCD_RATIN_MODEL_ID = E.SCD_RATIN_MODEL_ID AND A.LANGUAGE_CD = E.LANGUAGE_CD

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 SCD_SEQ_NBR Number(5,0) INTEGER NOT NULL Sequence Number
5 SCD_RATING_TEXT Character(18) VARCHAR2(18) NOT NULL Scoring Text
6 SCD_RATING_DESC Character(254) VARCHAR2(254) NOT NULL Rating Description