MSU Human Resources >> Ebshelp >> Using-the-ebs-portal >> Working with Tables


Personalizing Report Criteria

Information in the HR/Payroll screens of the EBS Portal are frequently shown in a table format, which is a condensed way to show complex or large amounts of data. Below are tips for working with this format.

Getting Help

Often in form fields, using the help icon Help Icon on a field (or F4 key) pops open a window where you can search for entries. Often these searches return more results than desired. Rather than searching again, the results can be sorted to find the desired choice, as demonstrated in the lower left screenshot

sample search screen   another sample search screen

Some screens (above, right) can jump to a specific option by looking for specific text, like “AP” then clicking the binocular. The columns can also be sorted by clicking to the right of the column label.

Narrowing it Down

Like help lookups, other screens present options which are structured in a table. To help you find the correct row to select, the table can be sorted and filtered by clicking the heading of the table. 

example of sorting of a table 

another example of sorting a table

A Special Case for Selecting Rows

Several reports in Supervisor Tools present a list of employees in a table. Often, supervisors arrive at this screen and expect the details of the report. First, they must choose which employees to include in the report results. The table has a frequently overlooked option in the upper left select all icon  to select all employees at once (you can also use the control or shift keys with the mouse to select multiple individual rows or a range of rows).

screenshot of table where all rows can be selected 

Report Results

Once information is returned to the screen it may be formatted in a table. There are often options to sort, filter, download, search, and view more details.

Sorting, Filtering, and Downloading

Many tables have a toolbar that allows for sorting, filtering, and other options. Below an example from the HR Forms Workflow Report.

table toolbar

Using Position Details and Relationships, the filter filter table icon and download download table icon options look different. 

download and filter example 

The same data from Edit Reporting Relationships is shown, with a filter option, as well as options to change the view, and add a new record.  

table view example 

More Detail by Double-Clicking

Some tables allow  you to see more detail by double-clicking a row in the table. Again, looking at the Quota Balance Report under Supervisor Tools.

table row that allows double clicking

Double-clicking a row brings up additional detail on the record. 

time entries report screen 

The option is also available in the HR Forms Workflow Report; double-clicking brings more details (see below.)

double click on form process step

More Detail by Scrolling

In Recorded Time Entries for Unit, the clue that there is more information is the scrollbar at bottom.

screenshot of scroll bar 

Scroll right to see additional columns, which are frequently overlooked, like these.

screenshot of additional columns 

Summary

Carefully exploring the screens you use to see what options are available can help you be more productive. Use these tips to see if you can improve the effectiveness of using HR and Payroll applications. 

©