CAR_MILEAGE_UK

(SQL Table)
Index Back

Car Mileage Record - UK

Car Mileage Record - UK

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
4 BENEFIT_NBR Number(3,0) SMALLINT NOT NULL Note! Although this field is part of the index schema for most Base Benefits enrollment-related records, it was in fact never functionally implemented. As such, it is CRITICAL that this field always be set to zero 0.
5 EFFDT Date(10) DATE Effective Date
6 CAR_ID Character(7) VARCHAR2(7) NOT NULL Car Identification Number used in Administer Company Cars module.

Prompt Table: CAR_DATA

7 TAX_YEAR_END_UK Character(4) VARCHAR2(4) NOT NULL Tax Year End
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
2007=Year Ending 5th of April 2007
2008=Year Ending 5th of April 2008
2009=Year Ending 5th of April 2009
2010=Year Ending 5th of April 2010
2011=Year Ending 5th of April 2011
2012=Year Ending 5th of April 2012
2013=Year Ending 5th of April 2013
8 MILEAGE_TYPE_UK Character(1) VARCHAR2(1) NOT NULL Type of Mileage
A=Actual
E=Expected
9 MILEAGE_CODE_UK Character(1) VARCHAR2(1) NOT NULL Mileage Code
H=18000+
L=0-2499
M=2500-17999