|
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
|