|
SELECT h.business_unit , h.treas_header_id , d.transaction_line , d.instrmnt_base_type , d.equity_id , d.equity_symbol , d.exchg_cd , d.nbr_of_contracts , d.transaction_price , d.transaction_amt , d.transact_currency , d.settlement_dt , h.start_dt , h.sale_price , h.sale_price_percent , h.sale_trans_amt , h.sale_current_value , h.sale_pro_percent , h.sale_proceeds , h.sale_dt , h.sale_settlement_dt , h.sale_currency , h.sale_bank_setid , h.sale_bank_cd , h.sale_bank_cd_cust , h.sale_bank_acct_key , h.sale_settlement_id , h.sale_cpty_setid , h.sale_counterparty , h.sale_cpty_dealer , h.sale_cpty_ref , h.deal_status , h.treasury_portfolio FROM PS_TRX_HEADER_TR h , ps_trx_detail_tr d WHERE h.business_unit = d.business_unit AND h.treas_header_id = d.treas_header_id AND d.instrmnt_base_type = '09' AND h.deal_status = '03' AND d.contingent_upon = ' ' AND h.TR_APPV_STATUS IN ('01','06')
|
| # |
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 |
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 |
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
|
| 5 |
EQUITY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Equity Identification Number - used to identify an equity in the system. the number is system generated and used for technical purposes only.
Prompt Table:
TRX_EQTY_DEFN
|
| 6 |
EQUITY_SYMBOL |
Character(15) |
VARCHAR2(15) NOT NULL |
Ticker symbol to identify an equity on the exchange that it is traded on
Prompt Table:
TRX_EQTY_DEFN
|
| 7 |
EXCHG_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Trading exchange code
Prompt Table:
TRX_EXCHANGE_CD
|
| 8 |
NBR_OF_CONTRACTS |
Signed Number(18,4) |
DECIMAL(16,4) NOT NULL |
This is the number of future contracts associated with a deal
|
| 9 |
TRANSACTION_PRICE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The preferred business price for a given deal transaction.
|
| 10 |
TRANSACTION_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The nominal or actual deal transaction amount.
|
| 11 |
TRANSACT_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"The nominal
Prompt Table:
CURRENCY_CD_TBL
|
| 12 |
SETTLEMENT_DT |
Date(10) |
DATE |
The settlement date for a given cash -based transaction, or the start date for a Treasury Deal.
|
| 13 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 14 |
SALE_PRICE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The sales price for a buy/sellback transaction.
|
| 15 |
SALE_PRICE_PERCENT |
Number(14,8) |
DECIMAL(13,8) NOT NULL |
The percentage of Unwind par value of which a financial instrument is priced when booked into the system.
|
| 16 |
SALE_TRANS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Unwind Par Amount
|
| 17 |
SALE_CURRENT_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The subject accounting value for a buy/sellback transaction.
|
| 18 |
SALE_PRO_PERCENT |
Number(14,8) |
DECIMAL(13,8) NOT NULL |
The percentage of Unwind par value of which a financial instrument is priced when booked into the system.
|
| 19 |
SALE_PROCEEDS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The received sales proceeds for a buy/sellback transaction.
|
| 20 |
SALE_DT |
Date(10) |
DATE |
The transaction sales date for a buy/sellback transaction.
|
| 21 |
SALE_SETTLEMENT_DT |
Date(10) |
DATE |
The agreed upon settlement date for a buy/sellback transaction.
|
| 22 |
SALE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
The subject transaction currency for a buy/sellback transaction.
Prompt Table:
CURRENCY_CD_TBL
|
| 23 |
SALE_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The subject tableset ID associated with the treasury bank code for a buy/sellback transaction.
|
| 24 |
SALE_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
The subject settlement bank code for a buy/sellback transaction.
Prompt Table:
BANK_TR_BANK_VW
|
| 25 |
SALE_BANK_CD_CUST |
Character(5) |
VARCHAR2(5) NOT NULL |
The subject treasury bank code for a buy/sellback transaction.
|
| 26 |
SALE_BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
The subject bank account for a buy/sellback transaction.
Prompt Table:
BANK_TR_ACTS_VW
|
| 27 |
SALE_SETTLEMENT_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
The subject settlement instructions for a buy/sellback transaction.
Prompt Table:
BANK_SETL_CS_VW
|
| 28 |
SALE_CPTY_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The subject settlement bank tableset ID for a buy/sellback transaction.
|
| 29 |
SALE_COUNTERPARTY |
Character(5) |
VARCHAR2(5) NOT NULL |
The subject counterparty for a buy/sellback transaction.
Prompt Table:
BANK_TR_CPTY_VW
|
| 30 |
SALE_CPTY_DEALER |
Character(10) |
VARCHAR2(10) NOT NULL |
The subject dealer for a buy/sellback transaction.
|
| 31 |
SALE_CPTY_REF |
Character(15) |
VARCHAR2(15) NOT NULL |
The subject transaction reference identifier for a buy/sellback transaction.
|
| 32 |
DEAL_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Represents the specific state or point in the life cycle of a deal transaction.
01=Under Negotiation
02=Sample
03=Open
04=Matured
05=Deactivated
06=Rejected
07=Sold / Bought back
08=Forecasted
09=Partially Sold/Bought Back
Default Value: 03
|
| 33 |
TREASURY_PORTFOLIO |
Character(15) |
VARCHAR2(15) NOT NULL |
A unique key identifier for a position portfolio that may be associated with a given deal transaction.
Prompt Table:
TRX_PORTFLIO_TR
|