RT_RATE_DEF_TBL

index back

Market Rate Data Definition

Market Rate Data Definition

PeopleSoft Field Name Field Type Column Type Description
RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index

Prompt Table: RT_INDEX_TBL

TERM Number(5,0) INTEGER NOT NULL Term
FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code

Prompt Table: CURRENCY_CD_TBL

TO_CUR Character(3) VARCHAR2(3) NOT NULL To Currency Code

Prompt Table: CURRENCY_CD_TBL

MAX_VARIANCE Number(6,2) DECIMAL(5,2) NOT NULL Maximum Variance
ERROR_TYPE Character(3) VARCHAR2(3) NOT NULL Error Type
ERR=Stop
NON=None
WAR=Warning

Default: WAR

INT_BASIS Character(2) VARCHAR2(2) NOT NULL Day Count Basis
30=30/360
3E=30E/360
A0=Actual/360
A5=Actual/365
AA=Actual/Actual
RT_RATE_ADM_MAXVAR Number(6,2) DECIMAL(5,2) NOT NULL Maximum Variance EC Owned fields in Tools build
ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

Prompt Table: PSROLEDEFN_SRCH

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19