PeopleSoft - Alter Audit

DDDAUDIT is an SQR script that compares your production SQL data tables with the PeopleSoft PeopleTools record definitions to identify inconsistencies.

SYSAUDIT is an SQR script used to identify “orphaned” PeopleSoft objects. For example, SYSAUDIT can identify a module of PeopleCode that exists but does not relate to any other objects in the system. SYSAUDIT also identifies other inconsistencies within your database.

To verify that the PeopleSoft PeopleTools definitions are synchronized with the underlying SQL data tables in your database, run the PeopleSoft PeopleTools alter record process on all records in your system. This process, called an Alter Audit, compares the data structures of your database tables with the PeopleSoft PeopleTools definitions to identify inconsistencies. The Alter Audit then creates SQL scripts with the data definition language (DDL) changes that are required to synchronize your database with the PeopleSoft PeopleTools definitions.

To run Alter Audit:
1. Launch PeopleSoft PeopleTools and sign in to the Target database.
2. From Application Designer, select File, New…
3. Select Project, and then click OK.
4. Select Insert, Definitions into Project...
5. Select Records from the Definition Type drop-down list box.
6. Select Table from the Type drop-down list box.
7. Click Insert, and then click Select All.
8. Click Insert, and then click Close.
9. Select File, Save All.
10. Enter a project name of your choice.
11. Click OK.
12. Select Build, Project..

Note. Triggers are always dropped and re-created during the alter process and will always show up in the generated Alter Audit script. You can ignore the generated script for triggers.