| 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. |
|
avgOriginalLoanSize |
decimal |
|
This is the average original loan size of the underlying collateral. |
|
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. |
|
createdDate |
dateTime |
|
Field to indicate the date when first data leg was inserted. |
|
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* |
timeline |
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. |
|
maximumLoanSize |
decimal |
|
This is the maximum loan size for loans in Quartile 4. |
|
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. |
|
oneMonthPrePayPenalty |
decimal |
|
This field defines one prepayment penalty received at collateral group level. |
|
oneMonthSeverity |
decimal |
|
The trustee Reported 1mo Severity % |
|
originalLoanToValue |
decimal |
|
This is the weighted average original Loan to Value ratio of underlying collateral. |
|
outstandingBalance |
decimal |
|
This is the current ending schedule balance of the loan. |
|
propertyType |
string(1000) |
|
This field indicates the property type of underlying collateral. |
|
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. |