SCD_KPI_MAP_HDR

(SQL Table)
 Index Back

Scorecarding Score Mapping Def

Scorecarding Score Mapping Definition

  • Parent Record Of SCD_KPI_MAP_DTL

    • # 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_KPI_MAP_METHOD Character(1) VARCHAR2(1) NOT NULL KPI Mapping Method
    A=Actual
    L=Linear
    S=Scoring Model
    U=User Defined
    3 SCD_RATIN_MODEL_ID Character(10) VARCHAR2(10) NOT NULL Rating Model ID
    4 SCD_KPI_RNG_HI_OPR Character(2) VARCHAR2(2) NOT NULL KPI Highest Value
    EQ=Equal To
    GE=Greater Than or Equal To
    GT=Greater Than

    Default Value: EQ

    5 SCD_KPI_RNG_LO_OPR Character(2) VARCHAR2(2) NOT NULL KPI Lowest Value
    EQ=Equal To
    LE=Less Than or Equal To
    LT=Less Than

    Default Value: EQ

    6 SCD_KPI_MAP_DIR Character(2) VARCHAR2(2) NOT NULL Mapping Direction
    HL=High to Low
    LH=Low to High

    Default Value: LH

    7 SCD_KPI_VAL_RNG_HI Signed Number(10,3) DECIMAL(8,3) NOT NULL KPI Highest Value
    8 SCD_KPI_VAL_RNG_LO Signed Number(10,3) DECIMAL(8,3) NOT NULL Bottom of Range