TRW_EXTRNL_DATA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	TRW_EXTDATA_ID	Character(15)	VARCHAR2(15) NOT NULL	External Data ID Prompt Table: TRW_EXTDATA_TBL
4	TRW_DATE	Date(10)	DATE NOT NULL	Reward Date
5	TRW_EE_PAID_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employee Paid Amount
6	TRW_ER_PAID_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Employer Paid Amount
7	TRW_CO_PROV_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Company Provided Amount
8	TRW_UNITS	Number(8,0)	INTEGER NOT NULL	TRW Units
9	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 Default Value: 001
10	TRW_RATE_PER_UNIT	Number(19,6)	DECIMAL(18,6) NOT NULL	Total Rewards Statement - Rate Per Unit
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL