ST_EXER_RELEASE(SQL Table) |
Index Back |
|---|---|
Stock Exercise Release tableDefines the stock exercise release information captured by the option tranaction processing. |
| # | 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 | Company's Stock Identification Symbol |
| 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. |
| 5 | RELEASE_NBR |
Number(8,0) | INTEGER NOT NULL |
System assigned release number used to uniquely identify the release record.
Default Value: 0 |
| 6 | RELEASE_DT | Date(10) | DATE NOT NULL | The date of this release transaction. |
| 7 | SHARES_RELEASED | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | The number of shares released. |
| 8 | RELEASE_FMV | Number(19,6) | DECIMAL(18,6) NOT NULL | Fair market value of the shares released. |
| 9 | RELEASE_VALUE | Number(19,6) | DECIMAL(18,6) NOT NULL | Release Value |
| 10 | RELEASE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status of the release - active or void.
A=Active P=Pending V=Void Default Value: A |
| 11 | STATUS_DT | Date(10) | DATE |
Status Date
Default Value: %date |
| 12 | RELEASE_METHOD | Character(4) | VARCHAR2(4) NOT NULL |
Release Method
CASH=Cash LOAN=Loan SDS=Same Day Sale STC=Sell to Cover TRD=Trade Default Value: CASH |
| 13 | ST_COST_SHARE_SOLD | Number(19,6) | DECIMAL(18,6) NOT NULL |
Number of shares sold from this exercise.
Default Value: 0 |
| 14 | ST_COST_SALE_PRICE | Number(19,6) | DECIMAL(18,6) NOT NULL |
Sale price of shares sold from this exercise.
Default Value: 0 |
| 15 | EST_GROSS_PROCEEDS | Signed Number(23,6) | DECIMAL(21,6) NOT NULL | The estimated gross proceeds from the sale. |
| 16 | DISPOSITION_NBR | Number(8,0) | INTEGER NOT NULL |
System assigned disposition number used to uniquely identify the disposition record.
Default Value: 0 |
| 17 | SWAP_FMV | Number(19,6) | DECIMAL(18,6) NOT NULL |
Fair market value of the shares swapped.
Default Value: 0 |
| 18 | SHARES_TRADED | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | The number of shares traded. |
| 19 | TRADE_VALUE | Number(19,6) | DECIMAL(18,6) NOT NULL | Trade Value |
| 20 | SEC_FEES | Number(19,6) | DECIMAL(18,6) NOT NULL | The SEC fees charged on this transaction. |
| 21 | BROKERAGE_FEES | Number(19,6) | DECIMAL(18,6) NOT NULL | The brokerage fees charged on this transaction. |
| 22 | BROKERAGE_CMSN | Number(19,6) | DECIMAL(18,6) NOT NULL | The brokerage commission charged on this transaction. |
| 23 | ST_ORD_INCOME | Signed Number(20,6) | DECIMAL(18,6) NOT NULL |
Ordinary Income
Default Value: 0 |
| 24 | ST_AMT_INCOME | Signed Number(20,6) | DECIMAL(18,6) NOT NULL |
AMT Income
Default Value: 0 |
| 25 | RELEASE_RECEIPT_DT | Date(10) | DATE | The date the release receipt was generated. |
| 26 | TRANSFER_CNTL_NBR | Number(7,0) | INTEGER NOT NULL | Number assisgned to identify instructions to the transfer agent. |
| 27 | ESCROW_CNTL_NBR | Number(7,0) | INTEGER NOT NULL | Number assigned to identify instructions to the escrow agent. |
| 28 | TRANSFER_ISSUE_DT | Date(10) | DATE | Date the transfer issuance instructions are printed. |
| 29 | REPLACE_REL_NBR | Number(8,0) | INTEGER NOT NULL |
System assigned release number used to uniquely identify the release record which replaces this release.
Prompt Table: ST_EXER_REL_VW |
| 30 | 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 |
| 31 | 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 |
| 32 | ST_PR_DT | Date(10) | DATE | This field is the date that a transaction was sent to payroll. |
| 33 | PAYCHECK_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Paycheck number. |
| 34 | PROCESS_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Process Group |
| 35 | REVERSAL_DT | Date(10) | DATE | Reversal Date |
| 36 | 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. |
| 37 | 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. |
| 38 | COMMENTS | Long Character | CLOB | Comment |