GPJP_RC_IH_T_FL (SQL Table)	Index Back
Inhabitant Tax File Create RC Run Control record used in the Inhabitant Tax File creation process.

GPJP_RC_IH_T_FL

(SQL Table)

Inhabitant Tax File Create 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

7 FILE_HANDLE Character(2) VARCHAR2(2) NOT NULL File Handle
Prompt Table: GPJP_FILE_HANDL

#	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
7	FILE_HANDLE	Character(2)	VARCHAR2(2) NOT NULL	File Handle Prompt Table: GPJP_FILE_HANDL