TRW_EE_TMP_AMD (SQL Table)	Index Back
Employee Temp Amend Table This is a temporary table that is used in the Administrator Statement component to update the amend status stored on the Employee Statement record (TRW_EE_STMT)

TRW_EE_TMP_AMD

(SQL Table)

Employee Temp Amend Table

This is a temporary table that is used in the Administrator Statement component to update the amend status stored on the Employee Statement record (TRW_EE_STMT)

# 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
Prompt Table: TRW_EE_SRCH_VW

3 TRW_STMT_RCD Number(3,0) SMALLINT NOT NULL Statement Record

4 TRW_AMEND_STATUS Character(3) VARCHAR2(3) NOT NULL Amend Statement Status
BLD=Build
CAN=Cancel
EXT=Extract
PUB=Publish

#	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 Prompt Table: TRW_EE_SRCH_VW
3	TRW_STMT_RCD	Number(3,0)	SMALLINT NOT NULL	Statement Record
4	TRW_AMEND_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Amend Statement Status BLD=Build CAN=Cancel EXT=Extract PUB=Publish