GPJP_RA_PYE_DTA

#	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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	GPJP_RA_BY_DISABL	Character(1)	VARCHAR2(1) NOT NULL	This value is used for knowing whether the Retirement was by Disability Y/N Table Edit Default Value: N
5	PRD_BGN_DT	Date(10)	DATE NOT NULL	Period Begin Date
6	PRD_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date
7	GPJP_RA_YRS_SERV	Number(2,0)	SMALLINT NOT NULL	Years of service for the current Retirement Allowance.
8	GPJP_RA_INC_RPT	Character(1)	VARCHAR2(1) NOT NULL	Used to determine whether the Retirement Income Report was Submitted. Y/N Table Edit Default Value: Y
9	GPJP_RA_ER_FRM_SYR	Number(19,6)	DECIMAL(18,6) NOT NULL	Retirement Allowance Earnings From the Same Year.
10	GPJP_RA_WHTAX_SYR	Number(19,6)	DECIMAL(18,6) NOT NULL	Withholding Tax for Retirement Allowance in the Same Year.
11	GPJP_RA_YR_SRV_SYR	Number(2,0)	SMALLINT NOT NULL	Years of Service for the Retirement Allowance in the Same Year.
12	GPJP_RA_MUNIC_SYR	Number(19,6)	DECIMAL(18,6) NOT NULL	Municipality Tax for Retirement Allowance in the Same Year.
13	GPJP_RA_PREFT_SYR	Number(19,6)	DECIMAL(18,6) NOT NULL	Prefecture Tax for Retirement Allowance in the Same Year.
14	GPJP_RA_ER_OTH	Number(19,6)	DECIMAL(18,6) NOT NULL	Retirement Allowance Other Earnings in the last 5 years.
15	GPJP_RA_OVRLAP_YRS	Number(2,0)	SMALLINT NOT NULL	Overlapping Years of Service.
16	GPJP_YEA_SUBMIT	Number(1,0)	SMALLINT NOT NULL	Submit to Tax Office. 1/0 Table Edit (1=True, 0=False)