cancel
Showing results for 
Search instead for 
Did you mean: 

Payroll rules - Premiums

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member193210
Active Contributor
0 Kudos

We have not implemented premiums from CAT2 (and it may be something we could use), but I think that you could solve your problem if you were to create a temporary variable (or a second WT) in order to calculate the 5% premium only on the base salary.

If the attendance generates a basic salary WT (BASE) and the premium code generates either a separate WT (MEAL or HELI) or a single WT (MEAL) plus a temporary variable (&HELI), then you should be able to add 5% to WT BASE in an other PCR.

Personnaly, I would use a constant from V_T511K to hold the value of the "Inspection by helicopter" premium since it would then be easy to delimit any change in the future.

Answers (2)

Answers (2)

Former Member
0 Kudos

I changed the order of some of the rules and that seemed to do the trick.

Former Member
0 Kudos

Thanks for the reply and we are, in fact, using a separate WT for the 5% premium. But somehow that WT (WT1141) is getting the 5% premium plus the meal payemt amount of $20.72.

former_member193210
Active Contributor
0 Kudos

Generate a Payroll Simulation "With Protocol" for an employee, and expand your protocol to search for WT 1141 to fond out where it is generated and where it's amount changes.