HDG_HDG_ITM_VW

(SQL View)
 Index Back

SELECT C.BUSINESS_UNIT ,C.HEDGE_ID ,A.BUSINESS_UNIT_TRX , A.TREAS_HEADER_ID ,D.DESCR150_MIXED ,C.HEDGED_ITEM_PCT FROM PS_HDG_TRD_LINK A , PS_HDG_HEDGE B , PS_HDG_HEDGED_ITEM C ,PS_TRX_HEADER_TR D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.HEDGE_ID = B.HEDGE_ID AND B.HEDGE_ID = C.HEDGE_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.TREAS_HEADER_ID = D.TREAS_HEADER_ID AND A.HEDGED_ITEM_SEQ = C.HEDGED_ITEM_SEQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
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 BUSINESS_UNIT_TRX Character(5) VARCHAR2(5) NOT NULL The Business Unit for a Treasury Deal (table TRX_HEADER_TR)
4 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.
5 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description
6 HEDGED_ITEM_PCT Number(7,3) DECIMAL(6,3) NOT NULL Percentage of item hedged.

Default Value: 100