DBA Table ITD Limit
HERE IS THE SCENARIO:
Two groups of employees with different standard hours per day:
- Group 1 Employees work 8:00 hours per day
- Group 2 Employees work 7:00 hours per day
SICK TIME ACCRUAL RULES
- Group 1 accrues 12 hours sick time per month, which reflects 1.5 day per month (STD 8 Hrs/day * 1.5 = 12 H)
- Group 1 accrues 10.50 hours sick time per month, which reflects 1.5 day per month (STD 7 Hrs/day * 1.5 = 10.50 H)
Currently setup using two different DBAs for accruing sick time. In redesigning the DBA architecture, I would like to shrink those two Accrual DBAs into one only which makes it seamless when an employee switches from one group to the other since we would have only one Sick Accrual DBA structure rather than two.