Building and Maintaining Data

This section discusses how to:

  • Build and maintain data.

  • Create SQL tables.

You must keep underlying database definitions synchronized with PeopleSoft definitions. Therefore, from PeopleSoft Application Designer, you must:

  • Submit SQL Alter and Create commands for all types of database definitions.

  • Manage the database index.

  • Manage the table space.

  • Manage the DDL model for tables, indexes, and table spaces.

To access data, you must create a SQL table and then store data in the fields and records. The process of running the SQL to synchronize the database with records, indexes, and DDL is called the Build process.

The Build feature processes definitions at these levels:

  • Current record.

  • Selected records in the project workspace.

  • All records in the project.