HDG_SRC_FIN_VW (SQL View)	Index Back
Hedge Source "Source-Finan" VW A view over HDG_SRC_TBL, but with key field order changed to: SETID, HEDGE_TYPE_133, HEDGED_ITEM_SRC, HEDGED_ITM_FINANCIAL (to aid related display fields on panels)

HDG_SRC_FIN_VW

(SQL View)

Hedge Source "Source-Finan" VW

A view over HDG_SRC_TBL, but with key field order changed to: SETID, HEDGE_TYPE_133, HEDGED_ITEM_SRC, HEDGED_ITM_FINANCIAL (to aid related display fields on panels)

SELECT setid ,hedge_type_133 ,hedged_item_src ,hdgd_itm_financial ,prompt_tbl ,hedged_item_type ,mtm_excl_val_type FROM PS_HDG_SRC_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 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

3 HEDGED_ITEM_SRC Character(3) VARCHAR2(3) NOT NULL This identifies which sub-system/product contains the item being hedged.
BDF=Budgets Forecast
POO=Purchase Order
TRD=Treasury Deal
TRE=Other Hedgeable Items

4 HDGD_ITM_FINANCIAL Character(1) VARCHAR2(1) NOT NULL Is the hedged item/transaction a Financial Asset or Liability, or a non-financial Firm Commitment with Financial components? (FAS133 paras 21(e-f) & 29(g-h))
N=Nonfinancial Item
Y=Financial Item
Y/N Table Edit

5 PROMPT_TBL Character(15) VARCHAR2(15) NOT NULL Prompt Table
Prompt Table: PSRECDEFN

6 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

7 MTM_EXCL_VAL_TYPE Character(4) VARCHAR2(4) NOT NULL A code that selects what processing and label the user wants to appear against field MTM_EXCL_VALUE on the Deal Analytics page. 1st char is either "C" display Cumulative adjustment amounts (like Amortized Cost), or "P" display Period by period adjustment amounts (FAS133 derivatives) Next 3 chars are the LABEL_ID of one of MTM_EXCL_VALUE's labels.
CAC=Cumulative Amortized Cost
CFVA=Cumulative Fair Value
PFVA=Per Period Fair Value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	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
3	HEDGED_ITEM_SRC	Character(3)	VARCHAR2(3) NOT NULL	This identifies which sub-system/product contains the item being hedged. BDF=Budgets Forecast POO=Purchase Order TRD=Treasury Deal TRE=Other Hedgeable Items
4	HDGD_ITM_FINANCIAL	Character(1)	VARCHAR2(1) NOT NULL	Is the hedged item/transaction a Financial Asset or Liability, or a non-financial Firm Commitment with Financial components? (FAS133 paras 21(e-f) & 29(g-h)) N=Nonfinancial Item Y=Financial Item Y/N Table Edit
5	PROMPT_TBL	Character(15)	VARCHAR2(15) NOT NULL	Prompt Table Prompt Table: PSRECDEFN
6	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
7	MTM_EXCL_VAL_TYPE	Character(4)	VARCHAR2(4) NOT NULL	A code that selects what processing and label the user wants to appear against field MTM_EXCL_VALUE on the Deal Analytics page. 1st char is either "C" display Cumulative adjustment amounts (like Amortized Cost), or "P" display Period by period adjustment amounts (FAS133 derivatives) Next 3 chars are the LABEL_ID of one of MTM_EXCL_VALUE's labels. CAC=Cumulative Amortized Cost CFVA=Cumulative Fair Value PFVA=Per Period Fair Value