Topics Map > Human Resource System (HRS) > Benefits Administration

Running the Federal Employee Life Insurance Contributions Query in HRS

Overview

UW Extension has a few employees eligible who are both Federal and State Employees. These employee are eligible to enrolled into Federal Life Insurance and pay a premium each payroll. This query provides UW Extension the ability to identify and report these premiums for each payroll.

Process Considerations:

  • Report should be run after each monthly payroll confirmation.
You may click on the links below to navigate directly to a section:


Instructions

1. Navigate to: Reporting Tools > Query > Query Viewer

2.  Enter UW_BN_FEGLI_PY_CONTRIB into the search criteria and click Search.
Fed Query Search

3.  You are shown the Search Results below.  If you had done a partial search, multiple queries may appear in the list.  If you searched for the specific query you are looking for, you should only see that value below.  To view the query, click the link for Excel.

Fed Query Runt to Excel

4.  Once you click on the Excel link, a new page will open.  On that page, you will enter the Pay Run ID into the Pay Run ID field.

5.  After you choose your PayRun ID, click View Results.

9.2 Fed Enter PayRun ID

6.  Open the query using Microsoft Excel and click OK or Open depending on your internet browser.

Below is an example of Mozilla Firefox.
FEGLI - Pop Up
Below is an example of Windows Internet Explorer 9.
FEGLI - IE Pop UP

7.  Review the results and determine a course of actions if needed.  Note:  An employee will appear on the report with multiple rows for each plan along with employee and employer deductions.  The data appearing in the Excel spreadsheet is:

a.  ID = Empl ID

b.  Name = Employee Name

c.  Empl Rcd#

d.  Plan Type = A list of Plan Type are available in  Plan Types, Benefit Plans, and Payroll Deductions Job Aid in HRS .

e.  Cvrg Date = Coverage date

f.  Eff Date = Deduction date

g.  Group = Pay Group

h.  Pay Period End

i.  Plan = A list of Benefit Plans are available in Plan Types, Benefit Plans, and Payroll Deductions Job Aid in HRS.

j.  Deductn Cd = A list of Deduction Codes are available in Plan Types, Benefit Plans, and Payroll Deductions Job Aid in HRS 

k.  Ded Class = Deduction Class

l.  Curr Dedn = Current Deduction Amount


Sample Report

FEGLI - Excel


Additional Resources

Related KBs:

Get Help

  • Click HERE to contact UW Shared Services - Service Operations Department or HERE for the UWSS IT HelpDesk if you have any issues with these instructions.




Keywords:FEGLI Plan Type 2I 2J 2K 2L FEDBAS FEDA FEDB1 FEDB2 FEDB3 FEDB4 FEDB5 FEDC1 FEDC2 FEDC3 FEDC4 FEDC5 BN, Benefits BN, Benefits   Doc ID:17248
Owner:Joanna B.Group:UW–Shared Services
Created:2011-03-09 19:00 CDTUpdated:2020-08-10 10:02 CDT
Sites:Human Resource System (HRS), UW-La Crosse, UW–Shared Services
Feedback:  0   0