| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
STOCK_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Stock ID
Default Value: ST_GRANT.STOCK_ID
|
| 3 |
GRANT_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
System assigned grant number used to uniquely identify the grant record.
|
| 4 |
EXERCISE_NBR |
Number(8,0) |
INTEGER NOT NULL |
System assigned exercise number used to uniquely identify the exercise record.
Default Value: 0
|
| 5 |
STOCK_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Stock Plan
Default Value: ST_GRANT.STOCK_PLAN
|
| 6 |
EXERCISE_DT |
Date(10) |
DATE NOT NULL |
Exercise Date
|
| 7 |
SHARES_EXERCISED |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Number of shares exercised.
|
| 8 |
EXERCISE_FMV |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Exercise price - defaults to Exercise FMV
|
| 9 |
EXERCISE_VALUE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Exercise Value
|
| 10 |
EXERCISE_COST |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Cost of Shares
|
| 11 |
EXERCISE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Holds the information related to exercising stock options.
A=Active
P=Pending
V=Void
Default Value: A
|
| 12 |
STATUS_DT |
Date(10) |
DATE |
Status Date
Default Value: %date
|
| 13 |
RESTRICTD_EXERCISE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether or not the exercise is for unvested shares.
Y/N Table Edit
Default Value: N
|
| 14 |
ELECTION_83B |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether or not an employee has elected to file an 83B.
Y/N Table Edit
Default Value: N
|
| 15 |
ELECTION_83B_DT |
Date(10) |
DATE |
The date that the 83B election was filed.
|
| 16 |
EXERCISE_METHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
Exercise Method
CASH=Cash
LOAN=Loan
SAR=SAR Exercise
SDS=Same Day Sale
STC=Sell to Cover
SWAP=Swap
Default Value: CASH
|
| 17 |
TRADE_FOR_TAXES |
Character(1) |
VARCHAR2(1) NOT NULL |
Trade For Taxes
Y/N Table Edit
Default Value: N
|
| 18 |
ST_COST_SHARE_SOLD |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Number of shares sold from this exercise.
Default Value: 0
|
| 19 |
ST_COST_SALE_PRICE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Sale price of shares sold from this exercise.
Default Value: 0
|
| 20 |
EST_GROSS_PROCEEDS |
Signed Number(23,6) |
DECIMAL(21,6) NOT NULL |
The estimated gross proceeds from the sale.
|
| 21 |
DISPOSITION_NBR |
Number(8,0) |
INTEGER NOT NULL |
System assigned disposition number used to uniquely identify the disposition record.
Default Value: 0
|
| 22 |
SWAP_FMV |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Fair market value of the shares swapped.
Default Value: 0
|
| 23 |
SHARES_SWAPPED |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Total number of shares swapped.
|
| 24 |
SWAP_VALUE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Swap Value
|
| 25 |
SHARES_TRADED |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
The number of shares traded.
|
| 26 |
TRADE_VALUE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Trade Value
|
| 27 |
SEC_FEES |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
The SEC fees charged on this transaction.
|
| 28 |
BROKERAGE_FEES |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
The brokerage fees charged on this transaction.
|
| 29 |
BROKERAGE_CMSN |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
The brokerage commission charged on this transaction.
|
| 30 |
ST_ORD_INCOME |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Ordinary Income
Default Value: 0
|
| 31 |
ST_AMT_INCOME |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
AMT Income
Default Value: 0
|
| 32 |
EXER_RECEIPT_DT |
Date(10) |
DATE |
Exercise Notice Date
|
| 33 |
REPLACE_EXER_NBR |
Number(8,0) |
INTEGER NOT NULL |
Replace Exercise Number
Prompt Table:
ST_GRNT_EXER_VW
|
| 34 |
ST_CALC_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is for audit purposes and will determine how the tax calculations were calculated (i.e. the source of the tax calculation).
M=Manual Entry
N=North Amercian Payroll
P=Copy Previous Taxes
S=Load Default Taxes
Default Value: M
|
| 35 |
ST_SEND_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is for audit purposes and will determine how the tax information was delivered to Payroll: either via the interface with Paysheets or via a manual report.
N=North American Payroll
R=Stock Payroll Report
|
| 36 |
ST_PR_DT |
Date(10) |
DATE |
This field is the date that a transaction was sent to payroll.
|
| 37 |
PAYCHECK_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Paycheck number.
|
| 38 |
PROCESS_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Group
|
| 39 |
REVERSAL_DT |
Date(10) |
DATE |
Reversal Date
|
| 40 |
TRANSFER_CNTL_NBR |
Number(7,0) |
INTEGER NOT NULL |
Number assisgned to identify instructions to the transfer agent.
|
| 41 |
ESCROW_CNTL_NBR |
Number(7,0) |
INTEGER NOT NULL |
Number assigned to identify instructions to the escrow agent.
|
| 42 |
TRANSFER_ISSUE_DT |
Date(10) |
DATE |
Date the transfer issuance instructions are printed.
|
| 43 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 44 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 45 |
COMMENTS |
Long Character |
CLOB |
Comment
|