| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 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 |
PROMPT_TBL |
Character(15) |
VARCHAR2(15) NOT NULL |
Prompt Table
Prompt Table:
TR_PSRECDEFN_VW
|
| 6 |
HEDGED_ITEM_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
The type of FAS 133 Hedged item.
Either an Unrecognized Firm Commitment, a Recognized Asset or Liability, or a Forecasted Transaction.
A hedged item STARTS as one of these, and then changes according to HEDGED_ITEM_STATUS
FOT=Forecasted Transaction
NIF=Net Investment in a Foreign Op
RAL=Recognized Asset or Liability
UFC=Unrecognized Firm Commitment
|
| 7 |
MTM_EXCL_VAL_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
A code that selects what processing and label the user wants to appear against field MTM_EXCL_VALUE on the Deal Analytics page.
1st char is either "C" display Cumulative adjustment amounts (like Amortized Cost), or "P" display Period by period adjustment amounts (FAS133 derivatives)
Next 3 chars are the LABEL_ID of one of MTM_EXCL_VALUE's labels.
CAC=Cumulative Amortized Cost
CFVA=Cumulative Fair Value
PFVA=Per Period Fair Value
Default Value: PFVA
|