CONFO_OUTBND_VW(SQL View) |
Index Back |
---|---|
Outbound Confo ViewTreasury 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 |