Simple and Quick Audit access
Every customer will have a set of records and fields that they audit within PeopleSoft – and these will vary wildly from client to client. What doesn’t change however, is the need to view the rows recorded in the audit records. Unfortunately, PeopleSoft doesn’t deliver anything to let you do this, you have to either use SQL or craft a Query. Many people don’t have SQL skills, and Query often isn’t appropriate as either people don’t have the skills, the access or it’ll take too long. To fill this gap I decided to build the following tool:
This component allows you specify an audit record to examine (both record and record/field level auditing is supported by the tool).
Once the page loads, you are shown two areas where you can filter the audit rows that will be returned. The first area lists common audit fields (i.e. those that will appear on all audit records, plus some fields which allow you to specify a date range). The second area reads the keys from the record that the audit rows relate to and allows you to filter by those also (so these are dynamic, based on the record that you selected).
When you click search you audit record is queried and the rows returned (subject to your query fields).
A quick and easy way to allow non-technical staff to look-up audit data.
Currently live with 1 customer.
Fully tested on PeopleTools 8.50, 8.51 and 8.52. (It should work on 8.4x but has not yet been tested.)
Price: £400 / $640
Interested? Get in touch by filling out our quick Purchase form.
