ST_OPTN_TAO3A

(SQL Table)
Index Back

Stock Balance Temp - Grants

This record is a temporary record to store active stock grants for specified Stock Plans details used during Stock Balance processing.

# 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 VEST_DT Date(10) DATE NOT NULL Vesting Date
4 SHARES_VESTED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares that vest on VEST_DT.
5 SHARES_EXERCISED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares exercised.
6 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.
7 EXPIRATN_DT Date(10) DATE NOT NULL Expiration Date
8 TERM_EXPIRATN_DT Date(10) DATE Expiration date of unexercised shares when emplyee terminates.