BEN_SRCH_H_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	DAY1	Number(2,0)	SMALLINT NOT NULL	Day 1
4	MONTH1	Number(2,0)	SMALLINT NOT NULL	Month 1
5	YEAR_DISPLAY	Number(4,0)	SMALLINT NOT NULL	Year Display
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
7	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
8	ASOFDATE	Date(10)	DATE	As of Date
9	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
10	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
11	RUNDATE	Date(10)	DATE	Process Scheduler Run Date
12	BEN_SRCH_TBL	Character(18)	VARCHAR2(18) NOT NULL	Used to AE pgm is supply table name
13	YEAR_NBR	Number(1,0)	SMALLINT NOT NULL	Years Number
14	PROCESS_IND	Character(1)	VARCHAR2(1) NOT NULL	Process Indicator A=Assign Benefit Program E=Elect Options N=Normal Processing P=Prepare Options R=Re-Enter V=Void
15	ASOF_DT	Date(10)	DATE	As of Date
16	PLAN_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	This is used to identify a category of Benefits Plans, based on their common functional attributes. 1=Health Benefits 2=Life and Accidental Death 3=Disability Insurance 4=Savings Plans 5=Leave 6=Spending Accounts 7=Retirement Plans 8=Pension Plans 9=Vacation Buy and Sell A=Simple Benefits
17	BEN_IF_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Used for Benefits Relate Lang processing
18	BEN_RELLANG_TBL	Character(18)	VARCHAR2(18) NOT NULL	Field used for the related Lang table
19	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
20	BEN_JOB_TBL	Character(18)	VARCHAR2(18) NOT NULL	Benefits Job TBL for AE pgm