CONFO_OUTBND_VW

(SQL View)
Index Back

Outbound Confo View

Treasury transactions (deals) dealt by dealers

SELECT a.business_unit , a.treas_header_id , b.transaction_line , a.instrument_type , a.transaction_dt , a.counterparty , a.descr150_mixed , a.dealer_oprid , a.cpty_reference , a.cpty_dealer , a.fclty_id , b.opt_exercise_type , b.transaction_amt , b.transaction_amt_2 , b.transaction_price , b.transact_proceeds , b.price_percent_par , b.transact_currency , b.trans_currency_2 , b.swap_principals , b.settlement_dt , b.maturity_dt , b.issue_dt , b.interest_start_dt , b.transaction_rate , b.transaction_rate_2 , b.transaction_yield , b.rate_reset_type , b.rate_reset_type_2 , b.int_basis , b.int_basis_2 , b.int_calculation , b.int_calculation_2 , b.straightline_disc , b.floating_mkt_cd , b.floating_mkt_cd_2 , b.floating_margin , b.floating_margin_2 , b.security_id , b.pay_bank_acct_num , b.pay_bank_cd , b.pay_bnk_id_nbr , b.pay_settlement_id , b.rec_bank_acct_num , b.rec_bank_cd , b.rec_bnk_id_nbr , b.rec_settlement_id FROM PS_TRX_HEADER_TR a , ps_trx_detail_tr b WHERE a.business_unit=b.business_unit AND a.treas_header_id=b.treas_header_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
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 INSTRUMENT_TYPE Character(10) VARCHAR2(10) NOT NULL Instrument type
5 TRANSACTION_DT Date(10) DATE Transaction date (often used as trade date)
6 COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL Represents a treasury dealing counterpart.
7 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description
8 DEALER_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that originally created and saved a given deal tran
9 CPTY_REFERENCE Character(15) VARCHAR2(15) NOT NULL A reference identifier associated with a dealing counterparty transaction.
10 CPTY_DEALER Character(10) VARCHAR2(10) NOT NULL The assigned external dealer or trader associated with a given dealing counterparty.
11 FCLTY_ID Character(12) VARCHAR2(12) NOT NULL A unique key identifier that represents a given counterparty facility.
12 OPT_EXERCISE_TYPE Character(1) VARCHAR2(1) NOT NULL The option exercise type.
A=American
B=Bermudan
E=European
13 TRANSACTION_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL The nominal or actual deal transaction amount.
14 TRANSACTION_AMT_2 Signed Number(28,3) DECIMAL(26,3) NOT NULL The nominal transaction amount for the second leg of a deal transacation.
15 TRANSACTION_PRICE Signed Number(28,3) DECIMAL(26,3) NOT NULL The preferred business price for a given deal transaction.
16 TRANSACT_PROCEEDS Signed Number(28,3) DECIMAL(26,3) NOT NULL The amount of funds that changes hands when a deal is complete.
17 PRICE_PERCENT_PAR Number(14,8) DECIMAL(13,8) NOT NULL The percentage of par value of which a financial instrument is priced when booked into the system.
18 TRANSACT_CURRENCY Character(3) VARCHAR2(3) NOT NULL "The nominal
19 TRANS_CURRENCY_2 Character(3) VARCHAR2(3) NOT NULL "The nominal
20 SWAP_PRINCIPALS Character(1) VARCHAR2(1) NOT NULL Stores information about whether Princiapls should be swapped. If yes, when.
B=At Commencement & Maturity
C=At Commencement
M=At Maturity
N=Don't Swap
21 SETTLEMENT_DT Date(10) DATE The settlement date for a given cash -based transaction, or the start date for a Treasury Deal.
22 MATURITY_DT Date(10) DATE The maturity date for a deal transaction.
23 ISSUE_DT Date(10) DATE Issue Dt
24 INTEREST_START_DT Date(10) DATE The coupon period start date for a given deal transaction.
25 TRANSACTION_RATE Number(16,8) DECIMAL(15,8) NOT NULL The applicable interest rate for a given deal transaction.
26 TRANSACTION_RATE_2 Number(16,8) DECIMAL(15,8) NOT NULL The applicable interest rate for the second leg of a given deal transaction.
27 TRANSACTION_YIELD Signed Number(15,8) DECIMAL(13,8) NOT NULL The applicable yield for an interest rate physical deal transaction.
28 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
29 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
30 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
31 INT_BASIS_2 Character(2) VARCHAR2(2) NOT NULL The accrual day count basis for the receive side in a two leged deal
30=30/360
3E=30E/360
A0=Actual/360
A5=Actual/365
AA=Actual/Actual
32 INT_CALCULATION Character(2) VARCHAR2(2) NOT NULL Interest calculation method for financial instruments.
AR=Interest Bearing
CD=Canadian Discount
DS=Straight Discount
DY=Discount to Yield
33 INT_CALCULATION_2 Character(2) VARCHAR2(2) NOT NULL Interest calculation method for financial instruments
AR=Interest Bearing
DS=Straight Discount
DY=Discount to Yield
34 STRAIGHTLINE_DISC Character(1) VARCHAR2(1) NOT NULL Describes whether a deal transaction's discount amount is to be amortized with the straightline method, or handled using the Yield to Maturity (Constant Yield) method
N=Constant Yield Method
Y=Straightline Method
35 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.
36 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
37 FLOATING_MARGIN Signed Number(13,8) DECIMAL(11,8) NOT NULL The supplemental interest rate
38 FLOATING_MARGIN_2 Signed Number(13,8) DECIMAL(11,8) NOT NULL The supplemental interest rate
39 SECURITY_ID Character(10) VARCHAR2(10) NOT NULL A reference identifier for a given deal transaction.
40 PAY_BANK_ACCT_NUM Character(35) VARCHAR2(35) NOT NULL The bank account number for the disbursing side of a settlement transaction.
41 PAY_BANK_CD Character(5) VARCHAR2(5) NOT NULL The bank for the disbursing side of a settlement transaction.
42 PAY_BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL The alphanumeric bank identifier associated with a bank on the disbursing side of a settlement trans
43 PAY_SETTLEMENT_ID Character(5) VARCHAR2(5) NOT NULL Represents the settlement instructions identifier associated with the submitter of a
44 REC_BANK_ACCT_NUM Character(35) VARCHAR2(35) NOT NULL The bank account number for the receiving side of a settlement transaction.
45 REC_BANK_CD Character(5) VARCHAR2(5) NOT NULL The bank for the receiving side of a settlement transaction.
46 REC_BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL The alphanumeric bank identifier associated with a bank on the receiving side of a settlement transa
47 REC_SETTLEMENT_ID Character(5) VARCHAR2(5) NOT NULL The settlement instructions associated with the bank and account on the receiving side