SETIDDefault Value: SHARE
Prompt Table: SP_SETID_NONVW
FORM_IDDefault Value: NEXT
PRODUCT_IDCAT_CHANNEL01=Internal
02=Web Self-Service
03=All Channels
RBF_FORM_PROD_V(SQL View) |
Index Back |
|---|---|
Retrieve AppForm - ProductRetrieve AppForm - Product |
| SELECT A.SETID , A.FORM_ID , B.PRODUCT_ID , B.CAT_CHANNEL FROM PS_RBF_APPFORM_HDR A ,PS_RBF_PROD_APPL B WHERE A.SETID = B.SETID AND A.FORM_ID = B.FORM_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.
Default Value: SHARE Prompt Table: SP_SETID_NONVW |
| 2 | FORM_ID |
Character(15) | VARCHAR2(15) NOT NULL |
The unique identifier of App form
Default Value: NEXT |
| 3 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 4 | CAT_CHANNEL |
Character(2) | VARCHAR2(2) NOT NULL |
Channel
01=Internal 02=Web Self-Service 03=All Channels |