RATE_TYPE_MAP (SQL Table)	Index Back
Rate Type Map This record contains the mappings between production and model rate types

RATE_TYPE_MAP

(SQL Table)

Rate Type Map

This record contains the mappings between production and model rate types

# 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.
Prompt Table: RT_TYPE_TBL

2 TO_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Model Rate Type
Prompt Table: RT_TYPE_TBL

3 RTBL_MODEL_RATE Character(1) VARCHAR2(1) NOT NULL Model Rates
C=Clear
S=Seed
Default Value: S

4 FROM_DATE Date(10) DATE From Date

#	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. Prompt Table: RT_TYPE_TBL
2	TO_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Model Rate Type Prompt Table: RT_TYPE_TBL
3	RTBL_MODEL_RATE	Character(1)	VARCHAR2(1) NOT NULL	Model Rates C=Clear S=Seed Default Value: S
4	FROM_DATE	Date(10)	DATE	From Date