Building Record Definitions

                 

We begin by selecting Build > Current Definition in the Application Designer, the Build dialog box is displayed. The build dialog box contains the Build Options, Build Execute Options, and the Build Settings. Under the Build Options, you can Create Tables, Create Indexes, Create Views, Alter Tables, and Create Triggers. 

When you want to create an application data table, select the Create Tables checkbox. Notice that the Create Indexes checkbox is automatically selected when the Create Tables Option is selected. Indexes can be created independently of tables, especially if you change a record definition and specify a new key or alternate search keys. 

Select the Create Views option when you want to create a view. Views do not have their own indexes in PeopleSoft. They use the indexes of the tables from which the data originates. 

Select the Alter Tables option when you wish to change an existing table without losing any existing data on the table. 

Select the Create Trigger option to create a database trigger which is a type of stored procedure that executes automatically when a user makes a specific data modification statement on a specified table. Triggers are applicable to mobile applications and optimization servers. 

Under the Build Execute Options, the three choices are Build script file, Execute SQL now, and Execute and build script. Select the Build script file choice when you wish to generate the SQL script file to complete the choices selected under the Build Options, but you don’t want to execute the SQL automatically at that time. I typically select execute SQL script now, because Application Designer automatically builds the SQL Script so there is rarely a time where you need to analysis the SQL script.