AUDIT_RG_CHG_RQ(SQL Table) |
Index Back |
|---|---|
Change Request AuditAudit Main table for Change Management Application. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AUDIT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | The OPRID of the user who made the changes audited on an audit record. |
| 2 | AUDIT_STAMP | DateTime(26) | TIMESTAMP | Date and Time Stamp |
| 3 | AUDIT_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values |
| 4 | AUDIT_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Name of the record definition audited. AUDIT_RECNAME is used in User-Defined Audit Record Definitions. |
| 5 | CHANGE_REQUEST_ID | Character(15) | VARCHAR2(15) NOT NULL | change request identification is key to change request |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_RG_NONVW |
| 7 | RG_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Summary description of a Change Request |
| 8 | RG_REASON | Character(4) | VARCHAR2(4) NOT NULL |
Business Reason for Change request
Prompt Table: RG_UD_REQ_BUSR |
| 9 | BO_ID_REQUESTOR | Number(31,0) | DECIMAL(31) NOT NULL | Change Requester Identification number |
| 10 | ROLE_TYPE_ID_REQ | Number(12,0) | DECIMAL(12) NOT NULL | Change Management application Requester Role Type ID |
| 11 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL |
Department
Prompt Table: DEPT_TBL_WRK_VW |
| 12 | RG_LOCATION | Character(50) | VARCHAR2(50) NOT NULL | Location field for a Change Request Requestor |
| 13 | RG_REQUEST_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Change Management Type of Change Request.
Prompt Table: RG_UD_REQ_TYPE |
| 14 | RG_REQ_SUB_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Change Management change Request Sub Type
Prompt Table: RG_UD_REQ_SUBTY |
| 15 | RG_PRIORITY | Character(4) | VARCHAR2(4) NOT NULL |
change management
Prompt Table: RG_UD_REQ_PRTY |
| 16 | RG_CATEGORY | Character(4) | VARCHAR2(4) NOT NULL |
change management change Request Category
Prompt Table: RG_UD_REQ_CATGY |
| 17 | RG_IMPACT | Character(4) | VARCHAR2(4) NOT NULL |
Impact of a Change request..........
Prompt Table: RG_UD_REQ_IMPCT |
| 18 | BO_ID_OWNER | Number(31,0) | DECIMAL(31) NOT NULL | Financial Account Business Object ID |
| 19 | BO_ROLE_TYPE_ID | Number(12,0) | DECIMAL(12) NOT NULL | BO_ROLE_TYPE_ID |
| 20 | RG_24_7_SCHEDULE | Character(1) | VARCHAR2(1) NOT NULL |
Change Management indicator for a Change Request to schedule tasks over all hours and all days between the start date and end date of the Change Request.
Y/N Table Edit |
| 21 | START_DT | Date(10) | DATE | Start date field to store start date value. |
| 22 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 23 | END_DT | Date(10) | DATE | This field stores the end date values. |
| 24 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 25 | RG_DURATION_DAYS | Signed Number(6,0) | DECIMAL(5) NOT NULL | Change Management application Change Request length, days portion. |
| 26 | RG_DURATION_HOURS | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | Change Management length of Change Request hours portion |
| 27 | 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 Prompt Table: RG_UD_REQ_STATE |
| 28 | CHANGE_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
status of a Change Request in Change Management application
Prompt Table: RG_UD_REQ_STATU |
| 29 | RG_SEVERITY | Character(4) | VARCHAR2(4) NOT NULL |
Severity code on a Change Request, not used now
HIGH=High LOW=Low MED=Medium |
| 30 | RESOLUTION | Character(4) | VARCHAR2(4) NOT NULL |
Resolution Identification code used in Change Management Application
Prompt Table: RG_UD_REQ_RESO |
| 31 | RELEASE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Name of the Release for Change Management application...... |
| 32 | DESCRLONG | Long Character | CLOB | Long Description |
| 33 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 34 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 35 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 36 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 37 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 38 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |