MTM_CURVE_VW (SQL View)	Index Back
Mark to Market Interest Rates View for Mark to Market Interest Rates

MTM_CURVE_VW

(SQL View)

Mark to Market Interest Rates

View for Mark to Market Interest Rates

SELECT rt_rate_index ,from_cur ,to_cur ,rt_type ,term ,%DateAdd(effdt,term) ,%Round(%DecDiv(rate_mult,rate_div),8) FROM ps_rt_rate_tbl r WHERE effdt = ( SELECT MAX(effdt) FROM ps_rt_rate_tbl WHERE rt_rate_index=r.rt_rate_index AND from_cur=r.from_cur AND to_cur=r.to_cur AND rt_type=r.rt_type AND effdt >=%CurrentDateIn )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index

2 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

3 CURRENCY_CD_2 Character(3) VARCHAR2(3) NOT NULL Currency code 2

4 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.

5 TERM Number(5,0) INTEGER NOT NULL Term

6 MATURITY_DT Date(10) DATE The maturity date for a deal transaction.

7 RT_RATE Number(16,8) DECIMAL(15,8) NOT NULL Market Rate

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RT_RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Market Rate Index
2	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
3	CURRENCY_CD_2	Character(3)	VARCHAR2(3) NOT NULL	Currency code 2
4	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.
5	TERM	Number(5,0)	INTEGER NOT NULL	Term
6	MATURITY_DT	Date(10)	DATE	The maturity date for a deal transaction.
7	RT_RATE	Number(16,8)	DECIMAL(15,8) NOT NULL	Market Rate