| # |
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 |
HEDGED_ITEM_SEQ |
Number(4,0) |
SMALLINT NOT NULL |
Sequence number of the hedged item. this allows mulitple items to be designated as hedged items.
|
| 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 |
HEDGED_ITEM_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Percentage of item hedged.
|
| 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 |
ACCOUNTED_GAINLOSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gain or Loss accounted for
|
| 13 |
ACCOUNTED_FOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Whether Accounted for
|