CSV exportsData specification

Export data specifications

Target audience: This feature is for clients accessing exports of users and enquiries in the Gensen salary sacrifice system.

Introduction

This document outlines the user and enquiries export data specification for the salary sacrifice (“SS”) quotation platform. Exports are supplied as CSV files that conform with RFC 4180. To summarise and clarify:

  • Files include a header line that denotes the field headings as defined below

  • The character encoding used is UTF-8

  • Separator character: ,

  • Quote character: “

User specification

Field heading

Data type

Description

Example(s)

user_idstringWe use the Auth0 ID in our systems”auth0|65437kkd0s34d7d4659a8ed7”
given_namestringThe given/first name of the userJake
family_namestringThe family name/surname of the userSmith
emailstringThe user’s email addressjake@example.com
phone_numberstringThe phone number the user has added. We don’t format it before sending it to you so it may vary.

+447777777777
077 7777 7777

date_registereddatetime1Date and time the user signed up2013-09-17T19:00:00.000Z
employerstringThe name of the employer and (plan ID)Acme Inc (153)
terms_agreedboolean2If the user has agreed to the terms & conditions of the site, should always be truetrue
marketing_email_consentboolean2If the user has selected to sign up for email marketingfalse
marketing_sms_consentboolean2If the user has selected to sign up for text marketingtrue
internal_userboolean2

Set if the user is an internal user or a dummy account in the platform, (e.g. a sales staff or marketing exec) and should not be contacted.

false

Enquiry specification

Field heading

Data type

Description

Example(s)

quote_refnumberThe quote identifier66953
employeestringThe full name of the userJake Smith
age_at_enquirynumberThe age of the user when they submitted the enquiry35
postcodestringThe postcode the user resides inG1 7AB
residencyResidency3The country the user resides inScotland
tax_bandTax Band 4The tax band the user’s income falls underBasic
makestringThe make or brand of the vehicleFord
modelstringThe model of the vehicleExplorer
derivativestringThe derivative the user has requested3.0 Petrol Titanium 5dr SUV
optionsstringA list of options the user has requested (each option presented on a new line within the cell). Set to ‘Default configuration’ if no option customisation have been set.Leather - Black with grey double stitching - Interior (148258)
Bodypanels in special solid paint - Exterior Features (148153)
TRIDION safety cell in lava orange - Exterior Features (107525)
fuel_type

Fuel Type 5

The type of fuel the vehicle uses.Petrol
list_pricenumber | empty6The P11D value of the vehicle (in £). This includes any options selected.32000
co2_emissionsnumberThe emissions in CO₂ the vehicle emits300
zero_emission_rangenumber | empty6The WLTP EV range of the vehicle in miles. May be ommited if the vehicle does not have an EV range.245
term_yearsnumberHow long the lease term lasts in years3
mileage_per_annumnumberHow many annual miles the user has requested in the contract100000
estimated_delivery_datedate | empty6If a date has been passed into Gensen for a special offer vehicle, the date gets returned here as an estimate the user has been shown2021-09-16
rental_ex_vatnumberThe quoted rental price (in £) excluding VAT and early termination protection453.59
maintenance_ex_vatnumber | empty6The quoted maintenance cost (in £)19.67
insurance_monthlynumberThe quoted insurance cost (in £)149.23
contingency_monthlynumber | empty6

The quoted contingency fee (in £). If contingency is configured as a percentage for the employer, this column will contain the calculated amount.

12.23
excess_mileage_ppmnumber | empty6

The quoted excess mileage cost per mile. This is currently empty as we are not receiving the excess mileage ppm from clients.

5
emissions_standardstring | empty

The emissions standard the vehicle complies with, e.g. “EURO 6” or “EURO 6E-BIS”.

EURO 6
salary_sacrifice_grossnumber | empty6

Average monthly gross cost over the full term (in £)

658.65
employerstringThe name of the employer and (plan ID)Acme Inc (153)
vat_recovery_fractionnumber7The percentage of VAT recovery the user receives0.75
nic_sharing_fractionnumber7

The percentage of NIC savings the user receives (set to 0 if the employer has opted out of NIC sharing)

0.5
early_termination_cover”ETI” | “ETP” | ""

Indicates if early termination insurance (ETI) or early termination protection (ETP) is included in the quote.

ETI
early_termination_insurance_premiumnumber | empty6

Monthly insurance premium for early termination

12.34
early_termination_protection_monthlynumber | empty6

The amount of early termination protection that is applied as part of the overall rental cost (ex VAT).

48.00
motor_insurance_provider”default” | “fleet” | “personal”

Indicates the motor insurance provider, which can be our default provider (Lloyd Latchford), the employer’s fleet insurance, or the user’s personal insurance.

fleet
motor_insurance_quote_idstringThe quote identifier the motor insurance provider has given us.IOWKPQIOWEB9SK
main_driver_namestring

The name of the main driver for insurance purposes, which may be different from the employee name.

Janet Smith
main_driver_dobdate1The birthday of the primary driver1953-09-17
additional_driver_2_namestring | empty6The name of the secondary driverJane Doe
additional_driver_2_dobdate | empty6The birthday of the secondary driver1953-09-17
additional_driver_3_namestring | empty6The name of the tertiary driverJohn Doe
additional_driver_3_dobdate | empty6The birthday of the tertiary driver1953-09-17
emailstringThe email address of the userjake@example.com
phone_numberstringThe phone number the user has added. We don’t format it before sending it to you so it may vary.

+447777777777
077 7777 7777

user_idstringThe user identifier”auth0|65437kkd0s34d7d4659a8ed7”
option_idsstring | empty6A list of option ids in the same order to the options field”12342,23671,993821”
created_atdatetime1Date and time the user submitted the enquiry2013-09-17T19:00:00.000Z
internal_enquiryboolean2

Set if the enquiry was made by an internal user or a dummy account in the platform, (e.g. a sales staff or marketing exec) and should not be contacted.

false
addressstring | empty6

The address at which the car will be usually parked overnight. Not collected for employer-supplied or private insurance.

11 Acacia Avenue, Palm Springs, Lesser Snodbury, AB12 3CD
vehicle_idstringThe vehicle ID provided in the supplied rate books.XYZ12345
cap_idinteger | empty

The cap ID of the vehicle.

123456
model_yearstring | empty

The model year of the vehicle.

2024.25
bodytypestring

The body type (body style) of the vehicle.

Hatchback
client_rate_idstring

A rate identifier as provided in supplied rate books. This may indicate the funder or the client that has provided the rate.

Lex1234567890
request_type”Enquiry” | “Order”

Indicates whether the record relates to an enquiry or an order. An order implies that the employee has completed the full process and agreed to take the vehicle with the quote indicated. An enquiry suggests the employee is interested in the deal but wishes to be called back or otherwise discuss details.

Order

Changelog

  • 2026-03-25:
    • Added column emissions_standard to the enquiry export specification to indicate the emissions standard the vehicle complies with.
  • 2026-02-03:
    • Added column request_type to the enquiry export specification to indicate whether the record relates to an enquiry or an order.
  • 2025-10-24:
    • Added columns early_termination_insurance_premium and early_termination_protection_monthly to the enquiry export specification.

Footnotes

  1. Date format types comply with ISO 8601 standards

    • For fields marked as date: yyyy-mm-dd
    • For fields marked as datetime: yyyy-mm-ddThh:ii:ss.fffZ
    ↩ ↩2 ↩3

  2. Boolean values are set to either true or false. Note that they are represented as strings and not integers (like 0 and 1). ↩ ↩2 ↩3 ↩4 ↩5

  3. Residency allowable values:

    • UK
    • Scotland
    • Wales
    ↩

  4. Tax band codes (note that S stands for Scottish):

    • Basic
    • Higher
    • Additional
    • Effective
    • SStarter
    • SBasic
    • SIntermediate
    • SHigher
    • SAdvanced
    • STop
    • SEffective
    ↩

  5. Fuel types:

    • Diesel
    • Petrol
    • HybridDieselElectric
    • HybridPetrolElectric
    • HybridDieselPlugin
    • HybridPetrolPlugin
    • Electric
    • ElectricExtendedRange
    • FlexiblePetrolGas
    • Lpg
    ↩

  6. Fields that include the type empty will be empty in the CSV file if the value is not present (e.g. Diesel,,153 as opposed to Diesel,null,153). ↩ ↩2 ↩3 ↩4 ↩5 ↩6 ↩7 ↩8 ↩9 ↩10 ↩11 ↩12 ↩13 ↩14 ↩15

  7. Percentage values are set as a decimal fraction of the percentage, e.g. 0.75 is 75% ↩ ↩2

CSV exports