| # |
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 |
Stock ID
|
| 5 |
STOCK_PLAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Stock Plan Type
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
|