PROCESS_INSTANCEOPRIDRUN_CNTL_IDA=Process All
G=Process By Group
P=Process by Participant
E=Purchase Plan
O=Option Plan
ESPP_REVERS_AET(SQL Table) |
Index Back |
|---|---|
Grant Value AE State RecordGrant Valuation AE State Record holds all bind variables used during the processing of the ST_VALUE AE process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | PURCHASE_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase ID |
| 5 | ESPP_RUN_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Processing Method
A=Process All G=Process By Group P=Process by Participant |
| 6 | PROCESS_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Process Group |
| 7 | STOCK_ID | Character(10) | VARCHAR2(10) NOT NULL | Company's Stock Identification Symbol |
| 8 | STOCK_PLAN | Character(10) | VARCHAR2(10) NOT NULL | Stock Plan |
| 9 | STOCK_PLAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Stock Plan
E=Purchase Plan O=Option Plan |
| 10 | OFFERING_ID | Character(10) | VARCHAR2(10) NOT NULL | Offering ID |
| 11 | PERIOD_END_DT | Date(10) | DATE | Period End Date |
| 12 | IF_FLAG | Character(1) | VARCHAR2(1) NOT NULL | If flag |
| 13 | ESPP_CONFIRM_RUN | Character(1) | VARCHAR2(1) NOT NULL | Confirm Purchase |