RBF_REGION_VW(SQL View) |
Index Back |
|---|
| SELECT a.SETID , a.PRODUCT_ID , b.REGION_ID , a.PROD_REGION_FLAG , b.START_DT , b.END_DT FROM PS_PROD_ITEM a , PS_PROD_REGION b WHERE a.SETID = b.SETID AND a.PRODUCT_ID = b.PRODUCT_ID AND a.MARKET = b.MARKET AND a.MARKET = 'FIN' AND b.REGION_CATEGORY = 'PROD' |
| # | 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_NONVW |
| 2 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 3 | REGION_ID | Character(15) | VARCHAR2(15) NOT NULL | This field stores the region id value. |
| 4 | PROD_REGION_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Product Region Flag for PROD_ITEM
A=All Regions E=All except Regions below I=Only in Regions below |
| 5 | START_DT | Date(10) | DATE | Start date field to store start date value. |
| 6 | END_DT | Date(10) | DATE | This field stores the end date values. |