ST_GRANT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_ST_GT
2	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Company's Stock Identification Symbol Prompt Table: STOCK_TBL
3	GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	System assigned grant number used to uniquely identify the grant record.
4	GRANT_DT	Date(10)	DATE NOT NULL	Grant Date
5	STOCK_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Stock Plan Prompt Table: ST_OPT_PLAN_VW
6	VC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	VC Plan ID
7	VC_PAYOUT_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Payout Period ID
8	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
9	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: ST_GRANT_ERNS
10	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
11	SHARES_GRANTED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of shares granted.
12	GRANT_PRICE	Number(19,6)	DECIMAL(18,6) NOT NULL	Price an employee pays to exercise the option. Default Value: 0
13	GRANT_REASON	Character(4)	VARCHAR2(4) NOT NULL	Grant Reason Prompt Table: ST_GRNT_RSN_TBL
14	EXER_BFR_VEST	Character(1)	VARCHAR2(1) NOT NULL	This field indicates that exercise is allowed before vesting. Typically used with RSA's. N=No Y=Yes Y/N Table Edit Default Value: N
15	TRANSFER_ALLOW	Character(1)	VARCHAR2(1) NOT NULL	Transferable Options N=No Y=Yes Y/N Table Edit Default Value: N
16	AGREEMENT_ID	Character(10)	VARCHAR2(10) NOT NULL	Agreement ID Prompt Table: ST_AGREEMENT_VW
17	AGREEMENT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Identifies whether the agreement was accepted, rescinded, or offer outstanding. A=Accepted Offer O=Outstanding Offer R=Rescinded Offer Default Value: O
18	AGREEMENT_DT	Date(10)	DATE	Agreement Date
19	GRANT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Grant Status A=Active P=Pending V=Void - Data Entry Error Default Value: P
20	STATUS_DT	Date(10)	DATE NOT NULL	Status Date Default Value: %date
21	ISO_LIM_GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	Number of grant which is created due to an over limit ISO condition.
22	REPRICE_GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	Number of the replacing grant due to reprice. Prompt Table: ST_GRNT_REPR_VW
23	ST_CANCEL_DT	Date(10)	DATE	Cancelation Date
24	ST_CANCEL_REASON	Character(4)	VARCHAR2(4) NOT NULL	Reason shares were cancelled. RESC=Employee Rescinded Offer RPRC=Reprice TER=Termination
25	STOCK_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Stock Action Prompt Table: STOCK_ACTN_TBL
26	STOCK_ACTION_DT	Date(10)	DATE	Date the stock action is effective.
27	VEST_SUSPEND_DT	Date(10)	DATE	The date vesting is suspended when an employee is on leave.
28	VEST_DEFER_DT	Date(10)	DATE	The date the employee must return from leave to avoid vesting deferral.
29	EXER_SUSPND_BGN_DT	Date(10)	DATE	No exercises will be allowed on or after this date.
30	EXER_SUSPND_END_DT	Date(10)	DATE	Used in conjunction with Exer_Suspnd_Bgn_Dt.
31	EXERCISE_HOLD_DT	Date(10)	DATE	Exercise Hold Date
32	ISO_EXER_AS_NQ_DT	Date(10)	DATE	Excercises on or after this date must be treated as NQ
33	RET_ELIG	Character(1)	VARCHAR2(1) NOT NULL	Retirement Eligible Y/N Table Edit Default Value: N
34	RET_ELIG_DT	Date(10)	DATE	Retire Eligible Dt
35	FORECAST_RET_ELIG	Character(1)	VARCHAR2(1) NOT NULL	Forecast Retirement Eligible Y/N Table Edit Default Value: N
36	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.
37	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.
38	COMMENTS	Long Character	CLOB