PROBINSTPL_PI_DATES_VW(SQL View) |
Index Back |
|---|---|
Dates by ProbinstNeeded to get to the date fields without having bu_group as a key. Feel free to add more dates if you need this as well. |
| SELECT PROBINST , CURRENT_DTTM , START_DATE , END_DATE , EARLY_DATE , LATE_DATE , CAPACITY_DATE FROM PS_PL_PROBINST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | CURRENT_DTTM | DateTime(26) | TIMESTAMP | 08/27/01 EGS (CN#PL900-1.0): Added |
| 3 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 4 | END_DATE | Date(10) | DATE | End Date |
| 5 | EARLY_DATE | Date(10) | DATE | 08/31/01 EGS (CN#PL900-1): Added. |
| 6 | LATE_DATE | Date(10) | DATE | 08/31/01 EGS (CN#PL900-1): Added. |
| 7 | CAPACITY_DATE | Date(10) | DATE | 08/31/01 EGS (CN#PL900-1): Added. |