RUN_CNTL_CAR(SQL Table) |
Index Back |
---|---|
Run Control for CarsRun 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_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 | 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 |