Selected category
|
Selected base table
|
Selected tables (Available tables)
|
Selected fields
|
Order
|
HR - History
|
Payments history
|
Payments history
|
Earning / deduction code*
|
N/A
|
Company*
|
N/A
|
Payment date*
|
N/A
|
Employee number
|
2
|
Transaction amount
|
4
|
Employment and compensation
|
Employee status*
|
N/A
|
Employment and compensation > Personal information
|
Complete name
|
3
|
Company
|
Company short description
|
1
|
Company earnings and deductions
|
Earning / deduction description1
|
N/A
|
* These fields have been selected as “filters only” (by clicking on the  icon during creations). They are used to filter data but do not appear on the report.
Default filters:
(Conditions)
|
Filters
|
And / Or
|
Field(s) and condition(s) applied
|
Criteria
|
Values
|
1
|
|
|
Employee status (Employm./compens.)
|
Equal (=)
|
Active
|
Or
|
Employee status (Employm./compens.)
|
Equal (=)
|
Vacation
|
2
|
And
|
|
Earning / deduction code (Payment hist.)
|
Equal (=)
|
G1
|
Or
|
Earning / deduction code (Payment hist.)
|
Equal (=)
|
G43
|
Or
|
Earning / deduction code (Payment hist.)
|
Equal (=)
|
G771
|
3
|
And
|
|
Payment date (Payment hist.)
|
Greater or equal (>=)
|
|
4
|
And
|
|
Company (Payment hist.)
|
Equal (=)2
|
|
Calculation in columns configuration:
|
Field in columns:
|
Earning / deduction description (Earnings/deduct.)
|
Calculated field:
|
Transaction amount (Payment history)
|
Calculation type:
|
Sum
|
Selection of totals’ levels:
|
Fields
|
✓ |
Earning / deduction description (Earnings/deduct.)
|
✓ |
Company short description (Company)
|
|
Employee number (Payment hist.)
|
Sort:
|
Fields
|
Order
|
Company short description (Company)
|
Ascending
|
Employee number (Payment hist.)
|
Ascending
|
1 “In columns” field.
2 During creation, this field has been left blank and during production, we have selected the required company.
|
