GPJP_RA_PYE_DTA (SQL Table)	Index Back
Retirement Allowance GP/JPN The details of Current Retirement and Former Retirement Allowances are tracked for a Payee for each EMPLID-EMPL_RCD combination.

GPJP_RA_PYE_DTA

(SQL Table)

Retirement Allowance GP/JPN

The details of Current Retirement and Former Retirement Allowances are tracked for a Payee for each EMPLID-EMPL_RCD combination.

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

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 Period Begin Date

6 PRD_END_DT Date(10) DATE 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_STRT_DT1 Date(10) DATE Retirement Allowance Start Date

9 GPJP_RA_STRT_DT2 Date(10) DATE Retirement Allowance Start Date

10 GPJP_RA_END_DT1 Date(10) DATE Retirement Allowance End Date

11 GPJP_RA_END_DT2 Date(10) DATE Retirement Allowance End Date

12 GPJP_RA_YRS_SERV1 Number(2,0) SMALLINT NOT NULL Years of service for the current Retirement Allowance.

13 GPJP_RA_YRS_SERV2 Number(2,0) SMALLINT NOT NULL Years of service for the current Retirement Allowance.

14 GPJP_RA_YRS_SERV3 Number(2,0) SMALLINT NOT NULL Years of service for the current Retirement Allowance.

15 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

16 GPJP_RA_ER_FRM_SYR Number(19,6) DECIMAL(18,6) NOT NULL Retirement Allowance Earnings From the Same Year.

17 GPJP_RA_WHTAX_SYR Number(19,6) DECIMAL(18,6) NOT NULL Withholding Tax for Retirement Allowance in the Same Year.

18 GPJP_RA_YR_SRV_SYR Number(2,0) SMALLINT NOT NULL Years of Service for the Retirement Allowance in the Same Year.

19 GPJP_RA_MUNIC_SYR Number(19,6) DECIMAL(18,6) NOT NULL Municipality Tax for Retirement Allowance in the Same Year.

20 GPJP_RA_PREFT_SYR Number(19,6) DECIMAL(18,6) NOT NULL Prefecture Tax for Retirement Allowance in the Same Year.

21 GPJP_RA_ER_OTH Number(19,6) DECIMAL(18,6) NOT NULL Retirement Allowance Other Earnings in the last 5 years.

22 GPJP_RA_OVRLAP_YRS Number(2,0) SMALLINT NOT NULL Overlapping Years of Service.

23 GPJP_YEA_SUBMIT Number(1,0) SMALLINT NOT NULL Submit to Tax Office.
1/0 Table Edit (1=True, 0=False)

24 GPJP_RA_GENERAL Character(1) VARCHAR2(1) NOT NULL This value is used for knowing whether the Retirement was by General
N=No
Y=Yes
Default Value: Y

25 GPJP_RA_SPEC_EXEC Character(1) VARCHAR2(1) NOT NULL This value is used for knowing whether the Retirement was by General
N=No
Y=Yes

26 DATE1 Date(10) DATE Date 1

27 DATE2 Date(10) DATE Date 2

28 GPJP_CHK_BOX1 Character(1) VARCHAR2(1) NOT NULL GPJP check box
Y/N Table Edit

29 GPJP_CHK_BOX2 Character(1) VARCHAR2(1) NOT NULL GPJP check box
Y/N Table Edit

30 GPJP_CHK_BOX3 Character(1) VARCHAR2(1) NOT NULL GPJP check box
Y/N Table Edit

31 GPJP_CHK_BOX4 Character(1) VARCHAR2(1) NOT NULL GPJP check box
Y/N Table Edit

#	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 Record
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	Period Begin Date
6	PRD_END_DT	Date(10)	DATE	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_STRT_DT1	Date(10)	DATE	Retirement Allowance Start Date
9	GPJP_RA_STRT_DT2	Date(10)	DATE	Retirement Allowance Start Date
10	GPJP_RA_END_DT1	Date(10)	DATE	Retirement Allowance End Date
11	GPJP_RA_END_DT2	Date(10)	DATE	Retirement Allowance End Date
12	GPJP_RA_YRS_SERV1	Number(2,0)	SMALLINT NOT NULL	Years of service for the current Retirement Allowance.
13	GPJP_RA_YRS_SERV2	Number(2,0)	SMALLINT NOT NULL	Years of service for the current Retirement Allowance.
14	GPJP_RA_YRS_SERV3	Number(2,0)	SMALLINT NOT NULL	Years of service for the current Retirement Allowance.
15	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
16	GPJP_RA_ER_FRM_SYR	Number(19,6)	DECIMAL(18,6) NOT NULL	Retirement Allowance Earnings From the Same Year.
17	GPJP_RA_WHTAX_SYR	Number(19,6)	DECIMAL(18,6) NOT NULL	Withholding Tax for Retirement Allowance in the Same Year.
18	GPJP_RA_YR_SRV_SYR	Number(2,0)	SMALLINT NOT NULL	Years of Service for the Retirement Allowance in the Same Year.
19	GPJP_RA_MUNIC_SYR	Number(19,6)	DECIMAL(18,6) NOT NULL	Municipality Tax for Retirement Allowance in the Same Year.
20	GPJP_RA_PREFT_SYR	Number(19,6)	DECIMAL(18,6) NOT NULL	Prefecture Tax for Retirement Allowance in the Same Year.
21	GPJP_RA_ER_OTH	Number(19,6)	DECIMAL(18,6) NOT NULL	Retirement Allowance Other Earnings in the last 5 years.
22	GPJP_RA_OVRLAP_YRS	Number(2,0)	SMALLINT NOT NULL	Overlapping Years of Service.
23	GPJP_YEA_SUBMIT	Number(1,0)	SMALLINT NOT NULL	Submit to Tax Office. 1/0 Table Edit (1=True, 0=False)
24	GPJP_RA_GENERAL	Character(1)	VARCHAR2(1) NOT NULL	This value is used for knowing whether the Retirement was by General N=No Y=Yes Default Value: Y
25	GPJP_RA_SPEC_EXEC	Character(1)	VARCHAR2(1) NOT NULL	This value is used for knowing whether the Retirement was by General N=No Y=Yes
26	DATE1	Date(10)	DATE	Date 1
27	DATE2	Date(10)	DATE	Date 2
28	GPJP_CHK_BOX1	Character(1)	VARCHAR2(1) NOT NULL	GPJP check box Y/N Table Edit
29	GPJP_CHK_BOX2	Character(1)	VARCHAR2(1) NOT NULL	GPJP check box Y/N Table Edit
30	GPJP_CHK_BOX3	Character(1)	VARCHAR2(1) NOT NULL	GPJP check box Y/N Table Edit
31	GPJP_CHK_BOX4	Character(1)	VARCHAR2(1) NOT NULL	GPJP check box Y/N Table Edit