ST_TRSR_TAO2(SQL Table) | 
Index Back | 
|---|---|
Stock Balance Temp - GrantsThis 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 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
| 2 | Character(10) | VARCHAR2(10) NOT NULL | System assigned grant number used to uniquely identify the grant record. | |
| 3 | STOCK_PLAN | Character(10) | VARCHAR2(10) NOT NULL | Stock Plan | 
| 4 | ST_CANCEL_DT | Date(10) | DATE | Cancellation Date | 
| 5 | ST_CANCEL_REASON | Character(4) | VARCHAR2(4) NOT NULL | 
Reason shares were cancelled.
 RESC=Employee Rescinded Offer RPRC=Reprice TER=Termination  | 
| 6 | SHARES_GRANTED | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Number of shares granted. |