HDG_HEDGE_C_VW (SQL View)	Index Back
Used in Hedge Management

HDG_HEDGE_C_VW

(SQL View)

Used in Hedge Management

SELECT a.business_unit , a.hedge_collection , a.hedge_id , b.hedge_status , b.hedge_type , b.hedge_type_133 , b.inception_dt , b.hedge_ef_ases_cd , b.discontinue_dt , b.descr60 FROM PS_HDG_COLLCTN_DTL a ,ps_hdg_hedge b WHERE a.business_unit = b.business_unit AND a.hedge_id = b.hedge_id AND a.effdt=( SELECT MAX(c.effdt) FROM PS_HDG_COLLCTN_DTL c WHERE c.setid=a.setid AND c.hedge_collection=a.hedge_collection AND c.effdt <=%CurrentDateIn)

Related Language Record: HDG_HDG_CVW_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_TRD_NONVW

2 HEDGE_COLLECTION Character(15) VARCHAR2(15) NOT NULL Collection of Hedges

3 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

4 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
Default Value: A

5 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
Default Value: 133

6 HEDGE_TYPE_133 Character(3) VARCHAR2(3) NOT NULL Hedge type when FAS 133 is applied.
CF=Cash Flow Hedge
FV=Fair Value Hedge
XAS=FX FV of Available-for-Sale
XCF=FX Cash Flow Hedge
XFC=FX FV of Firm Commitment
XNI=FX Hedge of Net Investment

7 INCEPTION_DT Date(10) DATE NOT NULL Inception date of the hedge
Default Value: %Date

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

9 DISCONTINUE_DT Date(10) DATE Date on which a hedge is discontinued.

10 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_TRD_NONVW
2	HEDGE_COLLECTION	Character(15)	VARCHAR2(15) NOT NULL	Collection of Hedges
3	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
4	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 Default Value: A
5	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 Default Value: 133
6	HEDGE_TYPE_133	Character(3)	VARCHAR2(3) NOT NULL	Hedge type when FAS 133 is applied. CF=Cash Flow Hedge FV=Fair Value Hedge XAS=FX FV of Available-for-Sale XCF=FX Cash Flow Hedge XFC=FX FV of Firm Commitment XNI=FX Hedge of Net Investment
7	INCEPTION_DT	Date(10)	DATE NOT NULL	Inception date of the hedge Default Value: %Date
8	HEDGE_EF_ASES_CD	Character(3)	VARCHAR2(3) NOT NULL	Effectiveness Assessment method ANI=Assume No Ineffectiveness CRG=Correlation - Regression CUO=Cumulative Offset
9	DISCONTINUE_DT	Date(10)	DATE	Date on which a hedge is discontinued.
10	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description