EO_RATERPT_VW1 (SQL View)	Index Back
Market Rate Data Temp table Market Rates table. Key placed on Term used for Prompting for a specific terms. Used for Batch pub from EO9030

EO_RATERPT_VW1

(SQL View)

Market Rate Data Temp table

Market Rates table. Key placed on Term used for Prompting for a specific terms. Used for Batch pub from EO9030

SELECT DISTINCT PROCESS_INSTANCE , OPRID , RUN_CNTL_ID , RT_RATE_INDEX , TERM , FROM_CURRENCY , RT_TYPE FROM PS_EO_RATECALC_RPT WHERE RATECALC_RPT_TYPE = 'R'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

4 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index
Prompt Table: RT_INDEX_TBL

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

6 FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL From Currency
Prompt Table: CURRENCY_CD_TBL

7 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	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPRID_VW
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	RT_RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Market Rate Index Prompt Table: RT_INDEX_TBL
5	TERM	Number(5,0)	INTEGER NOT NULL	Term
6	FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	From Currency Prompt Table: CURRENCY_CD_TBL
7	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.