Processing Mass Changes

Important! Mass Change is a deprecated product. It is strongly recommended that you use Application Engine instead. For more information on PeopleSoft Application Engine, see PeopleTools: Application Engine.

Processing mass changes consists of a definition phase and a processing phase. First, you define the selection criteria and changes for the selected data; then you run the Structured Query Reports (SQRs) that process the changes you defined.

Note: The development staff must create mass change types and templates before you can use the mass change definitions discussed in this section.

This section discusses how to:

Define a mass change.
Process a mass change.

Page Name	Definition Name	Navigation	Usage
Description	MC_DEFN_00	Checklists > Mass Change - Checklists > Mass Change Definition > Description Communications > Mass Change - Communications > Mass Change Definition > Description Records and Enrollment > Enroll Students > Block Enrollment > Mass Change Definition > Description Student Admissions > Processing Applications > Mass Change > Mass Change Definition > Description Contributor Relations > Initiatives > Process Initiatives > Initiative Mass Change > Description	Define the mass change.
Criteria and Defaults	MC_DEFN_01	Checklists > Mass Change - Checklists > Mass Change Definition > Criteria and Defaults Communications > Mass Change - Communications > Mass Change Definition > Criteria and Defaults Records and Enrollment > Enroll Students > Block Enrollment > Mass Change Definition > Criteria and Defaults Student Admissions > Processing Applications > Mass Change > Mass Change Definition > Criteria and Defaults Contributor Relations > Initiatives > Process Initiatives > Initiative Mass Change > Criteria and Defaults	Define criteria and set defaults for mass changes.
Student Administration	MC_DEFN_SA	Campus Community > Checklists > Mass Change - Checklists > Mass Change Definition > Student Administration Campus Community > Communications > Mass Change - Communications > Mass Change Definition > Student Administration Records and Enrollment > Enroll Students > Block Enrollment > Mass Change Definition > Student Administration Student Admissions > Processing Applications > Mass Change > Mass Change Definition > Student Administration Contributor Relations > Initiatives > Process Initiatives > Initiative Mass Change > Student Administration	Set specific parameters for mass change definitions. The resulting mass change SQL statements will include these parameters.
Generate SQL	MC_DEFN_02	Campus Community > Checklists > Mass Change - Checklists > Mass Change Definition > Generate SQL Campus Community > Communications > Mass Change - Communications > Mass Change Definition > General SQL Records and Enrollment > Enroll Students > Block Enrollment > Mass Change Definition > Generate SQL Student Admissions > Processing Applications > Mass Change > Mass Change Definition > General SQL Contributor Relations > Initiatives > Process Initiatives > Initiative Mass Change > Generate SQL	Generate the SQL to run a mass change.
Execution History	MC_DEFN_03	Campus Community > Checklists > Mass Change - Checklists > Mass Change Definition > Execution History Campus Community > Communications > Mass Change - Communications > Mass Change Definition > Execution History Records and Enrollment > Enroll Students > Block Enrollment > Mass Change Definition > Execution History Student Admissions > Processing Applications > Mass Change > Mass Change Definition > Execution History Contributor Relations > Initiatives > Process Initiatives > Initiative Mass Change > Execution History	View the history of a completed mass change.
Group Definition	MC_GROUP_01	Campus Community > Checklists > Mass Change - Checklists > Mass Change Group Campus Community > Communications > Mass Change - Communications > Mass Change Group Student Admissions > Processing Applications > Mass Change > Mass Change Group	Combine mass change definitions into a group and set the execution sequence.
Run Mass Change	RUN_MASSCHNG	Campus Community > Checklists > Mass Change - Checklists > Mass Change Group Campus Community > Communications > Mass Change - Communications > Mass Change Group Records and Enrollment > Enroll Students > Block Enrollment > Run Mass Change Student Admissions > Processing Applications > Mass Change > Run Mass Change	Execute the mass change.
Mass Change Result	MC_CHK_RESULT	Campus Community > Checklists > Mass Change - Checklists > Mass Change Group Campus Community > Communications > Mass Change - Communications > Mass Change Group Records and Enrollment > Enroll Students > Block Enrollment > Mass Change Group Student Admissions > Processing Applications > Mass Change > Mass Change Group	View mass change results.

The definition phase comprises these steps:

Select a mass change template, and use it to create a mass change definition.
Outline the criteria for selecting rows, and identify the columns and values to be changed.
Generate the SQL statement.

The processing phase comprises these steps:

Run the Mass Change SQR to select, change, and transfer the data to temporary tables.
(Optional) Review the data for accuracy (recommended).
This PeopleSoft application delivers features that enable you to review the mass change results. You can view the results of mass change definitions using the Mass Change Result page (one of the locations is Campus Community > Communications > Mass Change - Communications > Mass Change Results). Other Campus Solutions applications also have pages for reviewing mass change results; these pages are described in the documentation for the specific application.
Run the appropriate process to load the data from temporary tables into PeopleSoft tables (if applicable).
For example, to insert communications or checklists, you run the 3C Engine process to insert the mass change results into the PeopleSoft tables.

This flowchart illustrates mass change integration:

Processing Mass Changes

Pages Used for Processing Mass Changes

Defining the Mass Change

Processing the Mass Change