BEN_SRCH_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	ASOFDATE	Date(10)	DATE	As of Date
5	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
6	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
7	RUNDATE	Date(10)	DATE	Process Scheduler Run Date
8	BEN_SRCH_TBL	Character(18)	VARCHAR2(18) NOT NULL	Used to AE pgm is supply table name
9	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
10	BEN_IF_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Used for Benefits Relate Lang processing
11	BEN_RELLANG_TBL	Character(18)	VARCHAR2(18) NOT NULL	Field used for the related Lang table
12	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
13	BEN_JOB_TBL	Character(18)	VARCHAR2(18) NOT NULL	Benefits Job TBL for AE pgm