GPJP_YEA_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	GPJP_TAX_ESTAB	Character(15)	VARCHAR2(15) NOT NULL	Salary Payer Reference Number
6	DATE_YEAR_VAL	Number(4,0)	SMALLINT NOT NULL	Date Year Value
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
11	PIN_NUM_LAST	Number(8,0)	INTEGER NOT NULL	Last Used Element Number
12	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter
13	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
14	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
15	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
16	LABEL1	Character(15)	VARCHAR2(15) NOT NULL	User Field 1-Label, this label will be displayed in the Self Service Absences Transactions Pages
17	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
18	RELATIONSHIP	Character(2)	VARCHAR2(2) NOT NULL	Relationship to Employee
19	GPJP_RELATIONSHIP	Character(2)	VARCHAR2(2) NOT NULL	Relationships for Japan used in Reports and Dependent Tax data.
20	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
21	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
22	ERA1_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores the Era Name for the GP Year End Adjustment AE program.
23	ERA2_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores the Era Name for the GP Year End Adjustment AE program.
24	ERA3_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores the Era Name for the GP Year End Adjustment AE program.
25	ERA4_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores the Era Name for the GP Year End Adjustment AE program.
26	DAY_DESCR_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores descriptions used on the AE program GPJP_YEALOAD.
27	MONTH_DESCR_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores descriptions used on the AE program GPJP_YEALOAD.
28	YEAR_DESCR_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores descriptions used on the AE program GPJP_YEALOAD.
29	GPJP_END_OF_YEAR	Character(10)	VARCHAR2(10) NOT NULL	Tracks December 31st of the supplied year.
30	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
31	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
32	GPJP_YEA_MIDDT	Character(6)	VARCHAR2(6) NOT NULL	Hired/Termination Date in Year/Month/Date Format.
33	GPJP_YEA_ADD_PRIOR	Character(1)	VARCHAR2(1) NOT NULL	Add Prior Employment Details
34	GPJP_YEA_PRINT_INS	Character(1)	VARCHAR2(1) NOT NULL	Print Insurance Details
35	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
36	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
37	GPJP_YEA_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Year-End Adjustment 10=Subject 20=Not Subject
38	GPJP_YEA_HIRMID	Number(1,0)	SMALLINT NOT NULL	Hired/Terminated Mid-Year.
39	BIRTHDATE	Date(10)	DATE	Date of Birth
40	DT_OF_DEATH	Date(10)	DATE	Date of Death
41	AGE_YEARS	Number(3,0)	SMALLINT NOT NULL	Age Years
42	WHERE_VALUE1	Character(30)	VARCHAR2(30) NOT NULL	Value for rule selection criteria.