Note |
---|
This article assumes you are familiar with the entity elections that have been made for processing term loans. |
Add Term Loan Facilities
To manually add a term loan facility:
- In Accounting Center, in the left navigation pane, click Setup > Securities > Manage Securities > Issue Viewer.
You see the Issue Viewer tool. - Click the Add arrow.
- Point to Fixed Income and click Term Loans.
You see the Term Loans panel. - Complete the options on the Term Loans panel.
The following fields are required to set up a term loan: Issue Date, Issue Price, Maturity Date, and Maturity Price fields for the facility level security. Be sure to set the Processing Security Type field to DBAMTL, and set the Trading Flat field to Yes. - Click Submit.
Add Term Loan Contracts
Term loan contracts are used by the system to define multiple interest streams that make up a term loan facility. Contracts can have a fixed or variable rate.
To manually add a term loan contract:
- In Accounting Center, in the left navigation pane, click Setup > Securities > Manage Securities > Issue Viewer.
You see the Issue Viewer tool. - Click the Add arrow.
- Point to Fixed Income and click Term Loans.
You see the Term Loans panel. - Complete the options on the Term Loans panel.
The panel requires you to define all interest related fields, such as Coupon Type, Day Count Basis, Issue Date, Dated Date, First and Last Coupon Dates, and Maturity Date, as well as the Issue Price and Maturity Price fields. Be sure to set the Processing Security Type field to DBIBTL, and set the Trading Flat field to Yes. - Click Submit.
Change Term Loan Facilities
Some fields are locked when there is an existing position on the security. This is because a change would impact the existing position. These fields include Asset Currency, Dual Currency Indicator, Investment Type, Processing Security Type, Quantity Type, Price Multiplier, and Quantity Scale. Other fields are locked so they cannot be changed. See the About Locked Security Master Record Fields in Issue Viewer page for more information.
Note |
---|
If you need to change a security master record, Eagle recommends canceling the security, making changes to the security master record, and rebooking the security. |
To manually change a term loan facility:
- In Accounting Center, in the left navigation pane, click Setup > Securities > Manage Securities > Issue Viewer.
You see the Issue Viewer tool. - Enter the query parameters and click Search.
You see a list of security records that meet your selection criteria in the Query Result window. - Select the security record you want to update, click the Change arrow, and click Change Term Loans. Or double-click the security record.
You see the Change Term Loans panel. - Change the options on the Change Term Loans panel.
- Click Submit.
Change Term Loan Contracts
To manually change a term loan contract:
In Accounting Center, in the left navigation pane, click Setup > Securities > Manage Securities > Issue Viewer.
You see the Issue Viewer tool.- Enter the query parameters and click Search.
You see a list of security records that meet your selection criteria in the Query Result window. - Select the security record you want to update, click the Change arrow, and click Change Term Loans. Or double-click the security record.
You see the Change Term Loans panel. - Change the options on the Change Term Loans panel.
- Click Submit.
Term Loans Panel Options
The following are the options in the Term Loans panel. Note options may vary according to your selections.
Option | Tag | Description |
---|---|---|
SRM Status Flag | ||
Release Status | 614 | Displays the release status of the Security Reference Manager (SRM) record. This field is null when adding a new security. |
Authorize Flag | 11742 | Flags records that have been authorized. |
Validation Process Flag | 4569 | Flags records that have been reviewed in the Security Reference Manager (SRM). |
Long Term Debt Identification | ||
Issue Name | 961 | Specifies the name of the security. |
Issue Description | 962 | Describes the security. |
Ticker | 13 | Specifies the system of letters used to uniquely identify the security. |
CUSIP/SEDOL Check Digit Control Flag | 2292 | Indicates whether you want to generate or validate CUSIP and SEDOL numbers. Options include:
|
Primary Asset ID Type | 1432 | Specifies the primary asset identifier type for the security, such as CUSIP, ISIN, and SEDOL. |
Primary Asset ID | 14 | Specifies the primary asset identifier for the security. |
Alt Asset ID Type | 5501 | Specifies an alternate asset identifier type for the security. |
Alt Asset ID | 1795 | Specifies the alternate asset identifier for the security. |
Long Term Debt Xreference Identification | ||
CUSIP | 1952 | Specifies the Committee of Uniform Security Identification Procedure (CUSIP), a unique identification number that identifies the security issue. |
ISIN | 1955 | Specifies the International Security Identification (ISIN), a unique international identification number that identifies the security issue. |
Sedol | 1958 | Specifies the Stock Exchange Daily Official List (SEDOL) number, a unique identification number that identifies the security issue. |
Reuters | 1961 | Specifies the Reuters identification number that identifies the security issue. |
Bloomberg ID | 1964 | Specifies the Bloomberg identification number that identifies the security issue. |
SICOVM | 1967 | Specifies the SICOVM identification number that identifies the security issue. |
Valoren | 1970 | Specifies the Valoren identification number that identifies the security issue. |
CEDEL | 1973 | Specifies the Centrale de Livraison de Valuers Mobilieres (CEDEL) identification number that identifies the security issue. |
INTERNAL | 1976 | Specifies the internal identification number that identifies the security issue. |
CINS | 1979 | Specifies the CINS identification number that identifies a foreign security issue. The CINS numbering system is an extension of the CUSIP numbering system. |
Xref Exchange | 1981 | Specifies the exchange where the security is traded. |
Long Term Debt Details | ||
Investment Type | 11 | Displays the investment type, such as FI (fixed income). |
Processing Security Type | 3931 | Specifies the code value that the system uses to identify the type of security you are adding. Options include:
Additional options appear based on your selection. |
Security Type | 82 | Specifies the type of security. |
Sub Security Type | 1464 | Specifies the sub security type. |
Granularity Category | 11476 | Specifies the asset's classification for ledger granularity purposes. If the security attributes available for ledger granularity account breakouts (security type, long/short indicator, Federal tax indicator, market sector description, affiliated/unaffiliated, and issue country) do not provide enough detail, you can use a granularity category to classify the asset for ledger reporting. Code values are maintained under the GRANULARITY_CAT code category. |
Cost Basis Rule Type | 2817 | Specifies the cost basis rule type for cost basis reporting. |
Quantity Type | 12 | Specifies the quantity generally accepted as a standard for exchanges, such as shares and par. The system uses par as a default. |
Price Multiplier | 18 | Determines the price. For fixed income securities, the system defaults to .01, treating treat the price as a percentage (for example., a price of 100 is equal to 100%). You should not change this value once a position exists. |
Quantity Scale | 19 | Calculates the ratio of units bought to units used for earnings. The default is 1, so that 1 unit of par purchased equals one unit of earnings. You should not change this value once a position exists. |
Country of Risk | 2288 | Specifies the issuer of the security's principal place of business. |
Country of Risk Code | 10536 | Specifies the code of the issuer of the security's principal place of business. |
Issue Country | 2290 | Specifies the name of the country that issued the security. |
Issue Country Code | 1418 | Specifies the identification number that represents the country that issued the security. |
Dual Currency Indicator | 11802 | Indicates whether the security is a dual currency instrument. A dual currency instrument is a financial instrument based in one currency that makes payments of income and/or principal in a different currency. Options include:
|
Asset Currency | 85 | Specifies the currency in which the security is priced. You should not change this value once a position exists. For a dual currency instrument, the asset currency identified in this field is the base currency. |
Settlement Currency | 63 | Specifies the currency in which the security is settled. This field initially displays the value you specified for the Asset Currency field, but you can change it. |
Income Currency | 1186 | Specifies the currency in which the security pays income. This field displays the asset currency by default, but you can change it if you identify the security as a dual currency instrument. For a dual currency instrument, this value may be called the settlement currency. When the income currency differs from the asset currency for a dual currency instrument, the security accrues income in the asset currency but converts the local currency amounts to the income currency at the time the coupon is dropped based on the fixing parameters specified for the dual currency instrument. |
Issue Tax Type | 668 | Identifies the security's tax structure. It is used with global tax withholding and tax reclaim processing. NOTE: Do not select All when setting up the tax structure for a security using this panel. |
Primary Exchange | 2291 | Specifies the marketplace in which the security is traded. |
Primary Exchange Code | 17 | Specifies the code of the marketplace in which the security is traded. It is also used with global tax withholding and tax reclaim processing. |
Region | 5423 | Specifies a region. It does not necessarily mean the location of the exchange in which a security is traded. For example, suppose you have a Canadian bond that trades in the London Stock Exchange. You may want to set the region to Canada or North America. The values for this field are user defined. You can add values using the Codes workspace. |
State Code | 1343 | Specifies the state in which the security is issued. |
Amount Issued | 1537 | Specifies the amount of par original that has been issued by the issuer. |
Amount Outstanding | 1543 | Specifies the amount of par that has not been retired by the issuer. |
Muni Industry Classification | 3130 | Defines the type of issuance or type of municipal bond classification that was issued. |
SIC Code | 1789 | Specifies the Standard Industry Classification (SIC), a code used to categorize and uniquely identify business activities. |
Amortization Accretion Rule Type | 12008 | Specifies a list of valid amortization rule types. |
Demand Feature | 10555 | Specifies the demand feature. |
GL Product Code | 11094 | Specifies the GL product code. |
Long Term Debt Coupon Periods | ||
Coupon | 70 | Specifies the rate at which the security accrues interest. It is expressed as an accrual rate. A value of zero is required for zero coupon bonds. |
Coupon Type Code | 97 | Indicates the type of coupon associated with the security. Options include:
|
Day Count Basis | 471 | Specifies the number of days assumed in a month or year when interest rates are quoted. For more information, see the Fixed Income Processing Guide. |
Payment Frequency | 2287 | Specifies the frequency at which the security pays interest. NOTE: The first and last coupon date must be in sync with the payment frequency of the bond. |
Payment Frequency Code | 472 | Specifies the code that represents the payment frequency. |
Business Day Convention | 1536 | Determines when a coupon should pay interest should the scheduled coupon due date occur on a non business day. |
Business Calendar Name | 1480 | Specifies the business calendar for the security. The system uses the value to identify business days and non business days for the purposes of determining the coupon payment date and coupon payment schedules. |
Day of Month Override | 1533 | Identifies the day of the month or business day of the month on which the security is to pay income. This is based on the business calendar. |
Interest Payment Timing | 1523 | Determines the coupon date, when more than one possible set of coupon dates can be calculated. Options include:
If you do not enter a value, the system uses the last day of the month to calculate coupons. |
Delay Days | 1799 | Specifies the number of days between the end of the accrual period and the actual receipt of the coupon and principal payment. The system uses this value in the creation of coupons, paydown transactions, and payup transactions, as well as in the Cash Flow Projections report. |
Delay Days Type | 5074 | Indicates whether the delay days are business days or calendar days. Options include:
|
Coupon Delay Days | 4908 | Specifies the number of days to extend the coupon period. |
Coupon Delay Days Type | 3999 | Indicates whether the coupon delay days are business days or calendar days. Options include:
This field is not required for a term loan. |
Maturity Delay Days | 3997 | Specifies the number of days to delay generation of the maturity transaction. |
Maturity Delay Days Type | 3998 | Indicates whether the maturity delay days are business days or calendar days. Options include:
This field is not required for a term loan. |
Long Term Debt Dates | ||
Issue Price | 69 | Specifies the original issue price of the security. |
Issue Date | 68 | Specifies the original date of issue. |
Dated Date | 1183 | Specifies the date the security first begins to accrue interest. |
First Coupon Date | 473 | Specifies the date of the first coupon payment. The First Coupon Date, Last Coupon Date, and Payment Frequency fields are used to create a coupon schedule for the security, from issuance to maturity date. The coupon schedule consists of three coupon periods. The system uses the First Coupon Date, Payment Frequency, Timing of Payment, Day of Month Override, Business Day Convention, and Last Coupon Date fields in the earnings process to calculate the second coupon period (also referred to as the second to last period or penultimate). The system uses the Last Coupon Date and the Maturity Date fields in the earnings process to calculate the last coupon period. The last coupon period can be a long length coupon period, a short length coupon period, or a normal length coupon period. NOTE: The first and last coupon date must be in sync with the payment frequency of the bond. |
Last Coupon Date | 474 | Specifies the date of the last normal length coupon period. Eagle recommends that you enter penultimate. NOTE: The first and last coupon date must be in sync with the payment frequency of the bond. |
Maturity Date | 38 | Specifies the date that the security repays all outstanding principal and stops earning interest. |
Maturity Price | 42 | Specifies the price at which the security returns principal. For an interest only security, the value is zero. For the majority of other debt issues, this value is 100.00. |
Variable Rate Next Reset Date | 3006 | Specifies the date of the next rate reset for a security with a variable rate coupon type. |
Long Term Debt Flags | ||
Trading Flat | 3949 | Indicates whether the security is trading with or without interest. Options include:
NOTE: This field must be set to Yes, as term loans trade flat. |
OID Indicator | 218 | Indicates whether the security is OID (original issue discount) eligible. Options include:
|
Zero Coupon Indicator | 1300 | Indicates if a zero in the Coupon field represents a zero coupon bond. Options include:
|
Convertible Indicator | 1531 | Indicates whether the security is a convertible bond. Options include:
|
Call Flag | 1182 | Indicates whether the security has a call option. Options include:
NOTE: This field must be set to Yes to add a call corporate action. |
Put Flag | 1546 | Indicates whether the security has a put option. Options include:
NOTE: This field must be set to Yes to add a put corporate action. |
Sink Flag | 1780 | Indicates whether the security is eligible for sinking fund payments. Options include:
NOTE: This field must be set to Yes to add a sink schedule corporate action. |
Federal Tax Indicator | 1545 | Indicates whether the security has a U.S. Federal Tax Indicator. It is used in the SEC Yield calculation. Options include:
|
Refund Indicator | 3132 | Indicates whether the security is eligible for pre-refunding, an entire issue call, or a mandatory put. Options include:
|
Muni Funding Flag | 3131 | Indicates whether an interest bearing municipal security is eligible for pre-refunding. Options include:
|
Insured Flag | 3104 | Indicates whether a bond is insured from defaulting. Options include:
|
AMT Flag | 3113 | Indicates whether a bond is subject to the Alternative Minimum Tax (ATM) for individuals. Options include:
|
Default Indicator | 1551 | Indicates whether a bond is in default. Options include:
|
Default Date | 10142 | Specifies the date on which the bond went into default. |
IO/PO Flag | 10143 | This field identifies interest only (IO) and principal only (PO) mortgage strip securities. Options include:
|
PIK Flag | 1777 | Indicates whether the security is a PIK (payment in kind) bond. Options include:
NOTE: This field must be set to Yes to add a PIK bond corporate action. |
Restricted Flag | 1139 | Indicates any trade restrictions on the security. Options include:
|
Inactive Flag | 11043 | Indicates whether the security is inactive. Options include:
NOTE: If this field is set to Yes, no trades are allowed. |
Eusd Eligible | 11529 | Indicates whether the security is eligible for the tax equalization process. Options include:
|
Financial Innovation | 11530 | Indicates whether the security is eligible for the financial innovation process. Options include:
|
Govt Bond Flag | 10347 | Indicates whether the security is a government bond. Options include:
|
2a7 Flag | 11811 | Specifies 2a7 WAM processing. Options include:
|
Time Sensitive Indicator | 11926 | Specifies whether the security uses floating rate data that changes over time if you set the Coupon Type field to Floating Rate. Options include:
|
Synthetic Eligible | 12024 | Indicates whether the security is synthetic eligible. Options include:
|
Muni State Taxable Flag | 10248 | Indicates whether the security is subject to municipal state taxes. Options include:
|
144A Eligible Indicator | 1301 | Indicates whether the security is 144A eligible. Options include:
This field applies to debt instruments and is used for reference only. |
Private Registration | 10528 | Indicates whether the security is a private registration. Options include:
This field applies to debt instruments and is used for reference only. |
Minimum Piece | 1540 | Specifies the minimum original tradable amount. This field applies to debt instruments and is used for reference only. |
Private Placement | 1421 | Indicates whether the security is a private placement. Options include:
This field applies to debt instruments and is used for reference only. |
Look Thru Value | 1808 | Specifies the underlying security. |
Look Thru Ind | 1776 | Used to view exposure to the underlying security, index, or portfolio. |
Hybrid Flag | 2908 | Indicates whether the security is a hybrid. Options include:
|
SVO Category | 5856 | Specifies the Securities Valuation Office category for the security. |
SVO Subcategory | 5858 | Specifies the Securities Valuation Office subcategory for the security. |
Compound Information | ||
Compounding Indicator | 11875 | Specifies whether the security compounds unpaid interest. Options include:
If you set this field to Yes, the remaining compound information fields are required. |
Compounding Method | 11876 | Identifies the method used for compounding interest. Options include:
|
Compounding Frequency | 11877 | Specifies the frequency at which the security compounds interest. |
First Compounding Date | 11878 | Specifies the first date on which the compounding begins for the security. |
Last Compounding Date | 11879 | Specifies the end date on which the compounding begins for the security. |
Dual Currency Information | ||
Dual Currency Conversion Factor | 11803 | Specifies the initial FX rate at issuance used at issuance to convert the local currency for a dual currency instrument. Used for reference purposes only. This field appears if the Dual Currency Indicator field has a value of Yes. |
Principal Currency | 11813 | Specifies the currency in which the security pays principal for a dual currency instrument. This field displays the asset currency by default, but you can change it if you identify the security as a dual currency instrument. The principal currency matches either the asset currency or the income currency, allowing you to apply a single set of fixing parameters to the dual currency instrument. When the principal currency differs from the asset currency for a dual currency instrument, the security calculates principal in the asset currency but converts the local currency amounts to the principal currency at the time the maturity or corporate action is created. It bases the amount on the fixing parameters specified for the dual currency instrument. This field appears if the Dual Currency Indicator field has a value of Yes. |
Settlement Rate Option | 11816 | Specifies the FX rate source used to convert the local accrued amounts into the income and/or principal currency for the dual currency instrument. This conversion determines actual income and/or principal settlement amounts. The system uses this security level source rather than the accounting basis' FX source for the security. This field appears if the Dual Currency Indicator field has a value of Yes. NOTE: Although this value is an FX rate, you store it as an index because the to/from currencies are embedded and not provided. It accommodates multiple values that are common to a price. |
FX Rate Type | 11817 | Identifies the type of FX fixing rate the system uses from the Settlement Rate Option field for a dual currency instrument. This field appears if the Dual Currency Indicator field has a value of Yes. Options include:
|
FX Fixing Period Multiplier | 12027 | Specifies the multiplier for the time period or FX fixing period for a dual currency instrument. You can specify a positive number such as 1, 2, or 3, or can specify a negative number. This field appears if the Dual Currency Indicator field has a value of Yes. |
FX Fixing Period | 11818 | Identifies the time period used to calculate the fixing rate for a dual currency instrument. This field appears if the Dual Currency Indicator field has a value of Yes. Options include:
|
FX Fixing Period Date Type | 12028 | Specifies whether the fixing period for a dual currency instrument uses business days or calendar days. This field appears if the Dual Currency Indicator field has a value of Yes. Options include:
|
FX Fixing Business Day Convention | 12029 | Determines how to adjust the calendar date for the FX fixing date if the date would otherwise fall on a day that is not a business day based on the fixing day's calendar. This field appears if the Dual Currency Indicator field has a value of Yes. Options include:
|
FX Fixing Business Center | 12340 | Identifies the business calendar to use for the dual currency instrument's fixing period. This field appears if the Dual Currency field has a value of Yes and the FX Fixing Period Date Type field has a value of Business. |
FX Fixing Date Relative To | 12341 | Identifies the anchor dates for selecting the FX rates for a dual currency instrument. This field appears if the Dual Currency Indicator field has a value of Yes. Options include:
|
Issuer Information | ||
Credit Enhancement | 1532 | Indicates whether the security is credit enhanced. Options include:
|
Issuer ID Name | 2285 | Specifies the name of the issuer. |
Issuer ID | 1413 | Specifies the identifier of the company or municipality that offered the security for sale. |
Country of Incorporation Code | 1174 | Displays the ISO country code in which the issuer of the security was incorporated. |
Issuer Industry | 1417 | Specifies the industry of the issuer. |
Legal Entity Identifier (LEI) | 5089 | Displays the Legal Entity Identifier (LEI) that identifies the issuer as a financial party. If an LEI value is present, the Legal Entity Identifier Details section appears. |
Legal Entity Identifier Details | ||
Legal Name | 5090 | Displays the legal name of the issuer as the financial party registered with the LEI. |
Entity Status | 5091 | Displays the status of the issuer. For example, ACTIVE and INACTIVE. |
Legal Form | 5092 | Displays the legal form of the issuer as financial party registered with the LEI. For example, CORPORATION. |
Assigned Date | 5093 | Displays the date when the issuer's LEI was assigned. |
Last Update Date | 5094 | Displays the date when the issuer's LEI information was last updated. |
Disabled Date | 5095 | Displays the date when the issuer's LEI information was disabled. |
Record State | 5096 | Displays the record state for the issuer's LEI. The record state indicates the current process status of the CFTC Interim Compliant Identifier (CICI) record. For example, UNDER_REVIEW, DUPLICATE, CONFLICTING_SOURCES, INADEQUATE_SOURCES, VALIDATED, PENDING_REMOVAL. |
Certification State | 5097 | Displays the certification state used to register the issuer's LEI. For example, CERTIFIED, NOT_CERTIFIED, STALE. |
Street | 5098 | Displays the street address used to register the issuer's LEI. |
City | 5099 | Displays the city used to register the issuer's LEI. |
State | 5100 | Displays the state code used to register the issuer's LEI. |
Zip | 5180 | Displays the ZIP code used to register the issuer's LEI. |
Country Code | 5181 | Displays the country code used to register the issuer's LEI. |