ST_SPLIT10A_TAO

(SQL Table)
Index Back

Split ESPP DispositionTemp

ST_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