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, ...
Note: The ampersand (&) character must be used to "blank" the Flag and UDF fields.

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.