TR_INTREST_DEAL

(SQL View)
 Index Back

View over deals with reset

list of physical and notional deals that have a floating rate type

SELECT DISTINCT D.BUSINESS_UNIT , D.TREAS_HEADER_ID , D.TRANSACTION_LINE , H.INSTRUMENT_TYPE , H.INSTRMNT_TEMPLATE , H.TRANSACTION_DT , H.COUNTERPARTY , H.DEAL_STATUS , H.TREAS_MASTER_ID , H.TRD_TRADE_ID , H.SECURITY_ID , H.DESCR150_MIXED , D.VERSION 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 IN ('01','02')

  • Parent record: TRX_PORTFLIO_TR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.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.

    Prompt Table: TR_INTREST_D_VW

    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

    Prompt Table: INSTR_INST_H_VW

    5 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

    Prompt Table: INSTR_TMPL_H_VW

    6 TRANSACTION_DT Date(10) DATE NOT NULL Transaction date (often used as trade date)
    7 COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL Represents a treasury dealing counterpart.

    Prompt Table: BANK_TR_CPTY_VW

    8 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

    9 TREAS_MASTER_ID Character(12) VARCHAR2(12) NOT NULL Master ID for a given deal header.

    Prompt Table: TRX_HEADER_VW2

    10 TRD_TRADE_ID Character(12) VARCHAR2(12) NOT NULL Trade ID

    Prompt Table: TRD_HEADER_VW

    11 SECURITY_ID Character(10) VARCHAR2(10) NOT NULL A reference identifier for a given deal transaction.

    Prompt Table: TRX_SEC_VW

    12 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description
    13 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference