STOCK_IDSTOCK_PLAN_TYPEE=Purchase Plan
O=Option Plan
STOCK_PLANEFFDTST_VC_NQ_VW(SQL View) |
Index Back |
|---|---|
Stock/VC NQ Plan Type ViewST_VC_NQ_VW is a view that displays all plan types that are of type Non-Qualifying Stock Option. This view is used as a prompt table for the Variable Comp definition panel if the Variable Comp plan type chosen as Stock - NQ. |
| SELECT O.STOCK_ID , O.STOCK_PLAN_TYPE , O.STOCK_PLAN , O.EFFDT , S.DESCR FROM PS_STOCK_PLAN_TBL S , PS_ST_OPTION_PLAN O WHERE S.STOCK_ID = O.STOCK_ID AND S.STOCK_PLAN_TYPE = O.STOCK_PLAN_TYPE AND S.STOCK_PLAN = O.STOCK_PLAN AND O.ST_OPTION_NQ = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STOCK_ID |
Character(10) | VARCHAR2(10) NOT NULL | Company's Stock Identification Symbol |
| 2 | STOCK_PLAN_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Type of Stock Plan
E=Purchase Plan O=Option Plan |
| 3 | STOCK_PLAN |
Character(10) | VARCHAR2(10) NOT NULL | Stock Plan |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |