ST_OPTN_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	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID Prompt Table: STOCK_TBL
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	AS_OF_DATE	Date(10)	DATE	As of Date
8	OPTION_OUTSTANDING	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Options Outstanding
9	SHARES_ALLOC_PLAN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Plan Shares Allocated
10	SHARES_AUTHORIZED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Authorized But Unissued
11	SHARES_AVAIL_ISSUE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Available to Issue
12	SHARES_CANCELLED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Cancelled
13	SHARES_EXERCISED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of shares exercised.
14	SHARES_EXPIRED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Expired
15	SHARES_GRANTED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of shares granted.
16	SHARES_RELEASED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	The number of shares released.
17	SHARES_REPURCHASED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of shares repurchased.
18	SHARES_SWAPPED	Number(19,6)	DECIMAL(18,6) NOT NULL	Total number of shares swapped.
19	SHARES_EXER_SWAP	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Exercised Shares Swapped
20	SHARES_REL_SWAP	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Released Shares Swapped
21	SHARES_EXER_SAR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Exercised SAR Shares
22	SHARES_CANCEL_RPRC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Cancelled from Reprice
23	SHARES_EXPIRE_RPRC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Expired from Reprice
24	SHARES_CANCEL_PLAN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Cancelled
25	SHARES_EXPIRE_PLAN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Expired
26	SHARES_CAN_PLAN_RP	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Cancelled
27	SHARES_EXP_PLAN_RP	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Expired
28	SHARES_ALLOC_EXPIR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Plan Shares Expired