Example of Loading Retroactive Payroll Calculation Event Groups

Assume you need to monitor retrospective salary and element entry changes so you can calculate the necessary payroll adjustments.

For example, Lucy Hall is awarded a backdated salary increase effective from 1st June. An event is required to identify the salary change that took place on this date. The event enables retropay to calculate the salary arrears that are payable to Lucy.

Create an event group for the retroactive recalculation of payroll for your legislative data group.

This example EventGroup.dat file loads a retropay event group that tracks salary and element entry.

METADATA|EventGroup|EventGroupCode|LegislativeDataGroupName|EventGroupName|EventGroupType|ProrationType
MERGE|EventGroup|EvtGrpCD_Salary|US Legislative Data Group|EvtGrp_Salary|R|
METADATA|DateTrackedEvent|EventGroupCode|LegislativeDataGroupName|ColumnName|UpdateType|ProrationStyle|DatedObjectName
MERGE|DateTrackedEvent|EvtGrpCD_Salary|US Legislative Data Group|SALARY_AMOUNT|DT_UPDATE_COLUMN||oracle.apps.hcm.compensation.salary.core.protectedModel.entity.SalaryEO
MERGE|DateTrackedEvent|EvtGrpCD_Salary|US Legislative Data Group|SCREEN_ENTRY_VALUE|DT_CORRECTION||oracle.apps.hcm.payrolls.elements.entries.protectedModel.entity.ElementEntryValueDEO
MERGE|DateTrackedEvent|EvtGrpCD_Salary|US Legislative Data Group|SCREEN_ENTRY_VALUE|DT_UPDATE_COLUMN||oracle.apps.hcm.payrolls.elements.entries.protectedModel.entity.ElementEntryValueDEO
MERGE|DateTrackedEvent|EvtGrpCD_Salary|US Legislative Data Group||DT_INSERT||oracle.apps.hcm.compensation.salary.core.protectedModel.entity.SalaryEO
MERGE|DateTrackedEvent|EvtGrpCD_Salary|US Legislative Data Group||DT_INSERT||oracle.apps.hcm.payrolls.elements.entries.protectedModel.entity.ElementEntryValueDEO

Note: You can use the predefined event groups for retroactively recalculating payroll and for prorating the earnings and deductions.