RB_MLPB_RUL2_VW

(SQL View)
 Index Back

Multilevel Rules

Union of different rule types from various MLPB rule tables for use in other views.

SELECT FAS.SETID SETID , FAS.RULE_ID AS RULE_ID , FAS.PRODUCT_ID AS PRODUCT_ID FROM PS_RB_RULE_FAS_TBL FAS UNION SELECT PRG.SETID , PRG.RULE_ID , PRG.PRODUCT_ID FROM PS_RB_RULE_PRG_TBL PRG UNION SELECT ARR.SETID , ARR.RULE_ID , ARR.PRODUCT_ID FROM PS_RB_ATTR_ARR_TBL ARR UNION SELECT RARR.SETID , RARR.RULE_ID , RARR.PRODUCT_ID FROM PS_RB_RULE_ARR_TBL RARR UNION SELECT ERA.SETID , ERA.RULE_ID , ERA.PRODUCT_ID FROM PS_RB_RULE_ERA_TBL ERA UNION SELECT ATR.SETID , ATR.RULE_ID , ATR.PRODUCT_ID FROM PS_RB_RULE_ATR_TBL ATR UNION SELECT BRN.SETID , BRN.RULE_ID , BRN.PRODUCT_ID FROM PS_RB_RULE_BRN_TBL BRN UNION SELECT PRD.SETID , PRD.RULE_ID , PRD.PRODUCT_ID_ALT FROM PS_RB_RULE_PRD_TBL PRD UNION SELECT DDFN.SETID , DDFN.RULE_ID , ' ' FROM PS_RB_RULE_DFN_TBL DDFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
2 RULE_ID Character(8) VARCHAR2(8) NOT NULL Field used for storing rule id information
3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID