Remuneration fields on JOBHIST

The four remuneration fields on JOBHIST

The Remuneration tab of employment history (JOBHIST) shows the employee's base schedule and hours

In addition it shows 4 salary fields:

  1. Hourly rate
  2. Salary per pay period
  3. Annual pay
  4. Annual Full Time Equivalent (FTE) pay
    (What the employee would earn if they were full time)

These salary fields are interrelated; when you change one of these values, the others change too. The calculations for those other fields are sometimes subtle (usually due to rounding) but the whole thing is configurable.

These fields are kept in JOBHIST, but are encrypted in the data base. To show them on a report use functions:
SALARY(), UNITRATE(), ANNUAL(), ANNUALFT()

Is there a primary rate field?

No, but...

  • When rates are applied from the rates table (for example, when an employee changes job), one rate is specified therein, and the others are calculated using the rules below. Which rate is used in defined in the Remuneration Plan.

  • The Hourly rate is used for all payroll calculation.

Pay Periods Per Year

The actual number of pay periods can vary from one year to another. For JOBHIST and calculating hourly rates it is important to use the average.
The number used in calculations below is taken from the PERIOD table. The usual number of periods for a weekly pay is 52.1786.

For tax calculations, Umana uses the number of pay periods in your pay calendar in the current year. (Special periods and periods > 60 are not counted.)

When the hourly-rate changes

1. The salary-per-period is recalculated:
= hourly-rate hours-per-week weeks-per-period

2. The Annual and Annual-FTE rates are calculated from the per-pay salary the multiplier in the period table.

When the salary-per-pay changes

1. The hourly-rate is recalculated:
= salary-per-pay / (hours-per-week weeks-per-period)

 If you have configured [x]Prevent impossible salary/period
then the salary-per-periods will subsequently be recalculated from the hourly rate to to prevent rounding errors. See OPTIONS > Employment

2. The Annual and Annual-FTE rates are calculated from the per-pay salary x periods-per year.

When the Annual or AnnualFTE amount changes

1. The Annual or AnnualFTE is calculated from the one that changed

2. The Salary-per-pay is recalculated: = Annual / periods-per-year

3. The Hourly pay is calculated from that (as above when the salary-per-pay changes)


© Carver Technologies, 2024 • Updated: 06/24/21
Comment or report a problem with this topic