RUN_CNTL_HDG_HG(SQL Table) |
Index Back |
---|---|
Run Control for Debt/InvDeals by Counterparty - Transaction Date |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
2 | 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 |