Understanding Triggers

This topic discusses:

  • Supported benefit triggers.

  • Delivered mass triggers.

Triggers are used to detect online changes that should result in some type of action. PeopleSoft Global Payroll for United States delivers both iterative and retro triggers for benefit related data. When a trigger is generated by a change to a record, it writes the required data necessary to process the trigger to a table.

  • Iterative triggers are written to GP_ITER_TRGR.

  • Retro triggers are written to GP_RTO_TRGR.

    Note: Retro triggers are processed using the forwarding method.

Three applications create triggers:

  • Manage Base Benefits business process in PeopleSoft HR.

  • Administer Workforce business process in PeopleSoft HR.

  • Benefits Administration.

Manage Base Benefits Business Process

An iterative and retro trigger is written when administration changes the following pages:

  • Benefit Program Participation.

  • Health Benefit Elections.

  • Life/ADD Elections.

Administer Workforce Business Process

An iterative and retro trigger is written when administration changes the Benefit Program field on the Benefit Participation page.

Benefits Administration

In Benefits Administration, a trigger is written to the BAS_ACTIVITY table whenever an employee has a qualified life event. The Benefits Administration process, BAS_RUNCTL, will evaluate that event and determine whether a new benefit enrollment record should be written for that employee.

If a new benefit enrollment record is written that affects the employee's benefit program, health plan enrollment, or life enrollment, a retroactive and iterative trigger is written to the GP_RTO_TRGR and GP_ITER_TRGR tables.

Mass triggers enable you to generate employee payroll triggers based on changes to setup tables. Mass triggers are specified for a certain record on a certain component. A SQL object defines the population affected by the change to the setup table. When the affected employees are determined, you can review the trigger details before accepting the changes.

PeopleSoft Global Payroll for United States delivers one mass trigger event definition, BEN MT, for the following components:

  • BEN_PROG_DEFN

  • BN_FORMULA

  • BN_RATE_TABLE

  • CALC_RULES_TABLE

  • COVERAGE_GROUP_TBL

  • LIFE_ADD_TABLE