STOCK_IDPrompt Table: STOCK_TBL
E=Purchase Plan
O=Option Plan
Default Value: %date
ST_OPT_PLAN_VW2(SQL View) |
Index Back |
|---|---|
View of Option Plans |
| SELECT O.STOCK_ID , O.STOCK_PLAN_TYPE , EFFDT FROM PS_ST_OPTION_PLAN O , PS_STOCK_PLAN_TBL S WHERE O.STOCK_ID = S.STOCK_ID AND O.STOCK_PLAN_TYPE = S.STOCK_PLAN_TYPE AND O.STOCK_PLAN_TYPE = 'O' AND O.STOCK_PLAN = S.STOCK_PLAN AND EFFDT >= APPRVL_DT AND EFFDT <= EXPIRATN_DT AND EFFDT = ( SELECT MAX(EFFDT) FROM PS_ST_OPTION_PLAN WHERE STOCK_ID = O.STOCK_ID AND STOCK_PLAN_TYPE = 'O' AND STOCK_PLAN = O.STOCK_PLAN AND EFFDT <= %CurrentDateIn) |
| # | 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_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Stock Plan Type
E=Purchase Plan O=Option Plan |
| 3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |