GPJP_SC_TER_RPT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	SEQ_NUM8	Number(8,0)	INTEGER NOT NULL	Sequence Number
4	GPJP_PREFECTURE_CD	Character(2)	VARCHAR2(2) NOT NULL	Prefecture Code
5	GPJP_SC_ESTAB_REF1	Character(10)	VARCHAR2(10) NOT NULL	Establishment Reference Number.
6	GPJP_SC_ESTAB_REF2	Character(10)	VARCHAR2(10) NOT NULL	Establishment Reference Number 2.
7	GPJP_HLTH_CARD_NUM	Number(8,0)	INTEGER NOT NULL	Health Insurance Card Number.
8	GPJP_HLTH_CARD_NM	Character(6)	VARCHAR2(6) NOT NULL	Health Insurance Card Number.
9	GPJP_SC_ESTAB2	Character(5)	VARCHAR2(5) NOT NULL	Establishment Number
10	GPJP_HLTHCARD_ATCH	Character(2)	VARCHAR2(2) NOT NULL	Insurance Card Attached
11	GPJP_HLTHCARD_RTRN	Character(2)	VARCHAR2(2) NOT NULL	Insurance Card Attached
12	GPJP_MULT_LOC_WRKR	Character(1)	VARCHAR2(1) NOT NULL	Multiple Location worker
13	GPJP_CONT_REH	Character(1)	VARCHAR2(1) NOT NULL	Continuous Rehired Employee
14	GPJP_AGE70_OLDER	Character(1)	VARCHAR2(1) NOT NULL	Age of 70 or older employee
15	GPJP_NOTIFY_OLD_EE	Character(1)	VARCHAR2(1) NOT NULL	Only Notification of 70 or older employee Y/N Table Edit
16	BIRTHDATE	Date(10)	DATE	Date of Birth
17	GPJP_CHRDT_ERA1	Character(1)	VARCHAR2(1) NOT NULL	Imperial Era
18	GPJP_CHRDT_YYMMDD1	Character(6)	VARCHAR2(6) NOT NULL	Character Date as YYMMDD
19	GPJP_CHRDT_ERA3	Character(1)	VARCHAR2(1) NOT NULL	Imperial Era
20	GPJP_CHRDT_YYMMDD3	Character(6)	VARCHAR2(6) NOT NULL	Character Date as YYMMDD
21	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
22	GPJP_PERS_NBR1	Character(13)	VARCHAR2(13) NOT NULL	This field stores the My Number of each employee and dependent.
23	ASOFDATE	Date(10)	DATE	As of Date
24	TERMINATION_DT	Date(10)	DATE	Termination Date
25	GPJP_CHRDT_ERA2	Character(1)	VARCHAR2(1) NOT NULL	Imperial Era
26	GPJP_CHRDT_YYMMDD2	Character(6)	VARCHAR2(6) NOT NULL	Character Date as YYMMDD
27	GPJP_CHG_FLG	Character(2)	VARCHAR2(2) NOT NULL	Status Change Reason Field. 01=New enrollment 02=Re-enrollment 03=Loss by Death 04=Loss by Age(PI) 05=Loss by Termination etc. 06=Occasional Revision 07=Regular Decision 08=Other 09=Excluded 10=New Enrollment after Loss 11=Rev. after Mat./Preg. Leave 11=Revision after Maternity Leave 12=Loss by Age (HI) 13=Loss By Disability 14=Loss by Soc Sec Agreement
28	GPJP_CUR_HEL_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Current Monthly Health Insurance Remuneration.
29	GPJP_CHAR_AMT1	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
30	GPJP_CUR_PEN_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Current Monthly Standard Pension Remuneration.
31	GPJP_CHAR_AMT2	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
32	GPJP_PEN_NO1	Character(4)	VARCHAR2(4) NOT NULL	Base Pension Department Sign
33	GPJP_PEN_NO2	Character(6)	VARCHAR2(6) NOT NULL	Base Pension Sequential Number
34	GPJP_CHRDT_ERA4	Character(1)	VARCHAR2(1) NOT NULL	Imperial Era
35	GPJP_CHRDT_YYMMDD4	Character(6)	VARCHAR2(6) NOT NULL	Character Date as YYMMDD
36	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
37	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
38	GPJP_DESCR75	Character(75)	VARCHAR2(75) NOT NULL	Comment