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.

RC_SOLPRDSRH_VW

(SQL View)

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

#	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