BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_SP_NONVW
VENDOR_IDPrompt Table: SPR_SUPPLR_DIM
SPF_SCORE_RULE_IDPrompt Table: SPB_SUP_SCR_DFN
SPB_SCR_R_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT a.BUSINESS_UNIT ,a.VENDOR_ID ,a.SPF_SCORE_RULE_ID ,CAST (%Round(%DecMult(%DecDiv(sum(a.SPB_METRIC_SCORE),b.SPF_METRIC_WEIGHT),100) ,2) AS DEC(4,2)) FROM PS_SPB_SCR_R_TBL a , PS_SPB_SCR_R_VW2 b WHERE a.BUSINESS_UNIT = b.BUSINESS_UNIT AND a.SPF_SCORE_RULE_ID= b.SPF_SCORE_RULE_ID GROUP BY a.BUSINESS_UNIT ,a.VENDOR_ID ,a.SPF_SCORE_RULE_ID,b.SPF_METRIC_WEIGHT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_SP_NONVW |
| 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 | SP_SCORE | Number(7,2) | DECIMAL(6,2) NOT NULL | Score |