ST_ESPP_PRC_AET(SQL Table) |
Index Back |
---|---|
State Table For ESPP_PRICEState 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 |