HDG_HEDGE_VW

(SQL View)

SELECT DISTINCT HEDGE_STRATEGY_CD , HEDGE_ID , HEDGE_TYPE ,HEDGE_SHORTCUT FROM PS_HDG_HEDGE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HEDGE_STRATEGY_CD Character(10) VARCHAR2(10) NOT NULL Risk Management Strategy Code
Prompt Table: HDG_STRATGY_TBL

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 HEDGE_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Hedge, either: FAS 133, IAS39, or Economic/Other
133=FAS 133 Hedge
39=IAS39 Hedge
OTH=Economic / Other Hedge

4 HEDGE_SHORTCUT Character(1) VARCHAR2(1) NOT NULL Checkbox for 'Use Shortcut Method for Interest Rate Swap Hedge'
N=No
Y=Yes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HEDGE_STRATEGY_CD	Character(10)	VARCHAR2(10) NOT NULL	Risk Management Strategy Code Prompt Table: HDG_STRATGY_TBL
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	HEDGE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Hedge, either: FAS 133, IAS39, or Economic/Other 133=FAS 133 Hedge 39=IAS39 Hedge OTH=Economic / Other Hedge
4	HEDGE_SHORTCUT	Character(1)	VARCHAR2(1) NOT NULL	Checkbox for 'Use Shortcut Method for Interest Rate Swap Hedge' N=No Y=Yes