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 to adjust your data.
6.Once validation is successful, click Import to create or update your records based on the reference code alignment.
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 if the pay is guaranteed (YES) or performance-based (NO). |
Enum: YES, NO. |
|
referenceCode |
Reference Code |
Unique identifier for the driver associated with the pay rate. |
Matches the reference code in the Driver Template (e.g., DR001). |