HDG_DEAL_VW (SQL View)	Index Back
Hegde Status changed in deals. View of a deal linked in a Hegde Relationship that changed status.

HDG_DEAL_VW

(SQL View)

Hegde Status changed in deals.

View of a deal linked in a Hegde Relationship that changed status.

SELECT PS_HDG_HEDGE_DEAL.BUSINESS_UNIT , PS_HDG_HEDGE_DEAL.HEDGE_ID , PS_HDG_HEDGE_DEAL.HEDGE_DEAL_SEQ , PS_HDG_HEDGE_DEAL.HEDGE_DEAL_PCT , PS_HDG_HEDGE_DEAL.HDG_ADDED_DT , PS_HDG_HEDGE_DEAL.HDG_REMOVED_DT , PS_HDG_HEDGE.INCEPTION_DT , PS_HDG_HEDGE.DISCONTINUE_DT , PS_HDG_HEDGE_DEAL.BUSINESS_UNIT_TRX , PS_HDG_HEDGE_DEAL.TREAS_HEADER_ID FROM PS_HDG_HEDGE_DEAL , PS_HDG_HEDGE , PS_TRX_HEADER_TR WHERE PS_HDG_HEDGE.BUSINESS_UNIT = PS_HDG_HEDGE_DEAL.BUSINESS_UNIT AND PS_HDG_HEDGE.HEDGE_ID = PS_HDG_HEDGE_DEAL.HEDGE_ID AND PS_HDG_HEDGE_DEAL.BUSINESS_UNIT_TRX = PS_TRX_HEADER_TR.BUSINESS_UNIT AND PS_HDG_HEDGE_DEAL.TREAS_HEADER_ID = PS_TRX_HEADER_TR.TREAS_HEADER_ID

# 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.

4 HEDGE_DEAL_PCT Number(7,3) DECIMAL(6,3) NOT NULL Proportion (percentage) of Deal Designated as Hedging Instrument

5 HDG_ADDED_DT Date(10) DATE Date that a Hedging Deal or a Hedged Item was added to the Hedge relationship

6 HDG_REMOVED_DT Date(10) DATE Date that a Hedging Deal or a Hedged Item was removed from the Hedge relationship

7 INCEPTION_DT Date(10) DATE NOT NULL Inception date of the hedge
Default Value: %Date

8 DISCONTINUE_DT Date(10) DATE Date on which a hedge is discontinued.

9 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

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

#	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.
4	HEDGE_DEAL_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Proportion (percentage) of Deal Designated as Hedging Instrument
5	HDG_ADDED_DT	Date(10)	DATE	Date that a Hedging Deal or a Hedged Item was added to the Hedge relationship
6	HDG_REMOVED_DT	Date(10)	DATE	Date that a Hedging Deal or a Hedged Item was removed from the Hedge relationship
7	INCEPTION_DT	Date(10)	DATE NOT NULL	Inception date of the hedge Default Value: %Date
8	DISCONTINUE_DT	Date(10)	DATE	Date on which a hedge is discontinued.
9	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
10	TREAS_HEADER_ID	Character(12)	VARCHAR2(12) NOT NULL	The unique key identifier for a given deal transaction.