ST_ESPP_UNC_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	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID
5	STOCK_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Stock Plan Type E=Purchase Plan O=Option Plan
6	STOCK_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Stock Plan
7	OFFERING_ID	Character(10)	VARCHAR2(10) NOT NULL	Offering ID
8	PURCHASE_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase ID
9	PERIOD_END_DT	Date(10)	DATE	Period End Date
10	PROCESS_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Process Group
11	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
12	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
13	SQL_ID	Character(30)	VARCHAR2(30) NOT NULL	TL
14	SQL_ID1	Character(30)	VARCHAR2(30) NOT NULL	TL
15	ESPP_RUN_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Processing Method A=Process All G=Process By Group P=Process by Participant
16	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
17	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
18	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
19	IF_FLAG	Character(1)	VARCHAR2(1) NOT NULL	If flag
20	SQL_ID2	Character(30)	VARCHAR2(30) NOT NULL	TL
21	SQL_ID3	Character(30)	VARCHAR2(30) NOT NULL	TL