Setting Up Mass Triggers

This chapter provides an overview of mass triggers and discusses how to:

Set up mass triggers.
Process mass trigger action events.

Understanding Mass Triggers

This feature enables you to generate employee triggers based on changes to setup tables. Mass triggers can be established for specific records on specific components. A set of SQL objects defines the population affected by the setup table change. Once the affected employees are determined, you can review the trigger details before accepting the changes.

To set up mass triggers you must:

Define the component/record and fields that activate the trigger on the Trigger Definitions page.
Set up the SQL objects that will check the records to determine the population affected by the setup table change. You must define the SQL objects using PeopleTools and select them on the Trigger SQL page.

The mass trigger event process occurs in three steps:

After saving the page containing the component/record and fields that activate the mass trigger, the event and the field values are stored on the mass trigger result table (GP_MT_TRIGGER). The event status is set to Unexpanded.
The system evaluates the SQL objects and writes the results to the mass trigger results table (GP_MT_RESULT), which records the impacted population. The event status is set to Expanded, if all objects expand successfully.
The system generates a list of retro and iterative triggers for the impacted population. Once completed, the event status is set to Triggers Generated.

You can view the events and their results on the Mass Trigger Events component. The system enables you to do the following:

Delete a trigger event using the Trigger Events page. This includes the mass trigger, the impacted population, and the generated payee triggers. Deletion cannot occur if any of the generated triggers have been processed.
Manually expand an event using the Impacted Employees page. You may want to generate triggers after correcting an erroneous SQL object. Manually expanded triggers can do the following:
- Generate the impacted population and the retroactive and iterative triggers for events that have a status of Unexpanded.
- Generate retroactive and iterative triggers for events that have a status of Expanded.

Setting Up Mass Triggers

This section discusses how to:

Define mass triggers.
Use SQL objects.
View the SQL statement.

Pages Used to Set Up Triggers

Page Name	Object Name	Navigation	Usage
Trigger Definition	GP_MT_TRG_DFN	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Triggers, Mass Trigger Definitions, Trigger Definition	Define which record activates the trigger.
Trigger SQL	GP_MT_TRG_SQL	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Triggers, Mass Trigger Definitions, Trigger SQL	Specify which SQL objects must be executed in order to retrieve the population impacted by a mass trigger event.
Sql Definition	GP_MT_SQLTXT_SEC	Select the SQL Definition link on the Trigger SQL page.	View the SQL definition.

Defining Mass Triggers

Access the Trigger Definition page.

Trigger Event ID

Associate a Trigger Event ID to link the mass trigger to the retroactive process ID that processes the generated payee triggers.

Ignore Terminated Employees

Select to ignore terminated employees when processing the mass trigger.

Field Name

List the fields that cause the system to generate a mass trigger event. Fields used as input parameters on the SQL Objects page need not be listed here. The system inserts them after saving.

Using SQL Objects

Access the Trigger SQL page.

SQL Object Identifier

Select any stand-alone SQL object defined in Application Designer. These objects contain placeholders for input parameters.

SQL Definition

Click to access the Sql Definition page.

Sequence number

Enter the number of the respective placeholders in the SQL object.

Field Name

Enter the fields used to fill the SQL object placeholders at runtime. Available fields prompt from the record listed above. Once saved, the system adds these fields to the Trigger Definition page.

Viewing the SQL Statement

Access the Sql Definition page.

Use this page to view a description of the SQL statement as well view the actual SQL text.

Processing Mass Trigger Action Events

This section discusses how to:

Delete an event.
Expand an event manually.
View retroactive triggers.
View iterative triggers.

Pages Used to Process Trigger Events

Page Name	Object Name	Navigation	Usage
Mass Trigger Events	GP_MT_TRIGGER	Global Payroll & Absence Mgmt, Absence and Payroll Processing, Prepare Payroll, Rvw/Expand Mass Triggers, Mass Trigger Events	View all mass trigger events listed for a component/record. Delete an event.
Message per MT Event	GP_MT_MSG_SEC	Click the Details link on the Mass Trigger Events page.	View a message.
Message	GPDE_MT_MSGLNG_SEC	Click the Details link on the Message per MT Event page.	View a message.
Field Values	GP_MT_TRG_VAL	Global Payroll & Absence Mgmt, Absence and Payroll Processing, Prepare Payroll, Rvw/Expand Mass Triggers, Field Values	View the field values valid before and after the mass trigger event.
Affected Employees	GP_MT_RESULT	Global Payroll & Absence Mgmt, Absence and Payroll Processing, Prepare Payroll, Rvw/Expand Mass Triggers, Affected Employees	View the list of employees affected by the mass trigger event. Manually expand an event.
Retro Triggers	GP_MT_RTO_TRG	Global Payroll & Absence Mgmt, Absence and Payroll Processing, Prepare Payroll, Rvw/Expand Mass Triggers, Retro Triggers	View the retroactive triggers generated for a mass trigger event.
Iterative Triggers	GP_MT_ITER_TRG	Global Payroll & Absence Mgmt, Absence and Payroll Processing, Prepare Payroll, Rvw/Expand Mass Triggers, Iterative Triggers	View the iterative triggers generated for a mass trigger event.
Calendar Groups	GP_MT_ITER_SEC	Click the Calendar Group ID button on the Iterative Triggers page.	View calendar groups.

Deleting an Event

Access the Mass Trigger Events page.

Click the Delete button to delete an event before processing the trigger. This action deletes the event's results tables, thus removing the field values, the list of affected employees, the retroactive triggers and the iterative triggers generated for the event. Only the users who created the trigger event can delete it.

Expanding an Event Manually

Access the Affected Employees page.

Expand/Refresh Employee List	Select to manually expand an event. Once activated, the system deletes the current list and generates a new one. All related retroactive and iterative triggers are also deleted and regenerated. The refresh button can only be activated if none of the related triggers have been processed. Only the user who created the mass trigger event can activate it.
EmplID	The system generates this list when storing the mass trigger event.
As of Date	The date that a retroactive calculation must occur.

Viewing Retroactive Triggers

Access the Retro Triggers page.

Trigger Effective Date	Corresponds to the As of Date on the Affected Employees page.
Trigger Status	Can either be Unprocessed, In Process, Processed, or Cancelled.
Trigger Tag	Combines the component name and record name for which the mass trigger event was generated.
Calendar Group ID	This is the ID used for processing the retroactive trigger.

Viewing Iterative Triggers

Access the Iterative Triggers page.

When a mass trigger is expanded an iterative trigger is generated for every affected employee and for every calendar group ID that is currently open. Click the Calendar Group button to access the Calendar Groups page and view the calendar groups for which an iterative trigger has been granted.

Trigger Event ID	Associate a Trigger Event ID to link the mass trigger to the retroactive process ID that processes the generated payee triggers.
Ignore Terminated Employees	Select to ignore terminated employees when processing the mass trigger.
Field Name	List the fields that cause the system to generate a mass trigger event. Fields used as input parameters on the SQL Objects page need not be listed here. The system inserts them after saving.

SQL Object Identifier	Select any stand-alone SQL object defined in Application Designer. These objects contain placeholders for input parameters.
SQL Definition	Click to access the Sql Definition page.
Sequence number	Enter the number of the respective placeholders in the SQL object.
Field Name	Enter the fields used to fill the SQL object placeholders at runtime. Available fields prompt from the record listed above. Once saved, the system adds these fields to the Trigger Definition page.