ST_PURCHASE_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID
4	STOCK_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Stock Plan Type E=Purchase Plan O=Option Plan
5	STOCK_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Stock Plan
6	OFFERING_ID	Character(10)	VARCHAR2(10) NOT NULL	Offering ID
7	PERIOD_END_DT	Date(10)	DATE	Period End Date
8	PROCESS_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Process Group
9	GRANT_DT	Date(10)	DATE	Grant Date
10	GRANT_FMV	Number(19,6)	DECIMAL(18,6) NOT NULL	Grant Fair Market Value
11	PURCHASE_FMV	Number(19,6)	DECIMAL(18,6) NOT NULL	Purchase FMV
12	PURCHASE_PRICE	Number(19,6)	DECIMAL(18,6) NOT NULL	Purchase Price
13	PURCH_PRC_NO_DISC	Number(19,6)	DECIMAL(18,6) NOT NULL	Price without Discount
14	SHARES_PURCHASED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Purchased
15	SHARES_UNROUNDED	Signed Number(23,9)	DECIMAL(21,9) NOT NULL	SHARES_UNROUNDED contains the full calculated vesting value based on the vesting percent and the vesting period count.
16	ESPP_CARRY_FWD_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	ESPP Carry Forward Amount
17	ESPP_PURCHASE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	ESPP Purchase Amount
18	ESPP_RESIDUAL_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Residual Amount
19	OFFER_PREV_CONTRIB	Number(19,6)	DECIMAL(18,6) NOT NULL	Offering Previous Contribution
20	OFFER_PREV_SHARES	Number(19,6)	DECIMAL(18,6) NOT NULL	Previous Shares Purchased
21	PURCH_PREV_CONTRIB	Number(19,6)	DECIMAL(18,6) NOT NULL	Purchase Period Other Contrib
22	PURCH_PREV_SHARES	Number(19,6)	DECIMAL(18,6) NOT NULL	Purchase Period Shares
23	ESPP_TOTAL_CONTRIB	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Contributions
24	PURCH_GRANT_VALUE	Number(19,6)	DECIMAL(18,6) NOT NULL	Grant Value
25	OFFER_GRANT_VALUE	Number(19,6)	DECIMAL(18,6) NOT NULL	Offering Grant Value
26	GRNT_VALUE_PARTIC	Number(16,6)	DECIMAL(15,6) NOT NULL	Participant Grant Value