TRW_STMT_RWDSUM (SQL Table)	Index Back
TRW Stmt Reward Item Summary This table stores a summary for the reward items extracted for a total rewards statement.

TRW_STMT_RWDSUM

(SQL Table)

TRW Stmt Reward Item Summary

This table stores a summary for the reward items extracted for a total rewards statement.

# 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_SECTION_ID Character(10) VARCHAR2(10) NOT NULL Section ID for sections in total rewards template.setup

3 TRW_RW_ITEM_ID Character(15) VARCHAR2(15) NOT NULL Total rewards statement - reward item ID

4 TRW_TOT_EE_EXTRACT Number(6,0) INTEGER NOT NULL Total Extracted Employees

#	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_SECTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Section ID for sections in total rewards template.setup
3	TRW_RW_ITEM_ID	Character(15)	VARCHAR2(15) NOT NULL	Total rewards statement - reward item ID
4	TRW_TOT_EE_EXTRACT	Number(6,0)	INTEGER NOT NULL	Total Extracted Employees