| key |
id |
string(200)* |
= |
This is the unique identifier for the tranche. |
| timeline |
lastModifiedDate |
dateTime* |
=< >= |
This is the timestamp of the latest instrument update. |
|
accrualStartDate |
date |
|
This is accrual start date for the next pay date of the tranche. |
|
assetClass |
string(500) |
|
This field is to identify the classification of an instrument based on IHSM Standard. |
| link |
batch |
Batch* |
= |
The Batch in which the Instrument is calculated. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the Instrument data are published. |
|
bbgTicker |
string(50) |
|
This is an identifier issued by Bloomberg for the instrument. |
|
bbgUniqueId |
string(50) |
|
This is Bloomberg's unique identifier for the instrument. |
|
billingCode |
string(200) |
|
This field indicates the billing code of the security. It is used to determine the correct billing for the use of the security. |
|
businessDayConvention |
string(255) |
|
This is the Business/Calendar day’s convention applicable to interest & principal payment. |
|
componentBalances |
string(1000) |
|
This is the outstanding balance for each of the components in the deal. |
|
components |
string(255) |
|
These are the names of components which are part of the deal e.g. A1A, A1B, IA etc. |
|
creditSupportGroup |
string(255) |
|
This is the formula used to calculate current credit support associated with a Tranche e.g.( RESIDUAL + OC) / COLLAT. |
|
currency |
string(3) |
|
This is the dominant currency of the collateral in the deal. |
|
currentCreditEnhancement |
string(500) |
|
This is the formula used to calculate current credit support associated with a Tranche e.g.( RESIDUAL + OC) / COLLAT. |
| filter_list |
cusip |
string(9) |
= |
A CUSIP is a nine-character alphanumeric code that identifies a financial security for the purposes of facilitating clearing and settlement of trades. |
|
daycount |
string(255) |
|
The calculation method used to count the number of days spanning an accrual period, as well as the method used to count the number of days in a year. |
| link |
deal |
Deal* |
|
This is the unique id of the deal. |
|
figi |
string(50) |
|
This is a global identifier issued by Bloomberg for the instrument. |
|
firstPaymentDate |
date |
|
This is the first interest payment date of the tranche. |
|
floaterCap |
decimal |
|
If floating tranche, this field is the interest rate cap for the borrower’s interest rate. |
|
floaterFloor |
decimal |
|
If floating tranche, this field is the interest rate floor for the borrower’s interest rate. |
|
floaterFormula |
string(500) |
|
This is the formula used to calculate the rate of interest payment. |
|
floaterIndex |
string(255) |
|
This is the specific Index on which a floating coupon is calculated for a tranche. |
|
floaterSpread |
decimal |
|
This is the spread or Margin used in the calculation of the interest rate. |
|
groundGroup |
string(300) |
|
This is the collateral ground groups which make up a collateral group. |
|
hasNotionalBalance |
boolean |
|
This flag is indicating notional status on the basis of backed tranche. |
|
indexMultiplier |
decimal |
|
This is the ARM index rate coefficient. Defaulted to 0 if not explicitly set. |
|
isImpliedWriteDown |
boolean |
|
This flag is indicating if the tranche has an implied write down. |
|
isOriginallyFullyInsured |
boolean |
|
This flag is indicating if the tranche was fully insured at issuance. |
|
isTargetEnhance |
boolean |
|
This flag is indicating if the tranche has an option of target enhancement. |
| filter_list |
isin |
string(12) |
= |
A ISIN is a 12-character alphanumeric code that identifies a financial security for the purposes of facilitating clearing and settlement of trades. |
|
issueDate |
date |
|
This is the date on which tranche was issued. |
|
legalFinalMaturityDate |
date |
|
Legal final maturity date which is the latest possible under any circumstances payment date of the tranche; reported only when explicitly provided in the prospectus separately from Stated Maturity. |
|
monolineInsurerName |
string(255) |
|
Name of insurance company that provides guarantees to issuers, often in the form of credit wraps that enhance the credit of the issuer. |
|
optionalRedemptionDate |
date |
|
The date after which a deal can be called as per an optional termination covenant |
|
optionalRedemptionFraction |
decimal |
|
The deal size fraction below which a deal can be called as per an optional termination covenant. |
|
optionalTerminationFlag |
boolean |
|
A flag indicating if the deal has an optional redemption covenant. |
|
originalCreditEnhancement |
decimal |
|
This is the percentage of credit support for the tranche at issuance. |
|
originalNotionalBalance |
decimal |
|
This is the notional balance of the tranche at issuance. |
|
originalPariPassuBalance |
decimal |
|
This is the combined principal balance at issuance of all tranches pari-passu with the specified tranche. |
|
originalSeniorBalance |
decimal |
|
This is the combined principal balance at issuance of all tranches senior to the specified tranche. |
|
originalSubordinate |
decimal |
|
This is the combined principal balance at issuance of all tranches subordinate to the specified tranche. |
|
originalSupport |
decimal |
|
This is the percentage of credit support for the tranche at issuance. |
|
originalSupportAmount |
decimal |
|
This is the amount of credit support for the tranche at issuance. |
|
originalSupportBasis |
decimal |
|
Credit support basis amount indicates the total amount from which the credit support is to be drawn for a tranche. |
|
originalTrancheBalance |
decimal |
|
This is the original tranche balance at issuance. |
|
paymentDelay |
long |
|
These are the points to an array which contains the interest delay days for each tranche. |
|
prospectusGroup |
string(300) |
|
This is a structural group that backs a specific bond. |
|
ratings |
InstrumentRating[1000] |
|
This is an unique id for instrument rating. |
|
repaymentDate |
date |
|
This is the currently anticipated repayment date. |
|
securityAbbreviation |
string(255) |
|
This is a short description of the security. |
|
securityDescription |
string(255) |
|
This is a detailed description of the security. |
|
securityStatus |
string(200) |
|
This is the status of the security at deal level. |
|
source |
string(30) |
|
This is the source from which the Instrument record was last updated. |
|
statedFinalMaturityDate |
date |
|
This is the stated maturity date which is the latest expected payment date of the tranche as stated by the issuer, usually calculated based on 0CPR/0CDR scenario. |
|
supportGroupNumber |
decimal |
|
The percentage of credit support for the tranche at issuance. |
|
tranche |
string(255) |
|
This is the name of bond class. |
|
trancheFrequency |
string(200) |
|
This is the interest payment frequency for the specific tranche. |
|
trancheStatus |
string(100) |
|
This is the status of the security at tranche/instrument level. |
|
trancheType |
string(255) |
|
This is the description of the tranche. |
|
tranchesSupported |
string(500) |
|
This is the name of senior bond classes which are supported by subordinate bonds. |