SYS, DDD, ALTER AUDIT REPORTS DEFINITIONS

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.

Application Engine Audits Result: Exception(s) Found

(AE-01) AE programs without any sections:

Clear List Audits Result: OK

Electronic Commerce Audit Result: OK

Field Definition Audit Result: OK

Menu Definition Audit Result: Exception(s) Found

(MENU-03) The Menu Item table contains Component that does not exist in the Component Definition table

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.

(TABLE-1) SQL Table Names defined in the Application Designer that are not blank and not the same as the Record Name:

(TABLE-2) SQL Table defined in the Application Designer and not found in the Database:

(TABLE-3) SQL Table defined in the Database and not found in the Application Designer:

(TABLE-4) Tablespace not defined for SQL Table in the Application Designer:

(TABLE-5) Table Contains More Than 500 Fields :

(VIEWS-1) Views defined in the Application Designer and not found in the Database:

(VIEWS-2) Views defined in the Database and not found in the Application Designer:

(INDEX-1) Index defined in the Application Designer and not found in the Database:

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.