EOEP_NDXVAL_VW (SQL View)	Index Back
Price Index Values This view returns the index values from RT_RATE_TBL. Here is how the fields in RT_RATE_TBL are used, RT_RATE_INDEX - whose category is "Economic Indicator" TERM - N/A should leave blank or always use same value FROM_CUR, TO_CUR - have to be the same RT_TYPE - N/A should always use same value RATE_MULT - price index vlaue RATE_DIV - N/A

EOEP_NDXVAL_VW

(SQL View)

Price Index Values

This view returns the index values from RT_RATE_TBL. Here is how the fields in RT_RATE_TBL are used, RT_RATE_INDEX - whose category is "Economic Indicator" TERM - N/A should leave blank or always use same value FROM_CUR, TO_CUR - have to be the same RT_TYPE - N/A should always use same value RATE_MULT - price index vlaue RATE_DIV - N/A

SELECT R.RT_RATE_INDEX , R.FROM_CUR , R.EFFDT , R.RATE_MULT FROM PS_RT_RATE_TBL R , PS_RT_INDEX_TBL I WHERE R.RT_RATE_INDEX = I.RT_RATE_INDEX AND I.RT_CATEGORY = '30' AND R.FROM_CUR = R.TO_CUR

# 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 This field stores the Currency Code value.

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 EOEP_NDX_VALUE Signed Number(17,8) DECIMAL(15,8) NOT NULL Price Index Value

#	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	This field stores the Currency Code value.
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EOEP_NDX_VALUE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Price Index Value