GPJP_YEASS_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	GPJP_TAX_ESTAB	Character(15)	VARCHAR2(15) NOT NULL	Salary Payer Reference Number
5	DATE_YEAR_VAL	Number(4,0)	SMALLINT NOT NULL	Date Year Value
6	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GP_PYENT
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
9	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL
10	GPJP_PAYEE_IND	Character(1)	VARCHAR2(1) NOT NULL	Checkbox that indicates whether a list of payees has been provided for the pay slip generation.
11	GPJP_YEA_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	SS YEA - Status Approved used to load data Y/N Table Edit
12	GPJP_YEA_STATUS_SB	Character(1)	VARCHAR2(1) NOT NULL	SS YEA - Status Submitted used to load data Y/N Table Edit
13	ASOFDATE	Date(10)	DATE	As of Date
14	ERA1_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores the Era Name for the GP Year End Adjustment AE program.
15	ERA2_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores the Era Name for the GP Year End Adjustment AE program.
16	ERA3_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores the Era Name for the GP Year End Adjustment AE program.
17	ERA4_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores the Era Name for the GP Year End Adjustment AE program.
18	DAY_DESCR_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores descriptions used on the AE program GPJP_YEALOAD.
19	MONTH_DESCR_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores descriptions used on the AE program GPJP_YEALOAD.
20	YEAR_DESCR_JPN	Character(10)	VARCHAR2(10) NOT NULL	Stores descriptions used on the AE program GPJP_YEALOAD.