HDG_RELT_VW2 (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_VW2

(SQL View)

Hegde Deals (FAS133)

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

SELECT HT.BUSINESS_UNIT , HT.HEDGE_ID , HT.HEDGED_ITEM_SEQ , 'HI' , HT.BUSINESS_UNIT_TRX , HT.TREAS_HEADER_ID , HI.HDG_ADDED_DT , HI.HDG_REMOVED_DT , H.HEDGE_STATUS , H.DISCONTINUE_DT FROM PS_HDG_TRD_LINK HT , PS_HDG_HEDGED_ITEM HI , PS_HDG_HEDGE H WHERE H.BUSINESS_UNIT = HT.BUSINESS_UNIT AND H.HEDGE_ID = HT.HEDGE_ID AND H.HEDGE_TYPE = '133' AND HT.BUSINESS_UNIT = HI.BUSINESS_UNIT AND HT.HEDGE_ID = HI.HEDGE_ID AND HT.HEDGED_ITEM_SEQ = HI.HEDGED_ITEM_SEQ AND HI.HEDGED_ITEM_SRC = 'TRD'

# 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 HEDGED_ITEM_SEQ Number(4,0) SMALLINT NOT NULL Sequence number of the hedged item. this allows mulitple items to be designated as hedged items.

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	HEDGED_ITEM_SEQ	Number(4,0)	SMALLINT NOT NULL	Sequence number of the hedged item. this allows mulitple items to be designated as hedged items.
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.