RPC_ATTR_ITEMVW (SQL View)	Index Back
Restr. rules drop down items View used to retreive attribute drop down itmes information for attribute restriction rules

RPC_ATTR_ITEMVW

(SQL View)

Restr. rules drop down items

View used to retreive attribute drop down itmes information for attribute restriction rules

SELECT a.SETID , a.RULE_ID , a.UNIQUE_ID , a.ATTR_ITEM_ID , a.IS_DEFAULT FROM PS_RB_ITEM_ARR_TBL a WHERE EXISTS ( SELECT 1 FROM PS_RPC_ATTR_RULE b WHERE a.SETID = b.SETID AND a.RULE_ID = b.RULE_ID)

# 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 UNIQUE_ID Character(20) VARCHAR2(20) NOT NULL Unique_Id

4 ATTR_ITEM_ID Character(15) VARCHAR2(15) NOT NULL Attribute Item ID

5 IS_DEFAULT Character(1) VARCHAR2(1) NOT NULL Default Template
N=No
Y=Yes

#	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	UNIQUE_ID	Character(20)	VARCHAR2(20) NOT NULL	Unique_Id
4	ATTR_ITEM_ID	Character(15)	VARCHAR2(15) NOT NULL	Attribute Item ID
5	IS_DEFAULT	Character(1)	VARCHAR2(1) NOT NULL	Default Template N=No Y=Yes