GPJP_RC_IH_MUN2 (SQL Table)	Index Back
Run Ctrl for Muni data load Run Control for Ap Engine Process which loads Municipality data from a flat file into GPJP_IH_PYE_TAX/ GPJP_IH_PYE_TX2.

GPJP_RC_IH_MUN2

(SQL Table)

Run Ctrl for Muni data load

Run Control for Ap Engine Process which loads Municipality data from a flat file into GPJP_IH_PYE_TAX/ GPJP_IH_PYE_TX2.

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

4 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

5 GPJP_LOAD_OPTION Character(4) VARCHAR2(4) NOT NULL Load IH Tax JPN
DA=Delete All Option
DLNO=Delete only loaded/ Not Overwr
DLOR=Delete only loaded/overwrite
Default Value: DLNO

#	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	FILE_HANDLE	Character(2)	VARCHAR2(2) NOT NULL	File Handle Prompt Table: GPJP_FILE_HANDL
4	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
5	GPJP_LOAD_OPTION	Character(4)	VARCHAR2(4) NOT NULL	Load IH Tax JPN DA=Delete All Option DLNO=Delete only loaded/ Not Overwr DLOR=Delete only loaded/overwrite Default Value: DLNO