| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
TAX_YEAR_END_UK |
Character(4) |
VARCHAR2(4) NOT NULL |
TAX_YEAR_END_UK
1995=Year Ending 5th of April 1995
1996=Year Ending 5th of April 1996
1997=Year Ending 5th of April 1997
1998=Year Ending 5th of April 1998
1999=Year Ending 5th of April 1999
2000=Year Ending 5th of April 2000
2001=Year Ending 5th of April 2001
2002=Year Ending 5th of April 2002
2003=Year Ending 5th of April 2003
2004=Year Ending 5th of April 2004
2005=Year Ending 5th of April 2005
2006=Year Ending 5th of April 2006
2006=Year Ending 5th of April 2006
2007=Year Ending 5th of April 2007
2007=Year Ending 5th of April 2007
2008=Year Ending 5th of April 2008
2008=Year Ending 5th of April 2008
2009=Year Ending 5th of April 2009
2009=Year Ending 5th of April 2009
2010=Year Ending 5th of April 2010
2010=Year Ending 5th of April 2010
2011=Year Ending 5th of April 2011
2011=Year Ending 5th of April 2011
2012=Year Ending 5th of April 2012
2012=Year Ending 5th of April 2012
2013=Year Ending 5th of April 2013
2013=Year Ending 5th of April 2013
|
| 4 |
CAR_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Car Identification Number used in Administer Company Cars module.
|
| 5 |
MAKE_AND_MODEL |
Character(70) |
VARCHAR2(70) NOT NULL |
Make and Model
|
| 6 |
REGISTRATION_DT |
Date(10) |
DATE |
Registration Date
|
| 7 |
AVAILABLE_FROM_DT |
Date(10) |
DATE |
Car available from
|
| 8 |
AVAILABLE_TO_DT |
Date(10) |
DATE |
Car available to (date)
|
| 9 |
AVAILABLE_TO_STR |
Character(10) |
VARCHAR2(10) NOT NULL |
Car available to (text)
|
| 10 |
BUSINESS_MILEAGE_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
2,499 or less
Y/N Table Edit
|
| 11 |
BUSINESS_MILEAGE_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
2,500 - 17,999
Y/N Table Edit
|
| 12 |
BUSINESS_MILEAGE_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
18,000 or more
Y/N Table Edit
|
| 13 |
UNAVAILABLE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days car unavailable
|
| 14 |
PAYMENT_RECEIVED |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Payment received
|
| 15 |
LIST_PRICE |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
List Price
|
| 16 |
ACCESSORIES_PRICE1 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Accessories price
|
| 17 |
ACCESSORIES_PRICE2 |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Accessories Price
|
| 18 |
TOTAL_CAR_AND_ACC |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Total = car + accessories
|
| 19 |
CAPITAL_CONT |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Capital Contribution
|
| 20 |
CAR_BENEFIT_CHARGE |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Car Benefit Charge
|
| 21 |
FUEL_PROVIDED |
Character(1) |
VARCHAR2(1) NOT NULL |
Fuel provided for private use
Y/N Table Edit
|
| 22 |
FUEL_REIMBURSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Full cost of fuel reimbursed
Y/N Table Edit
|
| 23 |
ENGINE_TYPE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Engine Type
DIE=Diesel with cylinder capacity
OTH=Car without cylinder capacity
PET=Petrol with cylinder capacity
Prompt Table:
ENGINE_TYPE_UK
|
| 24 |
ENGINE_SIZE_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
1400cc or less
Y/N Table Edit
|
| 25 |
ENGINE_SIZE_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
1401cc - 2000cc
Y/N Table Edit
|
| 26 |
ENGINE_SIZE_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
over 2000cc
Y/N Table Edit
|
| 27 |
FUEL_BEN_CHARGE |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Fuel Benefit Charge
|
| 28 |
C02_EMISSIONS |
Number(3,0) |
SMALLINT NOT NULL |
C02 Emissions g/km
|
| 29 |
TAX_PERCENTAGE |
Number(2,0) |
SMALLINT NOT NULL |
Tax Percentage
|