RT_RATE_DEF_TBL

index back

Market Rate Data Definition

Market Rate Data Definition

PeopleSoft Field NameField TypeColumn TypeDescription
RT_RATE_INDEXCharacter(10)VARCHAR2(10) NOT NULLMarket Rate Index

Prompt Table: RT_INDEX_TBL

TERMNumber(5,0)INTEGER NOT NULLTerm
FROM_CURCharacter(3)VARCHAR2(3) NOT NULLFrom Currency Code

Prompt Table: CURRENCY_CD_TBL

TO_CURCharacter(3)VARCHAR2(3) NOT NULLTo Currency Code

Prompt Table: CURRENCY_CD_TBL

MAX_VARIANCENumber(6,2)DECIMAL(5,2) NOT NULLMaximum Variance
ERROR_TYPECharacter(3)VARCHAR2(3) NOT NULLError Type
ERR=Stop
NON=None
WAR=Warning

Default: WAR

INT_BASISCharacter(2)VARCHAR2(2) NOT NULLDay Count Basis
30=30/360
3E=30E/360
A0=Actual/360
A5=Actual/365
AA=Actual/Actual
RT_RATE_ADM_MAXVARNumber(6,2)DECIMAL(5,2) NOT NULLMaximum Variance EC Owned fields in Tools build
ROLENAMECharacter(30)VARCHAR2(30) NOT NULLThe 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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19