HDG_EF_DEAL_VW (SQL View)	Index Back
Cumulative Offset Hedge Deals

HDG_EF_DEAL_VW

(SQL View)

Cumulative Offset Hedge Deals

SELECT H.BUSINESS_UNIT , H.HEDGE_ID , H.HEDGE_EF_ASES_CD , C.SETID , C.CALENDAR_ID , C.FISCAL_YEAR , C.ACCOUNTING_PERIOD , DM.MTM_CURRENCY ,SUM(DM.MTM_ACCTG_VALUE_PR) - SUM(DM.MTM_ACCTG_VALUE) , SUM(DM.MTM_ACCTG_VALUE_PR) , SUM(DM.MTM_ACCTG_VALUE) FROM PS_HDG_HEDGE H , PS_HDG_HEDGE_DEAL D , PS_HDG_DEAL_MTM DM , PS_CAL_DETP_TBL C WHERE H.BUSINESS_UNIT = D.BUSINESS_UNIT AND H.HEDGE_ID = D.HEDGE_ID AND D.BUSINESS_UNIT = DM.BUSINESS_UNIT AND D.HEDGE_ID = DM.HEDGE_ID AND D.HEDGE_DEAL_SEQ = DM.HEDGE_DEAL_SEQ AND DM.AS_OF_DATE BETWEEN C.BEGIN_DT AND C.END_DT GROUP BY H.BUSINESS_UNIT, H.HEDGE_ID, H.HEDGE_EF_ASES_CD, C.SETID, C.CALENDAR_ID, C.FISCAL_YEAR, C.ACCOUNTING_PERIOD,DM.MTM_CURRENCY

# 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

3 HEDGE_EF_ASES_CD Character(3) VARCHAR2(3) NOT NULL Effectiveness Assessment method
ANI=Assume No Ineffectiveness
CRG=Correlation - Regression
CUO=Cumulative Offset

4 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID

5 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

6 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

7 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

8 MTM_CURRENCY Character(3) VARCHAR2(3) NOT NULL The stated currency for a deal transaction's fair value (mark-to-market)

9 HEDGE_VARIATION Signed Number(28,3) DECIMAL(26,3) NOT NULL Variation

10 MTM_ACCTG_VALUE_PR Signed Number(28,3) DECIMAL(26,3) NOT NULL Fair Value

11 MTM_ACCTG_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL The Fair Value (Mark to Market) of a Treasury Deal, or the Fair Value or Cash Flows of a hedged item

#	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
3	HEDGE_EF_ASES_CD	Character(3)	VARCHAR2(3) NOT NULL	Effectiveness Assessment method ANI=Assume No Ineffectiveness CRG=Correlation - Regression CUO=Cumulative Offset
4	CALENDAR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Calendar SetID
5	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
6	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
7	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
8	MTM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The stated currency for a deal transaction's fair value (mark-to-market)
9	HEDGE_VARIATION	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Variation
10	MTM_ACCTG_VALUE_PR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Fair Value
11	MTM_ACCTG_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The Fair Value (Mark to Market) of a Treasury Deal, or the Fair Value or Cash Flows of a hedged item