SCD_KPIS_MPD_VW

(SQL View)
 Index Back

SCD Score Model Map Detail

Scorecarding KPI Scoring Model Mapping Details

SELECT A.SCD_KPI_DEF_ID ,C.SCD_RATIN_MODEL_ID ,A.SCD_SEQ_NBR ,C.SCD_RATING_TEXT ,A.SCD_KPI_MAP_SCORE ,A.SCD_KPI_VAL_FR_OPR ,A.SCD_KPI_VAL_FROM ,A.SCD_KPI_VAL_TO_OPR ,A.SCD_KPI_VAL_TO FROM %Table(SCD_KPI_MAP_DTL) A INNER JOIN %Table(SCD_KPI_MAP_HDR) B ON A.SCD_KPI_DEF_ID=B.SCD_KPI_DEF_ID INNER JOIN %Table(SCD_RATMOD_VALS) C ON B.SCD_RATIN_MODEL_ID=C.SCD_RATIN_MODEL_ID AND A.SCD_SEQ_NBR=C.SCD_SEQ_NBR WHERE B.SCD_KPI_MAP_METHOD='S'

  • Related Language Record: SCD_KPISMMP_LNV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCD_KPI_DEF_ID Character(10) VARCHAR2(10) NOT NULL KPI 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_KPI_VAL_FR_OPR Character(2) VARCHAR2(2) NOT NULL KPI Value From
    EQ=Equal To
    GE=Greater Than or Equal To
    GT=Greater Than
    7 SCD_KPI_VAL_FROM Signed Number(10,3) DECIMAL(8,3) NOT NULL KPI Value From
    8 SCD_KPI_VAL_TO_OPR Character(2) VARCHAR2(2) NOT NULL KPI Value To
    EQ=Equal To
    LE=Less Than or Equal To
    LT=Less Than
    9 SCD_KPI_VAL_TO Signed Number(10,3) DECIMAL(8,3) NOT NULL KPI Value To