TRX_INTEREST_TR (SQL Table)	Index Back
Treasury Deal Interest Dates Interest period end dates, Floating Rate Reset dates, Interest dates, Payment dates, Rates, Amort factors for Interest Rate Physicals and Interest Rate Swaps.

TRX_INTEREST_TR

(SQL Table)

Treasury Deal Interest Dates

Interest period end dates, Floating Rate Reset dates, Interest dates, Payment dates, Rates, Amort factors for Interest Rate Physicals and Interest Rate Swaps.

Parent record: TRX_DETAIL_TR

# 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 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.

3 TRANSACTION_LINE Number(3,0) SMALLINT NOT NULL The separate and distinct base instrument type components of a given deal transaction.

4 NOMINAL_DT Date(10) DATE The nominal (non-adjusted) date for a given deal transaction cash flow.

5 TRX_PAYMENT_TYPE Character(1) VARCHAR2(1) NOT NULL Decides that the payment is towards the interest on the loan or a part of the principal amount of the loan. For a future the code indicates the margin type.
I=Interest Payment
P=Paydown
R=Drawdown
X=Exchange at Rate Reset
Default Value: I

6 TRANSACTION_LEG Number(1,0) SMALLINT NOT NULL The separate and distinct business positions of a given deal transaction line.
1=Pay Leg
2=Receive Leg

7 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

8 INTEREST_DT Date(10) DATE The business date for an interest period in a deal transaction.

9 PAYMENT_DT Date(10) DATE Payment Date

10 QUASI_COUPON_DT_SW Character(1) VARCHAR2(1) NOT NULL "An internal switch that indicates that an accrual
N=Normal period coupon, not odd
Y=Is included in odd length
Y/N Table Edit
Default Value: N

11 RESET_RATE_SET Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate that a floating rate for a particular cash flow has been ascertained and e
N=Rate Not Set
Y=Reset Rate Set
Y/N Table Edit

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

13 RATE_RESET_DT Date(10) DATE The date that an interest rate quoted in the market is captured for purposes of calculating interest

14 PRINCIPAL_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL The notional principal balance of a given deal transaction at commencement.

15 OVERRIDE_AMT_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to override the system generated interest rate amount for a given variable rate deal
Y/N Table Edit
Default Value: N

16 PAYMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a customer payment.

17 PRINCIPAL_PAYMENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment that goes towards paying the principal.

18 INTEREST_PAYMENT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment that goes towards paying the interest.

19 AMORT_MTHD_FACTOR Signed Number(24,20) DECIMAL(22,20) NOT NULL Factor that has to be applied to calculate the amortizing cashflow for the corresponding period.

20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

21 RESET_RATE Number(16,8) DECIMAL(15,8) NOT NULL Rate directly taken from the reset source. May be operator input or, potentially, supplied by automated source.

22 FLOATING_MARGIN Signed Number(13,8) DECIMAL(11,8) NOT NULL The supplemental interest rate

#	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	TREAS_HEADER_ID	Character(12)	VARCHAR2(12) NOT NULL	The unique key identifier for a given deal transaction.
3	TRANSACTION_LINE	Number(3,0)	SMALLINT NOT NULL	The separate and distinct base instrument type components of a given deal transaction.
4	NOMINAL_DT	Date(10)	DATE	The nominal (non-adjusted) date for a given deal transaction cash flow.
5	TRX_PAYMENT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Decides that the payment is towards the interest on the loan or a part of the principal amount of the loan. For a future the code indicates the margin type. I=Interest Payment P=Paydown R=Drawdown X=Exchange at Rate Reset Default Value: I
6	TRANSACTION_LEG	Number(1,0)	SMALLINT NOT NULL	The separate and distinct business positions of a given deal transaction line. 1=Pay Leg 2=Receive Leg
7	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
8	INTEREST_DT	Date(10)	DATE	The business date for an interest period in a deal transaction.
9	PAYMENT_DT	Date(10)	DATE	Payment Date
10	QUASI_COUPON_DT_SW	Character(1)	VARCHAR2(1) NOT NULL	"An internal switch that indicates that an accrual N=Normal period coupon, not odd Y=Is included in odd length Y/N Table Edit Default Value: N
11	RESET_RATE_SET	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate that a floating rate for a particular cash flow has been ascertained and e N=Rate Not Set Y=Reset Rate Set Y/N Table Edit
12	TRANSACTION_RATE	Number(16,8)	DECIMAL(15,8) NOT NULL	The applicable interest rate for a given deal transaction.
13	RATE_RESET_DT	Date(10)	DATE	The date that an interest rate quoted in the market is captured for purposes of calculating interest
14	PRINCIPAL_BALANCE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The notional principal balance of a given deal transaction at commencement.
15	OVERRIDE_AMT_SW	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to override the system generated interest rate amount for a given variable rate deal Y/N Table Edit Default Value: N
16	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
17	PRINCIPAL_PAYMENT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment that goes towards paying the principal.
18	INTEREST_PAYMENT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment that goes towards paying the interest.
19	AMORT_MTHD_FACTOR	Signed Number(24,20)	DECIMAL(22,20) NOT NULL	Factor that has to be applied to calculate the amortizing cashflow for the corresponding period.
20	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
21	RESET_RATE	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate directly taken from the reset source. May be operator input or, potentially, supplied by automated source.
22	FLOATING_MARGIN	Signed Number(13,8)	DECIMAL(11,8) NOT NULL	The supplemental interest rate