ST_ESPP_PRC_AET

(SQL Table)
Index Back

State Table For ESPP_PRICE

State Table Used for ESPP_PRICE AE Program.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Company's Stock Identification Symbol
5 STOCK_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Stock Plan
E=Purchase Plan
O=Option Plan
6 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan
7 OFFERING_ID Character(10) VARCHAR2(10) NOT NULL Offering ID
8 PURCHASE_ID Character(10) VARCHAR2(10) NOT NULL Purchase ID
9 PERIOD_BEGIN_DT Date(10) DATE Period Begin Date
10 GRANT_DT Date(10) DATE Grant Date
11 ESPP_PURCH_RULE Character(1) VARCHAR2(1) NOT NULL Purchase Price Rule
1=Use Beginning of Period FMV
2=Use End of Period FMV
3=Use Lower of Beginning or End
12 PERIOD_END_DT Date(10) DATE Period End Date
13 PURCHASE_DISCOUNT Number(6,2) DECIMAL(5,2) NOT NULL Purchase Discount
14 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
15 GRANT_FMV_MTHD Character(10) VARCHAR2(10) NOT NULL Grant FMV Method
16 PURCHASE_FMV_MTHD Character(10) VARCHAR2(10) NOT NULL Purchase FMV Method
17 DAILY_FMV_MTHD Character(10) VARCHAR2(10) NOT NULL Daily FMV Method
18 WHERE_CLAUSE Long Character(500) VARCHAR2(500) Where Clause
19 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
20 FMV_AVERAGE_DAYS Number(3,0) SMALLINT NOT NULL FMV Average Days
21 CURRENT_PRIOR_DAY Character(1) VARCHAR2(1) NOT NULL Current/Prior Business Day
C=Current Business Day
P=Prior Business Day
22 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
23 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule
24 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
25 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
26 EXCHANGE_ID Character(10) VARCHAR2(10) NOT NULL Exchange ID
27 IF_FLAG Character(1) VARCHAR2(1) NOT NULL If flag
28 AE_RETURN Character(1) VARCHAR2(1) NOT NULL Return
29 UPDATE_SW Character(1) VARCHAR2(1) NOT NULL Update Switch
30 CONTINUE_AE_FLAG Character(1) VARCHAR2(1) NOT NULL Continue AE Processing flag
31 LOGICAL_OPERATOR Character(2) VARCHAR2(2) NOT NULL Logical Operator
32 AE_INT_1 Number(1,0) SMALLINT NOT NULL Number Work Field
33 ONVALUE Character(4) VARCHAR2(4) NOT NULL On Value
34 GRANT_FMV Number(19,6) DECIMAL(18,6) NOT NULL Grant Fair Market Value
35 PURCHASE_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Purchase Price
36 PURCHASE_FMV Number(19,6) DECIMAL(18,6) NOT NULL Purchase FMV
37 PURCHASE_PRC_CALC Number(19,6) DECIMAL(18,6) NOT NULL Calculated Purchase Price
38 GRANT_FMV_HOLD Number(19,6) DECIMAL(18,6) NOT NULL Grant FMV Hold
39 NUM_OF_SETS Number(4,0) SMALLINT NOT NULL Number of Sets
40 AASSIGN_CMPNT1 Character(18) VARCHAR2(18) NOT NULL Alternate Name
41 COUNTER_GLOB Number(19,3) DECIMAL(18,3) NOT NULL Counter
42 DATE_WRK Date(10) DATE Date Work Field
43 TEMPDATE Date(10) DATE TempDate
44 NUM_PRD Number(16,6) DECIMAL(15,6) NOT NULL Period of Adjustment
45 PURCH_PRC_NO_DISC Number(19,6) DECIMAL(18,6) NOT NULL Price without Discount