What operators are supported for filtering the Earnings API
The following operators are supported to filter data on the Earnings API. The Earnings API interacts with employee-level recurring earnings in the Payroll/HR module. These earnings apply to each paycheck for the employee. The most popular filtering is done by earning code. The code field represents earning code. Sample earnings for an employee are CAR (car allowance), CELL (cell phone allowance), or ERMED (employer-paid medical). Earning codes can be customized per client. Use the Company Codes API to retrieve a list of valid earning codes.
| Field | Supported Operator |
|---|---|
| code | eq,ne,in,sw,ct |
| frequency | eq,ne,in,sw,ct |
| selfInsured | eq,ne |
| amount | eq,ne,gt,ge,lt,le,in |
| rate | eq,ne,gt,ge,lt,le,in |
| calculationCode | eq,ne,in,sw,ct |
| units | eq,ne,gt,ge,lt,le,in |
| rateCode | eq,ne,in,sw,ct |
| agency | eq,ne,in,sw,ct |
| miscellaneousInfo | eq,ne,in,sw,ct |
| effectiveDate | eq,ne,gt,ge,lt,le,in |
| effectiveFrom | eq,ne,gt,ge,lt,le,in |
| effectiveTo | eq,ne,gt,ge,lt,le,in |