ST_EXER_TRAN_VW (SQL View)	Index Back
View grant exercises

ST_EXER_TRAN_VW

(SQL View)

View grant exercises

SELECT EMPLID , STOCK_ID , GRANT_NBR , COUNT(*) FROM PS_ST_GRANT_EXER GROUP BY EMPLID , STOCK_ID , GRANT_NBR

# 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 Company's Stock Identification Symbol
Prompt Table: ST_OPT_PLAN_VW2

3 GRANT_NBR Character(10) VARCHAR2(10) NOT NULL System assigned grant number used to uniquely identify the grant record.

4 EXER_TRAN_COUNT Number(12,0) DECIMAL(12) NOT NULL Holds the number of exercise transactions found.

#	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	Company's Stock Identification Symbol Prompt Table: ST_OPT_PLAN_VW2
3	GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	System assigned grant number used to uniquely identify the grant record.
4	EXER_TRAN_COUNT	Number(12,0)	DECIMAL(12) NOT NULL	Holds the number of exercise transactions found.