ST_STOP035_TAO

(SQL Table)
Index Back

Temp Table for SQR STOP001

This table is used as a temp table for sqr STOP001 - Plann Summaries Report. The records are deleted at the end of the sqr.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
2 PROCESSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 GRANT_NBR Character(10) VARCHAR2(10) NOT NULL System assigned grant number used to uniquely identify the grant record.
5 VEST_DT Date(10) DATE Vesting Date
6 SHARES_VESTED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares that vest on VEST_DT.
7 SHARES_EXERCISED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares exercised.
8 EXPIRATN_DT Date(10) DATE Expiration Date
9 TERM_EXPIRATN_DT Date(10) DATE Expiration date of unexercised shares when emplyee terminates.
10 ST_CANCEL_REASON Character(4) VARCHAR2(4) NOT NULL Reason shares were cancelled.
RESC=Employee Rescinded Offer
RPRC=Reprice
TER=Termination
11 ST_CANCEL_DT Date(10) DATE Cancellation Date