ST_SPLIT10A_TAO(SQL Table) |
Index Back |
---|---|
Split ESPP DispositionTempST_SPLIT10_TAO is a temporary table to hold disposition data for stock splits. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | STOCK_PLAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Stock Plan
E=Purchase Plan O=Option Plan |
3 | STOCK_PLAN | Character(10) | VARCHAR2(10) NOT NULL | Stock Plan |
4 | OFFERING_ID | Character(10) | VARCHAR2(10) NOT NULL | Offering ID |
5 | PERIOD_END_DT | Date(10) | DATE | Period End Date |
6 | GRANT_DT | Date(10) | DATE | Grant Date |
7 | DISPOSITION_NBR | Number(8,0) | INTEGER NOT NULL | System assigned disposition number used to uniquely identify the disposition record. |
8 | SHARES_UNROUNDED | Signed Number(23,9) | DECIMAL(21,9) NOT NULL | SHARES_UNROUNDED contains the full calculated vesting value based on the vesting percent and the vesting period count. |
9 | SHARES_REMAINDER | Signed Number(23,9) | DECIMAL(21,9) NOT NULL | SHARES_REMAINDER field stores the number of shares that is part of the remainder for uneven share processing. |
10 | SHARES_ROUNDED | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Shares Rounded |
11 | DISPOSITION_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Staus of disposition - active, pending for survey, void
C=Confirmed P=Pending V=Void |