ST_SPLIT8A_TAO

(SQL Table)
Index Back

Split Release Issuance Temp

ST_SPLIT8_TAO is a temporary table to hold release issuance 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 ISSUANCE_NBR Number(8,0) INTEGER NOT NULL System assigned issuance number used to uniquely identify the issuance 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