Job rate indices

Job rate indices, EMPJOB_RATE_INDEX, indicate how an employee is to be paid for a particular job. Similar to how the job codes are listed, the job rate indices in this field are also listed in sequence and separated by a tilde (~) symbol.

For example:

3~5~2……

The number of indices received must equal the number of jobs listed for the employee. That is, an employee should not have a job code without a valid job rate index. If the number of job rate indices does not match the number of jobs supplied, an error message is logged.

If the import values for the job rate indices are prefixed with a dollar symbol ($), the Employee Import interprets the value as an actual job rate. This job rate along with the job code (EMP_JOB) are referenced against the JOB_RATE table to obtain the job rate index. This index is written to the field.

For example, the JOB_RATE table contains this entry for the RN job code:

Level Rate/Hour
1 $15.00
2 $18.00
3 $23.00

For the imported employee record, assume the job code was passed a value of RN and the job rate index was passed a value $18.00. The actual value stored in the employee's job rate index is 2.