Pay Formulas
An earning or deduction code worked out by a formula over the pay variables (hours, rate, base_pay, gross, years_of_service ...). Test it, activate it from a date, and change it only by adding a new version: payslips already paid keep the version they used. Set the code's "Worked out as" to Formula to use it.
Where to find it
Address in the console: /hrms/pay-formulas
List · 9 columns · 6 fields on its form · 3 of them required · 5 actions
What the list shows
These are the columns of the list, in the order they are drawn. Any of them can be sorted on, filtered on, hidden, or exported.
| Column | Kind | Field name |
|---|---|---|
| For | Status | element_kind |
| Code | Code | code |
| Code name | Text | code_name |
| Version | Number | version |
| Formula | Code | formula |
| From | Date | effective_from |
| To | Date | effective_to |
| State | Status | state |
| Tested | Yes or no | tested_ok |
The form
What is asked for when a record is created here. Required fields are marked; a choice drawn from a configuration list is one an administrator can extend without a release.
| Field | Type | Choices | Notes |
|---|---|---|---|
| For required | Choice | An earning code, A deduction code | |
| Code required | Text | The earning or deduction code this formula works out. | |
| Formula required | Long text | e.g. round(base_pay / periods_per_year * 0.05, 2), or if(years_of_service >= 5, 150, 100). | |
| Effective from | Date | ||
| Effective to | Date | ||
| What it does | Long text |
What you can do here
Try a formula
Try a formula
Asks for: For* Formula* Employee (optional) Hours Rate Gross so far
Test primary
Asks for: Employee (optional) Hours Rate Gross so far
Activate
Asks for: In force from
New version
Asks for: Starting
Retire
Asks for confirmation: End this version? Payslips already paid keep it.
* required
The rules that apply here
Everything on this screen obeys the platform rules rather than rules of its own. The ones worth knowing before you use it:
- Narrowing a list — search, conditions, sort, totals, export and saved views.
- What may be changed — the five grounds a record may not be edited on.
- Companies and business units — what the switcher above this list is doing to it.
- Creating a record — required fields, where choices come from, and how the number is allocated.
- Importing a spreadsheet — this screen accepts one, and it runs through the same rules as typing.