What are AlterAudit, Sysaudit and DDDAudit reports in PeopleSoft

Alter Audit is a process that identifies any records that require SQL Alter process. i.e. if the Data Designer definition doesn’t match Database definition. All records that are flagged should be Altered.

SQL Alter – The primary purpose of the Application Designer’s “SQL Alter” function is to bring SQL tables into accordance with PeopleTools record definitions. You can run SQL Alter in an “audit-only” mode that alerts you to discrepancies between your record definitions and SQL tables, but that doesn’t actually perform an alter.

PeopleSoft provides several data integrity tools to ensure the health of the information stored in your PeopleSoft system. These tools are SQL Alter, SYSAUDIT, and DDDAUDIT. You’ll typically want to use these tools during activities such as upgrades and system customizations to verify the integrity of your PeopleSoft system, and how it compares to your actual SQL objects.

SQL Alter – The primary purpose of the Application Designer’s “SQL Alter” function is to bring SQL tables into accordance with PeopleTools record definitions. You can run SQL Alter in an “audit-only” mode that alerts you to discrepancies between your record definitions and SQL tables, but that doesn’t actually perform an alter.

What is DDDAUDIT report?

DDDAUDIT – The Database Audit Report (DDDAUDIT.SQR) finds inconsistencies between PeopleTools record and index definitions and the database objects. This SQR consists of nine queries: four on tables, two on views, and three on indexes.

What is SYSAUDIT report?

SYSAUDIT – The purpose of PeopleSoft’s System Audit (SYSAUDIT.SQR) is to identify “orphaned” PeopleSoft objects and other inconsistencies within your system. An example of an orphaned object would be a module of People Code that exists, but which does not relate to any other objects in the system.