| 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] |