HDG_HDG_DEAL_VW

(SQL View)
 Index Back

Hedged Deals


SELECT A.BUSINESS_UNIT , A.HEDGE_ID , A.HEDGE_DEAL_SEQ , A.BUSINESS_UNIT_TRX , A.TREAS_HEADER_ID , A.MTM_ACCTG_VALUE_0 , A.MTM_ASEF_VALUE_0 , B.MTM_ASEF_GAINLOSS , B.AS_OF_DATE , B.MTM_ACCTG_VALUE FROM PS_HDG_HEDGE_DEAL A , PS_HDG_DEAL_MTM B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.HEDGE_ID = B.HEDGE_ID AND A.HEDGE_DEAL_SEQ = B.HEDGE_DEAL_SEQ AND B.AS_OF_DATE = ( SELECT MAX(C.AS_OF_DATE) FROM PS_HDG_DEAL_MTM C WHERE C.BUSINESS_UNIT=B.BUSINESS_UNIT AND C.HEDGE_ID=B.HEDGE_ID AND C.HEDGE_DEAL_SEQ = B.HEDGE_DEAL_SEQ)

  • Parent record: HDG_HEDGE

    • # 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 HEDGE_ID Character(12) VARCHAR2(12) NOT NULL Hedge ID identifies the designation of Hedging Deals (Instruments) as being the Hedge of Hedged Items
    3 HEDGE_DEAL_SEQ Number(4,0) SMALLINT NOT NULL Sequence of Hedging Deal (Hedging Instrument) within the list of Hedging Deals for a particular hedge. Allows 1:Many relationship between Hedges and Deals.

    Default Value: 1

    4 BUSINESS_UNIT_TRX Character(5) VARCHAR2(5) NOT NULL The Business Unit for a Treasury Deal (table TRX_HEADER_TR)

    Default Value: HDG_HEDGE.BUSINESS_UNIT

    Prompt Table: SP_BU_TRD_NONVW

    5 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.

    Prompt Table: %EDITTABLE
    Set Control Field: BUSINESS_UNIT_TRX

    6 MTM_ACCTG_VALUE_0 Signed Number(28,3) DECIMAL(26,3) NOT NULL The Initial (starting) Mark to Market Value for a Treasury Deal or other transaction
    7 MTM_ASEF_VALUE_0 Signed Number(28,3) DECIMAL(26,3) NOT NULL The FAS133 para 63 component of Fair Value included in the assessment of effectiveness initial value)
    8 MTM_ASEF_GAINLOSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Gain or Loss computed (FAS 133 para 63 included component)
    9 AS_OF_DATE Date(10) DATE As of Date
    10 MTM_ACCTG_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL The Fair Value (Mark to Market) of a Treasury Deal, or the Fair Value or Cash Flows of a hedged item