Driver Pay Rate Import Template
The import schema and attribute descriptions for the driver pay rate .csv import file
Instructions for Use
1.Navigate to the Bulk Import section by clicking the Add Item button (➕) on the main navigation bar.
2.Download the import template from the Bulk Import section of LoadAi for the relevant object, or use your own spreadsheet.
3.Prepare your data and upload the completed file.
4.If you’re using your own template, you may need to manually select the object you are mapping. If you use the LoadAi Sample Template, columns will be auto-identified and auto-mapped.
5. Review the column mapping and click Validate to check for warnings or errors. If corrections are needed, download the validation report, correct the errors in your file, and re-upload.
6. Once validation is successful, click Import to create or update your records. Records are matched and updated based on the referenceCode field.
The table below describes all required and optional columns for the Driver Pay Rate import file. Each row corresponds to one driver pay rate record.
Data Schema
Column Header |
Attribute |
Description |
Requirements |
|---|---|---|---|
|
payAmount |
Pay Amount |
The amount paid to the driver, expressed as a flat amount, percentage, or per-mile rate. |
Numeric for flat rates and per-mile pay, percentage for revenue share (e.g., 1.1, 50%). |
|
payDescription |
Pay Description |
Description of the pay type or the circumstances under which it applies. |
Plain text. |
|
payOperationMode |
Pay Operation Mode |
Indicates whether the pay applies to SOLO or TEAM operation mode. |
Enum: SOLO, TEAM. |
|
payType |
Pay Type |
The method of payment, such as flat rate, per mile, or revenue share. |
Enum: Flat Rate, Per Loaded Mile, Revenue Share. |
|
payUnit |
Pay Unit |
Indicates whether the pay amount is guaranteed regardless of performance (YES) or only paid upon meeting performance criteria (NO). |
Enum: YES, NO. |
|
referenceCode |
Reference Code |
Unique identifier for the driver associated with the pay rate. |
Must match the reference code in the Driver Template exactly (e.g., |