HDG_TRE_CF_VW

(SQL View)
Index Back

Hedged Exp (last resort) CF VW

View over HDG_EXPOSURE containing exposures that can be hedged in a Cash Flow hedge

SELECT business_unit , hedged_item_id , hedge_status , review_dt , hedged_item_type , hedged_item_status , hdgd_item_begin_dt , hdgd_item_end_dt , hdgd_item_amt , hdgd_item_amt_ccy , hdgd_item_quantity , hdgd_item_uom , hdg_risk_type , hdgd_item_details , descr60 FROM PS_HDG_EXPOSURE WHERE hedged_item_type IN ('FOT')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_TRE Character(5) VARCHAR2(5) NOT NULL Business Unit for Hedged Exposure of Last resort

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: BUS_UNIT_TBL_FS

2 HEDGED_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Hedged Item ID

Prompt Table: HDG_EXPOSURE

3 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

4 REVIEW_DT Date(10) DATE NOT NULL Review Date
5 HEDGED_ITEM_TYPE Character(3) VARCHAR2(3) NOT NULL The type of FAS 133 Hedged item. Either an Unrecognized Firm Commitment, a Recognized Asset or Liability, or a Forecasted Transaction. A hedged item STARTS as one of these, and then changes according to HEDGED_ITEM_STATUS
FOT=Forecasted Transaction
NIF=Net Investment in a Foreign Op
RAL=Recognized Asset or Liability
UFC=Unrecognized Firm Commitment
6 HEDGED_ITEM_STATUS Character(3) VARCHAR2(3) NOT NULL A FAS 133 hedged item starts life as type HEDGED_ITEM_TYPE, then after a period changes according to this field, HEGDED_ITEM_STATUS
CAL=Firm Commitment or Asset/Liab
CAN=Cancelled
FOT=Forecasted Transaction
NIF=Net Investment in a Foreign Op
NLP=No Longer Probable
RAL=Recognized Asset or Liability
UFC=Unrecognized Firm Commitment
7 HDGD_ITEM_BEGIN_DT Date(10) DATE The timing for a Firm Commitment, or the start date for the period within which a forecasted transaction is expected to occur
8 HDGD_ITEM_END_DT Date(10) DATE The timing for a Firm Commitment, or the end date for the period within which a Forecasted Transaction is expected to occur, or the end date of a recognized asset or liability (settlement date)
9 HDGD_ITEM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL The fixed price for a Firm Commitment, or the expected currency amount of a forecasted transaction
10 HDGD_ITEM_AMT_CCY Character(3) VARCHAR2(3) NOT NULL Currency of the hedged item.

Prompt Table: CURRENCY_CD_TBL

11 HDGD_ITEM_QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity or expected quantity of the hedged item.
12 HDGD_ITEM_UOM Character(3) VARCHAR2(3) NOT NULL Unit of Measure for field HDGD_ITEM_QUANTITY

Prompt Table: UNITS_TBL

13 HDG_RISK_TYPE Character(10) VARCHAR2(10) NOT NULL Type of Risk of Hedged item

Prompt Table: HDG_EXP_RSK_DEF

14 HDGD_ITEM_DETAILS Character(254) VARCHAR2(254) NOT NULL Details of the hedged item.
15 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description