RB_RULE_PATR_VW (SQL View)	Index Back
Attr Actions view - elig. rule View used for getting products for attribute actions section in Eligibility Rule

RB_RULE_PATR_VW

(SQL View)

Attr Actions view - elig. rule

View used for getting products for attribute actions section in Eligibility Rule

SELECT DISTINCT SETID , RULE_ID , PRODUCT_ID , ATTR_GRP_MARKET FROM PS_RB_RULE_ATR_TBL

# 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
Prompt Table: RB_CPRD_MLPB_VW

4 ATTR_GRP_MARKET Character(3) VARCHAR2(3) NOT NULL Used in the Object Type Attributes page
Prompt Table: RB_MARKET_VW

#	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 Prompt Table: RB_CPRD_MLPB_VW
4	ATTR_GRP_MARKET	Character(3)	VARCHAR2(3) NOT NULL	Used in the Object Type Attributes page Prompt Table: RB_MARKET_VW