How To: Use Report Column Filters
Column filters allow you to filter report data in a variety of different ways depending on the operator used.
= (Equals) - Allows you to filter to an exact match.
!= (Not equal) - Allows you to exclude an exact match from the filtered results.
Starts with - Allows you to filter by the beginning of a search term and will return any results with the same start.
Not starts - Allows you to filter out by the beginning of a search term and will return any results without the same start.
Like - Allows you to match a specified pattern within the data. It allows for partial matches, meaning you can filter for values that contain a certain word or substring.
Not like - Allows you to filter out a specified pattern within the data. It allows for partial matches, meaning you can filter out any values that contain a certain word or substring.
In - Allows you to filter data by determining if a column's value matches any value in a comma separated list.
Not in - Allows you to filter out data by determining if a column's value matches any value in a comma separated list.
Is null - Allows you to filter to columns without any data.
Is not null - Allows you to filter out columns without any data.
Between - Allows you to filter to data that falls within a range of two numeric values.
Not between - Allows you to exclude data that falls within a range of two numeric values.
Popular Articles
How To: Add Workflow Delegation for Backup Approval
If a manager/approver is out of the office for a period of time, Workflow Delegation can be set up to assign a different manager to handle approvals during their absence. Delegations can be add by the employee prior to their absence or by the Admin ...How To: Enter a Manual Check
Enter the Payroll Prep for the next scheduled payroll date Select View Pay Statements in the Add/Edit Pay Statements Payroll Prep step. Do not Initiate Payroll or Sync Time Select New Pay Statement Create a new pay statement using the Manual Pay ...How To: Submit a New Tax Withholding Form
Changes to withholding form, such as the IRS Form W-4, can be initiated directly in the system by an employee and approved by HR. Once processed, all changes will be automatically updated on the employee record and applied to the next payroll ...How To: Enroll in Benefits For Life Change Event
To enroll in benefits as the result of a life change event, such as the birth of a child, adoption, marriage, divorce, etc. select Start a new life change event on the My Benefits widget: You may also navigate to My Benefits > Enrollment > Life ...How To: Consent to Electronic Year-End Form Delivery (W2 or 1099)
To grant consent for electronic year-end forms, navigate to My Info > My Pay > Forms > W2 or 1099-NEC Click the Electronic Consent button Check the box to Receive Form W2 Electronically and confirm the update with your password Once you have ...
Related Articles
How To: Export a Report
To export a report, click on the three dot icon and click Export... A list of available export file formats is available in the File Format dropdown. The Display Header/Footer checkbox will include a header in the exported file. This header displays ...How To: Sort A Report
The columns in every report can be sorted or Multi-Column sorted. On the field you wish to sort, hover your mouse on the right hand side of the field header. Click the arrows once to sort in an Ascending (low to high) order. Click twice to sort in a ...How To: Run a Payroll Comparison Report
To help you easily track whether totals for the current payroll are in line with previously finalized payrolls, the system has a Payroll Comparison report. This report is available in your pre-process View Reports section of the Payroll Prep ...How To: Run a Benefit Census Report
To report on employees enrolled in benefit plans, navigate to Benefits / Benefit Plans The Benefit Census Report includes benefit enrollments as well as employee level information, such as SSN, Gender, Salary, etc. Each Benefit Plan should be added ...How To: Add and Remove Columns in a Report
Reports are created from specific views and columns can be added or removed from the view prior to saving the report. From a system view, click on the three dot ellipsis in the view and choose Add/Remove Columns... A list of available columns will be ...