CHANGE_REQUEST_IDBUSINESS_UNITRG_FWD_SCHED_VW(SQL View) |
Index Back |
|---|---|
Forward Schedule of ChangesView used to find out all Change Requests with Status of Approved or Executing. |
| SELECT CHANGE_REQUEST_ID , BUSINESS_UNIT , RG_SUMMARY , START_DT , START_TIME , END_DT , END_TIME , TIMEZONE FROM %Table(RG_CHANGE_REQST) WHERE CHANGE_STATUS IN ('APPR', 'EXEC') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CHANGE_REQUEST_ID |
Character(15) | VARCHAR2(15) NOT NULL | change request identification is key to change request |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | RG_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Summary description of a Change Request |
| 4 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 5 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 6 | END_DATE | Date(10) | DATE | End date field to store an end date. |
| 7 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 8 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |