When there are changes to employee data this may also imply changes to current or retrospective payroll run results for that employee. For example:

• RetroPay - where an employee receives an adjustment in the current pay period, but the adjustment was first incurred in a previous payroll period

• Recalculation - where changes are confined to the current pay period

• Proration - where adjustments earned on a pro-rata basis in another pay period are applied in the correct proportion to the current pay period

To identify when critical changes such these as have occurred, you can define each change as a table event and specify the action that you wish to take whenever the event is detected.

You can also group a related series of events into an event group so that you can process multiple events as a single group.

See Defining Event Groups

For details of primary key information and column names, refer to the Oracle HRMS Technical Reference Manual.

You define table events from the Table Event Updates window:

   Defining a table event:

1. Select the Table Name.

2. Select the Primary Key for your table.

3. Define the period for which you wish this event to be active. You do this by selecting a start date and then an end date.

   Selecting Row Level Events

   You enter the details of the change as a row level event.

4. Select the Event Type to specify the type of database update that will initiate this event. You can select from:

   • Insert - If you select this event type, you are making a change at row level only, and the Column Name field is not enabled.

   • Delete - If you select this event type, you are making a change at row level only, and the Column Name field is not enabled.

   • Update - If you select this event type, you also need to specify a column name because updates are not confined to the row level.

5. Select the Column Name.

6. Select the Change Type. You do not need to select a change type for retro-notification and proration. You need only make a selection here if you are defining an event for Continuous Calculation. In this case, the following change types are available:

   • DATE_EARNED - to trigger recalculation of the payroll run based on the date earned.

   • DATE_PROCESSED - to trigger recalculation of the payroll run based on the effective date of the run. Use this if you want to recalculate tax information.

   • PAYMENT - to trigger recalculation of the Prepayments process

   • COST_CENTRE - to trigger recalculation of the Costing process.

   • REPORTS - to track all events that generate reports. However, if you have already selected DATE_EARNED as a change type this includes the REPORTS type, and you do not need to specify REPORTS as a separate selection.