RPC_ATTR_RESTVW

(SQL View)
Index Back

Restr. rules product Info.

View used to retreive product information for attribute restriction rules

SELECT a.SETID , a.RULE_ID , a.PRODUCT_ID , a.UNIQUE_ID , a.PRODUCT_ID_RESTR , a.RULE_SCOPE , a.ATTR_GRP_MARKET , a.ATTRIBUTE_ID , a.IS_REQUIRED , a.RULE_EXPRESSION , a.ATTR_DEFAULT_VAL FROM PS_RB_ATTR_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 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
4 UNIQUE_ID Character(20) VARCHAR2(20) NOT NULL Unique_Id
5 PRODUCT_ID_RESTR Character(18) VARCHAR2(18) NOT NULL Restricted od restricting Product ID
6 RULE_SCOPE Character(4) VARCHAR2(4) NOT NULL Field used for storing rule scope information
CNTR=Contract
DPAR=Direct Parent
EXTS=External Service
INST=Instance
OCNT=Other Contract
OCST=Other Customer
PLAY=Play
SCST=Same Customer
7 MARKET Character(3) VARCHAR2(3) NOT NULL Market
8 ATTRIBUTE_ID Character(15) VARCHAR2(15) NOT NULL Attribute Label, Name or Properties
9 IS_REQUIRED Character(1) VARCHAR2(1) NOT NULL IS_REQUIRED
10 RULE_EXPRESSION Character(254) VARCHAR2(254) NOT NULL Field used for storing Rule Expression
11 ATTR_DEFAULT_VAL Character(254) VARCHAR2(254) NOT NULL Attribute default value