RC_SOLPRDSRH_VW(SQL View) |
Index Back |
---|---|
Solutions by ProductThis 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 |