janicej
Well Known Member
I need some help from the HR/Payroll gurus out there. Oracle support, as usual, has been totally unresponsive.
We have a 457(k) deferred compensation program where the employer matches the employee’s contribution 1:1 up to a limit of X dollars, depending on the benefit group. Someone who must hate me negotiated a change for 2007 so that now the employer match will be the greater of X dollars or 3% of base annual salary. So, there is the potential for the second limit to be different for every position. To makes matters more complicated, these DBAs are part of a group limit because of the IRS limitations on annual contributions.
I was able to come up with a DBA that calculates correctly for a single salary by using a calculation table with two limits. But, I’m thinking I need a way to come up with a variable second annual limit or set the limit at the employee level. I tried putting the second limit in the employee’s DBA record, but according to documentation, a limit set in a calculation table supersedes one set in the DBA or the employee master. It definitely doesn’t work.
Has anyone got any experience at calculating this type of benefit? I appreciate any and all tips and ideas.
We have a 457(k) deferred compensation program where the employer matches the employee’s contribution 1:1 up to a limit of X dollars, depending on the benefit group. Someone who must hate me negotiated a change for 2007 so that now the employer match will be the greater of X dollars or 3% of base annual salary. So, there is the potential for the second limit to be different for every position. To makes matters more complicated, these DBAs are part of a group limit because of the IRS limitations on annual contributions.
I was able to come up with a DBA that calculates correctly for a single salary by using a calculation table with two limits. But, I’m thinking I need a way to come up with a variable second annual limit or set the limit at the employee level. I tried putting the second limit in the employee’s DBA record, but according to documentation, a limit set in a calculation table supersedes one set in the DBA or the employee master. It definitely doesn’t work.
Has anyone got any experience at calculating this type of benefit? I appreciate any and all tips and ideas.