TRX_RATE_RESET (SQL Table)	Index Back
Reset rates on a daily basis. Stores the reset rates on a daily basis.

TRX_RATE_RESET

(SQL Table)

Reset rates on a daily basis.

Stores the reset rates on a daily basis.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_TRD_NONVW

2 RATE_RESET_DT Date(10) DATE NOT NULL The date that an interest rate quoted in the market is captured for purposes of calculating interest
Default Value: %date

3 FLOATING_MKT_CD Character(10) VARCHAR2(10) NOT NULL The code used as a key for obtaining market rates for interest rates and futures prices.

4 TRANSACT_CURRENCY Character(3) VARCHAR2(3) NOT NULL "The nominal

5 RESET_INDEX_TENOR Character(3) VARCHAR2(3) NOT NULL Tenor (Term) of Reset Rate Index - how long the Interest Rate applies for
D01=Overnight
D07=1 Week
D14=2 Week
D21=21 Day
D28=28 Day
D35=35 Day
D49=49 Day
M01=1 Month
M03=3 Month
M06=6 Month
M12=1 Year
X=Not Applicable

6 TRANSACTION_RATE Number(16,8) DECIMAL(15,8) NOT NULL The applicable interest rate for a given deal transaction.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_TRD_NONVW
2	RATE_RESET_DT	Date(10)	DATE NOT NULL	The date that an interest rate quoted in the market is captured for purposes of calculating interest Default Value: %date
3	FLOATING_MKT_CD	Character(10)	VARCHAR2(10) NOT NULL	The code used as a key for obtaining market rates for interest rates and futures prices.
4	TRANSACT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"The nominal
5	RESET_INDEX_TENOR	Character(3)	VARCHAR2(3) NOT NULL	Tenor (Term) of Reset Rate Index - how long the Interest Rate applies for D01=Overnight D07=1 Week D14=2 Week D21=21 Day D28=28 Day D35=35 Day D49=49 Day M01=1 Month M03=3 Month M06=6 Month M12=1 Year X=Not Applicable
6	TRANSACTION_RATE	Number(16,8)	DECIMAL(15,8) NOT NULL	The applicable interest rate for a given deal transaction.