TRX_HEADER_VW1

(SQL View)
 Index Back

View over trx_header

View of trx_header_tr deals, grouped by portfolio.

SELECT DH.business_unit , DH.instrument_type , DH.instrmnt_template , DH.treas_header_id , DH.treas_master_id , DH.deal_status , DH.treasury_portfolio , DH.counterparty_setid , DH.counterparty , DH.descr150_mixed FROM PS_TRX_HEADER_TR DH WHERE DH.deal_status = '03' AND NOT EXISTS ( SELECT '1' FROM PS_TRX_SELLBUY_MTC S WHERE S.business_unit = DH.business_unit AND S.treas_header_id = DH.treas_header_id)

  • Parent record: TRD_HEADER_TR

    • # 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 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.
    5 TREAS_MASTER_ID Character(12) VARCHAR2(12) NOT NULL Master ID for a given deal header.
    6 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
    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.
    8 COUNTERPARTY_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given dealing counterparty.
    9 COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL Represents a treasury dealing counterpart.
    10 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description