RG_FWD_SCHD_ACE(SQL Table) |
Index Back |
|---|---|
Forward Schedule of ChangesOutput of FSC AE program, and it is used to create Forward Schedule of Changes interactive report. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  UUID_RAW |
Character(36) | VARCHAR2(36) NOT NULL | Universal Unique Identifier - can be used as an identifier when processing a batch of data. |
| 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 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 6 | RG_BU_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Field used by Change Management in BAM reports. |
| 7 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 8 | CHANGE_STATUS | Character(4) | VARCHAR2(4) NOT NULL | status of a Change Request in Change Management application |
| 9 | RG_STATUS_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Field used by Change Management for BAM reports. |
| 10 | RG_CHANGE_STATE | Character(4) | VARCHAR2(4) NOT NULL |
Change request change State / Phase
CANC=Canceled COMP=Complete DEV=Development HOLD=On Hold IMPL=Implementation PEND=Change Pending POST=Postmortem Review PROP=Proposed REJ=Rejected RETN=Return for More Information REVW=Review |
| 11 | PHASE_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Phase description |
| 12 | RG_REQUEST_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Change Management Type of Change Request. |
| 13 | REQUEST_TYPE_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Change request type description |
| 14 | RG_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Summary description of a Change Request |
| 15 | RG_PRIORITY | Character(4) | VARCHAR2(4) NOT NULL | change management |
| 16 | RG_PRIORITY_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Field used by Change Management for BAM reports. |
| 17 | RG_CATEGORY | Character(4) | VARCHAR2(4) NOT NULL | change management change Request Category |
| 18 | RG_CATEGORY_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Field used by Change Management for BAM reports. |
| 19 | RG_IMPACT | Character(4) | VARCHAR2(4) NOT NULL | Impact of a Change request.......... |
| 20 | RG_IMPACT_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Field used for Change Management for BAM reports. |
| 21 | START_DT | Date(10) | DATE | Start date field to store start date value. |
| 22 | START_TIME | Time(15) | TIMESTAMP | Start Time |
| 23 | END_DT | Date(10) | DATE | This field stores the end date values. |
| 24 | END_TIME | Time(15) | TIMESTAMP | End Time |
| 25 | CLOSED_DATE | Date(10) | DATE | Date Closed |
| 26 | OUTAGE_DURATION | Number(4,0) | SMALLINT NOT NULL | Outage duration caused by a change. |
| 27 | OUTAGE_UNITS | Character(1) | VARCHAR2(1) NOT NULL |
Units of measurment (day, hour, minute) of outage.
D=Day(s) H=Hour(s) M=Minute(s) |
| 28 | OUTAGE | Character(30) | VARCHAR2(30) NOT NULL | Outage required by a change request |
| 29 | BO_ID_REQUESTOR | Number(31,0) | DECIMAL(31) NOT NULL | Change Requester Identification number |
| 30 | ROLE_TYPE_ID_REQ | Number(12,0) | DECIMAL(12) NOT NULL | Change Management application Requester Role Type ID |
| 31 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 32 | INTERESTED_PARTIES | Character(254) | VARCHAR2(254) NOT NULL | Parties affected by a change request or interested in it. |
| 33 | BO_ID_OWNER | Number(31,0) | DECIMAL(31) NOT NULL | Financial Account Business Object ID |
| 34 | BO_ROLE_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | BO_ROLE_TYPE_ID |
| 35 | BO_NAME_DISPLAY_2 | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |