SCD_KPISMMP_LNV

(SQL View)
 Index Back

SCD KPI Score Model Map Dtl Ln

SCD KPI Score Model Mapping Details Language

SELECT A.SCD_KPI_DEF_ID , C.LANGUAGE_CD , C.SCD_RATING_TEXT FROM %Table(SCD_KPI_MAP_HDR) A INNER JOIN %Table(SCD_KPI_MAP_DTL) B ON A.SCD_KPI_DEF_ID=B.SCD_KPI_DEF_ID INNER JOIN %Table(SCD_RM_VALS_LNG) C ON A.SCD_RATIN_MODEL_ID=C.SCD_RATIN_MODEL_ID AND B.SCD_SEQ_NBR=C.SCD_SEQ_NBR WHERE A.SCD_KPI_MAP_METHOD='S'

  • Related Language Record for SCD_KPIS_MPD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCD_KPI_DEF_ID Character(10) VARCHAR2(10) NOT NULL KPI ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 SCD_RATING_TEXT Character(18) VARCHAR2(18) NOT NULL Scoring Text