| key |
id |
string(200)* |
= |
The unique identifier for the tranche. |
| timeline |
lastModifiedDate |
dateTime* |
=< >= |
The timestamp of the latest instrument update. |
|
accrualConvention |
string(50) |
|
Indicates if instrument accrual days are hardcoded or not. |
|
accrualStartDate |
date |
|
Accrual start date for the next pay date of the tranche. |
|
accrualStartDay |
long |
|
The calendar day of payment month. |
|
amortFlag |
boolean |
|
Indicates if a security has a feature of pre decided amortization schedule. |
|
assetClass |
string(500) |
|
The classification of an instrument. |
| link |
batch |
Batch* |
= |
The batch in which the instrument data are published. |
| link |
batchRun |
BatchRun* |
= |
The batchRun in which the instrument data are published. |
|
bbgTicker |
string(50) |
|
Bloomberg ticker is a string of characters or numbers to identify a company or entity uniquely by Bloomberg. |
|
bbgUniqueId |
string(50) |
|
Bloomberg's unique identifier for the instrument. |
|
billingCode |
string(200) |
|
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) |
|
The business or calendar days convention applicable to interest & principal payment. |
|
capitalizedDeferredInterest |
boolean |
|
Indicates if a security unpaid interest is added to the principal balance instead of being paid in cash. [Magnitude: $] |
|
componentBalances |
string(1000) |
|
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 |
|
The first accrual start date |
|
couponSubType |
string(200) |
|
The coupon sub type of the instrument, used in conjunction with coupon type for example Floating: Floating then Fixed etc. |
|
couponType |
string(100) |
|
The coupon type of the instrument for example FIX, FLT, VAR etc. |
|
createdDate |
dateTime |
|
The date and time when first data leg was inserted. |
|
creditSupportGroup |
string(255) |
|
The formula used to calculate current credit support associated with a tranche e.g.( Residual + Overcollateralization) / Collateral). |
| filter_list |
currency |
string(3) |
= |
The dominant currency of the collateral in the deal. Follows ISO 4217 code. |
|
currentAccrualEndDate |
date |
|
The current accrual end date. |
|
currentAccrualStartDate |
date |
|
The current accrual start date. |
|
currentCreditEnhancement |
string(1000) |
|
The formula used to calculate current credit support associated with a tranche e.g.( Residual + Overcollateralization) / Collateral). |
| filter_list |
cusip |
string(9) |
= |
A Committee on Uniform Securities Identification Procedures (CUSIP) value 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* |
= |
The unique identifier of deal. |
|
determinationDay |
long |
|
The determination day for Commercial Mortgage-Backed Securities (CMBS) instruments. |
|
determinationDelay |
long |
|
The determination delay for Commercial Mortgage-Backed Securities (CMBS) instruments. |
|
distributionDay |
long |
|
The distribution day for Commercial Mortgage-Backed Securities (CMBS) instruments. |
|
factorableFlag |
boolean |
|
Indicates if a security has a feature of paying down or capitalizing on factor basis. |
|
figi |
string(50) |
|
A global identifier issued by Bloomberg for the instrument. |
|
firstPaymentDate |
date |
|
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. [Magnitude: %] |
|
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. [Magnitude: %] |
|
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) |
|
The formula used to calculate the rate of interest payment. |
|
floaterIndex |
string(255) |
|
The specific index on which a floating coupon is calculated for a tranche. |
|
floaterSpread |
decimal |
|
The spread or margin used in the calculation of the interest rate. [Magnitude: b.p] |
|
floaterSpreadDetails |
string(200) |
|
The spread or margin field used in the calculation of the interest rate with multiple trigger values. |
|
groundGroup |
string(300) |
|
The collateral ground groups which make up a collateral group. |
|
hasNotionalBalance |
boolean |
|
Indicates notional status on the basis of backed tranche. |
|
indexMultiplier |
decimal |
|
The Adjustable-Rate Mortgage (ARM) index rate coefficient. Defaulted to 0 if not explicitly set. [Magnitude: x] |
|
indexMultiplierDetails |
string(200) |
|
The Adjustable-Rate Mortgage (ARM) index rate coefficient field with multiple trigger values. |
|
isExchangeable |
boolean |
|
Indicates whether the instrument is exchangeable or not. |
|
isImpliedWriteDown |
boolean |
|
Indicates that the tranche has an implied write-down. |
|
isOriginallyFullyInsured |
boolean |
|
Indicates that the tranche was fully insured at issuance. |
|
isTargetEnhance |
boolean |
|
Indicates that the tranche has an option of target enhancement. |
| filter_list |
isin |
string(12) |
= |
An International Securities Identification Number (ISIN) value is a 12-character alphanumeric code that identifies a financial security for the purposes of facilitating clearing and settlement of trades. |
|
issueDate |
date |
|
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. [Magnitude: b.p] |
|
marginDetails |
string(200) |
|
The spread used in the calculation of the interest with multiple trigger values. |
|
maturityDate |
date |
|
The 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. The expected values are LegalFinal, StatedFinal and CollateralTermination |
|
maturityYears |
string(20) |
|
The maturity years of potential pools for To-Be-Announced (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) |
|
The mortgage type of To-Be-Announced (TBA) securities like UMBS (Uniform Mortgage-Backed Securities), GNMA I (Ginnie Mae I), etc. |
|
notionalStatus |
string(20) |
|
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. [Magnitude: x] |
|
optionalTerminationFlag |
boolean |
|
A flag indicating if the deal has an optional redemption covenant. |
|
originalCreditEnhancement |
decimal |
|
The percentage of credit support for the tranche at issuance. [Magnitude: %] |
|
originalNotionalBalance |
decimal |
|
The notional balance of the tranche at issuance. [Magnitude: $] |
|
originalPariPassuBalance |
decimal |
|
The combined principal balance at issuance of all tranches pari-passu with the specified tranche. [Magnitude: $] |
|
originalSeniorBalance |
decimal |
|
The combined principal balance at issuance of all tranches senior to the specified tranche. [Magnitude: $] |
|
originalSubordinate |
decimal |
|
The combined principal balance at issuance of all tranches subordinate to the specified tranche. [Magnitude: $] |
|
originalSupport |
decimal |
|
The percentage of credit support for the tranche at issuance. [Magnitude: %] |
|
originalSupportAmount |
decimal |
|
The amount of credit support for the tranche at issuance. [Magnitude: $] |
|
originalSupportBasis |
decimal |
|
The total amount from which the credit support is to be drawn for a tranche. [Magnitude: $] |
|
originalTrancheBalance |
decimal |
|
The original tranche balance at issuance. [Magnitude: $] |
|
paymentDelay |
long |
|
These are the points to an array which contains the interest delay days for each tranche. [Magnitude: days] |
|
principalPaymentFrequency |
string(200) |
|
The principal payment frequency for the specific tranche. |
|
product |
string(255) |
|
The product type of To-Be-Announced (TBA) securities like single family mortgage, balloon etc. |
|
prospectusGroup |
string(300) |
|
A structural group that backs a specific bond. |
|
ratingCategory |
string(10) |
|
Defines the rating category of the instrument The expected values are: IG (Investment Grade), HY (High Yield), Split and Unrated. |
|
ratings |
InstrumentRating[1000] |
|
An unique id for instrument rating. |
|
repaymentDate |
date |
|
The currently anticipated repayment date. |
|
securityAbbreviation |
string(255) |
|
A short description of the security. |
|
securityDescription |
string(255) |
|
A detailed description of the security. |
|
securityStatus |
string(200) |
|
The status of the security at deal level. |
|
seniority |
string(30) |
|
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) |
|
The month when seller delivers pools for To-Be-Announced (TBA) securities to seller like January, March etc. |
|
source |
string(30) |
|
The source from which the instrument record was last updated. |
|
statedFinalMaturityDate |
date |
|
The stated maturity date which is the latest expected payment date of the tranche as stated by the issuer, usually calculated based on 0CPR (zero Constant Prepayment Rate) or 0CDR (zero Constant Default Rate) scenario. |
|
supportGroupNumber |
decimal |
|
The percentage of credit support for the tranche at issuance. [Magnitude: %] |
|
tranche |
string(255) |
|
The name of bond class. |
| filter_list |
trancheFrequency |
string(200) |
= |
The interest payment frequency for the specific tranche. |
|
trancheStatus |
string(100) |
|
The status of the security at tranche or instrument level. |
|
trancheType |
string(255) |
|
The description of the tranche. |
|
tranchesSupported |
string(500) |
|
The name of senior bond classes which are supported by subordinate bonds. |
|
updatedGroundGroup |
string(2500) |
|
The collateral ground groups which make up a collateral group. |