SCD_KPI_DEF_IDEQ=Equal To
GE=Greater Than or Equal To
GT=Greater Than
Default Value: EQ
EQ=Equal To
LE=Less Than or Equal To
LT=Less Than
Default Value: EQ
HL=High to Low
LH=Low to High
Default Value: LH
SCD_KPIS_MPH_VW(SQL View) |
Index Back |
|---|---|
SCD Score Model Mapping DefScorecarding Scoring Model Mapping Header |
| SELECT 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_KPI_MAP_HDR) 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_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_DESCR45 | Character(45) | VARCHAR2(45) NOT NULL | 45 Character Description |
| 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 |