Inserting Fields into Records

To perform bulk insertions using PeopleSoft Application Designer, select Tools, and then Bulk Operations, and then Insert.

You can insert a source field into selected records only if the model field exists in those records. The source field is assigned the same record field properties as the model field in each record and is inserted immediately following the model field.

If the model field has a prompt table, then the system creates a prompt table for the source field by using the name of the source field with TBL appended to it.

If the record is either a SQL view or a dynamic view type, then the system modifies the associated SQL by expanding the SELECT clause to include the new field.

If the record is a subrecord, then the system updates the parent records of the SQL view or dynamic view type that contain this subrecord. If the SQL contains the model field in the WHERE clause or if the SQL is complex, then the system inserts the associated record into a project called BLK_<SOURCEFIELDNAME> and displays a status message. Examine the contents of that project after the operation completes to verify successful completion.

If the model field has PeopleCode associated with it in the record or in a component, then the system copies this PeopleCode to the new field with all of the references to the model field changed to refer to the new field.

Note:

Because performing this operation changes records that are used to build application tables, you must rebuild (alter) the database before these changes can be used.