0
Former Member
Jul 02, 2010 at 08:33 PM

175 Views

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

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:

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

And we modified ZALQ to create the meal payments on the time which also qualifies helicopter premium:

000010 TABLEALP NEXTR

000020 1 D VARGBPRAKN

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

It should be:

1 hour x \$40.00 \$40.00

1 meal payment \$20.72