GPJP_RA_WH_RPT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	DATE_YEAR_VAL	Number(4,0)	SMALLINT NOT NULL	Date Year Value
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
5	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
6	SUPV_LVL_ID	Character(8)	VARCHAR2(8) NOT NULL	Supervisor Level ID for use in capability grade system
7	PYMT_DT	Date(10)	DATE	Payment Date
8	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
9	PRD_END_DT	Date(10)	DATE	Pay Period End Date
10	GPJP_RA_YRS_SERV	Number(2,0)	SMALLINT NOT NULL	Years of service for the current Retirement Allowance.
11	GPJP_RA_BY_DISABL	Character(1)	VARCHAR2(1) NOT NULL	This value is used for knowing whether the Retirement was by Disability
12	GPJP_RA_INC_RPT	Character(1)	VARCHAR2(1) NOT NULL	Used to determine whether the Retirement Income Report was Submitted. Y/N Table Edit
13	GPJP_RA_ER_FRM_SYR	Number(19,6)	DECIMAL(18,6) NOT NULL	Retirement Allowance Earnings From the Same Year.
14	GPJP_RA_WHTAX_SYR	Number(19,6)	DECIMAL(18,6) NOT NULL	Withholding Tax for Retirement Allowance in the Same Year.
15	GPJP_RA_ER_OTH	Number(19,6)	DECIMAL(18,6) NOT NULL	Retirement Allowance Other Earnings in the last 5 years.
16	GPJP_RA_DEDUCTION	Number(19,6)	DECIMAL(18,6) NOT NULL	Holds deduction amount for retirement allowance for historical purposes
17	GPJP_RA_TAXABLE	Number(19,6)	DECIMAL(18,6) NOT NULL	Holds the taxable amount used in Retirement Allowance calculations for historical purposes.
18	GPJP_PYE_ADD1	Character(254)	VARCHAR2(254) NOT NULL	Payees Concatenated Home Address as of 1st Date of the Object Year.
19	GPJP_PYE_ADD2	Character(254)	VARCHAR2(254) NOT NULL	Payees Concatenated Home Address as of the current Date in record.
20	GPJP_PYR_ADD1	Character(254)	VARCHAR2(254) NOT NULL	Payees Tax Establishments Address as of the current Date in Record.
21	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
22	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
23	MUNICIPAL_CD_JPN	Character(6)	VARCHAR2(6) NOT NULL	Japanese Municipal Code
24	GPJP_RA_EARN1	Number(19,6)	DECIMAL(18,6) NOT NULL	Earnings for Retirement Allowance
25	GPJP_RA_IT1	Number(19,6)	DECIMAL(18,6) NOT NULL	Income Tax for Retirement Allowance
26	GPJP_RA_IH_MUNIC1	Number(19,6)	DECIMAL(18,6) NOT NULL	Municipality Tax for Retirement Allowance
27	GPJP_RA_IH_PREFT1	Number(19,6)	DECIMAL(18,6) NOT NULL	Prefecture Tax for Retirement Allowance
28	GPJP_RA_EARN2	Number(19,6)	DECIMAL(18,6) NOT NULL	Earnings for Retirement Allowance
29	GPJP_RA_IT2	Number(19,6)	DECIMAL(18,6) NOT NULL	Income Tax for Retirement Allowance
30	GPJP_RA_IH_MUNIC2	Number(19,6)	DECIMAL(18,6) NOT NULL	Municipality Tax for Retirement Allowance
31	GPJP_RA_IH_PREFT2	Number(19,6)	DECIMAL(18,6) NOT NULL	Prefecture Tax for Retirement Allowance
32	GPJP_RA_EARN3	Number(19,6)	DECIMAL(18,6) NOT NULL	Earnings for Retirement Allowance
33	GPJP_RA_IT3	Number(19,6)	DECIMAL(18,6) NOT NULL	Income Tax for Retirement Allowance
34	GPJP_RA_IH_MUNIC3	Number(19,6)	DECIMAL(18,6) NOT NULL	Municipality Tax for Retirement Allowance
35	GPJP_RA_IH_PREFT3	Number(19,6)	DECIMAL(18,6) NOT NULL	Prefecture Tax for Retirement Allowance
36	GPJP_YEA_SUBMIT	Number(1,0)	SMALLINT NOT NULL	Submit to Tax Office.
37	GPJP_TAX_ESTAB	Character(15)	VARCHAR2(15) NOT NULL	Salary Payer Reference Number