ST_PURCHASE_PD(SQL Table) |
Index Back |
---|---|
ESPP Purchase Period TableThis table define the purchase period for contributions for ESPP |
# | 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 Default Value: E |
3 | STOCK_PLAN | Character(10) | VARCHAR2(10) NOT NULL |
Stock Plan
Prompt Table: STOCK_PLAN_TBL |
4 | OFFERING_ID | Character(10) | VARCHAR2(10) NOT NULL |
Offering ID
Prompt Table: ST_OFFERING_PD |
5 | PERIOD_END_DT | Date(10) | DATE | Period End Date |
6 | PERIOD_BEGIN_DT | Date(10) | DATE | Period Begin Date |
7 | ESPP_PARTIC_RUN | Character(1) | VARCHAR2(1) NOT NULL | Update Participants |