ST_ACTN_PRC_VW2(SQL View) |
Index Back |
---|---|
Stock Option Type Prompt ViewThis 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 |