Type CollateralCashFlows
Type category Entity
Description The collateral cash flows for the deal.
Timeseries key id, settlementDateavailable from 1980-01-15
Fields
Name Type Filters Description
key id string(200)* = The unique identifier for the cash flow.
timeline settlementDate date* =< >= The date on which the specific collateral details are captured.
accumulatedNetLoss decimal The cumulative amount of losses since the inception of the deal. [Magnitude: $]
avgOriginalLoanSize decimal The average original loan size of the underlying collateral. [Magnitude: $]
bankrupt decimal The current balance of loans in bankruptcy expressed as a percentage of the ending collateral balance as computed from rolling up loan level data. [Magnitude: %]
baseRate decimal The base rate which include coupon, servicing fee and any additional cushion. [Magnitude: %]
link batch Batch* = The batch in which the collateral cash flow is provided.
link batchRun BatchRun* = The batchrun in which the collateral cash flow data is published.
link collateralLevelDetails CollateralLevelDetails The collateral with which the cash flow is associated.
createdDate dateTime The date and time when first data leg was inserted.
cumulativeLoss decimal The cumulative losses from inception expressed as a percentage of the original collateral balance. [Magnitude: %]
currentCollateralBalance decimal The current ending collateral balance. [Magnitude: $]
currentLoanToValue decimal The current loan to value ratio. [Magnitude: %]
currentMonthRepo decimal The current balance of loans repossessed in the current period as a percentage of the ending collateral balance. [Magnitude: %]
currentNetWac decimal The current weighted average net coupon on collateral. [Magnitude: %]
currentPendingCapitalizedInterest decimal The current amount of interest to be capitalized. [Magnitude: $]
currentPrincipalLiquidation decimal The current principal liquidation amount of the collateral pool. [Magnitude: $]
currentPrincipalLoss decimal The current principal loss amount of the collateral pool. [Magnitude: $]
currentPrincipalPrepayment decimal The current principal prepayment amount of the collateral pool. [Magnitude: $]
currentPrincipalRecovery decimal The current principal recoveries amount of the collateral pool. [Magnitude: $]
currentRepurchasedPrincipal decimal The current repurchased principal amount of the collateral pool. [Magnitude: $]
currentScheduledPrincipal decimal The current scheduled principal payment of the collateral pool. [Magnitude: $]
currentWac decimal The current weighted average gross coupon on collateral. [Magnitude: %]
link deal Deal* = The unique identifier of deal associated with the corresponding collateral for which this cash flow is published.
dealTicker string(255) The ticker of the deal.
deferment decimal The current balance of loans in deferment. [Magnitude: %]
excessSpread decimal The current excess spread in the deal. [Magnitude: %]
factor decimal The percentage of the original collateral balance of the group that remains outstanding. [Magnitude: %]
fico decimal The weighted-average FICO (Fair Isaac Corporation) score for the collateral pool. [Magnitude: x]
forbearance decimal The balance of loans in forbearance. [Magnitude: $]
foreclosure decimal The percentage of balance of loans in foreclosure. [Magnitude: %]
gracePeriod decimal The current balance of loans in the grace period expressed as a percentage. [Magnitude: %]
grossCoupon decimal The current weighted average gross coupon on collateral. [Magnitude: %]
grossWac decimal The gross weighted average coupon on collateral obtained by averaging each loan's gross coupon weighted by the loan's current balance. [Magnitude: %]
groupAccumulatedLoss decimal The total accumulated loss of the collateral group. [Magnitude: $]
groupNumber long Various group numbers for the specific deal.
inGracePeriod decimal The balance of loans in grace period. [Magnitude: $]
inSchool decimal The balance of loans in school. [Magnitude: $]
lastModifiedDate dateTime The date and time of the latest CollateralCashFlows update.
lifeCdrRepay decimal For student loans, standard life constant default rate on loans in repayment status. The Constant Default Rate (CDR) is an annualized measure of the percentage of mortgages in a mortgage-backed security (MBS) that default, calculated monthly based on the pool's remaining balance. [Magnitude: %]
lifeCpr decimal The life Constant Prepayment Rate (CPR) is an annualized percentage estimating the speed at which borrowers prepay principal on loans, such as mortgages, in a pool over a specific period. [Magnitude: %]
loanCount decimal The number of outstanding assets in the collateral pool. [Magnitude: actual]
maximumLoanSize decimal The maximum loan size for loans in quartile 4. [Magnitude: $]
modifiedLoans decimal The percentage of loans in the pool that have been modified. [Magnitude: %]
ninetyDayBankruptcy decimal The current balance of loans over 90 days bankrupt expressed as a percentage of the collateral balance. [Magnitude: %]
ninetyDayDelinquent decimal The current number of loans in over 90 days delinquent. [Magnitude: actual]
ninetyDayForeclosure decimal The current balance of loans over 90 days forecloser expressed as a percentage of the ending collateral balance. [Magnitude: %]
ninetyDayReo decimal The current balance of loans in 90 or more days Real Estate Owned (REO) expressed as a percentage of the ending collateral balance. [Magnitude: %]
ninetyPlusDaysForeclosureReoBankruptcy decimal Standard 90 day aggregate expressed as a percentage of the minimum current balance for listed statuses and the total current balance. [Magnitude: %]
nonConforming decimal Underlying loans that are non-conforming expressed as a percentage. i.e. either subprime or Alt-A. [Magnitude: %]
notFullDoc decimal The percentage of underlying loans which generally fall into the Alt-A sector of mortgage lending that gives borrowers the ability to state a limited amount of information on their mortgage application. [Magnitude: %]
numberOfAssets decimal The current number of assets for a collateral group. [Magnitude: actual]
oneMonthCdr decimal The current default rate (unscheduled balance decline due to liquidated loans). [Magnitude: %]
oneMonthCdrRepay decimal For student loan deals, standard Constant Default Rate (CDR) with only the collateral repayment in the current phase used in calculation. [Magnitude: %]
oneMonthCollectedInterest decimal The 1 month interest collected as reported by trustee. [Magnitude: $]
oneMonthCpr decimal The standard conditional prepayment rate calculation [Magnitude: %]
oneMonthCprRepay decimal For student loan deals, standard Constant Prepayment Rate (CPR) with only the collateral repayment in the current phase used in calculation. [Magnitude: %]
oneMonthCrr decimal The current Conditional Repayment Rate (CRR) calculation. [Magnitude: %]
oneMonthPpc decimal The standard Pricing Prepayment Curve (PPC) calculation. [Magnitude: %]
oneMonthPrePayPenalty decimal One-month prepayment penalty received at collateral group level. [Magnitude: $]
oneMonthSeverity decimal Trustee reported one-month severity. [Magnitude: %]
originalLoanToValue decimal The weighted average original loan to value ratio of underlying collateral. [Magnitude: %]
outstandingBalance decimal The current ending schedule balance of the loan. [Magnitude: $]
propertyType string(1000) The property type of underlying collateral.
reoCurrentBalance decimal The current balance of loans in Real Estate Owned (REO) expressed as a percentage of the ending collateral balance. [Magnitude: %]
repayment decimal The balance of loans in repayment. [Magnitude: $]
repo decimal The current balance of loans repossessed in the current period as a percentage of the ending collateral balance. [Magnitude: %]
reportedInSchool decimal For student loans, the percentage of loans where the borrower remains in school. [Magnitude: %]
reportedRepayment decimal The current balance of loans in repayment expressed as a percentage. This does not include deferment and forbearance. [Magnitude: %]
secondLien decimal The percentage of loans which are second lien at issue date. [Magnitude: %]
sixMonthCdr decimal Standard six-month constant default rate calculations. [Magnitude: %]
sixMonthCdrRepay decimal For student loans, standard six-month constant default rate on loans in repayment status. [Magnitude: %]
sixMonthCpr decimal Standard six-month constant prepayment rate calculations. [Magnitude: %]
sixMonthCprRepay decimal For student loans, standard six-month constant prepayment rate on loans in Repayment status. [Magnitude: %]
sixMonthCrr decimal Standard six-month conditional repayment rate calculation. [Magnitude: %]
sixMonthPpc decimal Standard six-month pricing prepayment curve calculations. [Magnitude: %]
sixMonthSeverity decimal Trustee reported six-month severity. [Magnitude: %]
sixtyDayDelinquent decimal Current balance of loans 30-59 days delinquent as a percentage of the ending collateral balance. [Magnitude: %]
sixtyDayForeclosure decimal Current balance of loans 30-59 days foreclosure expressed as a percentage of the ending collateral balance. [Magnitude: %]
sixtyDayReo decimal The current balance of loans 30-59 days Real Estate Owned (REO) expressed as a percentage of the ending collateral balance. [Magnitude: %]
sixtyPlusDaysDelinquent decimal Current balance of loans 60 or more days delinquent as a percentage of the ending collateral balance. [Magnitude: %]
sixtyPlusDaysForeclosureReoBankruptcy decimal Standard 60 day aggregate expressed as a percentage of the minimum current balance for listed statuses and the total current balance. [Magnitude: %]
spreadToBaseRate decimal Difference between net yield and base rate. [Magnitude: b.p]
statePercentCollateral string(1000) State represented in the collateral pool, as per weighted average principal balance.
statePercentFifthCollateral string(100) Fifth top state represented in the collateral pool, as per weighted average principal balance.
statePercentFirstCollateral string(100) First top state represented in the collateral pool, as per weighted average principal balance.
statePercentFourthCollateral string(100) Fourth top state represented in the collateral pool, as per weighted average principal balance.
statePercentSecondCollateral string(100) Second top state represented in the collateral pool, as per weighted average principal balance.
statePercentThirdCollateral string(100) Third top state represented in the collateral pool, as per weighted average principal balance.
thirtyDayDelinquent decimal Current balance of loans 30 days delinquent as a percentage of the ending collateral balance. [Magnitude: %]
threeMonthBaseRate decimal The three-month average of the base rate. [Magnitude: %]
threeMonthCdr decimal Standard three-month constant default rate calculations. [Magnitude: %]
threeMonthCdrRepay decimal For student loans, standard three-month constant default rate on loans in repayment status. [Magnitude: %]
threeMonthCpr decimal Standard three-month constant prepayment rate calculations. [Magnitude: %]
threeMonthCprRepay decimal For student loans, standard three-month constant prepayment rate on loans in repayment status. [Magnitude: %]
threeMonthCrr decimal Standard three-month conditional repayment rate calculation. [Magnitude: %]
threeMonthDealPsa decimal Standard three-month prepayment history, in Public Securities Association (PSA) units. [Magnitude: %]
threeMonthPpc decimal Standard three-month pricing prepayment curve calculations. [Magnitude: %]
threeMonthSeverity decimal Trustee reported three-month severity. [Magnitude: %]
threeMonthSpreadToBaseRate decimal Three-month average of spread to base rate. [Magnitude: b.p]
twelveMonthCdr decimal Standard twelve-month constant default rate calculations. [Magnitude: %]
twelveMonthCdrRepay decimal For student loans deal, standard twelve-month constant default rate on loans in repayment status. [Magnitude: %]
twelveMonthCpr decimal Standard twelve-month constant prepayment rate calculation derived from loan level data. [Magnitude: %]
twelveMonthCprRepay decimal For student loans, standard twelve-month constant prepayment rate on loans in repayment status. [Magnitude: %]
twelveMonthCrr decimal Standard twelve-month conditional repayment rate calculation. [Magnitude: %]
twelveMonthPpc decimal Standard twelve-month pricing prepayment curve calculations. [Magnitude: %]
twelveMonthSeverity decimal Standard twelve-month severity rate calculation. [Magnitude: %]
wala decimal Weighted average seasoning expressed in months. [Magnitude: months]
wam decimal Weighted average remaining Term expressed in months. [Magnitude: months]
wavgIoTerm decimal Weighted average of remaining interest-only months till maturity expressed in months. [Magnitude: months]
weightedAverageAmortizationTerm decimal Current weighted average of remaining amortization term till maturity (not including balloon term) expressed in months. [Magnitude: months]
weightedAverageRemainingTerm decimal Weighted average of remaining months till maturity expressed in months. [Magnitude: months]
112 rows of 112 total
API Open API Specification