Job Rate Indices (Column 66)

Job Rate Indices, EMPJOB_RATE_INDEX, which indicate how an employee is to be paid for a particular job, are listed in field column 66. 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 Standard HR Refresh interprets the value as an actual job rate. This job rate along with the job code (EMP_JOB) is referenced against the JOB_RATE table to obtain the Job Rate Index, which is written to the field.

For example, if the JOB_RATE table contains this entry:

Job Code: RN

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

Then, for the imported employee record, the job code field was passed a value 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.