GPJP_RC_IH_AUD (SQL Table)	Index Back
Run Control for Employee Munic Run Control for Employee Municipality Audit Report which verifies an employee's home postal code against POSTAL_TBL_JPN.

GPJP_RC_IH_AUD

(SQL Table)

Run Control for Employee Munic

Run Control for Employee Municipality Audit Report which verifies an employee's home postal code against POSTAL_TBL_JPN.

# 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 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 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

#	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	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	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