SCD_KPI_SMHS_VW

(SQL View)
 Index Back

SCD Score Model Mapping Def

Scorecarding Scoring Model Mapping Header Snapshot

SELECT A.SCD_EVALUATION_ID , A.SCD_KPI_DEF_ID ,A.SCD_RATIN_MODEL_ID ,B.SCD_DESCR45 , A.SCD_KPI_RNG_HI_OPR ,A.SCD_KPI_RNG_LO_OPR , A.SCD_KPI_MAP_DIR , A.SCD_KPI_VAL_RNG_HI ,A.SCD_KPI_VAL_RNG_LO FROM %Table(SCD_KPIEVMAP_HD) A INNER JOIN %Table(SCD_RATINMODELS) B ON A.SCD_RATIN_MODEL_ID=B.SCD_RATIN_MODEL_ID WHERE A.SCD_KPI_MAP_METHOD='S'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCD_EVALUATION_ID Character(10) VARCHAR2(10) NOT NULL Evaluation ID
2 SCD_KPI_DEF_ID Character(10) VARCHAR2(10) NOT NULL KPI ID
3 SCD_RATIN_MODEL_ID Character(10) VARCHAR2(10) NOT NULL Rating Model ID
4 SCD_DESCR45 Character(45) VARCHAR2(45) NOT NULL 45 Character Description
5 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

6 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

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

Default Value: LH

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