SCD_EVALUATION_IDSCD_KPI_DEF_IDSCD_SEQ_NBREQ=Equal To
GE=Greater Than or Equal To
GT=Greater Than
EQ=Equal To
LE=Less Than or Equal To
LT=Less Than
SCD_KPIEVMAP_DT(SQL Table) |
Index Back |
|---|---|
Scorecarding Score Mapping DtlScorecarding Score Mapping Details |
| # | 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_SEQ_NBR |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | SCD_KPI_MAP_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Mapped KPI Score Value |
| 5 | 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 |
| 6 | SCD_KPI_VAL_FROM | Signed Number(10,3) | DECIMAL(8,3) NOT NULL | KPI Value From |
| 7 | 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 |
| 8 | SCD_KPI_VAL_TO | Signed Number(10,3) | DECIMAL(8,3) NOT NULL | KPI Value To |