| # |
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 |
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.
Default Value: 1
|
| 4 |
HEDGED_ITEM_SRC |
Character(3) |
VARCHAR2(3) NOT NULL |
This identifies which sub-system/product contains the item being hedged.
BDF=Budgets Forecast
POO=Purchase Order
TRD=Treasury Deal
TRE=Other Hedgeable Items
|
| 5 |
HDGD_ITM_FINANCIAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Is the hedged item/transaction a Financial Asset or Liability, or a non-financial Firm Commitment with Financial components?
(FAS133 paras 21(e-f) & 29(g-h))
N=Nonfinancial Item
Y=Financial Item
|
| 6 |
HEDGED_ITEM_PRTION |
Character(3) |
VARCHAR2(3) NOT NULL |
portion of the hedged item.
ALL=All
EO=Embedded Option/Cap/Floor
PC=Percentage
RVL=Residual Value in Lease
SCF=Selected Cash Flows
Default Value: ALL
|
| 7 |
HEDGED_ITEM_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Percentage of item hedged.
Default Value: 100
|
| 8 |
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
Prompt Table:
HDG_SRC_MTM_VW
|
| 9 |
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
|
| 10 |
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.
|
| 11 |
MTM_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
The stated currency for a deal transaction's fair value (mark-to-market)
Default Value: BUS_UNIT_TBL_GL.BASE_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 12 |
AMORT_CARRYAMT_ADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
P24:"An adjustment of the carrying amount of a ... shall be amortized to earnings"
If appropriate to do so, then adjustments of the carrying amount of the hedged item should be amortized to earnings, and this checkbox is selected.
Y/N Table Edit
Default Value: N
|
| 13 |
AMORT_BEGIN_DT |
Date(10) |
DATE |
Date on which amortization period begins.
|
| 14 |
AMORT_END_DT |
Date(10) |
DATE |
Date on which amortization period ends.
|
| 15 |
HDGD_ITEM_BEGIN_DT |
Date(10) |
DATE |
The timing for a Firm Commitment, or the start date for the period within which a forecasted transaction is expected to occur
|
| 16 |
HDGD_ITEM_END_DT |
Date(10) |
DATE |
The timing for a Firm Commitment, or the end date for the period within which a Forecasted Transaction is expected to occur, or the end date of a recognized asset or liability (settlement date)
|
| 17 |
HDGD_ITEM_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The fixed price for a Firm Commitment, or the expected currency amount of a forecasted transaction
|
| 18 |
HDGD_ITEM_AMT_CCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency of the hedged item.
Prompt Table:
CURRENCY_CD_TBL
|
| 19 |
HDGD_ITEM_QUANTITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity or expected quantity of the hedged item.
|
| 20 |
HDGD_ITEM_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Unit of Measure for field HDGD_ITEM_QUANTITY
Prompt Table:
UNITS_TBL
|
| 21 |
HDGD_ITEM_QTY_CCY |
Character(3) |
VARCHAR2(3) NOT NULL |
The currency of a hedged item's Face Value when it is a Financial item
Prompt Table:
CURRENCY_CD_TBL
|
| 22 |
HDGD_ITEM_DETAILS |
Character(254) |
VARCHAR2(254) NOT NULL |
Details of the hedged item.
|
| 23 |
HDG_ADDED_DT |
Date(10) |
DATE NOT NULL |
Date that a Hedging Deal or a Hedged Item was added to the Hedge relationship
Default Value: %date
|
| 24 |
HDG_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Operator that added a Hedging Deal or Hedged Item to a Hedge
|
| 25 |
HDG_REMOVED_DT |
Date(10) |
DATE |
Date that a Hedging Deal or a Hedged Item was removed from the Hedge relationship
|
| 26 |
HDG_REMOVED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Operator that removed a Hedging Deal or Hedged Item from a Hedge
|