ST_PARTIC_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	PURCHASE_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase 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	PERIOD_END_DT	Date(10)	DATE	Period End Date
10	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.
11	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
12	ESPP_PARTIC_RULE	Character(1)	VARCHAR2(1) NOT NULL	Participant Enrollment Rule C=Enroll in Current Offer/Pur Pd O=Enroll in Next Offering P=Enroll in Next Purchase Period U=User Defined
13	GRANT_DT	Date(10)	DATE	Grant Date
14	PERIOD_BEGIN_DT	Date(10)	DATE	Period Begin Date
15	BEGIN_DT	Date(10)	DATE	Begin Date
16	ESPP_RUN_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Processing Method A=Process All G=Process By Group P=Process by Participant
17	PROCESS_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Process Group
18	SQL_ID	Character(30)	VARCHAR2(30) NOT NULL	TL
19	IF_FLAG	Character(1)	VARCHAR2(1) NOT NULL	If flag
20	CONFIRMED	Character(1)	VARCHAR2(1) NOT NULL	Confirmed
21	OFFERING_ID_PREV	Character(10)	VARCHAR2(10) NOT NULL	Offering ID