GPJP_PI_ADR_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	GPJP_PEN_NO1	Character(4)	VARCHAR2(4) NOT NULL	Base Pension Department Sign
8	GPJP_PEN_NO2	Character(6)	VARCHAR2(6) NOT NULL	Base Pension Sequential Number
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	GPJP_POSTAL1	Character(3)	VARCHAR2(3) NOT NULL	Postal Code 1
13	GPJP_POSTAL2	Character(4)	VARCHAR2(4) NOT NULL	Postal Code 2
14	GPJP_FLADDR_AC1	Character(75)	VARCHAR2(75) NOT NULL	Concatenated AC Address
15	GPJP_FLADDR1	Character(75)	VARCHAR2(75) NOT NULL	Concatenated Address
16	ASOFDATE	Date(10)	DATE	As of Date
17	GPJP_CHRDT_ERA2	Character(1)	VARCHAR2(1) NOT NULL	Imperial Era
18	GPJP_CHRDT_YYMMDD2	Character(6)	VARCHAR2(6) NOT NULL	Character Date as YYMMDD
19	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
20	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
21	GPJP_FLADDR_AC2	Character(75)	VARCHAR2(75) NOT NULL	Concatenated AC Address
22	GPJP_FLADDR2	Character(75)	VARCHAR2(75) NOT NULL	Concatenated Address
23	GPJP_DESCR75	Character(75)	VARCHAR2(75) NOT NULL	Comment
24	AGE	Number(3,0)	SMALLINT NOT NULL	Age
25	GPJP_ELIG_VOL_ER	Character(1)	VARCHAR2(1) NOT NULL	Eligibility For Voluntary Enrollment.
26	GPJP_HEL_EXC_FLG	Character(1)	VARCHAR2(1) NOT NULL	To track payees excluded from Health Insurance