TRA_HEDGE_ID_VW (SQL View)	Index Back
Deal ID Prompt Tbl

TRA_HEDGE_ID_VW

(SQL View)

Deal ID Prompt Tbl

SELECT DISTINCT BUSINESS_UNIT , %Substring(EVENT_ID,1,12) FROM PS_TRA_EVENT_CAL WHERE TR_SOURCE_CD = 'H'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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