ST_ESPP_CURR_VW(SQL View) |
Index Back |
|---|---|
Stock Purchase Currency ViewUsed by ST_PURCHASE_TBL for Stock Purchase currency combinations. |
| SELECT DISTINCT STOCK_ID ,STOCK_PLAN_TYPE ,STOCK_PLAN ,OFFERING_ID ,FROM_CUR ,TO_CUR FROM PS_ST_CONTRIB_PART |
| # | 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 |
| 4 | OFFERING_ID | Character(10) | VARCHAR2(10) NOT NULL | Offering ID |
| 5 | FROM_CUR | Character(3) | VARCHAR2(3) NOT NULL | From Currency Code |
| 6 | TO_CUR | Character(3) | VARCHAR2(3) NOT NULL | To Currency Code |