ST_GRNT_ACTV_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID 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
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 Rcd Nbr
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: STOCK_AGREEMENT
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_GRANT_VW3
23	ST_CANCEL_DT	Date(10)	DATE	Cancellation 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	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.
34	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.
35	COMMENTS	Long Character	CLOB	Comment