TRW_EE_STMT_ITM

(SQL Table)
 Index Back

TRW EE Stmt Reward Item Record

This table is the total rewards employee statement reward item summary table that summarizes the detail compensation data extracted by the Rewards Extract process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TRW_STMT_ID Character(15) VARCHAR2(15) NOT NULL Reward Statement ID
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 TRW_STMT_RCD Number(3,0) SMALLINT NOT NULL Statement Record
4 TRW_SECTION_ID Character(10) VARCHAR2(10) NOT NULL Section ID for sections in total rewards template.setup
5 TRW_RW_ITEM_ID Character(15) VARCHAR2(15) NOT NULL Total rewards statement - reward item ID
6 TRW_DETAIL_DT Date(10) DATE Reward Detail Date
7 TRW_DETAIL_C_DATA1 Character(50) VARCHAR2(50) NOT NULL Reward Detail Data 1 - Character
8 TRW_DETAIL_D_DATA1 Date(10) DATE Reward Detail Data 1 - Date
9 TRW_DETAIL_N_DATA1 Signed Number(23,6) DECIMAL(21,6) NOT NULL Reward Detail Data 1 - Numeric
10 TRW_DETAIL_C_DATA2 Character(50) VARCHAR2(50) NOT NULL Reward Detail Data 2 - Character
11 TRW_DETAIL_D_DATA2 Date(10) DATE Reward Detail Data 2 - Date
12 TRW_DETAIL_N_DATA2 Signed Number(23,6) DECIMAL(21,6) NOT NULL Reward Detail Data 2 - Numeric
13 TRW_DETAIL_C_DATA3 Character(50) VARCHAR2(50) NOT NULL Reward Detail Data 3 - Character
14 TRW_DETAIL_D_DATA3 Date(10) DATE Reward Detail Data 3 - Date
15 TRW_DETAIL_N_DATA3 Signed Number(23,6) DECIMAL(21,6) NOT NULL Reward Detail Data 3 - Numeric
16 TRW_DETAIL_C_DATA4 Character(50) VARCHAR2(50) NOT NULL Reward Detail Data 4 - Character
17 TRW_DETAIL_D_DATA4 Date(10) DATE Reward Detail Data 4 - Date
18 TRW_DETAIL_N_DATA4 Signed Number(23,6) DECIMAL(21,6) NOT NULL Reward Detail Data 4 - Numeric
19 TRW_DETAIL_C_DATA5 Character(50) VARCHAR2(50) NOT NULL Reward Detail Data 5 - Character
20 TRW_DETAIL_D_DATA5 Date(10) DATE Reward Detail Data 5 - Date
21 TRW_DETAIL_N_DATA5 Signed Number(23,6) DECIMAL(21,6) NOT NULL Reward Detail Data 5 - Numeric
22 TRW_EE_PAID_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Employee Paid Amount
23 TRW_ER_PAID_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Paid Amount
24 TRW_CO_PROV_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Company Provided Amount
25 TRW_UNITS Number(8,0) INTEGER NOT NULL TRW Units
26 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
27 TRW_RATE_PER_UNIT Number(19,6) DECIMAL(18,6) NOT NULL Total Rewards Statement - Rate Per Unit
28 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
29 TRW_REL_C_DATA1 Character(50) VARCHAR2(50) NOT NULL Related Reward Data 1 - Character
30 TRW_REL_D_DATA1 Date(10) DATE Related Reward Data 1 - Date
31 TRW_REL_N_DATA1 Number(22,6) DECIMAL(21,6) NOT NULL Related Reward Data 1 - Numeric
32 TRW_REL_C_DATA2 Character(50) VARCHAR2(50) NOT NULL Related Reward Data 2 - Character
33 TRW_REL_D_DATA2 Date(10) DATE Related Reward Data 2 - Date
34 TRW_REL_N_DATA2 Number(22,6) DECIMAL(21,6) NOT NULL Related Reward Data 2 - Numeric
35 TRW_REL_C_DATA3 Character(50) VARCHAR2(50) NOT NULL Related Reward Data 3 - Character
36 TRW_REL_D_DATA3 Date(10) DATE Related Reward Data 3 - Date
37 TRW_REL_N_DATA3 Number(22,6) DECIMAL(21,6) NOT NULL Related Reward Data 3 - Numeric
38 TRW_CALC_IND Character(3) VARCHAR2(3) NOT NULL Calculate Indicator
001=Not Calculated
002=Not Required
003=Done
004=Error
39 RT_RATE Number(16,8) DECIMAL(15,8) NOT NULL Market Rate
40 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code
41 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
42 TRW_DATASRC_ID Character(15) VARCHAR2(15) NOT NULL Total rewards statement - Reward Data Source ID