ST_OPTION_PARMS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Company's Stock Identification Symbol Prompt Table: STOCK_TBL
2	STOCK_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Stock Plan E=Purchase Plan O=Option Plan Default Value: O
3	STOCK_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Stock Plan Prompt Table: STOCK_PLAN_TBL
4	EFFDT	Date(10)	DATE	Effective Date Default Value: ST_OPTION_PLAN.EFFDT
5	OPTION_PARMS_ID	Character(10)	VARCHAR2(10) NOT NULL	The identifier associated with the parms for the option type defined.
6	ST_OPTION_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Option Type ISAR=ISO-Stock Appreciation Right ISO=Incentive Stock Option NQ=Non-Qualified NSAR=NQ-Stock Appreciation Right RSA=Restricted Stock Award
7	DFLT_OPTION_PARMS	Character(1)	VARCHAR2(1) NOT NULL	Default Y/N Table Edit Default Value: N
8	EXPIRE_BASIS_CD	Character(1)	VARCHAR2(1) NOT NULL	This field indicates which date is used as the base to calculate the length of time before an option expires. G=Grant Date H=Grant Date + 1 V=Vest Date W=Vest Date + 1
9	OPTION_LIFE_MM	Number(4,0)	SMALLINT NOT NULL	This field indicates the life of the option in numbers of months.
10	VEST_SCHED_ID	Character(10)	VARCHAR2(10) NOT NULL	The ID that identifies this vesting schedule. Prompt Table: ST_VEST_SCHED
11	AGREEMENT_ID	Character(10)	VARCHAR2(10) NOT NULL	Agreement ID Prompt Table: ST_AGREEMENT_VW
12	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description