RG_CHG_AUDIT_VW

(SQL View)
 Index Back

Change Audit View

Change Management Audit view record

SELECT A.CHANGE_REQUEST_ID , A.BUSINESS_UNIT , B.RECNAME , B.FIELDNAME , B.AUDIT_ACTN , B.AUDIT_STAMP , B.AUDIT_OPRID , B.OLDVALUE , B.NEWVALUE FROM PS_RG_CHANGE_REQST A , PSAUDIT B WHERE %Substring(B.KEY1,1,15) = A.CHANGE_REQUEST_ID AND %Substring(B.KEY2,1,5) = A.BUSINESS_UNIT

# 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

Default Value: NEXT

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT

Prompt Table: SP_BU_RG_NONVW

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
5 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
6 AUDIT_STAMP DateTime(26) TIMESTAMP Date and Time Stamp
7 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
8 OLDVALUE Character(65) VARCHAR2(65) NOT NULL Old Value
9 NEWVALUE Character(65) VARCHAR2(65) NOT NULL New Value