PROBINSTCHANGE_REQUEST_IDBUSINESS_UNITRG_FWD_SCHD_VW(SQL View) |
Index Back |
|---|---|
Forward Schedule of ChangesView used to find out all Change Requests with Start and End Date in a specified date range. |
| SELECT D.PROBINST , A.CHANGE_REQUEST_ID , A.BUSINESS_UNIT , %DateOut(A.START_DT) , %DateOut(A.END_DT) , B.BSE_TIMEZONE , A.RG_SUMMARY , %TimeOut(A.END_TIME) , %TimeOut(A.START_TIME) , A.RG_STATUS_DESCR , A.PHASE_DESCR , A.REQUEST_TYPE_DESCR , A.RG_PRIORITY_DESCR , A.RG_CATEGORY_DESCR , A.RG_IMPACT_DESCR , A.OUTAGE , A.BO_NAME_DISPLAY , A.INTERESTED_PARTIES , A.BO_NAME_DISPLAY_2 , %DateOut(A.CLOSED_DATE) FROM PS_RG_FWD_SCHD_ACE A , PSOPTIONS B , PS_RG_BAM_RUN_CTL C , PS_RG_BAM_RUN_INST D WHERE A.UUID_RAW = D.UUID_RAW AND A.START_DT >= C.START_DATE AND A.END_DT <= C.END_DATE AND C.OPRID = D.OPRID AND C.RUN_CNTL_ID = D.RUN_CNTL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | CHANGE_REQUEST_ID |
Character(15) | VARCHAR2(15) NOT NULL | change request identification is key to change request |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | RG_START_TIME_STR | Character(30) | VARCHAR2(30) NOT NULL | Start Time String |
| 5 | RG_END_TIME_STR | Character(30) | VARCHAR2(30) NOT NULL | End Time String |
| 6 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
| 7 | RG_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Summary description of a Change Request |
| 8 | END_TIME_STR | Character(18) | VARCHAR2(18) NOT NULL | END_TIME |
| 9 | START_TIME_STR | Character(18) | VARCHAR2(18) NOT NULL | START_TIME |
| 10 | RG_STATUS_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Field used by Change Management for BAM reports. |
| 11 | PHASE_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Phase description |
| 12 | REQUEST_TYPE_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Change request type description |
| 13 | RG_PRIORITY_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Field used by Change Management for BAM reports. |
| 14 | RG_CATEGORY_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Field used by Change Management for BAM reports. |
| 15 | RG_IMPACT_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Field used for Change Management for BAM reports. |
| 16 | OUTAGE | Character(30) | VARCHAR2(30) NOT NULL | Outage required by a change request |
| 17 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 18 | INTERESTED_PARTIES | Character(254) | VARCHAR2(254) NOT NULL | Parties affected by a change request or interested in it. |
| 19 | BO_NAME_DISPLAY_2 | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 20 | PROD_RLSE_DATE | Character(30) | VARCHAR2(30) NOT NULL | Production Release Date |