GPJP_IH_TAX_AET(SQL Table) |
Index Back |
---|---|
Inhabitant Tax Load AETState 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 |