EMPLIDSTOCK_IDST_OPTION_TYPEISAR=ISO-Stock Appreciation Right
ISO=Incentive Stock Option
NQ=Non-Qualified
NSAR=NQ-Stock Appreciation Right
RSA=Restricted Stock Award
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 |