| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 STOCK_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Company's Stock Identification Symbol
Prompt Table:
STOCK_TBL
|
| 2 |
STOCK_PLAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Stock Plan
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 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
PLAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
Default Value: 4A
Prompt Table:
SAVINGS_PLN_VW
|
| 6 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table:
ST_ESPP_SRCH
|
| 7 |
ST_GOVERN_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Contains the code used to identify the organization / entity responsible for setting the rules which govern the stock plans.
Prompt Table:
ST_GOVERN_BODY
|
| 8 |
OFFERING_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ESPP Offering Type
F=Fixed Offering
R=Rolling Offering
Default Value: F
|
| 9 |
OFFERING_CONC |
Character(1) |
VARCHAR2(1) NOT NULL |
Concurrent Offerings
Y/N Table Edit
Default Value: N
|
| 10 |
OFFERING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Offering Period Length
|
| 11 |
PURCHASE_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Purchase Period Length
|
| 12 |
ESPP_NAP_CONTRIB |
Character(1) |
VARCHAR2(1) NOT NULL |
North American Payroll
Y/N Table Edit
Default Value: N
|
| 13 |
ESPP_MAN_CONTRIB |
Character(1) |
VARCHAR2(1) NOT NULL |
Manual Contributions
Y/N Table Edit
Default Value: N
|
| 14 |
RT_RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Market Rate Index
Prompt Table:
RT_INDEX_TBL
|
| 15 |
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.
Default Value: INSTALLATION.EXCHNG_TO_RT_TYPE
Prompt Table:
RT_TYPE_TBL
|
| 16 |
PURCHASE_FMV_MTHD |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase FMV Method
Default Value: STOCK_DTL.FMV_METHOD
Prompt Table:
ST_FMV_MTHD_TBL
|
| 17 |
OFFER_BGN_FMV_MTHD |
Character(10) |
VARCHAR2(10) NOT NULL |
Offering Begin FMV Method
Default Value: STOCK_DTL.FMV_METHOD
Prompt Table:
ST_FMV_MTHD_TBL
|
| 18 |
GRANT_FMV_MTHD |
Character(10) |
VARCHAR2(10) NOT NULL |
Grant FMV Method
Default Value: STOCK_DTL.FMV_METHOD
Prompt Table:
ST_FMV_MTHD_TBL
|
| 19 |
DAILY_FMV_MTHD |
Character(10) |
VARCHAR2(10) NOT NULL |
Daily FMV Method
Prompt Table:
ST_FMV_MTHD_TBL
|
| 20 |
FMV_HOLIDAY_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates what day is used to determine the Fair Market Value of transactions that occur on a holiday.
N=Next Trading Day
P=Previous Trading Day
Default Value: P
|
| 21 |
FMV_WEEKEND_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates what day is used to determine the Fair Market Value of transactions that occur over a weekend.
1=Both Previous Trading Day
2=Both Next Trading Day
3=Saturday Next-Sunday Previous
4=Saturday Previous-Sunday Next
Default Value: 1
|
| 22 |
PURCHASE_PRC_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Price Rule
A=Average Daily FMV in Purch Pd
G=Grant FMV
L=Lower of Grant or Purchase FMV
P=Purchase FMV
X=User Defined
Default Value: L
|
| 23 |
PURCHASE_DISCOUNT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Purchase Discount
|
| 24 |
ESPP_QUICK_SALES |
Character(1) |
VARCHAR2(1) NOT NULL |
Quick Sales Allowed
Y/N Table Edit
Default Value: N
|
| 25 |
ESPP_HOLD_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
ESPP Holding Period
|
| 26 |
ESPP_INTEREST_PAID |
Character(1) |
VARCHAR2(1) NOT NULL |
Interest Paid
Y/N Table Edit
Default Value: N
|
| 27 |
PURCH_CONTRIB_LIM |
Number(16,6) |
DECIMAL(15,6) NOT NULL |
Purchase Contribution Limit
|
| 28 |
PURCH_SHARE_LIM_EE |
Number(8,0) |
INTEGER NOT NULL |
Participant Share Purchase Lim
|
| 29 |
PURCHASE_SHARE_LIM |
Number(8,0) |
INTEGER NOT NULL |
Total Purchase Share Limit
|
| 30 |
OFFER_CONTRIB_LIM |
Number(16,6) |
DECIMAL(15,6) NOT NULL |
Offer Contribution Limit
|
| 31 |
OFFER_SHARE_LIM_EE |
Number(8,0) |
INTEGER NOT NULL |
Offering Participant Share Lim
|
| 32 |
OFFERING_SHARE_LIM |
Number(8,0) |
INTEGER NOT NULL |
Offering Total Share Limit
|
| 33 |
PURCHASE_PRORATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pro-Rate Purchase
Y/N Table Edit
Default Value: N
|
| 34 |
ESPP_BALANCE_RULE |
Character(3) |
VARCHAR2(3) NOT NULL |
Balance Rule
CF=Carry Forward Balance
CFP=Carry Fwd when <= Purch Price
RF=Refund Balance
RFP=Refund when >= Purchase Price
Default Value: RFP
|
| 35 |
ESPP_BAL_THRESHOLD |
Number(3,0) |
SMALLINT NOT NULL |
Balance Threshold
|
| 36 |
DEC_PLACES |
Number(3,0) |
SMALLINT NOT NULL |
Number of Decimal Places
|
| 37 |
ST_ROUNDING_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine how the shares will be rounded to the maximum decimal point.
D=Round Down
S=Standard Rounding
U=Round Up
Default Value: D
|
| 38 |
DEC_PLACES2 |
Number(3,0) |
SMALLINT NOT NULL |
Number of Decimal Places
|
| 39 |
ST_ROUNDING_RULE2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine how thestock prices will be rounded to the maximum decimal point.
D=Round Down
S=Standard Rounding
U=Round Up
|
| 40 |
OFFER_GRNT_VAL_LIM |
Number(16,6) |
DECIMAL(15,6) NOT NULL |
Offering Grant Value Limit
|
| 41 |
PURCH_GRNT_VAL_LIM |
Number(16,6) |
DECIMAL(15,6) NOT NULL |
Purchase Grant Value Limit
|
| 42 |
ESPP_PARTIC_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Participant Enrollment Rule
C=Enroll in Current Offer/Pur Pd
O=Enroll in Next Offering
P=Enroll in Next Purchase Period
U=User Defined
Default Value: O
|
| 43 |
ST_VALUE_PLAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Valuation Plan Type
A=A:Max Shrs on Grant Price
B=B:Max Shrs on Witholding
C=C:Multi Purchase Offering
D=D:Multi Pur Offer with reset
E=E:Multi Pur Offer w/rollover
F=F:C+ Allow % chg after Purch
G=G:Single Purch Chg % anytime
H=H:C+G Multi Pur Chg % anytime
I=I:G+Allow Cash/Retro Increase
|
| 44 |
ST_FAS_COMP_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
FAS 123 Compensatory Plan
Y/N Table Edit
Default Value: Y
|
| 45 |
COMMENTS |
Long Character |
CLOB |
Comment
|