Selected category
|
Selected base table
|
Selected tables (Available tables)
|
Selected fields
|
Order
|
HR - Employment profile
|
Banks
|
Banks
|
Bank*
|
N/A
|
Employee number
|
4
|
Base year
|
6
|
Accrual %
|
7
|
Balance (Amount or quantity)1
|
8
|
Balance on termination (Amount or quantity)2
|
9
|
Employment and compensation
|
Employee status*
|
N/A
|
Employment and compensation > personal information
|
Complete name
|
5
|
Employment and compensation > company
|
Company*
|
N/A
|
Company short description
|
1
|
Employment and compensation > Positions > Division
|
Division
|
2
|
Division description
|
3
|
* These fields have been selected as “filters only” (by clicking on the  icon during creation). 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
|
2
|
And
|
Banks (Banks)
|
Equal (=)
|
305
|
3
|
And
|
Base year (Banks)
|
Larger or equal (>=)2
|
|
4
|
And
|
Company (Company)
|
Equal (=)3
|
|
Groups:
|
Selected fields
|
Company short description (Company)
|
Division (Divisions)
|
Sort:
|
Fields
|
Order
|
Division (Divisions)
|
Ascending
|
Employee number (Banks)
|
Ascending
|
Base year (Banks)
|
Ascending
|
Equation:
|
Fields
|
Equation
|
Balance2 (Banks)
|
Amount
|
Termination balance2 (Banks)
|
Amount
|
1 Amount or quantity depending on your company file’s configuration.
2 During creation, the field has been left blank and during production of the report, we have selected the requested year.
3 During creation, the field has been left blank and during production, we have selected the requested company.
|
