Alter Audit
The term alter audit in PeopleSoft refers to running an alter build script in application designer on a number of records (tables) to check if there are any differences between the PeopleSoft definitions and what exists in your database.
To perform a comprehensive alter audit of your current environment:
-
Start Application Designer
-
Create a new project, e.g.
ALTER_AUDIT -
Choose Insert > Definitions into Project (CTRL + F7)
-
In the insert into project search box, set your definition type to Records and the type to Table. Don't specify anything in the name field so you get all tables back. Press the enter key to perform the search. Start from the top and highlight all records from top to bottom. Then press insert to add them to your alter project (this can take some time). The number of record definitions found in the search //should// match the number of record definitions added to your project.
-
At this point, you have should have all PeopleSoft record definitions for database tables in your project. Save your project (this can take some time).
-
Choose Tools > Validate project. Make sure you say NO to the message about deleting invalid objects from your project. You should investigate any invalid records identified at this step, as it indicates problems with your PeopleSoft definitions. Once you know which definitions are invalid, you can do the validate project step again and this time say yes to the message about deleting invalid objects from your project. This will remove the invalid definitions from your project, which you do not want to attempt to build.
-
Choose Build > Project:
- Check the Alter Tables box
- Make sure the Build script file option is selected. You do not want to be making any changes to your database!
- Click on the Settings button
- Switch to the alter tab
- Confirm the settings are:
- Drop column if data present
- Truncate data if field too short
- Alter any - all check boxes selected
- Alter by Table Rename
-
Click on build to create your alter script. Say yes to the warning about potentially data destructive settings are active. In this case you are just building a script, not actually running it against your database. The build script will take some time to generate.
-
Check your build log for any warnings. Then open your build script to see what is listed. If you find any cases where an alter on a table is shown in the SQL, then it indicates that there is a difference between the table structure in the PeopleSoft record definition and what is stored in the database.
No Comments