How to do the slab system

Question

Hi,

I have slab system. for period of one year.

1- 0 to 14 .................. 0 percent ded

2- 15 to 29 .................. 25 percent ded

3- 30 to 44 .................. 50 percent ded

4- 45 to 59 .................. 75 percent ded

5- 60 to 74 .................. 75 percent ded

if employee absent more than 14 days then start deduction.

for example if employee absent 30 days

then apply slab. for 1st 14 days is no deduction, next 14 days 25 percent deduction and next 2 days 50 percent deduction.

below is example.

1- 0 to 14 (0%) .................. no deduction

2- 15 to 29 (25%) .................. 14 days

3- 30 to 44 (50%) .................. 14 days

4- 45 to 59 (75%) .................. 2 days

5- 60 to 74 (100%) .................. 0

i was thinking having a table whatever deduction then add in the tables.

Absent_No - numeric

Absent_EmployeeFromDate --date

Absent_EmployeeToDate --date

Absent_DeductionDays - numeric

Absent_SlabNo - numeric

Absent_EmployeeNo -numeric

but in next time if employee absent once again absent 15 days.

if i search the date in attendance then i will get total 30 before absent and now 15 days. (total 45 days)

then slab will apply below.

1- 0 to 14 (0%) .................. 0 percent ded

2- 15 to 29 (25%) .................. 14 days

3- 30 to 44 (50%) .................. 14 days

4- 45 to 59 (75%) .................. 2 already deduc + now 12 days deduction as 75%

5- 60 to 74 (100%) .................. 3 deduction as 100% Days

how to do this, please help on this.

also note that the no. of absent will come from Attenance Table.

 

Thanks

Basit.