STOCK_IDSTOCK_PLAN_TYPEE=Purchase Plan
O=Option Plan
STOCK_PLANST_FMV_OPTN_VW(SQL View) |
Index Back |
|---|
| SELECT A.STOCK_ID , A.STOCK_PLAN_TYPE , A.STOCK_PLAN FROM PS_STOCK_PLAN_TBL A , PS_ST_OPTION_PLAN B , PS_ST_ESPP_PLAN C WHERE A.STOCK_ID = B.STOCK_ID AND A.STOCK_PLAN_TYPE IN ('E','O') AND (A.STOCK_PLAN = B.STOCK_PLAN OR A.STOCK_PLAN = C.STOCK_PLAN) GROUP BY A.STOCK_ID, A.STOCK_PLAN_TYPE, A.STOCK_PLAN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STOCK_ID |
Character(10) | VARCHAR2(10) NOT NULL | Stock ID |
| 2 | STOCK_PLAN_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Stock Plan Type
E=Purchase Plan O=Option Plan |
| 3 | STOCK_PLAN |
Character(10) | VARCHAR2(10) NOT NULL | Stock Plan |