Manage Schedule DB Hedge Descriptions
- Maria Drewnowski
- Nancy Cohn (Deactivated)
You can “write in” various values related to hedging descriptions on the Schedule DB reports: Schedule DB Part A Section 1 and 2 (DBA1, DBA2) and Schedule DB Part B Section 1 and 2 (DBB1, DBB2).
To support these columns, there are tables in the ISTAR Database Schema along with a selection of panels to input the hedge descriptions at an asset level by SVO Company Code. The asset level descriptions can differ by long/short indicator and derivative election. After you add descriptions to these tables using the Create DB Hedge Description and Create Footnote Hedge Code panels, you only need to run the report to see the changes take effect on the Schedule DB reports.
The Create DB Hedge Description panels add the description information for each asset at the SVO Company level. Before you use the Create DB Hedge Description panels to add the asset level information, you use the Create Footnote Hedge Code panel if you are going to use values other than the default Type of Risk values and to add hedge code values for Footnote B. This allows the dynamic lookups in the Create DB Hedge Description to then pick up any Type of Risk (footnote A) values equal to Other, or pick up Hedge Code (footnote B) values added using the Footnote Hedge Code panel.
The following table illustrates the corresponding report columns that the Create DB Hedge Description panel fields update when submitted.
Create DB Hedge Description Panel Field | Corresponding Report Column |
|---|---|
Item Hedged Desc Manual Entry (tag 1019) or NOTE: When updating using a batch uploader, use tag 8792. |
|
Hedge Sched Line Code (tag 8792) |
|
Type of Risk (tag 8804) NOTE: When updating using a batch uploader, use tag 8793. |
|
Hedge Footnote (tag 1021) NOTE: When updating using a batch uploader, use tag 8794. |
|