TRX_RT_RESET_VW

(SQL View)
 Index Back

Deals that need rate to reset.

A view built to pick out deals that need their rates to be reset automatically.

SELECT A.BUSINESS_UNIT , C.RATE_RESET_DT , A.TREAS_HEADER_ID , A.TREAS_MASTER_ID , B.TRANSACTION_LINE , C.TRANSACTION_LEG , B.INSTRMNT_BASE_TYPE , B.FLOATING_MKT_CD , B.FLOATING_MKT_CD_2 , B.RESET_INDEX_TENOR , B.RESET_INDEX_TENOR2 , B.TRANSACT_CURRENCY , B.TRANS_CURRENCY_2 , B.FLT_MARGIN_OP , C.FLOATING_MARGIN , B.FLT2_MARGIN_OP , B.FLOATING2_MARGIN , B.FLT_MARGIN_OP_2 , C.FLOATING_MARGIN , B.FLT2_MARGIN_OP_2 , B.FLOATING2_MARGIN_2 , B.RATE_RESET_TYPE , B.RATE_RESET_TYPE_2 , C.RESET_RATE_SET , C.TRANSACTION_RATE FROM PS_TRX_HEADER_TR A , PS_TRX_DETAIL_TR B , PS_TRX_INTEREST_TR C WHERE B.BUSINESS_UNIT= A.BUSINESS_UNIT AND B.TREAS_HEADER_ID = A.TREAS_HEADER_ID AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.TREAS_HEADER_ID = B.TREAS_HEADER_ID AND C.TRANSACTION_LINE = B.TRANSACTION_LINE AND A.DEAL_STATUS IN ('03','04','07', '09') AND ( B.OPT_TRANSACT_LINE = 0 OR B.OPT_INT_RATE_CAP = 'B' OR B.OPT_INT_RATE_CAP = 'Y') AND C.RESET_RATE_SET = 'N' AND ( (A.DEAL_STATUS <> '07' AND A.DEAL_STATUS <> '09') OR C.PAYMENT_DT <= A.SALE_SETTLEMENT_DT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_TRD_NONVW

2 RATE_RESET_DT Date(10) DATE The date that an interest rate quoted in the market is captured for purposes of calculating interest
3 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.
4 TREAS_MASTER_ID Character(12) VARCHAR2(12) NOT NULL Master ID for a given deal header.
5 TRANSACTION_LINE Number(3,0) SMALLINT NOT NULL The separate and distinct base instrument type components of a given deal transaction.
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 INSTRMNT_BASE_TYPE Character(2) VARCHAR2(2) NOT NULL Instrument base type used as a building block for Treasury deals
01=Interest Rate Physical
02=Interest Rate Swap
03=FX Deal Physical
04=Option
05=Option - Binary Payoff
06=Futures Contract
07=Commodity
08=Generic Instrument
09=Equity
8 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.
9 FLOATING_MKT_CD_2 Character(10) VARCHAR2(10) NOT NULL A unique key identifier that describes a floating rate index basis associated with the second leg of a
10 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
11 RESET_INDEX_TENOR2 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
D28=28 Day
D35=35 Day
D49=49 Day
M01=1 Month
M03=3 Month
M06=6 Month
M12=1 Year
12 TRANSACT_CURRENCY Character(3) VARCHAR2(3) NOT NULL "The nominal
13 TRANS_CURRENCY_2 Character(3) VARCHAR2(3) NOT NULL "The nominal
14 FLT_MARGIN_OP Character(1) VARCHAR2(1) NOT NULL 1st floating margin operation, +/- or *//
*=Multiply By
+=Add
15 FLOATING_MARGIN Signed Number(13,8) DECIMAL(11,8) NOT NULL The supplemental interest rate
16 FLT2_MARGIN_OP Character(1) VARCHAR2(1) NOT NULL Floating margin operations, +/- or *//
*=Multiply By
+=Add
17 FLOATING2_MARGIN Signed Number(13,8) DECIMAL(11,8) NOT NULL The supplemental interest rate
18 FLT_MARGIN_OP_2 Character(1) VARCHAR2(1) NOT NULL 1st floating margin operation, +/- or *//
*=Multiply By
+=Add
19 FLOATING_MARGIN_2 Signed Number(13,8) DECIMAL(11,8) NOT NULL The supplemental interest rate
20 FLT2_MARGIN_OP_2 Character(1) VARCHAR2(1) NOT NULL Floating margin operation, +/- or *//
*=Multiply By
+=Add
21 FLOATING2_MARGIN_2 Signed Number(13,8) DECIMAL(11,8) NOT NULL The supplemental interest rate
22 RATE_RESET_TYPE Character(2) VARCHAR2(2) NOT NULL Describes whether a given deal transaction is subject to a fixed or floating interest rate.
FL=Floating
FX=Fixed
23 RATE_RESET_TYPE_2 Character(2) VARCHAR2(2) NOT NULL Describes whether a given deal transaction is subject to a fixed or floating interest rate for the sec
FL=Floating
FX=Fixed
24 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
25 TRANSACTION_RATE Number(16,8) DECIMAL(15,8) NOT NULL The applicable interest rate for a given deal transaction.