HDG_SUMMARY_VW

(SQL View)
Index Back

SELECT A.BUSINESS_UNIT ,A.HEDGE_ID ,A.BUSINESS_UNIT_TRX ,A.TREAS_HEADER_ID ,A.HEDGE_DEAL_PCT , C.DESCR150_MIXED FROM PS_HDG_HEDGE_DEAL A , PS_HDG_HEDGE B , PS_TRX_HEADER_TR C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.HEDGE_ID = B.HEDGE_ID AND A.TREAS_HEADER_ID = C.TREAS_HEADER_ID

# 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

Prompt Table: HDG_HEDGE

3 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

4 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.
5 HEDGE_DEAL_PCT Number(7,3) DECIMAL(6,3) NOT NULL Proportion (percentage) of Deal Designated as Hedging Instrument

Default Value: 100

6 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description