TRX_RESET_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 , D.VERSION FROM PS_TRX_DETAIL_TR D WHERE (INSTRMNT_BASE_TYPE = '02' AND (RATE_RESET_TYPE = 'FL' OR RATE_RESET_TYPE_2 = 'FL')) OR (INSTRMNT_BASE_TYPE = '01' AND (RATE_RESET_TYPE = 'FL' OR (RATE_RESET_TYPE = 'FX' AND EXISTS ( SELECT 'X' FROM PS_INSTR_HEADER_TR I , PS_TRX_HEADER_TR H WHERE I.INSTRUMENT_TYPE = H.INSTRUMENT_TYPE AND H.BUSINESS_UNIT = D.BUSINESS_UNIT AND H.TREAS_HEADER_ID = D.TREAS_HEADER_ID AND I.ALLOW_FIXED_RT_CHG = 'Y' ))))

  • 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: TRX_RESET_DEAL

    3 TRANSACTION_LINE Number(3,0) SMALLINT NOT NULL The separate and distinct base instrument type components of a given deal transaction.
    4 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference