Topics Map > Human Resource System (HRS) > Benefits Administration
Running the Benefit Email Query in HRS
Overview:The Benefit Email Query is designed to give Administrators the ability to identify employees who received benefit emails on a particular day for their business unit.
- The query requires an Administrator to enter Business Unit and Date.
- The "Query Result Set too Large" message will appear if query results are greater than 8,178.
- The full email message can be viewed on the Mail Retrieval Page.
1. Click Reporting Tools > Query > Query Viewer
2. Enter UW_BN_EMAIL into the search criteria and click 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.
4. A prompt window will open. On that page, enter the Business Unit and Date Sent you want to run the report for. You can also search for the Business Unit by clicking on the magnifying glass next to the field. After you choose your business unit, click View Results.
5. Open the query using Microsoft Excel and click OK or Open depending on your internet browse.
Below is an example of Mozilla Firefox.
Below is an example of Microsoft Edge.
Review the results. Note: An employee may appear on the report with multiple rows for separate email messages.
- Empl ID = Employee's ID Number
- Name = Employee's Name
- Unit = Business Unit
- Dept ID = Department ID Number
- Date Sent = Date the email was sent
- Email Address = Employee's email address
- Email Subject = The email subject line
The following message will appear if query results are greater than 8,178.
- Annual Benefit Enrollment Communications
- Income Continuation Insurance Communications
- State Group Life Annual Update Communication
- Summer Prepay Communications