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	Signed Number(6,0)	DECIMAL(5) 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	LABEL1	Character(15)	VARCHAR2(15) NOT NULL	User Field 1-Label, this label will be displayed in the Self Service Absences Transactions Pages
16	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
17	RELATIONSHIP	Character(2)	VARCHAR2(2) NOT NULL	Relationship to Employee
18	GPJP_RELATIONSHIP	Character(2)	VARCHAR2(2) NOT NULL	Relationships for Japan used in Reports and Dependent Tax data.
19	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
20	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
21	ERA1_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores the Era Name for the GP Year End Adjustment AE program.
22	ERA2_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores the Era Name for the GP Year End Adjustment AE program.
23	ERA3_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores the Era Name for the GP Year End Adjustment AE program.
24	ERA4_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores the Era Name for the GP Year End Adjustment AE program.
25	DAY_DESCR_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores descriptions used on the AE program GPJP_YEALOAD.
26	MONTH_DESCR_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores descriptions used on the AE program GPJP_YEALOAD.
27	YEAR_DESCR_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores descriptions used on the AE program GPJP_YEALOAD.
28	GPJP_END_OF_YEAR	Character(10)	VARCHAR2(10) NOT NULL	Tracks December 31st of the supplied year.
29	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
30	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
31	GPJP_YEA_MIDDT	Character(6)	VARCHAR2(6) NOT NULL	Hired/Termination Date in Year/Month/Date Format.
32	GPJP_YEA_ADD_PRIOR	Character(1)	VARCHAR2(1) NOT NULL	Add Prior Employment Details
33	GPJP_YEA_PRINT_INS	Character(1)	VARCHAR2(1) NOT NULL	Print Insurance Details
34	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
35	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
36	GPJP_YEA_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Year-End Adjustment 10=Subject 20=Not Subject
37	GPJP_YEA_HIRMID	Number(1,0)	SMALLINT NOT NULL	Hired/Terminated Mid-Year.
38	BIRTHDATE	Date(10)	DATE	Date of Birth
39	DT_OF_DEATH	Date(10)	DATE	Date of Death
40	AGE_YEARS	Number(3,0)	SMALLINT NOT NULL	Age Years
41	WHERE_VALUE1	Character(30)	VARCHAR2(30) NOT NULL	Value for rule selection criteria.
42	WHERE_VALUE2	Character(50)	VARCHAR2(50) NOT NULL	Field used as bind variable in AE process to dynamically build SQL statements using symbolic parameters %()
43	WHERE_VALUE3	Character(30)	VARCHAR2(30) NOT NULL	Value for rule selection criteria.
44	GPJP_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	This flag determines whether the current row should be processed or not
45	GPJP_CUR_YR_BGN_DT	Date(10)	DATE	Current Year Begin Date
46	GPJP_CUR_YR_END_DT	Date(10)	DATE	Current Year End Date
47	GPJP_NEX_YR_JUN1ST	Date(10)	DATE	June 1st, Next Year