| key |
id |
string(200)* |
= |
This is the unique identifier for the tranche. |
| timeline |
lastModifiedDate |
dateTime* |
=< >= |
This is the timestamp of the latest instrument update. |
|
accrualConvention |
string(50) |
|
This field indicates if Instrument accrual days are Hardcoded or not. |
|
accrualStartDate |
date |
|
This is accrual start date for the next pay date of the tranche. |
|
accrualStartDay |
long |
|
This is the calendar day of payment month. |
|
amortFlag |
boolean |
|
This field indicates if a security has a feature of pre decided amortization schedule. |
|
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. |
|
bloombergMarketSectorDescription |
string(100) |
|
Market Sector description from Bloomberg. |
|
bloombergSecurityType |
string(50) |
|
Bloomberg-generated type of security. |
|
bloombergSecurityType2 |
string(50) |
|
Bloomberg-generated alternative security type. |
|
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. |
|
couponDatedDate |
date |
|
This field defines first accrual start date |
|
couponSubType |
string(200) |
|
This field further defines the coupon type of the instrument, used in conjunction with coupon type for example Floating: Floating then Fixed etc. |
|
couponType |
string(100) |
|
This field defines the coupon type of the instrument for example FIX, FLT, VAR etc. |
|
createdDate |
dateTime |
|
Field to indicate the date when first data leg was inserted. |
|
creditSupportGroup |
string(255) |
|
This is the formula used to calculate current credit support associated with a Tranche e.g.( RESIDUAL + OC) / COLLAT. |
| filter_list |
currency |
string(3) |
= |
This is the dominant currency of the collateral in the deal. |
|
currentAccrualEndDate |
date |
|
This is the current accrual end date. |
|
currentAccrualStartDate |
date |
|
This is the current accrual start date. |
|
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. |
|
determinationDay |
long |
|
This is the determination day for CMBS Instruments. |
|
determinationDelay |
long |
|
This is the determination delay for CMBS Instruments. |
|
distributionDay |
long |
|
This is the distribution day for CMBS Instruments. |
|
factorableFlag |
boolean |
|
This field indicates if a security has a feature of paying down or capitalizing on factor basis. |
|
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. |
|
floaterCapDetails |
string(200) |
|
If floating tranche, this field is the interest rate cap for the borrower's interest rate with multiple trigger values. |
|
floaterFloor |
decimal |
|
If floating tranche, this field is the interest rate floor for the borrower’s interest rate. |
|
floaterFloorDetails |
string(200) |
|
If floating tranche, this field is the interest rate floor for the borrower's interest rate with multiple trigger values. |
|
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. |
|
floaterSpreadDetails |
string(200) |
|
This is the spread or margin field used in the calculation of the interest rate with multiple trigger values. |
|
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. |
|
indexMultiplierDetails |
string(200) |
|
This is the ARM index rate coefficient field with multiple trigger values. |
|
isExchangeable |
boolean |
|
This flag indicates whether the instrument is exchangeable or not. |
|
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. |
|
margin |
decimal |
|
The spread used in the calculation of the interest. |
|
marginDetails |
string(200) |
|
The spread used in the calculation of the interest with multiple trigger values. |
|
maturityDate |
date |
|
This field indicates maximum date between legal maturity date and stated maturity date. If both are not available then expected collateral termination date. |
|
maturityType |
string(50) |
|
Type of the maturity date like LegalFinal, StatedFinal etc. |
|
maturityYears |
string(20) |
|
This field indicates the maturity years of potential pools for TBA securities like 10,15,30 years etc. |
|
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. |
|
mortgageType |
string(100) |
|
This field indicates the mortgage type of TBA securities like UMBS, GNMA I etc. |
|
notionalStatus |
string(20) |
|
This field describes the notional status of the security like mix, pure. |
|
optionalRedemptionCondition |
string(500) |
|
The date or deal size fraction after which a deal can be called as per an optional termination covenant with multiple trigger values. |
|
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. |
|
principalPaymentFrequency |
string(200) |
|
This is the principal payment frequency for the specific tranche. |
|
product |
string(255) |
|
This field indicates the product type of TBA securities like Single Family Mortgage, Balloon etc. |
|
prospectusGroup |
string(300) |
|
This is a structural group that backs a specific bond. |
|
ratingCategory |
string(10) |
|
This field defines the rating category for example IG, HY, Split and Unrated. |
|
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. |
|
seniority |
string(30) |
|
This field defines the ranking structure of the instrument for payment. |
|
series |
string(50) |
|
Additional text about the security to represent series of the deal for example 2022-1, 2022-A, IV etc. from Bloomberg. |
|
settlementMonth |
string(20) |
|
This is the month when seller delivers pools for TBA securities to seller like January, March etc. |
|
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. |
| filter_list |
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. |