RC_SOLPRDSRH_VW

(SQL View)
Index Back

Solutions by Product

This is used as a search record for solutions by product pagelet. There are purposely no key fields so that the Tools search can always be bypassed and the pagelet will display without ever seeing the Tools search.

SELECT SETID , PRODUCT_ID , DESCR FROM PS_PROD_ITEM

# 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.

Prompt Table: SP_SETID_OPRVW

2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: RC_PROD_VW

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description