BN - WED - State Group Life Missing/Incorrect ABBR Report

GENERAL DESCRIPTION:

State Group Life Insurance requires an Annual Benefit Base Rate (ABBR) for the payroll process to accurately calculate the insurance premiums to charge each payroll. When employees are missing an SGL ABBR, the system will revert to annual salary which has not been rounded according to the rules for State Group Life. Benefit Administrators need to review the employee's job and compensation data and update or add an ABBR accordingly.

PROCESS CONSIDERATIONS:
  • This report will return a list of employees with an ABBR of less than $1,000 OR those missing an ABBR for State Group Life Insurance.
  • The ABBR should be entered or fixed prior to the first payroll in which State Group Life Insurance premiums will be charged.  The ABBR effective date cannot be earlier than the hire date on each Employee Record.
  • An SGL or SGL7 ABBR must be added to EVERY active Employee Rcd (Empl_Rcd) to ensure that the SGL premiums will calculate correctly regardless of which Empl_Rcd is marked as the Benefits Primary Record.  If you are missing an ABBR for a date other than the initial date of State Group Life eligibility (i.e. an historical row), you will need to use correction to add the effective dated row.  If you do not have correct history, please contact your AG Group for assistance.
  • HRS will NOT recognize a change in ABBR as an Event requiring Benefits Retro to calculate.  In the event an ABBR has been changed after a payroll has run, a Payline Adjustment will be required to pick up the missing premium.  If you cannot add a Payline Adjustment, please your AG Group for assistance.  Please note:  clicking the WiscIT button will not automatically create a ticket for you in Cherwell.

ANNUAL BENEFIT BASE RATE (ABBR) AMOUNTS:

  • First Year:  Must be based on an estimated annual salary during the first year the employee is eligible for the Wisconsin Retirement System (WRS). 
  • Existing Employees:  The Annual SGL Process will update the ABBR each year based on the prior WRS year's earnings or the highest year of reported WRS earnings, whichever is higher.  Employees who are aged 70 will have an SGL7 ABBR based on 50% of their highest year of reported WRS earnings.
  • Mid-year:  State Group Life ABBR's are NOT changed mid-year due to changes in FTE or annual salary.
  • Transfers:  The State Group Life ABBR must be based on the Transfer Record received from the transferring department/institution. 
  • The SGL ABBR should match the coverage amount on the State Group Life Insurance application submitted to the Department of Employee Trust Funds.  An SGL ABBR amount is required to submit eBenefits enrollments to the Department of Employee Trust Funds.



PROCEDURE STEPS:

1.   Log into HRS.  The Workflow Exception Dashboard queries will appear based on your current security and whether there is an error to fix.

2.  Click on the hyperlink for the UW_BN_SGL_ABBR query.


9.2 SGL ABBR Query

3.  A current list of employees who are missing an SGL ABBR or who have an ABBR of less than $1,000 will be displayed. This list will be refreshed each evening.  (Note:  Empl_ID's that appear as hyperlinks in the list have more than one error.  This often occurs if the employee has a missing or incorrect ICI ABBR as well as the SGL error.)

4.  Click the Check to Claim checkbox next to the employee you wish to work on.  Your name will appear in the Claimed By section with the date and time noted.

9.2 SGL Claimed By


5.  Click the BN_ANNL_BENEF_BASE hyperlink for the employee you have claimed.  


9.2 Link to Correct


6.  The employee's Update ABBR page will be displayed.  Click on the magnifying glass icon to select the ABBR type of SGL or SGL7 depending on whether your employee is under or over age 70.


9.2 Choose ABBR type


7.  To ensure that the correct ABBR is entered, you will need to navigate to the employee's JOB Data pages to obtain the date they became eligible for SGL and their annual salary.  Click the "New Window" hyperlink in the top right corner of your screen to open a second window to obtain this data.


9.2 New Window


8.  Navigate to Workforce Administration > Job Information > Job Data and enter the employee's Empl_ID and click Search.

9.  On the Work Location Tab verify the employee's SGL eligibility date.  In our example, the employee became eligible for WRS as of the Date of Hire. 


9.2 SGL DOH


10.  Click on the Compensation tab to obtain the employee's estimated annual salary which is the basis for the SGL ABBR for initial hires.  In this case, the salary needs to be rounded up to the next highest $1000.  For an annual salary of $35, 360 the ABBR that should be entered into HRS is $36,000.  (For an example of multiple jobs, Empl Rcd 0 salary of $14,300.00 and a Empl Rcd 1 salary of $14,500.00 are added together and rounded up to the nearest thousand to become $29,000.00.)


9.2 Annual Salary


11.  To add the employee's ABBR, click back on your Update ABBR window, or navigate to Benefits > Employee/Dependent Information > Update ABBRs

12.  Enter SGL or SGL7 in the Annual Benefit Base Rate Type field depending on the age of the employee.  The Effective Date used must be equal to or prior to the deduction effective date of their State Group Life enrollment.  In our example, we are adding an ABBR Type of "SGL," an Effective Date of "9/8/2016" (which is the date of hire) and an ABBR amount of "36000".  (Please note:  do not use commas or decimal points when entering an ABBR.  The system will add these for you when you save.)  When all information has been added, click the Save button to save the record.


9.2 Add an ABBR


13.  To verify that you now have the correct SGL ABBR entered into the system, navigate back to Benefits > Employee/Dependent Information > Review ABBRs.  Enter the employee's ID number in the Empl_ID field and click Search.  You should see the ABBR listed with the correct Base Rate Type, Effective Date, and Amount.


9.2 ABBR Verified

14.  Navigate back to the WED and click the Completed checkbox next to the employee's record you have fixed.  Your name will appear in the Completed By section with the date and time noted.  The employee's record will fall off the WED the next business day.


9.2 Completed By



ADDITIONAL RESOURCES:

Related KBs:

Related Links:






Keywords:Annual Benefit Base Rate State Group Life WRS Earnings Life Insurance benefits deductions premiums rates UW_BN_SGL_ABBR 2M 2N 2O SGL SGL7   Doc ID:46905
Owner:Joanna B.Group:Human Resource System (HRS)
Created:2015-02-06 10:24 CDTUpdated:2017-05-15 09:43 CDT
Sites:Human Resource System (HRS)
Feedback:  0   0