HDG_ITEM_VW (SQL View)	Index Back
Hedge Status changed for deals View of deals that are items in a hedge link relationship that changed status.

HDG_ITEM_VW

(SQL View)

Hedge Status changed for deals

View of deals that are items in a hedge link relationship that changed status.

SELECT PS_HDG_HEDGED_ITEM.BUSINESS_UNIT , PS_HDG_HEDGED_ITEM.HEDGE_ID , PS_HDG_HEDGED_ITEM.HEDGED_ITEM_SEQ , PS_HDG_HEDGED_ITEM.HEDGED_ITEM_PCT , PS_HDG_HEDGED_ITEM.HDG_ADDED_DT , PS_HDG_HEDGED_ITEM.HDG_REMOVED_DT , PS_HDG_HEDGE.INCEPTION_DT , PS_HDG_HEDGE.DISCONTINUE_DT , PS_HDG_TRD_LINK.BUSINESS_UNIT_TRX , PS_HDG_TRD_LINK.TREAS_HEADER_ID FROM PS_HDG_HEDGED_ITEM , PS_TRX_HEADER_TR , PS_HDG_TRD_LINK , PS_HDG_HEDGE WHERE PS_TRX_HEADER_TR.BUSINESS_UNIT = PS_HDG_TRD_LINK.BUSINESS_UNIT_TRX AND PS_TRX_HEADER_TR.TREAS_HEADER_ID = PS_HDG_TRD_LINK.TREAS_HEADER_ID AND PS_HDG_HEDGED_ITEM.BUSINESS_UNIT = PS_HDG_TRD_LINK.BUSINESS_UNIT AND PS_HDG_HEDGED_ITEM.HEDGE_ID = PS_HDG_TRD_LINK.HEDGE_ID AND PS_HDG_HEDGED_ITEM.HEDGED_ITEM_SEQ = PS_HDG_TRD_LINK.HEDGED_ITEM_SEQ AND PS_HDG_HEDGE.BUSINESS_UNIT = PS_HDG_HEDGED_ITEM.BUSINESS_UNIT AND PS_HDG_HEDGE.HEDGE_ID = PS_HDG_HEDGED_ITEM.HEDGE_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 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 HEDGED_ITEM_PCT Number(7,3) DECIMAL(6,3) NOT NULL Percentage of item hedged.

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	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	HEDGED_ITEM_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Percentage of item hedged.
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.