Tracking Recalculated Calendars

Global Payroll tags each Pay Process Stat record with a version and revision number appropriate to the retro method used. These version and revision numbers are the vehicles for tracking recalculation of a calendar period due to retroactivity.

Note:

We discuss the Pay Process Stat record in the topic on system architecture.

See Batch Processing Output Tables.

The system defines the original set of output results for a calendar calculation as Version 1, Revision 1 (V1R1). Each subsequent recalculation of the calendar increases either the version number or the revision number depending on the retro method:

Term	Definition
Corrective Retro	When the retro method is corrective, the version number increases by 1 and the revision number stays at 1. For example, the first corrective retro is Version 2, Revision 1 (V2R1). The second corrective retro (retro on retro) is Version 3, Revision 1 (V3R1), and so forth.
Forwarding Retro	When the retro method is forwarding, the version number stays the same and the revision number increases by 1. For example, the first forwarding retro is Version 1, Revision 2 (V1R2). The second forwarding retro (retro on retro) is Version 1, Revision 3 (V1R3), and so forth.

The system uses these numbers to determine which calculations to use as the old and new values when processing retro deltas.

Version and Revision Numbers Used When Calculating Retro on Retro

When the system calculates retro on retro—that is, when a period is recalculated more than once—and the retro method changes, the numbering scheme becomes more complicated. In the following example, Global Payroll recalculates five consecutive periods using the forwarding method on the first pass, and a combination of forwarding and corrective retro on the second pass.

Scenario:

The retro method changes from corrective to forwarding in period 3 when retro is first processed. The second time that retro is processed, the method changes from forwarding to corrective in the same period.

In the following table, P1 to P6 represent periods 1 to 6.

Description	P1	P2	P3	P4	P5	P6
Version and revision number for original calculation.	V1R1	V1R1	V1R1	V1R1	V1R1	V1R1
Initial recalculation method changes from corrective to forwarding in period 3.	Corrective	Forwarding
Version and revision numbers for initial recalculation.	V2R1	V2R1	V1R2	V1R2	V1R2	V1R2
Recalculation method changes from forwarding to corrective in period 3.	Forwarding	Corrective
Second recalculated version and revision numbers.	V2R2	V2R2	V2R1	V2R1	V2R1	V2R1

When forwarding follows corrective retro, the revision number increases by 1, and the version number remains the same as it was in the last maximum corrective run. However, when corrective retro follows forwarding, the version number increases by 1, and the revision number goes back to 1. This has important consequences for how the system calculates retro deltas.

See Calculating Retro Deltas and Processing Adjustments.

Version and Revision Numbers in Retro Adds

A retro add is a situation in which a previous gross-to-net does not exist for a payee, and retroactivity calls for a Pay Process Stat record to be created for the first time. For example, suppose that a payee initially thought to have been hired in February was actually hired in January. There is no gross-to-net for January, so when January is processed for retro, the system must create a Pay Process Stat record for the period and assign version and revision numbers to it.

The system assigns version and revision numbers as follows:

• Numbering retro adds when the retro method is forwarding.

  When the retro method is forwarding, the revision number must be greater than 1. If a previous gross-to-net calculation does not exist, and a retro add results in a gross-to-net for the first time, the system labels this calculation V1R2 even though it is technically the first gross-to-net. The reason for this is that forwarding retro does not replace the original results of a calculation with new ones, but uses them to generate retro deltas. V1R2 is created only to calculate the deltas to bring forward to the current period. V1R1 is not used because it does not contain the true results for the period.

• Numbering retro adds when the retro method is corrective.

  When the retro method is corrective, a previous gross-to-net does not exist, and a retro add results in a gross-to-net for the first time, the system labels this first calculation V1R1. The reason for this is that corrective retro replaces the results of the prior pay calculation (it does not use them only to create retro deltas), so when a period is added, it treats this period as if it were the original one.

The following tables illustrate how the system numbers Pay Process Stat records in retro add situations using forwarding and corrective retro.

Scenario:

In the following retro add situations, it is discovered that a payee who was calculated in period 1 should not have been processed in that period. The calculations for the payee are therefore reversed in Recalc No. 2. When it is later discovered that the payee belongs in that period after all, the system produces a new gross-to-net calculation using the version and revision numbers associated with Recalc No. 3:

Example 1

Period/Recalculation	Retro Method	Numbering
Period 1 (original calculation)	Not applicable	V1R1
Recalc No. 1	Corrective	V2R1
Recalc No. 2	Reversal (corrective)	V3R1
Recalc No. 3	Add (corrective)	V4R1

Example 2

Period/Recalculation	Retro Method	Numbering
Period 1 (original calculation)	Not applicable	V1R1
Recalc No. 1	Corrective	V2R1
Recalc No. 2	Reversal (corrective)	V3R1
Recalc No. 3	Add (forwarding)	V3R2

Example 3

Period/Recalculation	Retro Method	Numbering
Period 1 (original calculation)	Not applicable	V1R1
Recalc No. 1	Forwarding	V1R2
Recalc No. 2	Reversal (forwarding)	V1R3
Recalc No. 3	Add (forwarding)	V1R4

Example 4

Period/Recalculation	Retro Method	Numbering
Period 1 (original calculation)	Not applicable	V1R1
Recalc No. 1	Forwarding	V1R2
Recalc No. 2	Reversal (forwarding)	V1R3
Recalc No. 3	Add (corrective)	V2R1