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_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_SC_ESTAB2	Character(5)	VARCHAR2(5) NOT NULL	Establishment Number
7	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
8	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
9	BIRTHDATE	Date(10)	DATE	Date of Birth
10	GPJP_CHRDT_ERA1	Character(1)	VARCHAR2(1) NOT NULL	Imperial Era
11	GPJP_CHRDT_YYMMDD1	Character(6)	VARCHAR2(6) NOT NULL	Character Date as YYMMDD
12	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
13	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
14	GPJP_PEN_NO1	Character(4)	VARCHAR2(4) NOT NULL	Base Pension Department Sign
15	GPJP_PEN_NO2	Character(6)	VARCHAR2(6) NOT NULL	Base Pension Sequential Number
16	GPJP_POSTAL1	Character(3)	VARCHAR2(3) NOT NULL	Postal Code 1
17	GPJP_POSTAL2	Character(4)	VARCHAR2(4) NOT NULL	Postal Code 2
18	GPJP_FLADDR_AC1	Character(75)	VARCHAR2(75) NOT NULL	Concatenated AC Address
19	GPJP_FLADDR1	Character(75)	VARCHAR2(75) NOT NULL	Concatenated Address
20	ASOFDATE	Date(10)	DATE	As of Date
21	GPJP_CHRDT_ERA2	Character(1)	VARCHAR2(1) NOT NULL	Imperial Era
22	GPJP_CHRDT_YYMMDD2	Character(6)	VARCHAR2(6) NOT NULL	Character Date as YYMMDD
23	GPJP_MTH_CASH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Cash Monthly Remun
24	GPJP_MTH_MAT_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Non-Cash Mthly Remun
25	GPJP_SUM_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Of Monthly Remuneration In N.
26	GPJP_SC_DEP_RPT	Character(1)	VARCHAR2(1) NOT NULL	SI Dependent Report
27	GPJP_DESCR75	Character(75)	VARCHAR2(75) NOT NULL	Comment
28	AGE	Number(3,0)	SMALLINT NOT NULL	Age
29	GPJP_ELIG_VOL_ER	Character(1)	VARCHAR2(1) NOT NULL	Eligibility For Voluntary Enrollment.