Canon T3i 18.0MP Digital SLR Camera with 18-55mm IS Lens - Digital (Google Affiliate Ad)
HCM 9.1
PeopleTools 8.51.08
Requirement:
Enroll employees into Savings plans where they want to contribute upto the maximum limit set by IRS, but at the same time, distribute the deduction amount over the remaining pay periods of the calendar year.
Here are some of the actual SQLs which I wrote for my requirement, but can easily be tweaked for any specific case.
/*Get IRS defined limit for 402g = A */
SQLExec("SELECT DED_YTD_MAX FROM PS_LIMIT_TBL A WHERE A.LIMIT_TYPE='402' AND A.EFFDT=(SELECT MAX(B.EFFDT) FROM PS_LIMIT_TBL B WHERE A.LIMIT_TYPE=B.LIMIT_TYPE)", &l_MaxIRSLimit);
/*Get Prev Employer contribution to 401k if any = B */
SQLExec("SELECT DED_ADJ FROM PS_SAVINGS_MGT_EE WHERE EMPLID=:1 AND COMPANY=:2 AND CALENDAR_YEAR=:3 AND LIMIT_TYPE='402' AND LIMIT_EXT_TYPE='A'", xxx_AET.EMPLID, xxx_AET.COMPANY, &CurrCalYear, &l_401k_AdjAmtPrevEmployer);
/*Get current year YTD balance = C */
SQLExec("SELECT DED_YTD FROM PS_DEDUCTION_BAL WHERE EMPLID=:1 AND PLAN_TYPE IN (40,46) AND DED_CLASS='B' AND COMPANY=:2 AND BALANCE_ID='CY' AND BALANCE_YEAR=:3 AND BENEFIT_RCD_NBR=:4 ", xxx_AET.EMPLID, xxx_AET.COMPANY, &CurrCalYear, xxx_AET.BENEFIT_RCD_NBR, &l_401K_CurrYrYTDBal);
/*Calculate remaining pay periods for this year = D */
&l_RemainingPayPeriodsThisYr = 8;
/*Perform (A - B - C)/D */
&l_401kDedAmount = (&l_MaxIRSLimit + &l_401k_AdjAmtPrevEmployer + &l_401K_CurrYrYTDBal) / &l_RemainingPayPeriodsThisYr;
/*Call the Savings Plan Component Interface to insert a new row
Name of the component - SAVINGS_PLANS*/
Some useful navigations related to this requirement:
Main > Benefits > Enroll in Benefits > Savings Plans (Employee deductions for enrolled plans)
Main > Benefits > Enroll in Benefits >
(Employee deductions that have already happened e.g. 401k contribution at previous employer)
Main > Set Up HRMS > Product Related > Base Benefits > Rates and Rules > Limit Table
(define IRS limit for 402g deductions)
No comments:
Post a Comment