Viewing Audit Information
Viewing the data that is in the audit record is important. That's why you're storing the information. Because the information resides in a table within the RDBMS, you can extract it and manipulate it to suit your reporting needs. This section provides samples of how the information appears in an audit record and some sample queries that you can construct with PeopleSoft Query.
The following example presents the contents of PS_AUDIT_ABSENCE after a trigger test:
AUDIT_OPRID AUDIT_STAMP AUDIT_ACTN EMPLID ABSENCE_TYPE BEGIN_DT
----------- --------------------------- ---------- ----------- ------------ -------------------------
BARNEY07 2000-01-11 16:25:13.380 A GORD CNF 1981-09-12 00:00:00.000
BARNEY07 2000-01-11 16:25:36.123 K 8001 CNF 1981-09-12 00:00:00.000
BARNEY07 2000-01-11 16:25:36.123 K 8001 CNF 1983-03-02 00:00:00.000
BARNEY07 2000-01-11 16:25:36.123 K 8001 CNF 1983-08-26 00:00:00.000
BARNEY07 2000-01-11 16:25:36.133 N 8001 VAC 1981-09-12 00:00:00.000
BARNEY07 2000-01-11 16:25:36.133 N 8001 VAC 1983-03-02 00:00:00.000
BARNEY07 2000-01-11 16:25:36.133 N 8001 VAC 1983-08-26 00:00:00.000
BARNEY07 2000-01-11 16:25:40.790 D GORD CNF 1981-09-12 00:00:00.000
RETURN_DT DURATION_DAYS DURATION_HOURS REASON PAID_UNPAID
--------------------------- ------------- -------------- ------------------------------ -----------
1981-09-26 00:00:00.000 14 .0 None P
1981-09-26 00:00:00.000 14 .0 P
1983-03-07 00:00:00.000 6 .0 P
1983-09-10 00:00:00.000 13 2.0 P
1981-09-26 00:00:00.000 14 .0 P
1983-03-07 00:00:00.000 6 .0 P
1983-09-10 00:00:00.000 13 2.0 P
1981-09-26 00:00:00.000 14 .0 None P
EMPLOYER_APPROVED COMMENTS
----------------- -----------------------------
Y This is the comments field
Y
Y
Y
Y This is an update
Y This is an update
Y This is an update
Y
Note: For Microsoft SQL Server the AUDIT_OPRID field value will be NULL.