RS_FR_SUP_SM_WK(SQL Table) |
Index Back |
|---|---|
Supply Summary work tableESA for IT: Supply Summary work table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FORECAST_ID_SUP | Character(15) | VARCHAR2(15) NOT NULL | Supply Forecast ID |
| 2 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 4 | POOL_ID | Character(10) | VARCHAR2(10) NOT NULL | Pool ID field. |
| 5 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 6 | LEVEL1 | Number(5,0) | INTEGER NOT NULL | Level 1 |
| 7 | LEVEL2 | Number(5,0) | INTEGER NOT NULL | Level 2 |
| 8 | CAPACITY | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | SCP- Forecasted Supply stored as capacity. |
| 9 | FULL_TIME_RES_SUP | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Full Time Resources |
| 10 | LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Level |
| 11 | DESCR_LONG | Character(254) | VARCHAR2(254) NOT NULL | Long Description |