ST_ACTN_PRC_VW2

(SQL View)
Index Back

Stock Option Type Prompt View

This view list the Stock Option Types for a particular individual.

SELECT DISTINCT A.EMPLID , A.STOCK_ID , A.ST_OPTION_TYPE FROM PS_ST_GRANT A WHERE A.ST_CANCEL_DT IS NULL

# 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 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