EMPLIDGRANT_NBREXERCISE_NBRRELEASE_NBRDISPOSITION_NBRC=Confirmed
P=Pending
V=Void
ST_SPLIT11B_TAO(SQL Table) |
Index Back |
|---|---|
Split Release Disposition TempST_SPLIT11_TAO is a temporary table to hold release 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 | GRANT_NBR |
Character(10) | VARCHAR2(10) NOT NULL | System assigned grant number used to uniquely identify the grant record. |
| 3 | EXERCISE_NBR |
Number(8,0) | INTEGER NOT NULL | System assigned exercise number used to uniquely identify the exercise record. |
| 4 | RELEASE_NBR |
Number(8,0) | INTEGER NOT NULL | System assigned release number used to uniquely identify the release record. |
| 5 | DISPOSITION_NBR |
Number(8,0) | INTEGER NOT NULL | System assigned disposition number used to uniquely identify the disposition record. |
| 6 | 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. |
| 7 | 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. |
| 8 | SHARES_ROUNDED | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Shares Rounded |
| 9 | DISPOSITION_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Staus of disposition - active, pending for survey, void
C=Confirmed P=Pending V=Void |