GPJP_IH_TAX_AET

(SQL Table)
Index Back

Inhabitant Tax Load AET

State record used in the Inhabitant Tax File creation process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 GPJP_TAX_ESTAB Character(15) VARCHAR2(15) NOT NULL Salary Payer Reference Number
5 YEAR_CODE Character(4) VARCHAR2(4) NOT NULL Select Calendar 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
6 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
7 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
8 GPJP_COMPANY_CODE Character(10) VARCHAR2(10) NOT NULL Tracks a company identifier assigned by the banking institution.
9 BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Bank Branch ID
10 GPJP_ESTAB_LCN_AC Character(50) VARCHAR2(50) NOT NULL Used in Inhabitant Tax File creation process.
11 GPJP_ESTAB_NM_AC Character(40) VARCHAR2(40) NOT NULL Used in Inhabitant Tax File creation process.
12 ASOFDATE Date(10) DATE As of Date
13 START_DATE Date(10) DATE Start Date for Gen Standing PO
14 END_DATE Date(10) DATE End Date
15 FILE_HANDLE Character(2) VARCHAR2(2) NOT NULL File Handle
16 GPJP_CHRDT_YYMMDD1 Character(6) VARCHAR2(6) NOT NULL Character Date as YYMMDD
17 GPJP_CHARDATE Character(4) VARCHAR2(4) NOT NULL This field stores dates in a character format, specifically in the format of MMDD.
18 ERROR_TYPE Character(3) VARCHAR2(3) NOT NULL Error Type
ERR=Stop
NON=None
WAR=Warning
19 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code