Global Payroll Retro
Agenda
• Retroactive calculation overview
• Setting up Retroactive processing
• Examples from Retro test suite
• Q&A
Overview
Retroactive calculation
• Definition:
Retroactivity is the process of going back in time and
recalculating prior calendars due to change that were made after
the original calculation was run.
• Corrective Retro
Complete recalculation of the pay run for that calendar period.
• Forwarding Retro
Differences between the new and old calculations are carried
forward to the current calendar period.
Rules of Retroactive Processing
• Tracks recalculated calendars
• Calculates retro deltas and processes adjustments
• Loads balance accumulators
• Stores recalculated results
• Reverses previous results
Triggers
Definition: The mechanism used to detect online changes to the
data that should result in some system action is called trigger.
• Iterative triggers
• Retro triggers
• Segmentation triggers
Retro Trigger Source
- Automatic: Indicates triggers that were created based
on predefined conditions that you specify during setup.
- Manual: Indicates triggers that were manually entered
on the Payee Triggers - Retro - Unexpanded page. For a
manually inserted row of trigger data, the trigger source is
Manual and the trigger status is Unprocessed.
Setting up retroactivity Rules
Country setup page
Retro Process Definition Page
Retro Process Override Page
Corrective Retro Method
Retro Process Override Page
Corrective Retro Method
Retro Event Definition
Map Retro processes to event ID
Trigger Definition Page
Define Trigger Fields
Pay Entity Retro Limit Page
Setting up Backward and forward retro limits
Review Triggers
View, Add and Cancel Retro Triggers
Retro Regression Test Suite
Initial Setup
Note : October 1999 and November 1999 Calendars are finalized.
• Pay Rate Changes for December
GXEERT001 rcd# 0, GXEERT002
Work Location: Add new effective dated row.
Effective Date: 11/01/99
Action/Reason: Pay Rate Change
Rate Code: GXRCF1 Comp Rate 6000
Retro Change : Rate Code GXRCF1 change from 6000 to 6500 and GXRCH1 to 37.5
GXEERT001 rcd#1
Work Location: Add new effective dated row.
Effective date: 11/01/99
Action/Reason: Pay Rate Change
Compensation:
Rate Code: GXRCF1 Comp Rate 5000
Initial Setup Cont…
GXEERT005,GXEERT006
Work Location: Change the compensation Data on the already
existing Effective Date 11/15/99, Action/Reason of Data Change
Compensation:
Rate Code GXRCF1 Comp Rate 6000
Rate Code GXRCH1 Comp Rate 34.62
Rate Code GXRCT1 Points 120
Retro change during Jan :
Change effective date from 11/15/99 to 11/20/99
Insert new row for pay rate change 12/1/1999 Rate Code GXRCT1 points
130
Initial Setup Cont…
• Positive Input for December
• Add November, December and January Positive Input for each employee
GXEERT003
Pay Group: GXPGUSA1
Calendar ID: GXRT 1999/11 PAY
GXRT 1999/12 PAY
GXRT 2000/01 PAY
Entry Type: Earning
Element Name: GHEROVERTM
Override
Unit: Numeric, 5 (value)
GXEERT004
Pay Group: GXPGFRA2
Calendar ID: GXRT2 1999/11 PAY
GXRT2 1999/12 PAY
GXRT2 2000/01 PAY
Entry Type: Earning
Element Name: GHEROVERTM
Override
Unit: Numeric, 5 (value)
Initial Setup Cont…
• Retro Triggers
GXEERT001 (rcd #0), GXERT002, GXEERT003, GXEERT004
Retro – Unexpanded
Effective Date: 11/01/99
Event ID: GXRETRO
GXEERT005, GXERT006
Retro – Unexpanded
Effective Date: 11/15/99
Event ID: GXRETRO
Example for Forwarding Retro Active Processing
Results of November 1999 Calendar
V1 R1
November 1999 GXEERT002 Value
Earning GXHEROVERTM 36.06
GXHERSALARY 1050
GXHERPREM1 5000
Deductions GXHDD1 370.64
GXHDD6 141.46
Results of December 1999 Calendar
December 1999(Retro Change on GXEERT002 Value Retro Adjustments
Nov 99)
November 99
V1 R2
Earning GXHEROVERTM 36.06
GXHERSALARY 6000
GXHERPREM1 1260
Deduction GXHDD1 370.64
GXHDD6 141.46
December 99
V1 R1
Earning GXHEROVERTM 43.28
GXHERSALARY 6000 1000
GXHERPREM1 1260 210
Deduction GXHDD1 724.48
GXHDD6 203.66
Results of January 2000 Calendar
January 2000(Retro Change on Nov GXEERT002 Value Retro Adjustments
and Dec 99)
November 99
V1 R3
Earning GXHEROVERTM 36.06
GXHERSALARY 6500
GXHERPREM1 1365
Deduction GXHDD1 624.18
GXHDD2 500
GXHDD6 141.46
December 99
V1 R2
Earning GXHEROVERTM 46.88
GXHERSALARY 6500
GXHERPREM1 1365
Deduction GXHDD1 831.92
GXHDD2 500
GXHDD6 203.66
Results of January 2000 Calendar (Continued..)
January 2000 V1 R1
GXHEROVERM 46.88 3.6
Earning
GXHERSALARY 6500 1000
GXHERPREM1 1365 210
GXHDD1 833.16
Deduction
GXHDD2 500
GXHDD6 173.77
Results of February 2000 Calendar V1 R1
February 2000 GXEERT002 Value
Earning GXHEROVERTM 46.88
GXHERSALARY 6500
GXHERPREM1 1365
Deductions GXHDD1 625.83
GXHDD2 500
GXHDD6 173.58
Results of March 2000 Calendar
March 2000(Retro Change on Dec 99, GXEERT002 Value Retro Adjustments
Jan 2000 and Feb 2000)
December 99 V1 R3
Earning GXHEROVERTM 46.88
GXHERSALARY 7000
GXHERPREM1 1365
Deduction GXHDD1 925.62
GXHDD2 500
GXHDD6 203.66
January 2000 V2 R1
Earning GXHEROVERTM 46.88
GXHERSALARY 7000
GXHERPREM1 1365
Deduction GXHDD1 926.93
GXHDD2 600
GXHDD6 173.77
Results of March 2000 Calendar (Cont…)
March 2000(Retro Change on Dec 99, GXEERT002 Value Retro Adjustments
Jan 2000 and Feb 2000)
February 2000 V2 R1
Earning GXHEROVERTM 46.88
GXHERSALARY 7000
GXHERPREM1 1365
Deduction GXHDD1 926.93
GXHDD2 600
GXHDD6 173.77
March 2000 V1 R1
Earning GXHEROVERTM 54.09 0
GXHERSALARY 7500 1500
GXHERPREM1 1365
Deduction GXHDD1 871.45
GXHDD2 600
GXHDD6 206.89
Example for Corrective Retro Active Processing
Results of November 1999 Calendar V1 R1
November 1999 GXEERT001 Value
Earning GXHEROVERTM 36.06
GXHERSALARY 5000
GXHERPREM1 1050
Deductions GXHDD1 370.64
GXHDD6 141.46
Results of December 1999 Calendar
December 1999(Retro Change on GXEERT001 Value Retro Adjustments
Nov 99)
November 99
V2 R1
Earning GXHEROVERTM 36.06
GXHERSALARY 6000
GXHERPREM1 1260
Deduction GXHDD1 532.61
GXHDD6 141.46
December 99
V1 R1
Earning GXHEROVERTM 43.28
GXHERSALARY 6000
GXHERPREM1 1260
Deduction GXHDD1 533.14
GXHDD6 173.10
Results of January 2000 Calendar
January 2000(Retro Change on Nov GXEERT001 Value Retro Adjustments
and Dec 99)
November 99
V3 R1
Earning GXHEROVERTM 36.06
GXHERSALARY 6500
GXHERPREM1 1365
Deduction GXHDD1 624.18
GXHDD2 500
GXHDD6 141.46
December 99
V2 R1
Earning GXHEROVERTM 46.88
GXHERSALARY 6500
GXHERPREM1 1365
Deduction GXHDD1 625.83
GXHDD2 500
GXHDD6 173.1
Results of January 2000 Calendar Cont…
January 2000 V1 R1
GXHEROVERM 46.88
Earning
GXHERSALARY 6500
GXHERPREM1 1365
GXHDD1 625.83
Deduction
GXHDD2 500
GXHDD6 173.58
Results of February 2000 Calendar V1 R1
February 2000 GXEERT001 Value
Earning GXHEROVERTM 46.88
GXHERSALARY 6500
GXHERPREM1 1365
Deductions GXHDD1 625.83
GXHDD2 500
GXHDD6 173.58
Results of March 2000 Calendar
March 2000(Retro Change on Dec 99, GXEERT001 Value Retro Adjustments
Jan 2000 and Feb 2000)
December 99 V3 R1
Earning GXHEROVERTM 46.88
GXHERSALARY 7000
GXHERPREM1 1365
Deduction GXHDD1 707.44
GXHDD2 500
GXHDD6 173.1
January 2000 V1 R2
Earning GXHEROVERTM 46.88
GXHERSALARY 7000
GXHERPREM1 1365
Deduction GXHDD1 707.44
GXHDD2 600
GXHDD6 173.58
Results of March 2000 Calendar cont…
March 2000(Retro Change on Dec 99, GXEERT001 Value Retro Adjustments
Jan 2000 and Feb 2000)
February 2000 V1 R2
Earning GXHEROVERTM 46.88
GXHERSALARY 7000
GXHERPREM1 1365
Deduction GXHDD1 707.44
GXHDD2 600
GXHDD6 173.58
March 2000 V1 R1
Earning GXHEROVERTM 54.09
GXHERSALARY 7500
GXHERPREM1 1365
Deduction GXHDD1 983.97
GXHDD2 600
GXHDD6 214.05
Q
&
A