| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 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
|
| 3 |
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.
|
| 4 |
AS_OF_DATE |
Date(10) |
DATE NOT NULL |
As of Date
|
| 5 |
MTM_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
The stated currency for a deal transaction's fair value (mark-to-market)
|
| 6 |
HEDGE_DEAL_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Proportion (percentage) of Deal Designated as Hedging Instrument
|
| 7 |
MTM_ACCTG_VALUE_PR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Fair Value
|
| 8 |
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
|
| 9 |
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.
|
| 10 |
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)
|
| 11 |
MTM_GAINLOSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Mark to Market Gain or Loss computed
|
| 12 |
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)
|
| 13 |
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
|
| 14 |
MTM_ASEF_GAINLOSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gain or Loss computed (FAS 133 para 63 included component)
|
| 15 |
ACTD_ASEF_GAINLOSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gain or Loss accounted for (FAS 133 para 63 included component)
|
| 16 |
ACTD_EXCL_GAINLOSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gain or Loss accounted for (FAS 133 para 63 Excluded component)
|
| 17 |
ACCOUNTED_FOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Whether Accounted for
|