| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
| timeline |
asOf |
date* |
=< >= |
Month end date of index holdings |
|
amount |
decimal |
|
Facility Amount in MM |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the Price is calculated. |
|
bbergId |
string(20) |
|
A Bloomberg generated identifier associated with a particular issuer / tranche combination |
|
beginningConversionRateEur |
decimal |
|
Beginning conversion rate from loan currency into Eur |
|
beginningConversionRateGbp |
decimal |
|
Beginning conversion rate from loan currency into Gbp |
|
beginningConversionRateUsd |
decimal |
|
Beginning conversion rate from loan currency into Usd |
|
beginningMarketValue |
decimal |
|
Beginning Market-Value |
|
beginningMarketValueEur |
decimal |
|
Beginning Market-Value in Eur |
|
beginningMarketValueGbp |
decimal |
|
Beginning Market-Value in Gbp |
|
beginningMarketValueUsd |
decimal |
|
Beginning Market-Value in Usd |
|
beginningMarketWeight |
decimal |
|
Beginning Market-Weight |
|
beginningPrice |
decimal |
|
Price as Start Date |
|
combinedRating |
string(20) |
|
Combined rating of SNP and Moodys |
|
company |
string(200) |
|
Name of company |
|
country |
string(20) |
|
Country of loan |
|
covLite |
string(10) |
|
TRUE/FALSE indication of the tranche being cov-lite |
|
currency |
string(5) |
|
Currency of loan |
|
defaultIndicator |
string(10) |
|
TRUE/FALSE indication whether the loan has defaulted |
|
discountMarginToMaturity |
decimal |
|
Discount Margin to Maturity |
|
effectiveDate |
date |
|
Closing date of the loan |
|
endConversionRateEur |
decimal |
|
End conversion rate from loan currency into Eur |
|
endConversionRateGbp |
decimal |
|
End conversion rate from loan currency into Gbp |
|
endConversionRateUsd |
decimal |
|
End conversion rate from loan currency into Usd |
|
endDate |
date |
|
Pricing End Date |
|
endMarketValue |
decimal |
|
End Market-Value |
|
endMarketValueEur |
decimal |
|
End Market-Value in Eur |
|
endMarketValueGbp |
decimal |
|
End Market-Value in Gbp |
|
endMarketValueUsd |
decimal |
|
End Market-Value in Usd |
|
endMarketWeight |
decimal |
|
End Market-Weight |
|
endPrice |
decimal |
|
Price as of EndDate |
|
facility |
string(20) |
|
Tranche name |
|
fiveYearDiscountMargin |
decimal |
|
Discount Margin to 5-yr call |
|
fiveYearYield |
decimal |
|
Yield to 5-yr call |
|
fourYearDiscountMargin |
decimal |
|
Discount Margin to 4-yr call |
|
fourYearYield |
decimal |
|
Yield to 4-yr call |
|
hasLiborFloor |
string(10) |
|
YES/NO indication of the tranche having a Libor floor |
|
indexName |
string(400) |
|
Name of index |
|
industry |
string(100) |
|
Industry classification |
|
industrySegment |
string(50) |
|
Segment within Industry |
|
industryType |
string(50) |
|
Type of Industry |
|
interestReturn |
decimal |
|
Interest return between StartDate and EndDate |
|
interestReturnHedgedEur |
decimal |
|
Interest return Eur Hedged between StartDate and EndDate |
|
interestReturnHedgedGbp |
decimal |
|
Interest return Gbp Hedged between StartDate and EndDate |
|
interestReturnHedgedUsd |
decimal |
|
Interest return US Hedged between StartDate and EndDate |
|
interestReturnUnhedgedEur |
decimal |
|
Interest return Eur unHedged between StartDate and EndDate |
|
interestReturnUnhedgedGbp |
decimal |
|
Interest return Gbp unHedged between StartDate and EndDate |
|
interestReturnUnhedgedUsd |
decimal |
|
Interest return US unHedged between StartDate and EndDate |
|
issuer |
string(200) |
|
Name of borrower or issuer |
|
liborFloor |
decimal |
|
The minimum base rate in percentage paid in the event Libor is below the specified floor level. (i.e., 1.25 is 125 bps) |
| filter_list |
lxid |
string(20) |
= |
An IHS Markit generated unique identifier associated with a particular issuer / tranche combination |
|
maturityDate |
date |
|
Final maturity date |
|
moodysRating |
string(20) |
|
Moodys Rating |
|
principalReturn |
decimal |
|
Principal return between StartDate and EndDate |
|
principalReturnHedgedEur |
decimal |
|
Principal return Eur Hedged between StartDate and EndDate |
|
principalReturnHedgedGbp |
decimal |
|
Principal return Gbp Hedged between StartDate and EndDate |
|
principalReturnHedgedUsd |
decimal |
|
Principal return Usd Hedged between StartDate and EndDate |
|
principalReturnUnhedgedEur |
decimal |
|
Principal return Eur unHedged between StartDate and EndDate |
|
principalReturnUnhedgedGbp |
decimal |
|
Principal return Gbp unHedged between StartDate and EndDate |
|
principalReturnUnhedgedUsd |
decimal |
|
Principal return Usd unHedged between StartDate and EndDate |
|
ratingTier |
string(20) |
|
Indication whether the loan rating is in an Upper, Middle, Lower tier or Not Rated |
|
seniority |
string(20) |
|
Lien of the loan |
|
spRating |
string(20) |
|
SNP Rating |
|
spread |
decimal |
|
Spread of the Loan |
|
startDate |
date |
|
Pricing Start Date |
|
threeYearDiscountMargin |
decimal |
|
Discount Margin to 3-yr call |
|
threeYearYield |
decimal |
|
Yield to 3-yr call |
|
totalReturn |
decimal |
|
Total return between StartDate and EndDate |
|
totalReturnHedgedEur |
decimal |
|
Total return Eur Hedged between StartDate and EndDate |
|
totalReturnHedgedGbp |
decimal |
|
Total return Gbp Hedged between StartDate and EndDate |
|
totalReturnHedgedUsd |
decimal |
|
Total return Usd Hedged between StartDate and EndDate |
|
totalReturnUnhedgedEur |
decimal |
|
Total return Eur unHedged between StartDate and EndDate |
|
totalReturnUnhedgedGbp |
decimal |
|
Total return Gbp unHedged between StartDate and EndDate |
|
totalReturnUnhedgedUsd |
decimal |
|
Total return Usd unHedged between StartDate and EndDate |
|
twoYearDiscountMargin |
decimal |
|
Discount Margin to 2-yr call |
|
twoYearYield |
decimal |
|
Yield to 2-yr call |
|
yieldToMaturity |
decimal |
|
Yield to Maturity |