Type CollateralCashFlows
Type category Entity
Description This section provides all collateral cash flows for the deal.
Timeseries key id, settlementDate
Fields
Name Type Filters Description
key id string(200)* = This is the unique identifier for the cash flow.
timeline settlementDate date* =< >= This is the date on which the specific collateral details are captured.
accumulatedNetLoss decimal The cumulative amount of losses in USD since the inception of the deal.
bankrupt decimal This is the current Balance of Loans in Bankruptcy expressed as a percentage of the ending collateral balance as computed from rolling up loan level data.
baseRate decimal This is the base rate which include Coupon, Servicing Fee and any additional cushion.
link batch Batch* = This is the Batch in which the Collateral Cash Flow is provided.
link batchRun BatchRun* = This is the BatchRun in which the Collateral Cash Flow data is published.
link collateralLevelDetails CollateralLevelDetails This is the collateral with which the cash flow is associated.
cumulativeLoss decimal The cumulative losses from inception expressed as a percentage of the original collateral balance.
currentCollateralBalance decimal The current Ending Collateral Balance.
currentLoanToValue decimal The current Loan to Value Ratio.
currentMonthRepo decimal The current balance of loans REPOSSESSED in the current period as a percentage of the ending collateral balance.
currentNetWac decimal The current Weighted Average Net Coupon on Collateral.
currentPendingCapitalizedInterest decimal The current amount of interest to be capitalized.
currentPrincipalLiquidation decimal The current principal liquidation amount of the collateral pool.
currentPrincipalLoss decimal The current principal loss amount of the collateral pool.
currentPrincipalPrepayment decimal The current principal prepayment amount of the collateral pool.
currentPrincipalRecovery decimal The current principal recoveries amount of the collateral pool.
currentRepurchasedPrincipal decimal The current repurchased principal amount of the collateral pool.
currentScheduledPrincipal decimal The current scheduled principal payment of the collateral pool.
currentWac decimal The current Weighted Average Gross Coupon on Collateral.
link deal Deal* Deal the cash flow is for.
dealTicker string(255) This is the ticker of the deal.
deferment decimal The current balance of loans in deferment expressed as a percentage.
excessSpread decimal The current Excess Spread in the deal expressed as a percentage.
factor decimal This is the percentage of the original collateral balance of the group that remains outstanding.
fico decimal This is the weighted-average FICO score for the collateral pool.
forbearance decimal This is the balance Of Loans In Forbearance.
foreclosure decimal The percentage of Balance of loans in foreclosure.
gracePeriod decimal This is the current balance of loans in the grace period expressed as a percentage.
grossCoupon decimal The current Weighted Average Gross Coupon on Collateral.
grossWac decimal This is the gross Weighted Average Coupon on Collateral obtained by averaging each loan’s gross coupon weighted by the loan’s current balance.
groupAccumulatedLoss decimal This is the total accumulated loss of the collateral group.
groupNumber long This is the field providing various group numbers for the specific deal
inGracePeriod decimal This is the balance Of Loans In Grace Period.
inSchool decimal This is the balance Of Loans In School.
lastModifiedDate dateTime This is the timestamp of the latest CollateralCashFlows update.
lifeCdrRepay decimal This is used for student loans, standard life Constant Default Rate on loans in “Repayment” status.
lifeCpr decimal The Life Constant Prepayment Rate.
loanCount decimal The number of outstanding assets in the collateral pool.
modifiedLoans decimal The percentage of loans in the pool that have been modified.
ninetyDayBankruptcy decimal This is the current Balance of Loans over 90 days bankrupt expressed as a percentage of the collateral balance.
ninetyDayDelinquent decimal This is the current number of loans 90+ days delinquent.
ninetyDayForeclosure decimal This is the current Balance of Loans over 90 days FORECLOSURE expressed as a percentage of the ending collateral balance.
ninetyDayReo decimal This is the current balance of loans 90 or more days REO expressed as a percentage of the ending collateral balance.
ninetyPlusDaysForeclosureReoBankruptcy decimal This is standard 90 day aggregate expressed as a percentage of the minimum current balance for listed statuses and the total current balance.
nonConforming decimal This is underlying loans that are non-conforming expressed as a percentage. i.e. either subprime/Alt-A.
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.
numberOfAssets decimal Number Of Assets.
oneMonthCdr decimal This is the current default rate (unscheduled balance decline due to liquidated loans).
oneMonthCdrRepay decimal For student Loan deals, standard Constant Default Rate with only the collateral repayment in the current phase used in calculation.
oneMonthCollectedInterest decimal The 1 month interest collected as reported by trustee.
oneMonthCpr decimal This is the Standard Conditional Prepayment Rate calculation
oneMonthCprRepay decimal For student Loan deals, standard Constant Prepayment Rate with only the collateral repayment in the current phase used in calculation.
oneMonthCrr decimal This is the current Conditional Repayment Rate calculation.
oneMonthPpc decimal The standard Pricing Prepayment Curve calculation.
oneMonthSeverity decimal The trustee Reported 1mo Severity %
outstandingBalance decimal This is the current ending schedule balance of the loan.
reoCurrentBalance decimal This is the current balance of loans in REO expressed as a percentage of the ending collateral balance.
repayment decimal The Balance Of Loans in repayment.
repo decimal This is the current balance of loans REPOSSESSED in the current period as a percentage of the ending collateral balance.
reportedInSchool decimal For student loans, the percentage of loans where the borrower remains in school.
reportedRepayment decimal This is the current balance of loans in repayment expressed as a percentage. This does not include deferment and forbearance.
secondLien decimal The percentage of loans which are second lien at issue date.
sixMonthCdr decimal Standard 6 Month Constant Default Rate calculations.
sixMonthCdrRepay decimal For student loans, standard 6 month Constant Default Rate on loans in “Repayment” status.
sixMonthCpr decimal Standard 6 Month Constant Prepayment Rate calculations.
sixMonthCprRepay decimal For student loans, standard 6 month Constant Prepayment Rate on loans in “Repayment” status.
sixMonthCrr decimal Standard 6 month Conditional Repayment Rate calculation.
sixMonthPpc decimal Standard 6 Month Pricing Prepayment Curve calculations.
sixMonthSeverity decimal Trustee Reported 6mo Severity %.
sixtyDayDelinquent decimal Current balance of loans 30-59 days delinquent as a percentage of the ending collateral balance.
sixtyDayForeclosure decimal Current balance of loans 30-59 days foreclosure expressed as a percentage of the ending collateral balance.
sixtyDayReo decimal Current balance of loans 30-59 days REO expressed as a percentage of the ending collateral balance.
sixtyPlusDaysDelinquent decimal Current balance of loans 60 or more days delinquent as a percentage of the ending collateral balance.
sixtyPlusDaysForeclosureReoBankruptcy decimal Standard 60 day aggregate expressed as a percentage of the minimum current balance for listed statuses and the total current balance.
spreadToBaseRate decimal Difference between Net Yield and Base Rate.
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.
threeMonthBaseRate decimal The 3 month average of the Base Rate.
threeMonthCdr decimal Standard 3 Month Constant Default Rate calculations.
threeMonthCdrRepay decimal For student loans, standard 3 month Constant Default Rate on loans in “Repayment” status.
threeMonthCpr decimal Standard 3 Month Constant Prepayment Rate calculations.
threeMonthCprRepay decimal For student loans, standard 3 month Constant Prepayment Rate on loans in “Repayment” status.
threeMonthCrr decimal Standard 3 month Conditional Repayment Rate calculation.
threeMonthDealPsa decimal Standard 3 month prepayment history, in PSA units.
threeMonthPpc decimal Standard 3 Month Pricing Prepayment Curve calculations.
threeMonthSeverity decimal Trustee Reported 3mo Severity %
threeMonthSpreadToBaseRate decimal 3 month average of Spread to Base Rate.
twelveMonthCdr decimal Standard 12 Month Constant Default Rate calculations.
twelveMonthCdrRepay decimal For student loans deal, standard 12 month Constant Default Rate on loans in “Repayment” status.
twelveMonthCpr decimal Standard 12 Month Constant Prepayment Rate calculation derived from loan level data.
twelveMonthCprRepay decimal For student loans, standard 12 month Constant Prepayment Rate on loans in “Repayment” status.
twelveMonthCrr decimal Standard 12 month Conditional Repayment Rate calculation.
twelveMonthPpc decimal Standard 12 Month Pricing Prepayment Curve calculations.
twelveMonthSeverity decimal Standard 12 month severity rate calculation.
wala decimal Weighted Average Seasoning expressed in months.
wam decimal Weighted Average Remaining Term expressed in months.
wavgIoTerm decimal Weighted average of remaining I/O months till maturity expressed in months.
weightedAverageAmortizationTerm decimal Current weighted average of remaining amortization term till maturity (not including balloon term) expressed in months.
weightedAverageRemainingTerm decimal Weighted average of remaining months till maturity expressed in months.
106 rows of 106 total
API Open API Specification