HDG_DEAL_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	HEDGE_ID	Character(12)	VARCHAR2(12) NOT NULL	Hedge ID identifies the designation of Hedging Deals (Instruments) as being the Hedge of Hedged Items
5	TREAS_HEADER_ID	Character(12)	VARCHAR2(12) NOT NULL	The unique key identifier for a given deal transaction.
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
7	DEAL_MTM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The Mark to Market value of a Treasury Deal, or the Fair Value or Cash Flows of a hedged item
8	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag N=No Y=Yes
9	EXISTING_POSN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Existing Position
10	MTM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The stated currency for a deal transaction's fair value (mark-to-market)
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
12	MTM_ACCTG_VALUE_0	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The Initial (starting) Mark to Market Value for a Treasury Deal or other transaction
13	MTM_ACCTG_VALUE_PR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Fair Value
14	MTM_ASEF_VALUE_PR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The FAS133 para 63 component of Fair Value included in the assessment of effectiveness (previous value)
15	MTM_ASEF_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The FAS133 para 63 component of Fair Value included in the assessment of effectiveness
16	MTM_EXCL_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	(Cumulative) Adjustment amount excluded from the calculation of the change in fair value of a deal or hedged item. Corresponds to Amortized Cost for investments and to Para 19 adjustments for a hedged item. NOTE: ONLY Label IDs 3 characters or less can be used as user-chosen labels on the Define Intruments / Analytics page (if added as XLATs to field MTM_EXCL_VAL_TYPE + C/P prefix)
17	MTM_EXCL_VALUE_0	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Initial (Cumulative) Adjustment amount excluded from the calculation of the change in fair value of a hedged item. This is the CUMULATIVE Para 19 adjustment for a hedged item.
18	MTM_EXCL_VALUE_PR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Previous (cumulative) Adjustment amount excluded from the calculation of the change in fair value of a deal or hedged item. Corresponds to Amortized Cost for investments and to Para 19 adjustments for a hedged item.
19	HEDGE_DEAL_SEQ	Number(4,0)	SMALLINT NOT NULL	Sequence of Hedging Deal (Hedging Instrument) within the list of Hedging Deals for a particular hedge. Allows 1:Many relationship between Hedges and Deals.
20	BUSINESS_UNIT_TRX	Character(5)	VARCHAR2(5) NOT NULL	The Business Unit for a Treasury Deal (table TRX_HEADER_TR)
21	MTM_ASEF_VALUE_0	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The FAS133 para 63 component of Fair Value included in the assessment of effectiveness initial value)
22	HEDGE_DEAL_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	Proportion (percentage) of Deal Designated as Hedging Instrument
23	MTM_FN_USAGE	Character(2)	VARCHAR2(2) NOT NULL	This field specifies the specific analytic operation/function to be performed on that instrument type 00=MTM 01=Firm-wide Analysis 02=Convexity 03=Duration 04=MTM-A 05=File Export 06=Delta 07=Risk Measures 08=Sensitivity Analysis 09=Market Risk 10=Credit Risk 11=Operational Risk 12=Strategic Risk 13=Other
24	MTM_MODEL	Character(10)	VARCHAR2(10) NOT NULL	Represents a more granular method by which to establish diverse analytics function usages for a given finan
25	AS_OF_DATE	Date(10)	DATE	As of Date
26	AS_OF_DATE_01	Date(10)	DATE	As of Date 01