ST_ESPP_CNF_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	ESPP_RUN_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Processing Method A=Process All G=Process By Group P=Process by Participant
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	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID
6	STOCK_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Stock Plan Type E=Purchase Plan O=Option Plan
7	STOCK_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Stock Plan
8	OFFERING_ID	Character(10)	VARCHAR2(10) NOT NULL	Offering ID
9	PURCHASE_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase ID
10	PERIOD_END_DT	Date(10)	DATE	Period End Date
11	PROCESS_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Process Group
12	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
13	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
14	SQL_ID1	Character(30)	VARCHAR2(30) NOT NULL	TL
15	SQL_ID	Character(30)	VARCHAR2(30) NOT NULL	TL
16	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.
17	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
18	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
19	IF_FLAG	Character(1)	VARCHAR2(1) NOT NULL	If flag