RBF_PROD_APP_VW(SQL View) |
Index Back |
|---|
| SELECT P.SETID , P.PRODUCT_ID , P.CFG_KIT_FLAG , P.CP_TREE_DIST , PA.CAT_CHANNEL , PA.APPL_TYPE , PA.SCRIPT_ID , PA.FORM_ID , PA.URL FROM PS_PROD_ITEM P , PS_RBF_PROD_APPL PA WHERE P.SETID = PA.SETID (+) AND P.PRODUCT_ID = PA.PRODUCT_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 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 3 | CFG_KIT_FLAG |
Character(1) | VARCHAR2(1) NOT NULL |
Configured Kit Package
M=Multilevel Bundle Component N=Lightly Configured Y=Schema Enabled |
| 4 | CP_TREE_DIST |
Character(18) | VARCHAR2(18) NOT NULL | Distribution Model Field |
| 5 | CAT_CHANNEL |
Character(2) | VARCHAR2(2) NOT NULL |
Channel
01=Internal 02=Web Self-Service 03=All Channels |
| 6 | APPL_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Application Type
APPL=Application Form BRSC=Branch Script URL=URL |
| 7 | SCRIPT_ID | Number(12,0) | DECIMAL(12) NOT NULL |
Script ID
Prompt Table: RBF_BSCRIPT_VW |
| 8 | FORM_ID | Character(15) | VARCHAR2(15) NOT NULL |
The unique identifier of App form
Prompt Table: RBF_APPFORM_HDR |
| 9 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |