P11D_NOTES_UK

#	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 Rcd Nbr
3	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
4	CAR_ID	Character(7)	VARCHAR2(7) NOT NULL	Car Identification Number used in Administer Company Cars module.
5	P11D_NOTE_NO_UK	Number(2,0)	SMALLINT NOT NULL	Note Number
6	P11D_NOTE_DSC_UK	Character(100)	VARCHAR2(100) NOT NULL	Note Description