STOCK_IDSTOCK_PLANOFFERING_IDST_OFFERING_VW(SQL View) |
Index Back |
|---|---|
ESPP Offering Period TableThis tables defines the Employee Stock Purchase Plan Offering Period |
| SELECT A.STOCK_ID , A.STOCK_PLAN , A.OFFERING_ID , A.PERIOD_BEGIN_DT , A.PERIOD_END_DT , A.DESCR FROM PS_ST_OFFERING_PD A WHERE A.STOCK_PLAN_TYPE = 'E' |
| # | 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 |
Character(10) | VARCHAR2(10) NOT NULL | Stock Plan |
| 3 | OFFERING_ID |
Character(10) | VARCHAR2(10) NOT NULL | Offering ID |
| 4 | PERIOD_BEGIN_DT | Date(10) | DATE | Period Begin Date |
| 5 | PERIOD_END_DT | Date(10) | DATE | Period End Date |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |