EP_B_AUDIT_VW(SQL View) |
Index Back |
---|---|
Base Item Audit ViewView 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 |