The UBRETRO facility was designed to calculate retro amounts on benefit deductions when an employee receives a pay increase.
New Custom Functions - P2K_CF_WAGE_RATE and P2K_CF_PREMIUM. These new custom functions have been created to be used with UserCalcs which allow us to determine an employee's wage rate and premium rate based on dates defined in the UserCalc. These new functions are defined in the lexicon 'X_UC_FUNCTIONS'. If the functions are not listed in X_UC_FUNCTIONS lexicon, they can be manually added to the lexicon in {IMLN}The function 'P2K_CF_WAGE_RATE' will pass the wage rate from the employee's assignment as of the date found in the Global Variable 'CF WAGE DATE';
The function 'P2K_CF_PREMIUM' will pass the value of an employee's premium from their assignment as of the date found in the Global Variable 'CF PREMIUM DATE' and for the premium type defined in the Global Variable 'CF PREMIUM TYPE'.
Global Variables are needed to invoke the new custom function logic available in UserCalcs. The must be named exactly as shown: CF WAGE DATE, CF PREMIUM DATE, CF PREMIUM TYPEUsercalc Example: Capture wage rate and premium rate as of pay issue date The following UserCalc was written to capture the employee's wage rate and premium rates as per the Pay Issue Date and return the combined amounts to be used in the benefit calculation. This is a 'Function' type UserCalc and will return the value of the wage rate plus premium rate to the appropriate benefit component.
| LINE | CMD | TYPE 1 | OPERAND 1 | OPER | TYPE 2 | OPERAND 2 | TYPE 3 | OPERAND 3 | IF GO TO | ELSE GO TO | NOTES | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100 | LET | $G | CF WAGE DATE | EQ | DB | PPH.PAY_ISSUE_DATE | 110 | |||||
| 110 | LET | V | BASE WAGE | EQ | CF | P2K_CF_WAGE_RATE | 200 | |||||
| 200 | LET | $G | CF PREMIUM DATE | EQ | DB | PPH.PAY_ISSUE_DATE | 210 | |||||
| 210 | LET | $G | CF PREMIUM TYPE | EQ | A | CCR REG | 220 | |||||
| 220 | LET | V | CCR | EQ | CF | P2K_CF_PREMIUM | 300 | |||||
| 300 | LET | $G | CF PREMIUM DATE | EQ | DB | PPH.PAY_ISSUE_DATE | 310 | |||||
| 310 | LET | $G | CF PREMIUM TYPE | EQ | A | CORR_ASSIGN | 320 | |||||
| 320 | LET | V | CORR ASSIGN | EQ | CF | P2K_CF_PREMIUM | 400 | |||||
| 400 | LET | $G | CF PREMIUM DATE | EQ | DB | PPH.PAY_ISSUE_DATE | 410 | |||||
| 410 | LET | $G | CF PREMIUM TYPE | EQ | A | HPL | 420 | |||||
| 420 | LET | V | HPL | EQ | CF | P2K_CF_PREMIUM | 500 | |||||
| 500 | LET | $G | CF PREMIUM DATE | EQ | DB | PPH.PAY_ISSUE_DATE | 510 | |||||
| 510 | LET | $G | CF PREMIUM TYPE | EQ | A | LPL | 520 | |||||
| 520 | LET | V | LPL | EQ | CF | P2K_CF_PREMIUM | 600 | |||||
| 600 | LET | V | BENEFIT WAGE | ADD | V | BASE WAGE | V | CCR | 610 | |||
| 610 | LET | V | BENEFIT WAGE | ADD | V | BENEFIT WAGE | V | CORR ASSIGN | 620 | |||
| 620 | LET | V | BENEFIT WAGE | ADD | V | BENEFIT WAGE | V | HPL | 630 | |||
| 630 | LET | V | BENEFIT WAGE | ADD | V | BENEFIT WAGE | V | LPL | 99999 | |||
| 99999 | RET | V | BENEFIT WAGE |
The standard retroactive pay program UPRETRO will calculate the difference between the old and new wage rates and insert a pay line into the current period's pay header for each pay line that was evaluated.
Set Up Requirements#
The program will only process for pay components attached to benefit plans that have a 'Retro' pay component attached to the 'Retro Pay' tab on IPPC. It is important to update the appropriate element if new 'retro' pay components are createdIn order to ensure that retro wages are used in the benefit calculation and are picked up in the correct period a UserCalc (as shown below) is required to capture the retro earnings. This usercalc sample would be associated to the benefit plan IBPN as B0320
| LINE | CMD | TYPE 1 | OPERAND 1 | OPER | TYPE 2 | OPERAND 2 | TYPE 3 | OPERAND 3 | IF GO TO | ELSE GO TO | NOTES | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100 | LET | V | Base Earnings | EQ | EC | PT_STD_EARN | 110 | The purpose of this usercalc is to capture the earnings used in part time pension calculations. Only retro earnings that have dates within the pay period should be processed. Retro earnings should be used to calculate 'retro' benefits for the pay period they are earned in | ||||
| 110 | LET | V | ELPL.BEGIN_DATE | EQ | $S | PERIOD_START_DATE | 120 | |||||
| 120 | LET | V | ELPL.END_DATE | EQ | $S | PERIOD_END_DATE | 130 | |||||
| 130 | LET | V | RETRO EARNINGS | ELPL | ET | RETRO EARNINGS | 140 | |||||
| 140 | LET | V | TOTAL EARNINGS | ADD | V | BASE EARNINGS | V | RETRO EARNINGS | 99999 | |||
| 99999 | RET | V | TOTAL EARNINGS |
