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

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.