ST_ESPP_PUR_AET(SQL Table) |
Index Back |
---|---|
State Record for ESPP_PURCH |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
5 | STOCK_ID | Character(10) | VARCHAR2(10) NOT NULL | Company's Stock Identification Symbol |
6 | STOCK_PLAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Stock Plan
E=Purchase Plan O=Option Plan |
7 | STOCK_PLAN | Character(10) | VARCHAR2(10) NOT NULL | Stock Plan |
8 | OFFERING_ID | Character(10) | VARCHAR2(10) NOT NULL | Offering ID |
9 | PURCHASE_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase ID |
10 | PERIOD_BEGIN_DT | Date(10) | DATE | Period Begin Date |
11 | PROCESS_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Process Group |
12 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
13 | PERIOD_END_DT | Date(10) | DATE | Period End Date |
14 | PURCHASE_LIM_RULE | Character(1) | VARCHAR2(1) NOT NULL |
FMV interpretation
C=Calendar Year Y=Years Offering Outstanding |
15 | 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 |
16 | ESPP_BAL_THRESHOLD | Number(3,0) | SMALLINT NOT NULL | Balance Threshold |
17 | 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 |
18 | 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 |
19 | 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. |
20 | DEC_PLACES | Number(3,0) | SMALLINT NOT NULL | Number of Decimal Places |
21 | DEC_PLACES2 | Number(3,0) | SMALLINT NOT NULL | Number of Decimal Places |
22 | PURCHASE_SHARE_LIM | Number(8,0) | INTEGER NOT NULL | Total Purchase Share Limit |
23 | PURCHASE_VALUE_LIM | Number(16,6) | DECIMAL(15,6) NOT NULL | Allows specification of an amount for Sec. 423(b) of the Internal Revenue code that no employee may be granted an option which permits his rights to purchase stock under all such plans of his employer corporation and its parent and subsidiary corporations to accrue at a rate which exceeds $25,000 of fair market value of such stock for each calendar year in which such option is outstanding. |
24 | PURCH_CONTRIB_LIM | Number(16,6) | DECIMAL(15,6) NOT NULL | Purchase Contribution Limit |
25 | PURCH_GRNT_VAL_LIM | Number(16,6) | DECIMAL(15,6) NOT NULL | Purchase Grant Value Limit |
26 | PURCH_SHARE_LIM_EE | Number(8,0) | INTEGER NOT NULL | Participant Share Purchase Lim |
27 | GRANT_SHARES_LIM | Number(7,0) | INTEGER NOT NULL | This field indicates the maximum number of shares which may be granted to an individual during a defined period. |
28 | OFFERING_SHARE_LIM | Number(8,0) | INTEGER NOT NULL | Offering Total Share Limit |
29 | OFFER_CONTRIB_LIM | Number(16,6) | DECIMAL(15,6) NOT NULL | Offer Contribution Limit |
30 | OFFER_GRNT_VAL_LIM | Number(16,6) | DECIMAL(15,6) NOT NULL | Offering Grant Value Limit |
31 | OFFER_SHARE_LIM_EE | Number(8,0) | INTEGER NOT NULL | Offering Participant Share Lim |
32 | PURCHASE_DISCOUNT | Number(6,2) | DECIMAL(5,2) NOT NULL | Purchase Discount |
33 | WHERE_CLAUSE | Long Character(500) | VARCHAR2(500) | Where Clause |
34 | 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 |
35 | EXCHANGE_ID | Character(10) | VARCHAR2(10) NOT NULL | Exchange ID |
36 | IF_FLAG | Character(1) | VARCHAR2(1) NOT NULL | If flag |
37 | AE_RETURN | Character(1) | VARCHAR2(1) NOT NULL | Return |
38 | UPDATE_SW | Character(1) | VARCHAR2(1) NOT NULL | Update Switch |
39 | ST_PRICE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Price Indicator
A=Ask Price B=Bid Price C=Close Price D=Average Bid/Ask H=High Price L=Low Price O=Open Price P=Private S=Average Open/Close W=Average High/Low |
40 | CONTINUE_AE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Continue AE Processing flag |
41 | ESPP_CONFIRM_RUN | Character(1) | VARCHAR2(1) NOT NULL | Confirm Purchase |
42 | AE_INT_1 | Number(1,0) | SMALLINT NOT NULL | Number Work Field |
43 | AE_INT_2 | Number(2,0) | SMALLINT NOT NULL | Number Work Field |
44 | GRANT_FMV | Number(19,6) | DECIMAL(18,6) NOT NULL | Grant Fair Market Value |
45 | PURCHASE_PRICE | Number(19,6) | DECIMAL(18,6) NOT NULL | Purchase Price |
46 | PURCHASE_FMV | Number(19,6) | DECIMAL(18,6) NOT NULL | Purchase FMV |
47 | PURCHASE_PRC_CALC | Number(19,6) | DECIMAL(18,6) NOT NULL | Calculated Purchase Price |
48 | ANTI_DILUTION_PRC | Number(19,6) | DECIMAL(18,6) NOT NULL | Anti Dilution Price |
49 | DATE_WRK | Date(10) | DATE | Date Work Field |
50 | GRANT_DT | Date(10) | DATE | Grant Date |
51 | ESPP_RESIDUAL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Residual Type
C=Carry Forward N=None R=Refund |
52 | ESPP_PRICE_AMT | Number(22,6) | DECIMAL(21,6) NOT NULL | ESPP Purchase Price Used |
53 | PURCHASE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Purchase Type
A=Anti-Dilution Purchase S=Standard Purchase |
54 | PRORATE_FACTOR | Number(8,3) | DECIMAL(7,3) NOT NULL | Prorate Factor |
55 | ESPP_HOLD_PERIOD | Number(3,0) | SMALLINT NOT NULL | ESPP Holding Period |
56 | ESPP_RUN_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Processing Method
A=Process All G=Process By Group P=Process by Participant |
57 | ST_SALE_HOLD_DT | Date(10) | DATE | Sale Hold Date |
58 | SQL_ID | Character(30) | VARCHAR2(30) NOT NULL | TL |
59 | SQL_ID2 | Character(30) | VARCHAR2(30) NOT NULL | TL |
60 | SQL_ID3 | Character(30) | VARCHAR2(30) NOT NULL | TL |
61 | SQL_ID4 | Character(30) | VARCHAR2(30) NOT NULL | TL |
62 | SQL_ID5 | Character(30) | VARCHAR2(30) NOT NULL | TL |
63 | SQL_ID6 | Character(30) | VARCHAR2(30) NOT NULL | TL |
64 | BEGIN_DT | Date(10) | DATE | Begin Date |
65 | CONFIRMED | Character(1) | VARCHAR2(1) NOT NULL | Confirmed |
66 | END_DT | Date(10) | DATE | end date |
67 | PERIOD_START_DATE | Date(10) | DATE | Start Date |
68 | PERIOD_STOP_DATE | Date(10) | DATE | Stop Date |
69 | DECIMAL_VALUE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Value Decimal |
70 | OFFERING_VALUE_MAX | Number(16,6) | DECIMAL(15,6) NOT NULL | Offering Period Maximum |
71 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
72 | CURRENCY_CD1 | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
73 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
74 | RT_RATE_INDEX | Character(10) | VARCHAR2(10) NOT NULL | Market Rate Index |
75 | DECIMAL_POS | Number(2,0) | SMALLINT NOT NULL | Decimal Position |
76 | 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. |