ST_AE_OPTN_BAL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID Prompt Table: STOCK_TBL
2	STOCK_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Stock Plan Type E=Purchase Plan O=Option Plan
3	STOCK_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Stock Plan
4	AS_OF_DATE	Date(10)	DATE	As of Date
5	OPTION_OUTSTANDING	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Options Outstanding
6	SHARES_ALLOC_PLAN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Plan Shares Allocated
7	SHARES_AUTHORIZED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Authorized But Unissued
8	SHARES_AVAIL_ISSUE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Available to Issue
9	SHARES_CANCELLED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Cancelled
10	SHARES_EXERCISED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of shares exercised.
11	SHARES_EXPIRED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Expired
12	SHARES_GRANTED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of shares granted.
13	SHARES_RELEASED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	The number of shares released.
14	SHARES_REPURCHASED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of shares repurchased.
15	SHARES_SWAPPED	Number(19,6)	DECIMAL(18,6) NOT NULL	Total number of shares swapped.
16	SHARES_EXER_SAR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Exercised SAR Shares
17	SHARES_CANCEL_PLAN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Cancelled
18	SHARES_EXPIRE_PLAN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Shares Expired
19	SHARES_ALLOC_EXPIR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Plan Shares Expired