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