RUN_CNTL_HDG_HG

(SQL Table)
Index Back

Run Control for Debt/Inv

Deals by Counterparty - Transaction Date

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_TRD_NONVW

4 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
5 HEDGE_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Hedge, either: FAS 133, IAS39, or Economic/Other
133=FAS 133 Hedge
39=IAS39 Hedge
OTH=Economic / Other Hedge
6 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