|
accrualPeriod |
date |
|
The date from which the interest starts accruing. |
|
accruedInterest |
decimal |
|
Interest on a security that has accumulated since the previous coupon payment. |
|
analyticsId |
string(500) |
|
Analytics id |
|
askPrice |
decimal |
|
Ask price is the price at which a market maker is willing to sell the security. |
|
assetSwapMargin |
decimal |
|
Spread of a security over the swap curve. |
|
averageLife |
decimal |
|
Time the principal of a debt is expected to be outstanding. |
|
balanceUsedForAi |
decimal |
|
Balance used for the calculation of accrued interest. |
|
bidAskSpread |
decimal |
|
Difference between bid and ask price. |
|
bidPrice |
decimal |
|
Bid price is the price at which a market maker is willing to buy the security. |
|
bondType |
string(200) |
|
Type of CMBS security, i.e. fixed rate, WAC/Pass Thru. |
|
cashPaymentDate |
date |
|
Payment date for cash. |
|
cashPaymentPercentage |
decimal |
|
Coupon payments plus redemptions since the last index rebalancing. |
|
cashflowDate |
date |
|
Cashflow Date. |
|
countryOfRisk |
string(200) |
|
Country where the issuer has the most business risk. |
|
coupon |
decimal |
|
Coupon rate is the interest rate that the issuer agrees to pay each year. The annual amount of the interest payment made is called the coupon. The coupon rate multiplied by the principal of the bond provides the cash amount of the coupon. |
|
couponFrequency |
long |
|
Number of times per year the coupon is paid. |
|
couponPaymentPercentage |
decimal |
|
Interest paid since the last rebalancing, usually the last calendar day of a month. If there was no payment the value is 0. |
|
cumBondLossPct |
decimal |
|
Total principal loss for life of tranche as percent of original balance. |
|
cumulativeLosses |
decimal |
|
Cumulative losses on tranche to date. |
|
curCreditThickness |
decimal |
|
Bond Thickness based on current credit enhancement as of tape date. |
|
currency |
string(3) |
|
Currency or denomination of security. |
|
currentBalance |
decimal |
|
Current aggregate collateral balance. |
|
currentRedemptionPaymentPercentage |
decimal |
|
Redemption payment made in the current month. Expressed in percentage. |
|
currentSubordinationPct |
decimal |
|
Instrument subordinated percentage share. |
|
cusip |
string(9) |
|
Alphanumeric CUSIP numbers that are used to identify securities. |
|
dayCountMethod |
string(200) |
|
The date count convention based on which the accrued interest is calculated, it determines the number of days between two coupon payments. Typical conventions are 30/360, Act/Act, Act/360, etc. |
|
dealCurrentBalance |
decimal |
|
Deal Current bond balance. |
|
dealDelinq30DayAmt |
decimal |
|
Balance of loans that are 30 to 59 days delinquent as of tape date. |
|
dealDelinq60DayAmt |
decimal |
|
Balance of loans that are 60 to 89 days delinquent as of tape date. |
|
dealDelinq90DayAmt |
decimal |
|
Balance of loans that are 90+ days delinquent as of tape date. |
|
dealFactor |
decimal |
|
Percentage of deal remaining outstanding as of tape date. |
|
dealForeclosureAmt |
decimal |
|
Amount of the loans, which are in foreclosure state. |
|
dealName |
string(200) |
|
Deal Name. |
|
dealNonPerfMatBalloonAmt |
decimal |
|
Amount of the loans which are in balloon mortgages. |
|
dealOriginalBalance |
decimal |
|
Aggregate original balance of the deal. |
|
dealReoAmt |
decimal |
|
Real estate owned amount. |
|
dealType |
string(200) |
|
Deal Type. |
|
defaseCreditEnhance |
decimal |
|
The current credit support for bonds after adjustment for loans that are fully defeased. Trepp calculates Defeasance Adjusted Credit Enhancement by running cashflows and prepaying the fully defeased loans immediately to realize the effect of the certain principal payments. This methodology is a more precise measure than calculating a defeasance adjusted credit enhancement by subtracting the amount of defeased loans from the denominator of the credit enhancement calculation as the cashflow waterfall is reflected in Trepp's Defeasance Adjusted Credit Enhancement. The Defeasance Adjusted Credit Enhancement value is calculated only for non-CDO deals that have any underlying fully defeased loans. |
|
delinquency |
decimal |
|
A loan payment that is at least 30 days past due. |
|
dirtyPrice |
decimal |
|
Clean price plus accrued interest. |
|
discountMargin |
decimal |
|
Discount margin against a benchmark rate. |
|
finalMaturity |
date |
|
Refers to the time when the debt must be repaid or rolled over. The official expected maturity specified by the issuer in the prospectus, not the legal final maturity. This is the date on which the principal amount is due. |
|
firstSettlementDate |
date |
|
The date when the security is initially settled. |
|
instrInXDivPeriod |
boolean |
|
Flag indicating if the instrument is in exDiv period. |
|
interestShortFall |
decimal |
|
Current accumulated interest shortfall amount. |
|
isFloater |
boolean |
|
Indicates whether the security is floating rate note in which coupon changes over time depending on an underlying rate. |
|
isIo |
boolean |
|
Denotes if the CMBS instrument is an "interest only" security. |
|
isPac |
boolean |
|
Indicates if the CMBS security is of a planned amortization class tranche. |
|
isin |
string(12) |
|
The International Securities Identification Number (ISIN) is a code that uniquely identifies a specific securities issue. |
|
issuer |
string(200) |
|
Name of the company, government or organization that issued the security. |
|
issuerCountry |
string(200) |
|
Country where the issuer resides. |
|
lastCouponDate |
date |
|
When was last coupon paid. |
|
leadUnderwriter |
string(200) |
|
Lead underwriter (normalized across deals). |
|
masterServicer |
string(200) |
|
Master servicer (normalized across deals). |
|
modifiedDuration |
decimal |
|
The first derivative of the instrument's price with respect to yield. Measures the sensitivity of prices to changes in yield using local market conventions. |
|
monthsSinceClosingDate |
decimal |
|
Months since Original settlement date of deal (YYYYMMDD). |
|
nextCouponDate |
date |
|
Next coupon date of bond. |
|
originalBalance |
decimal |
|
Original bond balance. |
|
originalSubordinationPct |
decimal |
|
Original subordination percentage for bond (i.e., 25) - for “leg” deals, subordination level of legs will appear as 0. |
|
penaltyPercentage |
decimal |
|
Prepayment Premium or YM/Fixed Penalty distributed in current period. |
|
periodBondLoss |
decimal |
|
Loss amount in current period. |
|
priceSource |
string(200) |
|
Price source of the bond. |
|
priceType |
string(200) |
|
Indicates the price type used for the calculation, i.e. bid, ask or mid. |
|
projectedCurrentFactor |
decimal |
|
Expected redemption factor. |
|
redemptionFactor |
decimal |
|
Percentage of remaining notional on calculation date . |
|
referenceDataId |
string(500) |
|
Reference data id |
|
series |
string(200) |
|
Trepp internal series name. |
|
specialServicer |
string(200) |
|
Special servicer (normalized across deals). |
|
spread |
decimal |
|
TBA. |
|
tapeDate |
date |
|
Tape Date. |
|
trancheName |
string(200) |
|
Tranche name. |
|
trustee |
string(200) |
|
Trustee name (normalized across deals). |
|
underwriters |
string(200) |
|
Underwriters of the issue (normalized across deals). |
|
unrealizedAccruedInterest |
decimal |
|
Unrealized interest accrued since last payment. |
|
vintage |
long |
|
Year of issuance. |
|
xDivAccrualStartDate |
date |
|
Accrual Start Date as of last month end. |
|
xDivAccruedInterest |
decimal |
|
Accrued interest as of last month end. |
|
xDivAnalyticsDate |
date |
|
Analytics date as of last month end. |
|
xDivBalanceUsedForAi |
decimal |
|
Balance as of last month end. |
|
xDivCashflowDate |
date |
|
Next cashflow date as of last month end. |
|
xDivNextPayDate |
date |
|
Next pay date as of last month end. |
|
yearsSinceClosingDate |
decimal |
|
Years since Original settlement date of deal (YYYYMMDD). |
|
yield |
decimal |
|
Yield calculated via street convention. |