FORECAST_ID_SUPPOOL_IDPrompt Table: RS_RES_POOL
RS_SUP_POOL_VW(SQL View) |
Index Back |
|---|---|
Supply Forecast Pool ViewThis is the Supply Forecast Pool View |
| SELECT DISTINCT FORECAST_ID_SUP , POOL_ID ,DESCR254 FROM PS_RS_FR_SUP_SM_WK WHERE PROJ_ROLE='BLANKPOOL' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FORECAST_ID_SUP |
Character(15) | VARCHAR2(15) NOT NULL | Supply Forecast ID |
| 2 | POOL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Pool ID field. |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL |
Description of length 254
Prompt Table: RS_RES_POOL |