BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_SP_NONVW
SPF_SCORE_RULE_IDPrompt Table: SPB_SUP_SCR_DFN
SPB_SCR_R_VW2(SQL View) |
Index Back |
|---|
| SELECT u.BUSINESS_UNIT ,b.SPF_SCORE_RULE_ID ,SUM(b.SPF_METRIC_WEIGHT) FROM PS_SPB_SUP_SCR_SEQ b , PS_SET_CNTRL_GROUP s , PS_BUS_UNIT_TBL_SP u WHERE s.REC_GROUP_ID = 'SP_09' AND s.SETID = b.SETID AND b.SPF_METRIC_WEIGHT > 0 AND s.SETCNTRLVALUE = u.BUSINESS_UNIT AND b.EFFDT = ( SELECT MAX(b_s.EFFDT) FROM PS_SPB_SUP_SCR_SEQ b_s WHERE b.SETID = b_s.SETID AND b.SPF_SCORE_RULE_ID= b_s.SPF_SCORE_RULE_ID AND b_s.EFFDT <= %CurrentDateIn) GROUP BY u.BUSINESS_UNIT ,b.SPF_SCORE_RULE_ID |
| # | 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 | SPF_SCORE_RULE_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Scoring Rule
Prompt Table: SPB_SUP_SCR_DFN |
| 3 | SPF_METRIC_WEIGHT | Signed Number(4,0) | DECIMAL(3) NOT NULL | Metric Weight |