| # |
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 Record
|
| 3 |
STOCK_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Company's Stock Identification Symbol
Prompt Table:
STOCK_TBL
|
| 4 |
STOCK_PLAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Stock Plan
E=Purchase Plan
O=Option Plan
Default Value: E
|
| 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 NOT NULL |
Period End Date
Prompt Table:
ST_PURCHASE_PD
|
| 8 |
PROCESS_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Group
Prompt Table:
ST_PROCESS_GRP
|
| 9 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 10 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 11 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 12 |
ESPP_RESIDUAL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Residual Type
C=Carry Forward
N=None
R=Refund
|
| 13 |
ESPP_RESIDUAL_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Residual Amount
|
| 14 |
FROM_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
From Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 15 |
ESPP_CONTRIB_AMT |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Contribution Amount
|
| 16 |
TO_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
To Currency Code
|
| 17 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 18 |
RT_RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Market Rate Index
|
| 19 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 20 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 21 |
ST_OVRD_MARKET_RT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Exchange Rate Override
|
| 22 |
EXCHANGE_DT |
Date(10) |
DATE |
Exchange Date
|
| 23 |
ESPP_CONTRIB_STS |
Character(1) |
VARCHAR2(1) NOT NULL |
Contribution Status
N=New Contribution
P=Processed Contribution
R=Refunded
V=Reversed
Default Value: N
|
| 24 |
ESPP_REFUND_STS |
Character(1) |
VARCHAR2(1) NOT NULL |
Refund Status
P=Processed
R=Refunded
U=UnProcessed
V=Reversed
|
| 25 |
STATUS_DT |
Date(10) |
DATE |
Status Date
|
| 26 |
ST_PR_DT |
Date(10) |
DATE |
This field is the date that a transaction was sent to payroll.
|
| 27 |
ST_SEND_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is for audit purposes and will determine how the tax information was delivered to Payroll: either via the interface with Paysheets or via a manual report.
N=North American Payroll
R=Stock Payroll Report
|
| 28 |
OFFERING_NEXT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Next Offering ID
|
| 29 |
PERIOD_END_DATE |
Date(10) |
DATE |
Period End Date
|
| 30 |
CONFIRMED |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirmed
Y/N Table Edit
Default Value: N
|