TRW_ST_TMP_GRNT (SQL Table)	Index Back
TRW Stock Grant Temp Table This is the Stock Administration Grant Extract Temp table. This table acts as a temporary extract table that is used to extract stock grant reward data for a specific configured Reward Item.

TRW_ST_TMP_GRNT

(SQL Table)

TRW Stock Grant Temp Table

This is the Stock Administration Grant Extract Temp table. This table acts as a temporary extract table that is used to extract stock grant reward data for a specific configured Reward Item.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRW_STMT_ID Character(15) VARCHAR2(15) NOT NULL Reward Statement ID

2 TRW_DATASRC_ID Character(15) VARCHAR2(15) NOT NULL Total rewards statement - Reward Data Source ID

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

4 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Company's Stock Identification Symbol

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

6 GRANT_DT Date(10) DATE Grant Date

7 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan

8 ST_OPTION_TYPE Character(4) VARCHAR2(4) NOT NULL Option Type
ISAR=ISO-Stock Appreciation Right
ISO=Incentive Stock Option
NQ=Non-Qualified
NSAR=NQ-Stock Appreciation Right
RSA=Restricted Stock Award

9 SHARES_GRANTED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares granted.

10 GRANT_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Price an employee pays to exercise the option.

11 GRANT_REASON Character(4) VARCHAR2(4) NOT NULL Grant Reason
Prompt Table: ST_GRNT_RSN_TBL

12 EXER_BFR_VEST Character(1) VARCHAR2(1) NOT NULL This field indicates that exercise is allowed before vesting. Typically used with RSA's.
N=No
Y=Yes

13 TRW_UNITS Number(8,0) INTEGER NOT NULL TRW Units

14 TRW_UOM Character(3) VARCHAR2(3) NOT NULL TRW Unit of Measure
001=None
002=Hours
003=Days
004=Weeks
005=Months
006=Stock Shares

15 TRW_RATE_PER_UNIT Number(19,6) DECIMAL(18,6) NOT NULL Total Rewards Statement - Rate Per Unit

16 TRW_CO_PROV_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Company Provided Amount

17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRW_STMT_ID	Character(15)	VARCHAR2(15) NOT NULL	Reward Statement ID
2	TRW_DATASRC_ID	Character(15)	VARCHAR2(15) NOT NULL	Total rewards statement - Reward Data Source ID
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Company's Stock Identification Symbol
5	GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	System assigned grant number used to uniquely identify the grant record.
6	GRANT_DT	Date(10)	DATE	Grant Date
7	STOCK_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Stock Plan
8	ST_OPTION_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Option Type ISAR=ISO-Stock Appreciation Right ISO=Incentive Stock Option NQ=Non-Qualified NSAR=NQ-Stock Appreciation Right RSA=Restricted Stock Award
9	SHARES_GRANTED	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of shares granted.
10	GRANT_PRICE	Number(19,6)	DECIMAL(18,6) NOT NULL	Price an employee pays to exercise the option.
11	GRANT_REASON	Character(4)	VARCHAR2(4) NOT NULL	Grant Reason Prompt Table: ST_GRNT_RSN_TBL
12	EXER_BFR_VEST	Character(1)	VARCHAR2(1) NOT NULL	This field indicates that exercise is allowed before vesting. Typically used with RSA's. N=No Y=Yes
13	TRW_UNITS	Number(8,0)	INTEGER NOT NULL	TRW Units
14	TRW_UOM	Character(3)	VARCHAR2(3) NOT NULL	TRW Unit of Measure 001=None 002=Hours 003=Days 004=Weeks 005=Months 006=Stock Shares
15	TRW_RATE_PER_UNIT	Number(19,6)	DECIMAL(18,6) NOT NULL	Total Rewards Statement - Rate Per Unit
16	TRW_CO_PROV_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Company Provided Amount
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code