Patrick Lee 03-04-99: Selects the Rate Types that are valid for a particular currency code. SELECT A.TO_CUR, A.RT_TYPE FROM PS_RT_RATE_TBL A, PS_RT_INDEX_TBL B, PS_RUN_CNTL_PL C WHERE A.EFFDT = (SELECT MAX(EFFDT) FROM PS_RT_RATE_TBL WHERE A.RT_RATE_INDEX = RT_RATE_INDEX AND A.TERM = TERM AND A.FROM_CUR = FROM_CUR AND A.TO_CUR = TO_CUR AND A.RT_TYPE = RT_TYPE AND EFFDT <= SUBSTRING(CONVERT(CHAR,GETDATE()),1,11)) AND A.RT_RATE_INDEX = B.RT_RATE_INDEX AND B.DEFAULT_INDEX = 'Y' 09/01/99 EGS: added distinct

RT_TYPE_PP_VW

(SQL View)

Index Back

SELECT DISTINCT A.TO_CUR , A.RT_TYPE FROM PS_RT_RATE_TBL A , PS_RT_INDEX_TBL B WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_RT_RATE_TBL WHERE A.RT_RATE_INDEX = RT_RATE_INDEX AND A.TERM = TERM AND A.FROM_CUR = FROM_CUR AND A.TO_CUR = TO_CUR AND A.RT_TYPE = RT_TYPE AND EFFDT <= %CurrentDateIn) AND A.RT_RATE_INDEX = B.RT_RATE_INDEX AND B.DEFAULT_INDEX = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
2	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.