BUSINESS_UNITPrompt Table: BUS_UNIT_TBL_SP
VENDOR_IDPrompt Table: SPR_SUPPLR_DIM
SPF_SCORE_RULE_IDPrompt Table: SPB_SUP_SCR_DFN
SPF_PERF_METRICPrompt Table: SPB_METRIC_DFN
Prompt Table: SPB_LVL_CD_DFN
SPB_SCR_R_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_SP |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: SPR_SUPPLR_DIM |
| 3 | SPF_SCORE_RULE_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Scoring Rule
Prompt Table: SPB_SUP_SCR_DFN |
| 4 | SPF_PERF_METRIC |
Character(32) | VARCHAR2(32) NOT NULL |
Performance Metric
Prompt Table: SPB_METRIC_DFN |
| 5 | SPF_LEVEL_CODE | Character(15) | VARCHAR2(15) NOT NULL |
Performance Level Code
Prompt Table: SPB_LVL_CD_DFN |
| 6 | SPB_SUP_PERF_LEVEL | Number(1,0) | SMALLINT NOT NULL | Performance Level |
| 7 | SPB_METRIC_RESULT | Signed Number(33,2) | DECIMAL(31,2) NOT NULL | Metric Result |
| 8 | SPB_METRIC_SCORE | Number(8,2) | DECIMAL(7,2) NOT NULL | Metric Score |