| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERS_SRCH_GBL
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 3 |
STOCK_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Stock ID
Prompt Table:
STOCK_TBL
|
| 4 |
STOCK_PLAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Stock Plan Type
E=Purchase Plan
O=Option Plan
|
| 5 |
STOCK_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Stock Plan
Prompt Table:
STOCK_PLAN_TBL
|
| 6 |
OFFERING_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Offering ID
Prompt Table:
ST_OFFERING_PD
|
| 7 |
PERIOD_END_DT |
Date(10) |
DATE |
Period End Date
Prompt Table:
ST_PURCHASE_PD
|
| 8 |
PROCESS_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Group
|
| 9 |
GRANT_DT |
Date(10) |
DATE |
Grant Date
Prompt Table:
ST_ESPP_PARTIC
|
| 10 |
ESPP_HOLD_PURCHASE |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Purchase
E=Non-Employee
M=Major Shareholder
N=None
O=Other
T=Terminated or Non-Active
W=Withdrew from Plan
Default Value: N
|
| 11 |
ESPP_HOLD_REASON |
Character(10) |
VARCHAR2(10) NOT NULL |
Hold Reason
Prompt Table:
ST_HOLD_RSN_TBL
|
| 12 |
ESPP_GATHER_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Gather Contributions
Y/N Table Edit
Default Value: N
|
| 13 |
ESPP_CURR_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Convert Currencies
Y/N Table Edit
Default Value: N
|
| 14 |
ESPP_PURCHASE_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Stock
Y/N Table Edit
Default Value: N
|
| 15 |
CONFIRMED |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirmed
Y/N Table Edit
Default Value: N
|
| 16 |
ST_PARTIC_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Participation Override
Y/N Table Edit
Default Value: N
|