TRW_STMT_TBL (SQL Table)	Index Back
TRW Statement Table This table stores the attributes used to process a total rewards statement. It also maintains a field that tracks the process status of the total rewards statement.

TRW_STMT_TBL

(SQL Table)

TRW Statement Table

This table stores the attributes used to process a total rewards statement. It also maintains a field that tracks the process status of the total rewards statement.

Related Language Record: TRW_STMT_LNG

# 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_DESCR50 Character(50) VARCHAR2(50) NOT NULL Description field character 50

3 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
Prompt Table: EC_GRP_SEC_VW

4 TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Template ID
Prompt Table: TRW_TEMPLATE

5 FROMDATE Date(10) DATE NOT NULL From Date

6 THRUDATE Date(10) DATE NOT NULL End Date

#	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_DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description field character 50
3	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID. Prompt Table: EC_GRP_SEC_VW
4	TEMPLATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Template ID Prompt Table: TRW_TEMPLATE
5	FROMDATE	Date(10)	DATE NOT NULL	From Date
6	THRUDATE	Date(10)	DATE NOT NULL	End Date