ST_EXER_NQ_VW (SQL View)	Index Back
Non Qualified Exercise View This view will retrieve all exercises that occurred from Non-Qualified type options, such as NQs, RSA, NSARs, and ISARs with Payment Method of SAR Exercise.

ST_EXER_NQ_VW

(SQL View)

Non Qualified Exercise View

This view will retrieve all exercises that occurred from Non-Qualified type options, such as NQs, RSA, NSARs, and ISARs with Payment Method of SAR Exercise.

SELECT A.EMPLID ,A.STOCK_ID ,A.GRANT_NBR ,B.EXERCISE_NBR ,B.EXERCISE_DT ,A.ST_OPTION_TYPE ,B.SHARES_EXERCISED ,B.EXERCISE_FMV ,B.ST_ORD_INCOME FROM PS_ST_GRANT A , PS_ST_GRANT_EXER B WHERE A.EMPLID = B.EMPLID AND A.STOCK_ID = B.STOCK_ID AND A.GRANT_NBR = B.GRANT_NBR AND A.GRANT_STATUS = 'A' AND B.EXERCISE_STATUS = 'A' AND ((A.ST_OPTION_TYPE IN ('NQ','RSA','NSAR') OR (A.ST_OPTION_TYPE = 'ISAR' AND EXERCISE_METHOD = 'SAR')) OR ((A.ST_OPTION_TYPE = 'ISO' OR A.ST_OPTION_TYPE = 'ISAR') AND B.EXERCISE_DT >= A.ISO_EXER_AS_NQ_DT))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

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

4 EXERCISE_NBR Number(8,0) INTEGER NOT NULL System assigned exercise number used to uniquely identify the exercise record.

5 EXERCISE_DT Date(10) DATE Exercise Date

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 SHARES_EXERCISED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares exercised.

8 EXERCISE_FMV Number(19,6) DECIMAL(18,6) NOT NULL Exercise price - defaults to Exercise FMV

9 ST_ORD_INCOME Signed Number(20,6) DECIMAL(18,6) NOT NULL Ordinary Income

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID
3	GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	System assigned grant number used to uniquely identify the grant record.
4	EXERCISE_NBR	Number(8,0)	INTEGER NOT NULL	System assigned exercise number used to uniquely identify the exercise record.
5	EXERCISE_DT	Date(10)	DATE	Exercise Date
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	SHARES_EXERCISED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of shares exercised.
8	EXERCISE_FMV	Number(19,6)	DECIMAL(18,6) NOT NULL	Exercise price - defaults to Exercise FMV
9	ST_ORD_INCOME	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Ordinary Income