TRW_EXT_SQL_TMP (SQL Table)	Index Back
TRW Temp Extract SQL Table This is a temporary record utilized by the Reward Extract process (TRW_EXT_STMT) to store the generated SQL before it is executed.

TRW_EXT_SQL_TMP

(SQL Table)

TRW Temp Extract SQL Table

This is a temporary record utilized by the Reward Extract process (TRW_EXT_STMT) to store the generated SQL before it is executed.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

3 SQLTEXT Long Character(14000) CLOB SQL Statement Text

4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
3	SQLTEXT	Long Character(14000)	CLOB	SQL Statement Text
4	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description