CSV import file format

The CSV import file for the Job Rate Import Interface contains two types of record formats:

Job Format

Code (J), Job Name, Job Description, Start Date, End Date, …

Job Rate Format

Code (R), Job Name, Job Rate Index, Rate, Effective Date, ...

Therefore, in the CSV Job Rate Import file:

1. Job records have a J identifier.
2. Job rate records have an R identifier.

Job and Job Rate records are paired together by the job_name field. You can have a Job (J) record without a Job Rate (R) record (that is, you are just importing a Job definition). For each Job Rate (R) record, an existing Job definition must already exist in the application. For an example, see Job Rate Import CSV sample file.