GPJP_RC_IH_T_LD

(SQL Table)
 Index Back

Inhabitant Tax File Load RC

Run Control record used in the Inhabitant Tax File creation process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 GPJP_TAX_ESTAB Character(15) VARCHAR2(15) NOT NULL Salary Payer Reference Number

Prompt Table: GPJP_TAXESIT_VW

4 YEAR_CODE Character(4) VARCHAR2(4) NOT NULL Object Year
1994=1994
1995=1995
1996=1996
1997=1997
1998=1998
1999=1999
2000=2000
2001=2001
2002=2002
2003=2003
2004=2004
2005=2005
2006=2006
2007=2007
2008=2008
2009=2009
2010=2010
2011=2011
2012=2012
2013=2013
2014=2014
2015=2015
2016=2016
2017=2017
2018=2018
2019=2019
2020=2020
5 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December

Prompt Table: GPJP_MONTH_VW

6 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID

Prompt Table: GPJP_SRC_BANK