TRD_HEADER_VW

(SQL View)
 Index Back

Treasury Trade Header View

Treasury Trade header record view used on Deals

SELECT DISTINCT H.BUSINESS_UNIT , H.INSTRUMENT_TYPE , H.INSTRMNT_TEMPLATE , H.TRD_TRADE_ID , H.TRADE_TYPE , H.BUY_SELL , H.TREASURY_PORTFOLIO , H.TRANSACTION_DT , H.DESCR150_MIXED , H.COUNTERPARTY_SETID , H.COUNTERPARTY FROM PS_TRD_HEADER_TR H WHERE H.TRADE_CONF_STATUS = '02' AND H.TRADE_STATUS = '03' AND H.TRADE_TYPE = 'O' OR (H.TRADE_TYPE = 'C' AND NOT EXISTS( SELECT 'X' FROM PS_TRX_SELLBUY_MTC S WHERE S.BUSINESS_UNIT = H.BUSINESS_UNIT AND S.TRD_TRADE_ID = H.TRD_TRADE_ID))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INSTRUMENT_TYPE Character(10) VARCHAR2(10) NOT NULL Instrument type
3 INSTRMNT_TEMPLATE Character(10) VARCHAR2(10) NOT NULL A unique key identifier associated with an instrument that describes a separate template version of a pre
4 TRD_TRADE_ID Character(12) VARCHAR2(12) NOT NULL Trade ID

Prompt Table: TRD_HEADER_VW

5 TRADE_TYPE Character(1) VARCHAR2(1) NOT NULL Trade Type
C=Close
O=Open
6 BUY_SELL Character(1) VARCHAR2(1) NOT NULL Designates whether the deal transaction leg represents the buy or sell side of the transaction.
B=Buy/Issue
S=Sell/BuyBack
7 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

8 TRANSACTION_DT Date(10) DATE NOT NULL Transaction date (often used as trade date)
9 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description
10 COUNTERPARTY_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given dealing counterparty.
11 COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL Represents a treasury dealing counterpart.

Prompt Table: BANK_TR_CPTY_VW