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_SC_ESTAB_REF1	Character(10)	VARCHAR2(10) NOT NULL	Establishment Reference Number.
5	GPJP_SC_ESTAB_REF2	Character(10)	VARCHAR2(10) NOT NULL	Establishment Reference Number 2.
6	GPJP_HLTH_CARD_NUM	Number(8,0)	INTEGER NOT NULL	Health Insurance Card Number.
7	BIRTHDATE	Date(10)	DATE	Date of Birth
8	GPJP_CHRDT_ERA1	Character(1)	VARCHAR2(1) NOT NULL	Imperial Era
9	GPJP_CHRDT_YYMMDD1	Character(6)	VARCHAR2(6) NOT NULL	Character Date as YYMMDD
10	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
11	ASOFDATE	Date(10)	DATE	As of Date
12	GPJP_CHRDT_ERA2	Character(1)	VARCHAR2(1) NOT NULL	Imperial Era
13	GPJP_CHRDT_YYMMDD2	Character(6)	VARCHAR2(6) NOT NULL	Character Date as YYMMDD
14	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 Other Reason 06=Occasional Revision 07=Regular Decision 08=Other 09=Excluded 10=New Enrollment after Loss 11=Revision after Maternity Leave 11=Rev. after Mat./Preg. Leave 12=Loss by Age (HI) 13=Loss by Disability
15	GPJP_CUR_HEL_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Current Monthly Health Insurance Remuneration.
16	GPJP_CHAR_AMT1	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
17	GPJP_CUR_PEN_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Current Monthly Standard Pension Remuneration.
18	GPJP_CHAR_AMT2	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
19	GPJP_PEN_NO1	Character(4)	VARCHAR2(4) NOT NULL	Base Pension Department Sign
20	GPJP_PEN_NO2	Character(6)	VARCHAR2(6) NOT NULL	Base Pension Sequential Number
21	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
22	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
23	GPJP_DESCR75	Character(75)	VARCHAR2(75) NOT NULL	Comment