PV_CURR_RATE_VW (SQL View)	Index Back
ePro Current Rate ePro Current Rate

PV_CURR_RATE_VW

(SQL View)

ePro Current Rate

SELECT A.FROM_CUR , A.TO_CUR , A.RT_TYPE , A.RATE_MULT , A.RATE_DIV FROM PS_RT_DFLT_VW A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_RT_DFLT_VW B WHERE A.FROM_CUR = B.FROM_CUR AND A.TO_CUR = B.TO_CUR AND A.RT_TYPE = B.RT_TYPE AND B.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

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	FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code
2	TO_CUR	Character(3)	VARCHAR2(3) NOT NULL	To Currency Code
3	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
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