TNP Reporting Manual logo TNP Reporting Manual

Scope

A record of each of the licensee’s drivers who is paid an hourly rate, and any other record needed to capture actual TNP driver pay information that is not reflected in licensee’s hourly rate compensation records.

TNP companies may apply different compensation schemes. Therefore, some columns may be 0 for all records because those elements are not used.

File Format

Compensation data must be reported using the following schema and reported with the following [company]-compensation-[date].csv.

Field Element Data Type Required Description
NEW COMP1 Driver’s license number String Yes The driver’s license number of the TNP driver for this record. This number must correspond with driver’s license number listed in field D2.
NEW COMP2 Driver’s license state ISO 3166-2 abbreviations Yes The state issuing the driver’s license that is listed in COMP1. The license number and license state combination should correspond to the fields D2 and D3.
NEW COMP3 Total Fares Numeric Yes Total fares from all passenger trips collected over reporting period.
NEW COMP4 Hourly Pay Numeric Yes Total of any hourly rate paid to the TNP driver, exclusive of all other compensation during reporting period.
NEW COMP5 Trip Pay Numeric Yes Total TNP driver trip pay as reported in the trips data (not including tolls or tips and net of fees and taxes taxes) over reporting period.
NEW COMP6 Tips Numeric Yes Total amount of tips received from passengers over reporting period.
NEW COMP7 Other Compensation Numeric Yes Total value of any other compensation that is not reflected by any other fields in this dataset, including incentives, bonuses and any other payments.
NEW COMP8 Vehicle Payment Deduction Numeric Yes Total deductions for pay to cover TNP vehicle payments.
NEW COMP9 Gas Deduction Numeric Yes Total deductions from pay to cover gas expenses.
NEW COMP10 Cleaning Deduction Numeric Yes Total deductions from pay to cover cleaning fees.
NEW COMP11 Other Deduction Numeric Yes Total deductions from pay for other expenses.
NEW COMP12 Driver Net Pay Numeric Yes Total TNP driver net pay including bonus payments and subtracting deductions.
NEW COMP13 Report Period Start Date ISO 8601 Yes Start date of reporting period for pay/incentives/deductions.
NEW COMP14 Report Period End Date ISO 8601 Yes End date of reporting period for pay/incentives/deductions.