HDG_DEAL_X_PRMP (SQL View)	Index Back
Hedging Deals (Instruments) Prompt view for Treasury Deals when they are Hedging Deals (Rename BUSINESS_UNIT field to TRX_BUSINESS_UNIT to distinguish from BUSINESS_UNIT field in HDG_HEDGE). Includes 'D'erivatives, 'E'mbedded Derivatives, and 'X' Foreign-currency-denominated nonderivative. Used for hedge types 'XFC' and 'XNI'

HDG_DEAL_X_PRMP

(SQL View)

Hedging Deals (Instruments)

Prompt view for Treasury Deals when they are Hedging Deals (Rename BUSINESS_UNIT field to TRX_BUSINESS_UNIT to distinguish from BUSINESS_UNIT field in HDG_HEDGE). Includes 'D'erivatives, 'E'mbedded Derivatives, and 'X' Foreign-currency-denominated nonderivative. Used for hedge types 'XFC' and 'XNI'

SELECT DISTINCT h.business_unit ,h.treas_header_id ,h.instrument_type ,h.transaction_dt ,h.counterparty ,h.descr150_mixed ,h.deal_status ,i.fas133_instrument FROM PS_TRX_HEADER_TR h , ps_trx_detail_tr d , ps_instr_header_tr i WHERE d.business_unit = h.business_unit AND d.treas_header_id = h.treas_header_id AND i.setid = ( SELECT setid FROM ps_set_cntrl_rec WHERE recname = 'INSTR_HEADER_TR' AND setcntrlvalue = h.business_unit) AND i.instrument_type = h.instrument_type AND i.instrmnt_template = ' ' AND (i.fas133_instrument IN ('D','E') OR (i.fas133_instrument = 'X' AND d.transact_currency <> d.anchor_currency)) AND h.deal_status = '03'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_TRX Character(5) VARCHAR2(5) NOT NULL The Business Unit for a Treasury Deal (table TRX_HEADER_TR)
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_TRD_NONVW

2 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.
Prompt Table: TRX_HEADER_TR

3 INSTRUMENT_TYPE Character(10) VARCHAR2(10) NOT NULL Instrument type
Prompt Table: INSTR_INST_H_VW

4 TRANSACTION_DT Date(10) DATE Transaction date (often used as trade date)

5 COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL Represents a treasury dealing counterpart.
Prompt Table: BANK_TR_CPTY_VW

6 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description

7 DEAL_STATUS Character(2) VARCHAR2(2) NOT NULL Represents the specific state or point in the life cycle of a deal transaction.
01=Under Negotiation
02=Sample
03=Open
04=Matured
05=Deactivated
06=Rejected
07=Sold / Bought back
08=Forecasted
09=Partially Sold/Bought Back
Default Value: 02

8 FAS133_INSTRUMENT Character(1) VARCHAR2(1) NOT NULL listbox to choose the FAS 133 Hedging Instrument Type: "D" Derivative "E" Embedded Derivative "X" Nonderivative Foreign Currency "H" Hedgable Item If this field has a value, then this instrument can be used for FAS 133 hedging: D, E, X as Hedging Instruments, X, H as Hedged Items
D=Is a Derivative
E=Contains Embedded Derivative
H=Can be a Hedged Item
X=Nonderivative Foreign Currency

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_TRX	Character(5)	VARCHAR2(5) NOT NULL	The Business Unit for a Treasury Deal (table TRX_HEADER_TR) Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_TRD_NONVW
2	TREAS_HEADER_ID	Character(12)	VARCHAR2(12) NOT NULL	The unique key identifier for a given deal transaction. Prompt Table: TRX_HEADER_TR
3	INSTRUMENT_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Instrument type Prompt Table: INSTR_INST_H_VW
4	TRANSACTION_DT	Date(10)	DATE	Transaction date (often used as trade date)
5	COUNTERPARTY	Character(5)	VARCHAR2(5) NOT NULL	Represents a treasury dealing counterpart. Prompt Table: BANK_TR_CPTY_VW
6	DESCR150_MIXED	Character(150)	VARCHAR2(150) NOT NULL	Description
7	DEAL_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Represents the specific state or point in the life cycle of a deal transaction. 01=Under Negotiation 02=Sample 03=Open 04=Matured 05=Deactivated 06=Rejected 07=Sold / Bought back 08=Forecasted 09=Partially Sold/Bought Back Default Value: 02
8	FAS133_INSTRUMENT	Character(1)	VARCHAR2(1) NOT NULL	listbox to choose the FAS 133 Hedging Instrument Type: "D" Derivative "E" Embedded Derivative "X" Nonderivative Foreign Currency "H" Hedgable Item If this field has a value, then this instrument can be used for FAS 133 hedging: D, E, X as Hedging Instruments, X, H as Hedged Items D=Is a Derivative E=Contains Embedded Derivative H=Can be a Hedged Item X=Nonderivative Foreign Currency