SETIDPrompt Table: SP_SETID_NONVW
SPF_SCORE_RULE_IDEFFDTDefault Value: %date
SPF_PERF_METRICPrompt Table: SPB_METRIC_VW2
Prompt Table: SPB_LVL_CD_DFN
Default Value: 25
Default Value: 50
Default Value: 75
Default Value: 100
SPB_SUP_SCR_SEQ(SQL Table) |
Index Back |
|---|---|
Supplier Scoring Rule SeqSupplier Scoring Rule Seq |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | SPF_SCORE_RULE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Scoring Rule |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | SPF_PERF_METRIC |
Character(32) | VARCHAR2(32) NOT NULL |
Performance Metric
Prompt Table: SPB_METRIC_VW2 |
| 5 | SPF_LEVEL_CODE | Character(15) | VARCHAR2(15) NOT NULL |
Performance Level Code
Prompt Table: SPB_LVL_CD_DFN |
| 6 | SPF_METRIC_WEIGHT | Signed Number(4,0) | DECIMAL(3) NOT NULL | Metric Weight |
| 7 | SPF_LEVEL_1_PERC | Number(3,0) | SMALLINT NOT NULL |
Level 1 Percent
Default Value: 25 |
| 8 | SPF_LEVEL_2_PERC | Number(3,0) | SMALLINT NOT NULL |
Level 2 Percent
Default Value: 50 |
| 9 | SPF_LEVEL_3_PERC | Number(3,0) | SMALLINT NOT NULL |
Level 3 Percent
Default Value: 75 |
| 10 | SPF_LEVEL_4_PERC | Number(3,0) | SMALLINT NOT NULL |
Level Percentage
Default Value: 100 |