ST_ESPP_DISPOSN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID
3	STOCK_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Stock Plan Type E=Purchase Plan O=Option Plan
4	STOCK_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Stock Plan
5	OFFERING_ID	Character(10)	VARCHAR2(10) NOT NULL	Offering ID
6	PERIOD_END_DT	Date(10)	DATE	Period End Date
7	PROCESS_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Process Group
8	DISPOSITION_NBR	Number(8,0)	INTEGER NOT NULL	System assigned disposition number used to uniquely identify the disposition record. Default Value: 0
9	GRANT_DT	Date(10)	DATE	Grant Date
10	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 Default Value: N
11	DISPOSITION_DT	Date(10)	DATE	The date of the disposition.
12	DISPOSITION_SRC	Character(1)	VARCHAR2(1) NOT NULL	Disposition Source A=Administrator S=Self Service T=Third Party Default Value: A
13	DISPOSITION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of disposition - sale or transfer. S=Sale T=Transfer Default Value: S
14	DISPOSITION_PRICE	Number(19,6)	DECIMAL(18,6) NOT NULL	The share price at time of disposition.
15	DISPOSN_RECEIPT_DT	Date(10)	DATE	Disposition Receipt Date
16	SHARES_DISPOSED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of shares disposed.
17	DISPOSITION_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Staus of disposition - active, pending for survey, void C=Confirmed P=Pending V=Void Default Value: P
18	STATUS_DT	Date(10)	DATE	Status Date
19	ST_ORD_INCOME	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Ordinary Income
20	ST_PR_DT	Date(10)	DATE	This field is the date that a transaction was sent to payroll.
21	PAYCHECK_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Paycheck number.
22	ST_SEND_SRC	Character(1)	VARCHAR2(1) NOT NULL	This field is for audit purposes and will determine how the tax information was delivered to Payroll: either via the interface with Paysheets or via a manual report. N=North American Payroll R=Stock Payroll Report
23	REVERSAL_DT	Date(10)	DATE	Reversal Date
24	PROCESS_GRP2	Character(10)	VARCHAR2(10) NOT NULL	Process Group
25	DISPOSN_SURVEY_DT	Date(10)	DATE	Disposition Survey Date
26	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
27	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.