|
SELECT business_unit , hedged_item_id , hedge_status , review_dt , hedged_item_type , hedged_item_status , hdgd_item_begin_dt , hdgd_item_end_dt , hdgd_item_amt , hdgd_item_amt_ccy , hdgd_item_quantity , hdgd_item_uom , hdg_risk_type , hdgd_item_details , descr60 , fx_denominated , hdgd_itm_financial FROM PS_HDG_EXPOSURE WHERE hedge_status = 'A' AND hdgd_itm_financial = 'Y' AND hedged_item_type = 'UFC' AND fx_denominated = 'Y'
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT_TRE |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit for Hedged Exposure of Last resort
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
BUS_UNIT_TBL_FS
|
| 2 |
HEDGED_ITEM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Hedged Item ID
Prompt Table:
HDG_EXPOSURE
|
| 3 |
HEDGE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Stores the Status of a FAS 133 hedge:
"A" Active,
"I" Discontinued (Inactive),
"O" Discontinued - Remaining AOCI requiring reclassification
A=Active
I=Discontinued
O=Discontinued - Remaining AOCI
Default Value: A
|
| 4 |
REVIEW_DT |
Date(10) |
DATE NOT NULL |
Review Date
|
| 5 |
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
|
| 6 |
HEDGED_ITEM_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
A FAS 133 hedged item starts life as type HEDGED_ITEM_TYPE, then after a period changes according to this field, HEGDED_ITEM_STATUS
CAL=Firm Commitment or Asset/Liab
CAN=Cancelled
FOT=Forecasted Transaction
NIF=Net Investment in a Foreign Op
NLP=No Longer Probable
RAL=Recognized Asset or Liability
UFC=Unrecognized Firm Commitment
|
| 7 |
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
|
| 8 |
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)
|
| 9 |
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
|
| 10 |
HDGD_ITEM_AMT_CCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency of the hedged item.
Prompt Table:
CURRENCY_CD_TBL
|
| 11 |
HDGD_ITEM_QUANTITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity or expected quantity of the hedged item.
|
| 12 |
HDGD_ITEM_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Unit of Measure for field HDGD_ITEM_QUANTITY
Prompt Table:
UNITS_TBL
|
| 13 |
HDG_RISK_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Type of Risk of Hedged item
Prompt Table:
HDG_EXP_RSK_DEF
|
| 14 |
HDGD_ITEM_DETAILS |
Character(254) |
VARCHAR2(254) NOT NULL |
Details of the hedged item.
|
| 15 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 16 |
FX_DENOMINATED |
Character(1) |
VARCHAR2(1) NOT NULL |
FX Denominated distinguishes hedged items in a FX hedge versus those in a non-FX hedge
Default Value: N
|
| 17 |
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
|