ST_STOP001_TBL

(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 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID
5 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan
6 GRANT_NBR Character(10) VARCHAR2(10) NOT NULL System assigned grant number used to uniquely identify the grant record.
7 VEST_DT Date(10) DATE Vesting Date
8 GRANT_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Price an employee pays to exercise the option.
9 SHARES_VESTED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares that vest on VEST_DT.
10 SHARES_EXERCISED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares exercised.
11 EXPIRATN_DT Date(10) DATE Expiration Date
12 TERM_EXPIRATN_DT Date(10) DATE Expiration date of unexercised shares when emplyee terminates.
13 ST_CANCEL_REASON Character(4) VARCHAR2(4) NOT NULL Reason shares were cancelled.
RESC=Employee Rescinded Offer
RPRC=Reprice
TER=Termination
14 ST_CANCEL_DT Date(10) DATE Cancellation Date