Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 15 Current »

In the Term Loans panel, you can manually add and change a term loan facility and one or more term loan contracts. A term loan facility is a package of different bank loans upon which a single borrower can draw, as per the terms and conditions stated in a lending agreement signed by and between one or more banks and the borrower. Many lenders often participate in term loans and share the risks and returns, and the interest and principal proportional to their participation. This process is called syndication. Term loans are also referred to as bank loans. When you add a term loan, you create a term loan facility and link it with one or more term loan contracts.

Term loan facilities trade flat on the open market. That is, no traded interest is included on the trade. The traded interest, which is normally paid by the buyer to the seller, is received by the seller from the issuer/administrative agent on the next coupon date for each underlying interest stream of the term loan facility.

On this page

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:

  1. In Accounting Center, in the left navigation pane, click Setup Securities > Manage Securities > Issue Viewer.
    You see the Issue Viewer tool.
  2. Click the Add arrow.
  3. Point to Fixed Income and click Term Loans.
    You see the Term Loans panel.
  4. 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.
  5. 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:

  1. In Accounting Center, in the left navigation pane, click Setup Securities > Manage Securities > Issue Viewer.
    You see the Issue Viewer tool. 
  2. Click the Add arrow.
  3. Point to Fixed Income and click Term Loans.
    You see the Term Loans panel.
  4. 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.
  5. 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.

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:

  1. In Accounting Center, in the left navigation pane, click Setup Securities > Manage Securities > Issue Viewer.
    You see the Issue Viewer tool.
  2. Enter the query parameters and click Search.
    You see a list of security records that meet your selection criteria in the Query Result window.
  3. 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.
  4. Change the options on the Change Term Loans panel.
  5. Click Submit.

Change Term Loan Contracts

To manually change a term loan contract:

  1. In Accounting Center, in the left navigation pane, click Setup Securities > Manage Securities > Issue Viewer.
    You see the Issue Viewer tool.

  2. Enter the query parameters and click Search.
    You see a list of security records that meet your selection criteria in the Query Result window.
  3. 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.
  4. Change the options on the Change Term Loans panel.
  5. 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:

  • Generate Check Digit. Generates the remaining numbers if you enter part of the CUSIP or SEDOL number.
  • Validate Check Digit. Validates the CUSIP and SEDOL number you enter is correct.

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.

Cash Matching ID

1973

Identifies the security issue for use in cash matching when you use cash segregation. If you set up security cross reference identifiers of CMM for use with cash matching, you can provide a Cash Matching ID for each security you plan to use in cash matching.

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:

  • DBAMTL. Facility Term Loans.
  • DBIBTL. Contract Term Loans.

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:

  • Yes. Indicates that the security is a dual currency instrument. If you select Yes, you can specify an income currency and/or principal currency that differs from the asset currency. Also, additional fields in the Dual Currency Information section become available. These fixing parameters provide criteria used to retrieve the appropriate FX rate, or fixing rate, at which the dual currency instrument income and/or principal payment is converted.
  • No. Default. Indicates that the security is not a dual currency instrument.

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:

  • Floating Rate. The security has fixed coupon dates and uses a variable rate that is based on an underlying index and index offset to calculate the coupon to use for earnings. You must enter the rate in the Variable Rate table. 
  • Variable Rate. The security has fixed coupon dates and uses a variable rate based on the security identifier to calculate the coupon for use in earnings. You must enter the rate in the Variable Rate table.
  • Inverse Floater. The security has fixed coupon dates and uses a variable rate whose coupon rate is calculated inversely to the underlying index to which it is attached. When you select this value, the system displays the following fields: Inverse Floater Rate, Inverse Floater Multiple, Underlying Issue Name, Underlying Asset ID, and Index Offset. You must enter the rate in the Variable Rate table. 
  • Step Rate. The security has fixed coupon dates and uses a variable rate based on the security identifier to calculate the coupon for use in earnings. You must enter the rate in the Variable Rate table. The system recognizes this option as a step bond (also called a step coupon bond, step up bond, or step down bond). 
  • Fixed Rate. The security has fixed coupon dates and has a fixed coupon rate to calculate the coupon for use in earnings.
  • Unscheduled Variable Rate. The security has unscheduled payments and accrues interest based on a rate you enter in the Variable Rate table. 

Day Count Basis

471

Specifies the number of days assumed in a month or year when interest rates are quoted. For more information, see About Day Count Basis.

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:

  • Last Day of Month
  • Same Day of Month
  • None

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. Utilizes the Day Count Basis (tag 471) value to determine the actual receipts and settlements of the paydown and payup transactions.

Delay Days Type

5074

Indicates whether the delay days are business days or calendar days. Options include:

  • B (Business). Uses business days to identify delay days. The Business Calendar Name field (tag 1480) identifies the security's business calendar.
  • C (Calendar). Uses calendar days to identify delay days.

Coupon Delay Days

4908

Specifies the number of days to extend the coupon period.
This field is not required for a term loan.

Coupon Delay Days Type

3999

Indicates whether the coupon delay days are business days or calendar days. Options include:

  • B (Business). Uses business days to identify coupon delay days. The Business Calendar Name field (tag 1480) identifies the security's business calendar.
  • C (Calendar). Uses calendar days to identify coupon delay days.

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.
This field is not required for a term loan.

Maturity Delay Days Type

3998

Indicates whether the maturity delay days are business days or calendar days. Options include:

  • B (Business). Uses business days to identify maturity delay days. The Business Calendar Name field (tag 1480) identifies the security's business calendar.
  • C (Calendar). Uses calendar days to identify maturity delay days.

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.
The system uses this date to calculate the adjusted issue price for OID (original issue discount) amortization. If the instrument is OID eligible and it has a variable rate or floating rate, the rate must exist as of the issue date, so that the system can calculate the adjusted issue price.

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 Dated Date and the First Coupon Date fields in the earnings process to calculate the first coupon period. The first coupon period can be a long length coupon period, a short length coupon period, or a normal length coupon period.

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:

  • Yes. The system does not calculate accrued interest purchased or sold at the time of the acquisition or disposition. In the event of a disposition mid-coupon, the system creates a coupon at the end of the coupon period based on the interest earned during the period.
  • No. The system calculates accrued interest purchased or sold at the time of the acquisition or disposition.

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:

  • Yes. The security is OID eligible. For this flag to be set to Yes, the issue price must be less than the value in the Maturity Price field. The value in the Maturity Price field cannot be 0.
  • No. The security is not OID eligible.

Zero Coupon Indicator

1300

Indicates if a zero in the Coupon field represents a zero coupon bond. Options include:

  • Yes. The zero represents a zero coupon bond.
  • No. The zero does not represent a zero coupon bond.

Convertible Indicator

1531

Indicates whether the security is a convertible bond. Options include:

  • Yes. The security is a convertible bond. You must set up underlying security information by specifying a value in the Underlying Issue Name and Underlying Asset ID fields.
  • No. The security is not a convertible bond. The system does not allow you to set up the underlying security information.

Call Flag

1182

Indicates whether the security has a call option. Options include:

  • Yes. The security has a call option. You need to add call information for the security so that the system can calculate the yield for the security during the earnings process. 
  • No. The security does not have a call option.

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:

  • Yes. The security has a put option. You need to add put information for the security so that the system can calculate the yield for the security during the earnings process. 
  • No. The security does not have a put option.

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:

  • Yes. The security is eligible for sinking fund payments. You need to add sink information for the security so that the system can calculate the yield for the security during the earnings process. 
  • No. The security is not eligible for sinking fund payments.

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:

  • Yes. The security has a U.S. Federal Tax Indicator.
  • No. The security does not have a U.S. Federal Tax Indicator.

Refund Indicator

3132

Indicates whether the security is eligible for pre-refunding, an entire issue call, or a mandatory put. Options include:

  • None. Not applicable.
  • Pre-Refunded. The security is eligible for pre-refunding.
  • Entire Issue Call. The call option for the security applies to the entire issue.
  • Mandatory Put. The put option for the security is mandatory.

Muni Funding Flag

3131

Indicates whether an interest bearing municipal security is eligible for pre-refunding. Options include:

  • Yes. The municipal security is eligible for pre-refunding.
  • No. The municipal security is not eligible for pre-refunding.

Insured Flag

3104

Indicates whether a bond is insured from defaulting. Options include:

  • Yes. The bond is insured.
  • No. The bond is not insured.

AMT Flag

3113

Indicates whether a bond is subject to the Alternative Minimum Tax (ATM) for individuals. Options include:

  • Yes. The bond is subject to the Alternative Minimum Tax (ATM) for individuals.
  • No. The bond is not subject to the Alternative Minimum Tax (ATM) for individuals.

Default Indicator

1551

Indicates whether a bond is in default. Options include:

  • Yes. The bond is in default. The system does not process the maturity transaction of the bond at the time of maturity.
  • No. The bond is not in default. The system processes the maturity transaction on the Maturity Date of the bond.

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:

  • IO. Interest only.
  • PO. Principal only.
  • No. No interest or principal.

PIK Flag

1777

Indicates whether the security is a PIK (payment in kind) bond. Options include:

  • Yes. The security is a PIK.
  • No. The security is not a PIK.

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:

  • 144A. An SEC rule modifying a two year holding period requirement on privately placed securities to permit qualified institutional buyers to trade the positions among themselves.
  • Reg S. Various SEC rules relating to offers and sales made outside the U.S. without SEC Registration.
  • Reg D. An SEC regulation governing private placement exemptions. This rule allows some companies to raise capital through the sale of equity or debt securities without having to register the securities with the SEC.
  • Private Placement. The raising of capital using private rather than public placement. The result is the sale of securities to a relatively small number of investors.
  • 4(2) Paper
  • Other
  • None

Inactive Flag

11043

Indicates whether the security is inactive. Options include:

  • Yes. The system reports the security as inactive.
  • No. The system reports the security as active.

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:

  • Yes
  • No

Financial Innovation

11530

Indicates whether the security is eligible for the financial innovation process. Options include:

  • Yes
  • No

Govt Bond Flag

10347

Indicates whether the security is a government bond. Options include:

  • U.S. Government
  • None

2a7 Flag

11811

Specifies 2a7 WAM processing. Options include:

  • Adjustable Rate Government Security
  • Floating Rate Government Security
  • Short Term Variable Rate Security
  • Long Term Variable Rate Security
  • Short Term Floating Rate Security
  • Long Term Floating Rate Security
  • Repurchase Agreement
  • Portfolio Lending Agreement
  • Money Market Fund Security
  • None

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:

  • Yes. The security uses time sensitive information defined using SMF earnings time periods.
  • No. Time-sensitive floating rate information does not apply to the security.

Synthetic Eligible

12024

Indicates whether the security is synthetic eligible. Options include:

  • Yes
  • No

Muni State Taxable Flag

10248

Indicates whether the security is subject to municipal state taxes. Options include:

  • Yes
  • No

144A Eligible Indicator

1301

Indicates whether the security is 144A eligible. Options include:

  • Yes
  • No

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:

  • Yes
  • No

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:

  • Yes
  • No

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:

  • Yes
  • No

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:

  • Yes
  • No

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:

  • All. The index offset for floating rate securities is included in the compound interest calculation.
  • Flat. The index offset for floating rate securities is not included in the compound interest calculation.

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:

  • Ask
  • Bid
  • Last

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:

  • Day
  • Month
  • Week
  • Year

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:

  • B (Business). The fixing period uses business days when determining which date to select. The FX Fixing Business Center field identifies the business calendar to use for the security's fixing period.
  • C (Calendar). The fixing period uses all calendar days when determining which date to select. This field displays a value of C if you set the FX Fixing Period to Month, Week, or Year.

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:

  • Following. Adjusts the calendar date for the FX fixing date to the following business day if the date would otherwise fall on a day that is not a business day. You can select this value if the FX Fixing Period Date Type has a value of Calendar.
  • None. No calendar date adjustment occurs. If the FX Fixing Period Date Type has a value of Business, this field displays a value of None. If the FX Fixing Period Date Type has a value of Calendar, do not select a value of None.
  • Preceding. Adjusts the calendar date for the FX fixing date to the preceding business day if the date would otherwise fall on a day that is not a business day. You can select this value if the FX Fixing Period Date Type has a value of Calendar.

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:

  • Calculation End Date
  • Payment Date

Issuer Information



Credit Enhancement

1532

Indicates whether the security is credit enhanced. Options include:

  • Yes
  • None

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.

  • No labels