| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
PURCHASE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase ID
Prompt Table:
ST_PURCHASE_TBL
|
| 4 |
STOCK_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Stock ID
Prompt Table:
STOCK_TBL
|
| 5 |
STOCK_PLAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Stock Plan Type
E=Purchase Plan
O=Option Plan
Default Value: E
|
| 6 |
STOCK_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Stock Plan
Prompt Table:
STOCK_PLAN_TBL
|
| 7 |
OFFERING_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Offering ID
Prompt Table:
ST_OFFERING_PD
|
| 8 |
PERIOD_END_DT |
Date(10) |
DATE |
Period End Date
Prompt Table:
ST_PURCHASE_PD
|
| 9 |
ESPP_PARTIC_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Participants
Y/N Table Edit
Default Value: N
|
| 10 |
ESPP_GATHER_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Gather Contributions
Y/N Table Edit
Default Value: N
|
| 11 |
ESPP_CURR_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Convert Currencies
Y/N Table Edit
Default Value: N
|
| 12 |
ESPP_PURCHASE_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Stock
Y/N Table Edit
Default Value: N
|
| 13 |
ESPP_PRICE_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Prices
Y/N Table Edit
Default Value: N
|
| 14 |
ESPP_CONFIRM_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirm Purchase
Y/N Table Edit
Default Value: N
|
| 15 |
ESPP_UNCONFRM_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
UnConfirm Purchase
Y/N Table Edit
Default Value: N
|
| 16 |
STATUS_DT |
Date(10) |
DATE |
Status Date
|
| 17 |
ST_REPROCESS_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Reprocess
Y/N Table Edit
Default Value: N
|
| 18 |
ESPP_RUN_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Processing Method
A=Process All
G=Process By Group
P=Process by Participant
Default Value: A
|
| 19 |
ST_CALC_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Find Tax and Sale Info Year
|
| 20 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 21 |
ISSUANCE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of issuance - certificate or brokerage account
B=Broker
C=Certificate
E=Escrow
|
| 22 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON_NAME
|
| 23 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 24 |
FROMDATE |
Date(10) |
DATE |
From Date
|
| 25 |
THRUDATE |
Date(10) |
DATE |
End Date
|
| 26 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 27 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 28 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 29 |
ISSUANCE_TYPE_FROM |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of issuance - certificate or brokerage account
B=Broker
C=Certificate
|
| 30 |
ISSUANCE_TYPE_TO |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of issuance - certificate or brokerage account
B=Broker
C=Certificate
|
| 31 |
ST_BRANCH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Branch Identification
Prompt Table:
ST_BRKR_BRANCH
|
| 32 |
ST_BRANCH_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Branch ID
Prompt Table:
ST_BRKR_BRAN_VW
|
| 33 |
ST_BROKERAGE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Brokerage ID
Prompt Table:
ST_BROKER_TBL
|
| 34 |
ST_BROKERAGE_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Brokerage ID
Prompt Table:
ST_BROKER_TBL
|
| 35 |
INITIAL_ISSUANCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Initial Issuance
|
| 36 |
RERUN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rerun
N=No
Y=Yes
|
| 37 |
LAST_CONTROL_NO |
Character(1) |
VARCHAR2(1) NOT NULL |
Most Recent Control No
Y/N Table Edit
|
| 38 |
ST_PENDING_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Grant Pending FLag
Y/N Table Edit
|
| 39 |
ST_ACTIVE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Grant Active Flag
Y/N Table Edit
|
| 40 |
ST_SUSPEND_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Grant Suspend Flag
Y/N Table Edit
|
| 41 |
ST_CANCEL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Grant Cancel Flag
Y/N Table Edit
|
| 42 |
ST_EXPIRE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Expire Flag
D=Vested Shares Expire in
M=Vested Shares Expire in
Y/N Table Edit
|
| 43 |
ST_ACTIVE_EXER |
Character(1) |
VARCHAR2(1) NOT NULL |
Exercise Active
Y/N Table Edit
Default Value: Y
|
| 44 |
ST_CANCEL_EXER |
Character(1) |
VARCHAR2(1) NOT NULL |
Exercise Cancelled
Y/N Table Edit
|
| 45 |
ST_REVERSE_EXER |
Character(1) |
VARCHAR2(1) NOT NULL |
Exercise Reversed
Y/N Table Edit
|
| 46 |
ST_ALL_EXER |
Character(1) |
VARCHAR2(1) NOT NULL |
All Exercise
Y/N Table Edit
|
| 47 |
PROCESS_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Group
Prompt Table:
ST_PROCESS_GRP
|
| 48 |
ESPP_CONTRIB_DT |
Date(10) |
DATE |
Gather Contributions Date
Default Value: %Date
|