Payroll rules - Premiums
Hi all,
We use table V_T510P to generate meal payments. Currently the values are:
10 01 0001 1 Meal Pymt 12/22/2008 12/31/9999 20.72
10 02 0001 2 Meal Pymts 12/22/2008 12/31/9999 41.44
10 03 0001 3 Meal Pymts 12/22/2008 12/31/9999 62.16
Meal payments are input into CATS in fields Prem Nbr and ID.
We have a rule payroll ZALQ which uses the CATS input to create meal payments. ZALQ currently looks like:
000010 TABLEALP NEXTR
000020 1 D VARGBPRAKN
000030 ** ADDWT *
000040 01 TABLE 510PAMT+BBETRGNUM=1 RTE=0.00 ADDWT 1156NEXTR 2
000050 01 2 RTE=& VLBSZERO= NA ADDWT *
000060 02 TABLE 510PAMT+BBETRGNUM=2 RTE=0.00 ADDWT 1156NEXTR 3
000070 02 3 RTE=& VLBSZERO= NA ADDWT *
000080 03 TABLE 510PAMT+BBETRGNUM=3 RTE=0.00 ADDWT 1156NEXTR 4
000090 03 4 RTE=& VLBSZERO= NA ADDWT *
The above rule will generate meal payments corresponding to the $ values in T510P.
We need to create a 5% premium for employees who may spend a couple hours flying over transmission lines doing inspections. We would like to use CATS and table T510P. so we added premiums for 5%, plus values for 5% + a meal payment, 2 meal payments, etc. Table V_T510P now looks like this:
PSG Prem. no. Premium IDPremium text Start Date End Date Amount
10 01 0001 1 Meal Pymt 12/22/2008 12/31/9999 20.72
10 02 0001 2 Meal Pymts 12/22/2008 12/31/9999 41.44
10 03 0001 3 Meal Pymts 12/22/2008 12/31/9999 62.16
10 H0 0001 Helicopter Premium 12/19/2009 12/31/9999 0.00
10 H1 0001 1 MP + Helicopter Pr 12/19/2009 12/31/9999 20.72
10 H2 0001 2 MP + Helicopter Pr 12/19/2009 12/31/9999 41.44
10 H3 0001 3 MP + Helicopter Pr 12/19/2009 12/31/9999 62.16
We created a new rule (ZHEL) that creates the 5% premium:
000010 TABLEALP NEXTR
000020 1 D VARGBPRAKN
000030 ** ADDWT *
000040 H1 ADDWT * ZERO= N ZERO= R AMT*.05 ADDWT 1141
And we modified ZALQ to create the meal payments on the time which also qualifies helicopter premium:
000010 TABLEALP NEXTR
000020 1 D VARGBPRAKN
000030 ** ADDWT *
000040 01 TABLE 510PAMT+BBETRGNUM=1 RTE=0.00 ADDWT 1156NEXTR 2
000050 01 2 RTE=& VLBSZERO= NA ADDWT *
000060 02 TABLE 510PAMT+BBETRGNUM=2 RTE=0.00 ADDWT 1156NEXTR 3
000070 02 3 RTE=& VLBSZERO= NA ADDWT *
000080 03 TABLE 510PAMT+BBETRGNUM=3 RTE=0.00 ADDWT 1156NEXTR 4
000090 03 4 RTE=& VLBSZERO= NA ADDWT *
000100 H1 * TABLE 510PAMT+BBETRGNUM=1 RTE=0.00 ADDWT 1156NEXTR 5
000110 H1 5 * RTE=& VLBSZERO= NA ADDWT *
Using H1 as an example, the problem is that the premium ends up being 5% x (hrly rate + meal payment). For example if an employeeu2019s hourly rate in $40.00/hr the rules are giving:
1 hour x $40.00 $40.00
1 meal payment $20.72
Premium 5%x($60.72) $3.04
It should be:
1 hour x $40.00 $40.00
1 meal payment $20.72
Premium 5%x $40.00 $2.00
Any help?
Thanks,
Brent Adams