ST_CANCEL_TMP (SQL Table)	Index Back
Grant Cancellation Temp Table ST_CANCEL_TMP is a temporary work table to capture those grants that have cancellations or expirations within a given date range.

ST_CANCEL_TMP

(SQL Table)

Grant Cancellation Temp Table

ST_CANCEL_TMP is a temporary work table to capture those grants that have cancellations or expirations within a given date range.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

3 GRANT_NBR Character(10) VARCHAR2(10) NOT NULL System assigned grant number used to uniquely identify the grant record.

4 GRANT_DT Date(10) DATE Grant Date

5 ST_CANCEL_DT Date(10) DATE Cancellation Date

6 ST_CANCEL_REASON Character(4) VARCHAR2(4) NOT NULL Reason shares were cancelled.
RESC=Employee Rescinded Offer
RPRC=Reprice
TER=Termination

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID
3	GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	System assigned grant number used to uniquely identify the grant record.
4	GRANT_DT	Date(10)	DATE	Grant Date
5	ST_CANCEL_DT	Date(10)	DATE	Cancellation Date
6	ST_CANCEL_REASON	Character(4)	VARCHAR2(4) NOT NULL	Reason shares were cancelled. RESC=Employee Rescinded Offer RPRC=Reprice TER=Termination