POS_RT_RATE_TMP (SQL Table)	Index Back
Position rates Temp Table Temporary table used for position management. Stores the latest rate for a given process. the process, will populate the rates for a given Index, Rate type and term

POS_RT_RATE_TMP

(SQL Table)

Position rates Temp Table

Temporary table used for position management. Stores the latest rate for a given process. the process, will populate the rates for a given Index, Rate type and term

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code

3 TO_CUR Character(3) VARCHAR2(3) NOT NULL To Currency Code

4 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

5 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code
3	TO_CUR	Character(3)	VARCHAR2(3) NOT NULL	To Currency Code
4	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
5	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor