GPHK_EXC_DT_VW (SQL View)	Index Back
IR56 Conversion Definition VW This new view will be used as a prompt record on the EFFDT field. The purpose of the view is to display the effective dates entered on the market rates table. This will provide appropriate control to the user indicating the rate that will be used by the IR56 creation process.

GPHK_EXC_DT_VW

(SQL View)

IR56 Conversion Definition VW

This new view will be used as a prompt record on the EFFDT field. The purpose of the view is to display the effective dates entered on the market rates table. This will provide appropriate control to the user indicating the rate that will be used by the IR56 creation process.

SELECT DISTINCT RT_TYPE , EFFDT FROM PS_RT_RATE_TBL WHERE RT_RATE_INDEX = 'MODEL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DATE1 Date(10) DATE Date 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	DATE1	Date(10)	DATE	Date 1