HDG_RELT_VW (SQL View)	Index Back
Hegde Deals (FAS133) View of a deal linked in a Hegde Deal Relationship where the hedge type is FAS133.

HDG_RELT_VW

(SQL View)

Hegde Deals (FAS133)

View of a deal linked in a Hegde Deal Relationship where the hedge type is FAS133.

SELECT HD.BUSINESS_UNIT , HD.HEDGE_ID , HD.HEDGE_DEAL_SEQ , 'HD' , HD.BUSINESS_UNIT_TRX , HD.TREAS_HEADER_ID , HD.HDG_ADDED_DT , HD.HDG_REMOVED_DT , H.HEDGE_STATUS , H.DISCONTINUE_DT FROM PS_HDG_HEDGE_DEAL HD , PS_HDG_HEDGE H WHERE H.BUSINESS_UNIT = HD.BUSINESS_UNIT AND H.HEDGE_ID = HD.HEDGE_ID AND H.HEDGE_TYPE = '133'

# 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_RELT_SRC Character(2) VARCHAR2(2) NOT NULL Hedge Relation Source

5 BUSINESS_UNIT_TRX Character(5) VARCHAR2(5) NOT NULL The Business Unit for a Treasury Deal (table TRX_HEADER_TR)
Prompt Table: SP_BU_TRD_NONVW

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

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

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

9 HEDGE_STATUS Character(1) VARCHAR2(1) NOT NULL Stores the Status of a FAS 133 hedge: "A" Active, "I" Discontinued (Inactive), "O" Discontinued - Remaining AOCI requiring reclassification
A=Active
I=Discontinued
O=Discontinued - Remaining AOCI

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

#	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_RELT_SRC	Character(2)	VARCHAR2(2) NOT NULL	Hedge Relation Source
5	BUSINESS_UNIT_TRX	Character(5)	VARCHAR2(5) NOT NULL	The Business Unit for a Treasury Deal (table TRX_HEADER_TR) Prompt Table: SP_BU_TRD_NONVW
6	TREAS_HEADER_ID	Character(12)	VARCHAR2(12) NOT NULL	The unique key identifier for a given deal transaction.
7	HDG_ADDED_DT	Date(10)	DATE	Date that a Hedging Deal or a Hedged Item was added to the Hedge relationship
8	HDG_REMOVED_DT	Date(10)	DATE	Date that a Hedging Deal or a Hedged Item was removed from the Hedge relationship
9	HEDGE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Stores the Status of a FAS 133 hedge: "A" Active, "I" Discontinued (Inactive), "O" Discontinued - Remaining AOCI requiring reclassification A=Active I=Discontinued O=Discontinued - Remaining AOCI
10	DISCONTINUE_DT	Date(10)	DATE	Date on which a hedge is discontinued.