RUN_CNTL_CAR

(SQL Table)
Index Back

Run Control for Cars

Run Control for Cars

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON_NAME

5 EMPL_RCD_CHAR Character(3) VARCHAR2(3) NOT NULL Empl_rcd# character field