ST_REL_NQ_VW

(SQL View)
 Index Back

Non Qualified Release View

This view will retrieve all releases that occurred from Non-Qualified type options, such as NQs and RSA.

SELECT A.EMPLID , A.STOCK_ID , A.GRANT_NBR , B.EXERCISE_NBR , B.RELEASE_NBR , B.RELEASE_DT , A.ST_OPTION_TYPE , B.SHARES_RELEASED , B.RELEASE_FMV , B.ST_ORD_INCOME FROM PS_ST_GRANT A , PS_ST_EXER_RELEASE 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.RELEASE_STATUS = 'A' AND A.ST_OPTION_TYPE IN ('NQ','RSA','NSAR')

# 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 Company's Stock Identification Symbol
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 RELEASE_NBR Number(8,0) INTEGER NOT NULL System assigned release number used to uniquely identify the release record.
6 RELEASE_DT Date(10) DATE The date of this release transaction.
7 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
8 SHARES_RELEASED Signed Number(20,6) DECIMAL(18,6) NOT NULL The number of shares released.
9 RELEASE_FMV Number(19,6) DECIMAL(18,6) NOT NULL Fair market value of the shares released.
10 ST_ORD_INCOME Signed Number(20,6) DECIMAL(18,6) NOT NULL Ordinary Income