GPJP_SC_ENR_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_SC_ESTAB2	Character(5)	VARCHAR2(5) NOT NULL	Establishment Number
8	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
9	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
10	BIRTHDATE	Date(10)	DATE	Date of Birth
11	GPJP_CHRDT_ERA1	Character(1)	VARCHAR2(1) NOT NULL	Imperial Era
12	GPJP_CHRDT_YYMMDD1	Character(6)	VARCHAR2(6) NOT NULL	Character Date as YYMMDD
13	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
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 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
15	GPJP_PERS_NBR1	Character(13)	VARCHAR2(13) NOT NULL	This field stores the My Number of each employee and dependent.
16	GPJP_NO_PERS	Character(1)	VARCHAR2(1) NOT NULL	Reason for no Personal Number 1=Living abroad 2=Short Term Resident 3=Others
17	GPJP_NO_PERS_RSN	Character(75)	VARCHAR2(75) NOT NULL	Reason
18	GPJP_PEN_NO1	Character(4)	VARCHAR2(4) NOT NULL	Base Pension Department Sign
19	GPJP_PEN_NO2	Character(6)	VARCHAR2(6) NOT NULL	Base Pension Sequential Number
20	GPJP_POSTAL1	Character(3)	VARCHAR2(3) NOT NULL	Postal Code 1
21	GPJP_POSTAL2	Character(4)	VARCHAR2(4) NOT NULL	Postal Code 2
22	GPJP_FLADDR_AC1	Character(76)	VARCHAR2(76) NOT NULL	Concatenated AC Address
23	GPJP_FLADDR1	Character(152)	VARCHAR2(152) NOT NULL	Concatenated Address
24	ASOFDATE	Date(10)	DATE	As of 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_MTH_CASH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Cash Monthly Remun
28	GPJP_MTH_MAT_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Non-Cash Mthly Remun
29	GPJP_SUM_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Of Monthly Remuneration In N.
30	GPJP_SC_DEP_RPT	Character(1)	VARCHAR2(1) NOT NULL	SI Dependent Report
31	GPJP_DESCR75	Character(75)	VARCHAR2(75) NOT NULL	Comment
32	AGE	Number(3,0)	SMALLINT NOT NULL	Age
33	GPJP_ELIG_VOL_ER	Character(1)	VARCHAR2(1) NOT NULL	Eligibility For Voluntary Enrollment.
34	GPJP_AGE70_OLDER	Character(1)	VARCHAR2(1) NOT NULL	Age of 70 or older employee
35	GPJP_CONT_REH	Character(1)	VARCHAR2(1) NOT NULL	Continuous Rehired Employee
36	GPJP_MULT_LOC_WRKR	Character(1)	VARCHAR2(1) NOT NULL	Multiple Location worker
37	GPJP_SHORT_TIME	Number(1,0)	SMALLINT NOT NULL	Short Time Worker (< 3/4)
38	GPJP_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Part-Time L=Part-time < 3/4 N=N/A Y=Part-time
39	GPJP_NOTIFY_OLD_EE	Character(1)	VARCHAR2(1) NOT NULL	Only Notification of 70 or older employee