| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERS_SRCH_GBL
|
| 2 |
STOCK_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Stock ID
Prompt Table:
STOCK_TBL
|
| 3 |
STOCK_PLAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Stock Plan Type
E=Purchase Plan
O=Option Plan
|
| 4 |
STOCK_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Stock Plan
Prompt Table:
STOCK_PLAN_TBL
|
| 5 |
OFFERING_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Offering ID
Prompt Table:
ST_OFFERING_PD
|
| 6 |
PERIOD_END_DT |
Date(10) |
DATE |
Period End Date
Prompt Table:
ST_PURCHASE_PD
|
| 7 |
PROCESS_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Group
|
| 8 |
GRANT_DT |
Date(10) |
DATE |
Grant Date
|
| 9 |
ISSUANCE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of issuance - certificate or brokerage account
B=Broker
C=Certificate
E=Escrow
|
| 10 |
ST_BROKERAGE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Brokerage ID
|
| 11 |
ST_BRANCH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Branch Identification
|
| 12 |
ST_ACCOUNT_NBR |
Character(17) |
VARCHAR2(17) NOT NULL |
This field contains the account number to use when issuing the shares.
|
| 13 |
REGISTRATION_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Registration Name
|
| 14 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
Prompt Table:
ADDRESS_TYP_TBL
|
| 15 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
SCC_CNT_ADFMTVW
|
| 16 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 17 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 18 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 19 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 20 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 21 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 22 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 23 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 24 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 25 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 26 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 27 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 28 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 29 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 30 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 31 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 32 |
LEGEND_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This field indicates what issuance instructions are to be sent to the broker.
|
| 33 |
SHARES_PURCHASED |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Shares Purchased
|
| 34 |
PURCHASE_PRICE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Purchase Price
|
| 35 |
GRANT_FMV |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Grant Fair Market Value
|
| 36 |
PURCHASE_FMV |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Purchase FMV
|
| 37 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 38 |
ESPP_CARRY_FWD_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
ESPP Carry Forward Amount
|
| 39 |
ESPP_STOCK_CONTRIB |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
ESPP Stock Contribution Amount
|
| 40 |
ESPP_PURCHASE_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
ESPP Purchase Amount
|
| 41 |
ESPP_RESIDUAL_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Residual Amount
|
| 42 |
ESPP_RESIDUAL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Residual Type
C=Carry Forward
N=None
R=Refund
|
| 43 |
ESPP_TICK_IRS_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
IRS Purchase Value
|
| 44 |
ESPP_DISCOUNT_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Purchase Discount Amount
|
| 45 |
ST_ORD_INCOME |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Ordinary Income
|
| 46 |
ST_SALE_HOLD_DT |
Date(10) |
DATE |
Sale Hold Date
|
| 47 |
ESPP_QUICK_SALES |
Character(1) |
VARCHAR2(1) NOT NULL |
Quick Sales Allowed
Default Value: N
|
| 48 |
CONFIRMED |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirmed
Y/N Table Edit
Default Value: N
|
| 49 |
TRANSFER_CNTL_NBR |
Number(7,0) |
INTEGER NOT NULL |
Number assisgned to identify instructions to the transfer agent.
|
| 50 |
TRANSFER_ISSUE_DT |
Date(10) |
DATE |
Date the transfer issuance instructions are printed.
|
| 51 |
BRANCH_CNTL_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Number assigned to identify instructions to the brokerage branch.
|
| 52 |
BRANCH_ISSUE_DT |
Date(10) |
DATE |
Date the branch issuance instructions are printed.
|
| 53 |
PURCH_RECEIPT_DT |
Date(10) |
DATE |
Purchase Receipt Date
|