STOCK_IDPrompt Table: STOCK_TBL
STOCK_PLANPrompt Table: STOCK_PLAN_TBL
EFFDTST_OPT_PLAN_VW(SQL View) |
Index Back |
|---|---|
Stock Option PlanThis table defines various stock option plans and contains business rules which pertain at the stock option plan level. |
| SELECT A.STOCK_ID , A.STOCK_PLAN , A.EFFDT , B.DESCR FROM PS_ST_OPTION_PLAN A , PS_STOCK_PLAN_TBL B WHERE A.STOCK_ID = B.STOCK_ID AND B.STOCK_PLAN_TYPE = 'O' AND A.STOCK_PLAN = B.STOCK_PLAN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STOCK_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Stock ID
Prompt Table: STOCK_TBL |
| 2 | STOCK_PLAN |
Character(10) | VARCHAR2(10) NOT NULL |
Stock Plan
Prompt Table: STOCK_PLAN_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |