EP_B_AUDIT_VW

(SQL View)
Index Back

Base Item Audit View

View of PSAUDIT to view Establish Criteria Item modification History

SELECT %Substring(key1,1,8) , %Substring(key2,1,8) , %Substring(key3,1,12) , %Substring(key4,1,2) , audit_stamp , audit_oprid , audit_actn , RECNAME , fieldname , oldvalue , newvalue FROM PSAUDIT WHERE recname IN ('EP_APPR_B_ITEM')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EP_APPR_ID_CHAR Character(8) VARCHAR2(8) NOT NULL Appraisal Id field used for Item Audit View
2 EP_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Section type
3 EP_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier
4 EP_ITEM_SEQ_CHAR Character(2) VARCHAR2(2) NOT NULL Item sequence number used for item audit view

Default Value: 1

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