Vans (Van Allocations)

Full Description
Database Field
Data Type
Field Length
Inclusion
Pre-Format
Annual amount of cash foregone for Fuel (OpRA)
CASHFGFUEL

Numeric

10

Optional


Annual amount of cash foregone for the Van (OpRA)
CASHFGVAN

Numeric

10

Optional


Available from Date

FROM

Date

8

Compulsory

dd/mm/yyyy

Fuel cost repaid for personal mileage in full

FUELPAID

Character

3

Optional

Y

N

Fuel paid for by Employer

FUELSCALE

Character

3

Optional

Y

N

Made good value
MADEGOOD

Numeric

10

Not used


Mileage

MILEAGE

Numeric

10

Not used

 

Employee N I Number

NI_NUMBER

Character

10

Key field

 

Payroll Number

PAYROLL

Character

20

Key field

 

Payrolled valuePAYROLLEDNumeric
10Optional

Restricted Private Use

RESTRICTED

Character

3

Optional

 

Registration Number

R_NUMBER

Character

10

Key field

 

Shared Discount

SHAREDDISC

Numeric

10

Optional

 

Shared use
SHAREDUSE

Character

3

Optional


Available to Date

TO

Date

8

Compulsory

dd/mm/yyyy

Days Unavailable

UNAVAILBLE

Numeric

3

Optional