HDG_SRC_MTM_TBL(SQL Table) |
Index Back |
|---|---|
Hedge Source MTM Table"Mark to Market" methods for hedged items from a given source. For Fair Value hedges, this is how to compute the fair value of the item. For Cash Flow hedges, this is how to compute the cumulative cashflows for the item. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | 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 |
| 3 | HEDGE_TYPE_133 |
Character(3) | VARCHAR2(3) NOT NULL |
Hedge type when FAS 133 is applied.
CF=Cash Flow Hedge FV=Fair Value Hedge XAS=FX FV of Available-for-Sale XCF=FX Cash Flow Hedge XFC=FX FV of Firm Commitment XNI=FX Hedge of Net Investment |
| 4 | 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 |
| 5 | 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 |
| 6 | MTM_VENDOR_NM | Character(20) | VARCHAR2(20) NOT NULL |
3rd party analytics vendor used for valuation and analytics.
Prompt Table: MTM_VEND_FNC_VW |
| 7 | MTM_PROGRAM_NM | Character(30) | VARCHAR2(30) NOT NULL |
MTM Valuation/Analytic processing program
Prompt Table: MTM_PROG_DEFN |