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

Running the Federal Employee Retirement Contributions Query in HRS

Overview

The Federal Employee Retirement Contributions Query is designed to assist UW Extension in reporting contributions to the Federal government by payroll.

Process Considerations:

  • This Query should be run after each payroll has confirmed.
You may click on the links below to navigate directly to a section:

Instructions

1.  Click Reporting Tools → Query → Query Viewer

2. Enter UW_BN_FED_RTMT_PY_CONTRIB into the search criteria and click Search.
U Query Viewer

3.  You are shown the Search Results below.  If you had done a partial search, multiple queries could appear in the list.  Click the link for Excel.

Run 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.  Click View Results.

Enter Pay Run ID

5.  Open the query by clicking the OK or Open depending on your internet browser.

Below is an example of Mozilla Firefox.
Open with Excel
Below is an example of Windows Microsoft Edge.
Federal Retirement - IE Pop Up

6.  Review the results and determine a course of actions if needed.  

  • An employee will appear on the report with multiple rows for employee and employer deductions. 
  • The data appearing in the Excel spreadsheet is:
  1. ID = Empl ID
  2. Name = Employee Name
  3. Empl Rcd# = Employee Record (Job)
  4. Plan Type = Overarching group of benefit plans (ex. Plan Type 10 = Health)
  5. Eff Date = Deduction date
  6. Group = Pay Group
  7. Pay Period End
  8. Plan = The specific Benefit Plan the employee is enrolled in.
  9. Deductn Cd = The code that appears on an employee's payroll check.
  10. Ded Class = Deduction Class
  11. Curr Dedn = Current Deduction Amount
Federal Retirement - Excel

Additional Resources

Related KBs:

Get Help



KeywordsPlan Type 7V CRSR FERS BN, Benefits BN, Benefits   Doc ID17122
OwnerJack R.GroupUW–Shared Services
Created2011-02-28 19:00:00Updated2023-08-02 13:02:45
SitesUW–Shared Services
Feedback  0   0