EMPLIDSTOCK_IDGRANT_NBREXERCISE_NBRRELEASE_NBRISAR=ISO-Stock Appreciation Right
ISO=Incentive Stock Option
NQ=Non-Qualified
NSAR=NQ-Stock Appreciation Right
RSA=Restricted Stock Award
ST_REL_ISO_VW(SQL View) |
Index Back |
|---|---|
Qualified Release ViewThis view will retrieve all releases that occurred from Qualified type options, such as ISOs. |
| 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 = 'ISO' OR A.ST_OPTION_TYPE = 'ISAR') |
| # | 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 | 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_AMT_INCOME | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | AMT Income |