Calculating employee job rates
Employee job and job rate data in the application have date attributes for date effectiveness. For a calculation day, each job that the employee has worked must be calculated according to employee_job records (if any are defined). If the employee does not have jobs, the base rate is applied.
Example
If the employee has these jobs:
| Job | Employee | Start Date | End Date | Job Rate Index |
|---|---|---|---|---|
| Job 1 | Emp 1 | 01/01/1900 | 01/01/2000 | 1 |
| Job 1 | Emp 1 | 01/02/2000 | 01/01/3000 | 2 |
And the jobs have these rate indices:
| Job | Job Rate Index | Effective Date | Rate |
|---|---|---|---|
| Job 1 | 1 | 01/01/1900 | $10 |
| Job 1 | 1 | 01/02/2000 | $11 |
For 01/01/2001, the rate will be $11.
Here are the employee's work details for 01/01/2001 before job rates are applied (the employee's base rate is $10):
| Start Time | End Time | Tcode | H Type | Job | Rate |
|---|---|---|---|---|---|
| 10:00 | 18:00 | WRK | REG | Job 1 | $10 |
| 18:00 | 19:00 | WRK | OT1.5 | Job 2 | $15 |
Here are the employee's work details for 01/01/2001 after job rates are applied:
| Start Time | End Time | Tcode | H Type | Job | Rate |
|---|---|---|---|---|---|
| 10:00 | 18:00 | WRK | REG | Job 1 | $11 |
| 18:00 | 19:00 | WRK | OT1.5 | Job 2 | $15 |
Since the employee is on Job 1 as of 01/01/2001 and the rate of Job 1 as of this date is $11, the employee's 10:00-18:00 rate is changed to $11.
Note: No job rate calculation is performed for job=0 and any employee job/job rates with jobRateIndex=0. For others, if no valid job rate is found for the employee and job rate calculation is set up in the rule (rateType=JOB), a "No valid job rate error found" error is displayed for the calculation date.