| # |
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
|
| 7 |
TASK_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
TaskIID field. Key for RB_TSK record. Used by Task Management.
|
| 8 |
NOTE_SEQ_NBR |
Number(6,0) |
INTEGER NOT NULL |
Note ID
|
| 9 |
ATTACH_SEQ_NBR |
Number(6,0) |
INTEGER NOT NULL |
Attachment Sequence Number
|
| 10 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 11 |
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
|
| 12 |
SETID_PRODUCT |
Character(5) |
VARCHAR2(5) NOT NULL |
Product SetID
|
| 13 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 14 |
PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
PRoduct Group
|
| 15 |
RG_SUMMARY |
Character(80) |
VARCHAR2(80) NOT NULL |
Summary description of a Change Request
|
| 16 |
RG_REASON |
Character(4) |
VARCHAR2(4) NOT NULL |
Business Reason for Change request
Prompt Table:
RG_UD_REQ_BUSR
|
| 17 |
BO_ID_REQUESTOR |
Number(31,0) |
DECIMAL(31) NOT NULL |
Change Requester Identification number
|
| 18 |
DEPTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Department
|
| 19 |
RG_LOCATION |
Character(50) |
VARCHAR2(50) NOT NULL |
Location field for a Change Request Requestor
|
| 20 |
RG_REQUEST_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Change Management Type of Change Request.
|
| 21 |
RG_REQ_SUB_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Change Management change Request Sub Type
|
| 22 |
RG_PRIORITY |
Character(4) |
VARCHAR2(4) NOT NULL |
change management
Prompt Table:
RG_UD_REQ_PRTY
|
| 23 |
RG_CATEGORY |
Character(4) |
VARCHAR2(4) NOT NULL |
change management change Request Category
|
| 24 |
BO_ID_OWNER |
Number(31,0) |
DECIMAL(31) NOT NULL |
Financial Account Business Object ID
|
| 25 |
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.
|
| 26 |
START_DT |
Date(10) |
DATE |
Start date field to store start date value.
|
| 27 |
START_TIME |
Time(15) |
TIMESTAMP |
Start of Shift
|
| 28 |
END_DT |
Date(10) |
DATE |
This field stores the end date values.
|
| 29 |
END_TIME |
Time(15) |
TIMESTAMP |
End of Shift
|
| 30 |
CHANGE_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
status of a Change Request in Change Management application
Prompt Table:
RG_UD_REQ_STATU
|
| 31 |
RG_SEVERITY |
Character(4) |
VARCHAR2(4) NOT NULL |
Severity code on a Change Request, not used now
HIGH=High
LOW=Low
MED=Medium
|
| 32 |
RESOLUTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Resolution Identification code used in Change Management Application
Prompt Table:
RG_UD_REQ_RESO
|
| 33 |
RELEASE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Name of the Release for Change Management application......
|
| 34 |
ASSETTAG |
Character(40) |
VARCHAR2(40) NOT NULL |
Asset Tag
|
| 35 |
OBJECT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Related Object Type in Change Management Type of Object
CAS=Help Desk Case
CHG=Change Request
DEF=Quality Defect
|
| 36 |
OBJECT_SHOWN |
Character(15) |
VARCHAR2(15) NOT NULL |
Related Object displayed (one of: Change Request, Quality Defect, Case) for Change Request
|
| 37 |
NAME_DISPLAY4 |
Character(50) |
VARCHAR2(50) NOT NULL |
Name Display Work Area.........................
|
| 38 |
REQUESTED_BY_DT |
Date(10) |
DATE |
Change Management Requested By Date on a Change Request. (the requested completion date of the Change Request)
|
| 39 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 40 |
NOTE_SUMMARY |
Character(50) |
VARCHAR2(50) NOT NULL |
This field is used for Notes Summary (50 characters).
|
| 41 |
DESCRIPTION |
Character(35) |
VARCHAR2(35) NOT NULL |
Description
|
| 42 |
ATTACHUSERFILE |
Character(64) |
VARCHAR2(64) NOT NULL |
Attached File
|
| 43 |
RELATED_CHG_REQ_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Related change request Id when relating one change request to another change request
|