HDG_ASSESSMENT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_TRD_NONVW
2	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
3	ASSESSMENT_DT	Date(10)	DATE NOT NULL	Assessment Date Type
4	HEDGE_EF_ASES_CD	Character(3)	VARCHAR2(3) NOT NULL	Effectiveness Assessment method ANI=Assume No Ineffectiveness CRG=Correlation - Regression CUO=Cumulative Offset
5	ASSESSMENT_DTTIME	DateTime(26)	TIMESTAMP NOT NULL	Current date and time
6	ASSESSMENT_MADE	Character(1)	VARCHAR2(1) NOT NULL	Assessment made check box Y/N Table Edit
7	ASSESSMENT_PASSED	Character(1)	VARCHAR2(1) NOT NULL	Assessment passed check box Y/N Table Edit
8	PASS_FAIL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Pass / Fail E=Fair Value Missing F=Fail P=Pass
9	R_SQUARE	Signed Number(7,4)	DECIMAL(5,4) NOT NULL	R Square value used in Hedge effectiveness measurement
10	HDG_RATIO	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Ratio
11	ASSESSMENT_OPRID	Character(8)	VARCHAR2(8) NOT NULL	This is the Assessment Operator ID
12	MTM_ACCTG_VALUE_PR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Fair Value
13	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
14	HEDGE_VARIATION	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Variation
15	MTM_ACCT_VALUE_PR1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Fair Value
16	MTM_ACCTG_VALUE1	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
17	HEDGE_VARIATION1	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Variation
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
19	TO_YEAR	Number(4,0)	SMALLINT NOT NULL	To Year
20	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID Prompt Table: CAL_DEFN_TBL