ST_PRDISP_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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee 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	PROCESS_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Process Group
8	PROCESS_GRP2	Character(10)	VARCHAR2(10) NOT NULL	Process Group
9	GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	System assigned grant number used to uniquely identify the grant record.
10	OFFERING_ID	Character(10)	VARCHAR2(10) NOT NULL	Offering ID
11	PERIOD_END_DT	Date(10)	DATE	Period End Date
12	DISPOSITION_DT	Date(10)	DATE NOT NULL	The date of the disposition.
13	EXERCISE_NBR	Number(8,0)	INTEGER NOT NULL	System assigned exercise number used to uniquely identify the exercise record.
14	ST_ORD_INCOME	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Ordinary Income
15	RELEASE_NBR	Number(8,0)	INTEGER NOT NULL	System assigned release number used to uniquely identify the release record.
16	DISPOSITION_NBR	Number(8,0)	INTEGER NOT NULL	System assigned disposition number used to uniquely identify the disposition record.
17	DISQUAL_DISPOSN	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether or not this is a disqualifying disposition based on governing body rules. N=No Y=Yes
18	PAYCHECK_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Paycheck number.
19	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag
20	UPDATE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Update Flag