Performing Bulk Deletions
To perform bulk deletions by using PeopleSoft Application Designer, select
Use the delete operation to:
Remove the field from a list of pages, regardless of where the field exists on the page or whether it is in a grid.
Remove the field from the list of records.
The delete operation removes associated PeopleCode and modifies associated SQL either in the record or, if the record is a subrecord, in parent records.
If the field is in the SELECT clause of the SQL, the removal is straightforward. However, if the field is also used in a WHERE clause or if the field is the only item in the SELECT clause, then the record is not modified. Instead, it is inserted into a project called BLK_<SOURCEFIELDNAME> as noted in messages in the status screen.
Note: Users should examine a project with a targeted field in SQL statements individually to delete the field as required from the associated SQL.
Deleting fields from records and pages does not remove the field definition itself and does not remove the field from other applications, such as BI Publisher.
Note: Because performing this operation changes records, you must subsequently rebuild the database because each application data table is based on the record definition.