T-REX data dictionaries ensure users quick access to assess and gain insights into a variety of different metrics. The dictionaries allow users to match their original fields with the standardized T-REX field and definition they will see on the platform.
| Titan Field Name | Calculated or Raw | Asset Type | Field Description | Conditions | Calculation | Data_Type | Notes |
| Eligible Non-Prime Balance | Calc | Borrowing Base | If Calc is negative, 0 | Z-X*(Z/sum(y:z)) | CURRENCY | X: Total Excess Y: Total Eligible Prime Balance Z: Total Eligible Non Prime Balance | |
| Alternate Advance Rate | Raw | Borrowing Base | An alternate advance rate to be used for comparisons | *100 | NUMBER | ||
| Total Eligible Balance | Raw | Borrowing Base | CURRENCY | ||||
| Actual Principal Collected Amount | Calc | Borrowing Base | The reported net principal paid to the collection account. | CURRENCY | |||
| Fee Payment | Raw | Borrowing Base | Fees paid by the borrower to a lender. | CURRENCY | |||
| Collection Period End Date | Raw | Borrowing Base | The end date for current period collection | DATE | |||
| Advance Rate | Raw | Borrowing Base | The maximum percentage of the value of a collateral that a lender is willing to extend for a loan | *100 | NUMBER | ||
| Data as of Date | Raw | Borrowing Base | This is the 'default' as-of date for static data of an element. This is mandatory for Root Elements for them to show up in TRA. | DATE | |||
| Outstanding Advances | Raw | Borrowing Base | The cumulative sum of all advances made. | CURRENCY | |||
| Report Date | Raw | Borrowing Base | The date of the servicer report/cashflow report | DATE | |||
| Total Eligible Non Prime Balance | Raw | Borrowing Base | CURRENCY | ||||
| Eligible Prime Balance | Calc | Borrowing Base | If Calc is negative, 0 | Y-X*(Y/sum(y:z)) | CURRENCY | X: Total Excess Y: Total Eligible Prime Balance Z: Total Eligible Non Prime Balance | |
| Requested Advance Amount | Raw | Borrowing Base | Amount requested by borrower from a defined lending facility | CURRENCY | |||
| Borrowing Base | Calc | Borrowing Base | X + (Y*A/100) + (Z*B/100) | CURRENCY | X: Actual Principal Collected Amount Y: Eligible Prime Balance Z: Eligible Non Prime Balance A: Advance Rate B: Alternate Advance Rate | ||
| Adjusted Pool Balance | Calc | Borrowing Base | Pool Balance adjusted | If Calc is negative, 0 | X-Y | CURRENCY | X: Total Eligible Balance Y: Total Excess |
| Name | Concentration Calculation | ||||||
| Collection Period Begin Date | Raw | Concentration Calculation | The beginning date for current period collection | DATE | |||
| Used Asset Concentration | Both | Concentration Calculation | The concentration of loans balance dedicated to used assets. | X/Y*100 | NUMBER | X: Used Balance Y: Total Eligible Balance (From Pool) | |
| WA Credit Score | Raw | Concentration Calculation | An asset level calculation to determine the data facility WA credit score across principal balance | NUMBER | |||
| Prime Loan | Both | Concentration Calculation | X/Y*100 | NUMBER | X: Prime Loans Balance Y: Total Eligible Balance (From Pool) | ||
| Risk Concentration | Both | Concentration Calculation | the concentration of assets for high risk loans. | X/Y*100 | NUMBER | X: Risk Balance Y: Total Eligible Balance (From Pool) | |
| Largest State Concentration | Both | Concentration Calculation | The state where the highest concentration of underlying loans reside. | X/Y*100 | NUMBER | X: Largest State Balance Y: Total Eligible Balance (From Pool) | |
| Modified Concentration | Both | Concentration Calculation | The concentration of assets for loans that have been modified. | X/Y*100 | NUMBER | X: Modified Balance Y: Total Eligible Balance (From Pool) | |
| Ineligible FICO | Both | Concentration Calculation | The amount of loans with ineligible FICO scores. | X/Y*100 | NUMBER | X: No FICO + Low FICO Balance Y: Total Eligible Balance (From Pool) | |
| N Largest States Concentration | Both | Concentration Calculation | The concentration of balance dedicated to N largest states. | X/Y*100 | NUMBER | X: N Largest States Balance Y: Total Eligible Balance (From Pool) | |
| Risk Level Eligibility % | Both | Concentration Calculation | The risk level eligibility amount as a percentage of the pool. | X/Y*100 | NUMBER | X: Risk Level Eligibility Balance Y: Total Eligible Balance (From Pool) | |
| WA DTI | Calc | Eligibility Criteria | The weighted average Debt to Income ratio. | If Z = "Yes" | SUM(X*(Y/100)) of each loan / (T) | NUMBER | X: Outstanding Balance Y: Debt to Income Ratio Z: Eligible Loan Flag T: Total Eligible Balance |
| No FICO Score Balance | Calc | Eligibility Criteria | The balance of borrowers with no FICO score. | If Z = "Yes" AND Y = 0 | Sum X | CURRENCY | X: Outstanding Balance Y: FICO Score Z: Eligible Loan Flag |
| Prime Loans Balance | Calc | Eligibility Criteria | the Balance of prime loans. | If Z = "Yes" AND Y = "Yes" | Sum X | CURRENCY | X: Outstanding Balance Y: Prime Flag Z: Eligible Loan Flag |
| WA FICO Score | Raw | Eligibility Criteria | If Z = "Yes" | SUM(X*Y) of each loan / (T) | NUMBER | X: Outstanding Balance Y: FICO Score Z: Eligible Loan Flag T: Total Eligible Balance | |
| No FICO + Low FICO Balance | Calc | Eligibility Criteria | The balance of borrower with no FICO score or a low FICO score. | X + Y | CURRENCY | X: No FICO Score Balance Y: Low FICO Score Balance | |
| Low FICO Score Balance | Raw | Eligibility Criteria | The balance of loans with a low FICO score as defined by the client. | If Z = "Yes" AND Y =< 580 | Sum X | CURRENCY | X: Outstanding Balance Y: FICO Score Z: Eligible Loan Flag |
| Risk Balance | Calc | Eligibility Criteria | The balance of assets that are considered high risk. | If Z = "Yes" AND Y = 8 | Sum X | CURRENCY | X: Outstanding Balance Y: Custom Credit Tier Z: Eligible Loan Flag |
| High Risk Balance | Calc | Eligibility Criteria | The balance of assets that are considered risky. | If Z = "Yes" AND Y = 7 | Sum X | CURRENCY | X: Outstanding Balance Y: Custom Credit Tier Z: Eligible Loan Flag |
| Risk Level Eligibility Balance | Calc | Eligibility Criteria | X + Y | CURRENCY | X: Risk Balance Y: High Risk Balance | ||
| N Largest States Balance | Calc | Eligibility Criteria | The N largest states concentration in regards to loan balance. | Sum X, Y, Z | CURRENCY | X: Largest State Balance Y: 2nd Largest State Balance Z: 3rd Largest State Balance | |
| 2nd Largest State Balance | Calc | Eligibility Criteria | The 2nd largest state concentration in regards to loan balance. | GROUPBY(Y), Sum(X) | TAKE THE 2ND MAX FOR Y | CURRENCY | X: Outstanding Balance Y: State |
| Used Asset Balance | Calc | Eligibility Criteria | The balance of assets that are used. | If Y = "used" and Z = "Yes" | Sum X | CURRENCY | X: Outstanding Balance Y: New/Used Z: Eligible Loan Flag |
| 3rd Largest State Balance | Calc | Eligibility Criteria | The 3rd largest state concentration in regards to loan balance. | GROUPBY(Y), Sum(X) | TAKE THE 3RD MAX FOR Y | CURRENCY | X: Outstanding Balance Y: State |
| Largest State Balance | Calc | Eligibility Criteria | GROUPBY(Y), Sum(X) | TAKE THE MAX X FOR Y | CURRENCY | X: Outstanding Balance Y: State | |
| Modified Loans Balance | Calc | Eligibility Criteria | If Y =1 AND Z >= 1 AND T = "Yes" | Sum X | CURRENCY | X: Outstanding Balance Y: Active Duty Flag Z: Extension Number T: Eligible Loan Flag | |
| Used - EC Calc | Calc | Excess Concentration | The excess concentration calculation of used assets. | If T = "FAIL", Calculation, else 0 | Y - ((X/100)*Z) | CURRENCY | X: Used Asset Concentration (Limit) Y: Used Asset Balance Z: Eligible Loan Balance T: Used - EC Assess |
| WA Credit Score - EC Assess | Calc | Excess Concentration | For Excess Concentrations - determination of whether WA Credit Score limit is breached. Value is Pass/Fail | If X Actual > X Limit, "PASS", Else "FAIL" | TEXT | X: WA Credit Score Input | |
| Largest State - EC Assess | Calc | Excess Concentration | Whether the concentration of the largest state balance passes a certain threshold. | If X Actual > X Limit, "PASS", Else "FAIL" | TEXT | X: Largest State Concentration | |
| Risk - EC Assess | Calc | Excess Concentration | If X Actual > X Limit, "PASS", Else "FAIL" | TEXT | X: Risk Concentration | ||
| Used - EC Assess | Calc | Excess Concentration | Whether the concentration of used assets passes a threshold. | If X Actual > X Limit, "PASS", Else "FAIL" | TEXT | X: Used Asset Concentration | |
| Modified - EC Assess | Calc | Excess Concentration | Whether the balance of modified loans passes a threshold. | If X Actual > X Limit, "PASS", Else "FAIL" | TEXT | X: Modified Concentration | |
| Largest State Excess | Calc | Excess Concentration | If T = "FAIL", Calculation, else 0 | Y - ((X/100)*Z) | CURRENCY | X: Largest State Concentration (Limit) Y: Largest State Balance Z: Eligible Loan Balance T: Largest State - EC Assess | |
| Ineligible FICO - EC Calc | Calc | Excess Concentration | If T = "FAIL", Calculation, else 0 | Y - ((X/100)*Z) | CURRENCY | X: Ineligible FICO (Limit) Y: No FICO + Low FICO Balance Z: Eligible Loan Balance T: Ineligible FICO - EC Assess | |
| N Largest States Excess | Calc | Excess Concentration | If T = "FAIL", Calculation, else 0 | Y - ((X/100)*Z) | CURRENCY | X: Largest State Concentration (Limit) Y: Largest State Balance Z: Eligible Loan Balance T: Largest State - EC Assess | |
| Prime Loans - EC Calc | Calc | Excess Concentration | The excess concentration calculation of prime loans. | If T = "FAIL", Calculation, else 0 | Y - ((X/100)*Z) | CURRENCY | X: Prime Loan (Limit) Y: Prime Loan Balance Z: Eligible Loan Balance T: Prime Loans - EC Assess |
| N Largest States - EC Assess | Calc | Excess Concentration | Whether the concentration of the N largest states passes a certain threshold. | If X Actual > X Limit, "PASS", Else "FAIL" | TEXT | X: Largest State Concentration | |
| Ineligible FICO - EC Assess | Calc | Excess Concentration | Whether the low + no FICO score balance passes a certain threshold. | If X Actual > X Limit, "PASS", Else "FAIL" | TEXT | X: Ineligible FICO | |
| Total Excess | Calc | Excess Concentration | Sum (A,B,C,D,E,F,G,H,I,J) | CURRENCY | A: Risk - EC Calc B: Risk Level Eligibility - EC Calc C: Used - EC Calc D: N Largest States Excess E: Modified - EC Calc F: Largest State Excess G: Prime Loans - EC Calc H: WA Credit Score - EC Calc I: WA DTI - EC Calc J: Ineligible FICO - EC Calc | ||
| WA Credit Score - EC Calc | Calc | Excess Concentration | For Excess Concentrations - if WA Credit Score limit is breached $ amount affected | If T = "FAIL", Calculation, else 0 | Y - ((X/100)*Z) | CURRENCY | X: WA Credit Score Input (Limit) Y: WA FICO Score Z: Eligible Loan Balance T: WA Credit Score - EC Assess |
| Risk Level Eligibility - EC Calc | Calc | Excess Concentration | The excess concentration calculation of a risk threshold. | If T = "FAIL", Calculation, else 0 | Y - ((X/100)*Z) | CURRENCY | X: Risk Level Eligibility % (Limit) Y: Risk Level Eligibility Balance Z: Eligible Loan Balance T: Risk Level Eligibility - EC Assess |
| Risk - EC Calc | Calc | Excess Concentration | If T = "FAIL", Calculation, else 0 | Y - ((X/100)*Z) | CURRENCY | X: Risk Concentration (Limit) Y: Risk Balance Z: Eligible Loan Balance T: Risk - EC Assess | |
| Prime Loans - EC Assess | Calc | Excess Concentration | Whether the Prime Loans balance passes a certain threshold. | If X Actual > X Limit, "PASS", Else "FAIL" | TEXT | X: Prime Loan | |
| Risk Level Eligibility - EC Assess | Calc | Excess Concentration | Whether a certain risk threshold is met. | If X Actual > X Limit, "PASS", Else "FAIL" | TEXT | X: Risk Level Eligibility % | |
| WA DTI - EC Assess | Calc | Excess Concentration | Whether the WA debt to income ratio meets a certain threshold. | If X Actual > X Limit, "PASS", Else "FAIL" | TEXT | X: WA DTI | |
| WA DTI - EC Calc | Calc | Excess Concentration | If T = "FAIL", Calculation, else 0 | Y - ((X/100)*Z) | CURRENCY | X: WA DTI (Limit) Y: WA DTI Z: Eligible Loan Balance T: WA DTI - EC Assess | |
| Modified - EC Calc | Calc | Excess Concentration | The excess concentration calculation of modified loans. | If T = "FAIL", Calculation, else 0 | Y - ((X/100)*Z) | CURRENCY | X: Modified Concentration (Limit) Y: Modified Loans Balance Z: Eligible Loan Balance T: Modified - EC Assess |
| Monthly Vintage | Raw | Loan | DATE | ||||
| Verified Flag | Calc | Loan | A flag indicating whether a loan is verified. | If X = "Yes", "No", ELSE "Yes" | TEXT | X: Verification Certificate Flag | |
| Year Built | Raw | Loan | The year the property was built per the valuation report or underlying exposure document. | TEXT | |||
| Number of Loans | Calc | Loan | The aggregated number of loans represented in the aggregated balance. | Count the number of occurrences of the associated 'Borrower Identifier' that are found in the loan tape. | NUMBER | ||
| Natural Disaster Extensions | Raw | Loan | The number of extensions given to a borrower due to natural disasters. | NUMBER | |||
| Manual Exclusion | Calc | Loan | Exclusion of an asset in regards to the eligible pool. | 0 = "No", 1 = "Yes" | TEXT | ||
| Rediscount Rate | Raw | Loan | NUMBER | ||||
| Current Balance | Raw | Loan | Amount of loan outstanding as of pool cut off date, This should include any amounts that are secured by the mortgage and will be classed as principal in the transaction. | CURRENCY | |||
| Dealer ID | Raw | Loan | The identifier of the dealer. | TEXT | |||
| Original Balance | Raw | Loan | The initial balance of each loan at the cut-off date or pre-funded month. | CURRENCY | |||
| New/Used | Raw | Loan | Indicates if the underlying asset is new or used. | TEXT | |||
| UCC Flag | Calc | Loan | 0 = "No", 1 = "Yes" | TEXT | |||
| Date of Last Extension | Raw | Loan | The date of the last extension given to the borrower. | DATE | |||
| Parts Expense | Raw | Loan | The expense of parts to a vehicle, or piece of equipment. | CURRENCY | |||
| Counter | Calc | Loan | A value to allow for CRT calculations based on count | 1 | NUMBER | Assign each loan the value of 1 | |
| Extension Count | Raw | Loan | The number of contractual optional extentions terms . | NUMBER | |||
| Charge-Off Reason | Raw | Loan | The reason for the default of the loan. | TEXT | |||
| Original Balance Flag | Calc | Loan | A flag indicating the original loan amount not meeting a threshold set by the client. | If X <250 OR >50000, "Yes", ELSE "No" | TEXT | X: Original Balance | |
| Sale Price | Raw | Loan | The price achieved on sale of collateral in case of foreclosure. | CURRENCY | |||
| Cumulative Principal Repayment | Raw | Loan | The total amount of monies paid by a borrower has made to the lender above the scheduled payments due. | CURRENCY | |||
| Insurance Flag | Raw | Loan | A flag whether the borrower has insurance. | TEXT | |||
| State | Raw | Loan | Any State, Commonwealth or territory of the United States. | TEXT | |||
| Contract Stage Date | Raw | Loan | The date on which the contract was signed | DATE | |||
| Net Charged-Off | Raw | Loan | CURRENCY | ||||
| Payment To Income Percentage | Raw | Loan | The payment due to income percentage. | NUMBER | |||
| Charged-Off Principal Amount | Raw | Loan | The amount of the principal balance which was charged-off. | CURRENCY | |||
| Bankruptcy Date | Raw | Loan | Indicates the date on which a borrower filed for bankruptcy. | DATE | |||
| Material Modification Flag | Calc | Loan | A flag that indicates whether there has been a reduction in the interest rate, an extension of the term, a reduction in, or change in frequency of, any required payment or extension of a payment date or a reduction in the outstanding principal balance | 0 = "No", 1 = "Yes" | TEXT | ||
| Quarterly Vintage | Raw | Loan | Quarterly Vintage - a static version of the Vintage Qtr used in most data facilities.\ | TEXT | |||
| Rate Discount Amount | Raw | Loan | ACH interest rate discount received if the borrower is receiving an ACH discount | NUMBER | |||
| Active Duty Flag | Raw | Loan | TEXT | ||||
| Pool Identifier | Raw | Loan | Pool or Portfolio identifier / name of transaction. | TEXT | |||
| Down Payment | Raw | Loan | The initial payment made when something is bought on credit. | CURRENCY | |||
| Charged-Off Date | Raw | Loan | The default date of the loan | DATE | |||
| Product Type | Raw | Loan | Type of mortgage loans. | TEXT | |||
| Autopay Flag | Raw | Loan | A flag whether the borrower is on autopay for their loan payments. | TEXT | |||
| Extended Warranty Expense | Raw | Loan | the expense of the extended warranty to a borrower. | CURRENCY | |||
| Rental Flag | Calc | Loan | This flag indicates whether the Residential Property is a rental property. | If X = "lease", "Yes", ELSE "No" | TEXT | X: Collateral Type | |
| OEM Yield | Raw | Loan | NUMBER | ||||
| Default Flag | Calc | Loan | A flag indicating that either a payment or technical default has occurred. | If X > 120, "Yes", ELSE "No" | TEXT | X: Days Past Due | |
| Cumulative Recoveries | Raw | Loan | Cumulative recoveries – only relevant for cases with losses | CURRENCY | |||
| Borrower Verified Income | Raw | Loan | CURRENCY | ||||
| Custom Credit Tier | Raw | Loan | A custom defined tier to represent the rqange of credit scores that an individual falls into. | TEXT | |||
| Title Flag | Calc | Loan | If X = "No", Y="No", and Z = "No", "Yes", ELSE "No" | TEXT | X: Title Verification Status Y: UCC Flag Z: Verification Certificate Flag | ||
| Balance Ratio | Calc | Loan | To be used for graphing the percentage or ratio of assets in a given category. Should be calculated as 1/(Total Applicable Balance of Collateral) | X / Y | NUMBER | X: Outstanding Balance Y: Total Oustanding Balance of All Loans | |
| Zip Code | Raw | Loan | The zip code in which the collateral is located. | TEXT | |||
| FICO Score | Raw | Loan | A FICO® Score is a measurement of the relative degree of risk a borrower represents to a lender, i.e., that a borrower with a higher score may be less likely to default in payment than a borrower with a lower score. FICO® Score ranges from 300 - 850. | NUMBER | |||
| Tracked Vehicle Flag | Calc | Loan | A flag tracking the vehicle type. | If X = "tractor", "Yes", ELSE "No" | TEXT | X: Vehicle Type | |
| Extension Number | Raw | Loan | NUMBER | ||||
| Retail Price | Raw | Loan | CURRENCY | ||||
| Discounted Contract Balance | Raw | Loan | CURRENCY | ||||
| Extension Term | Raw | Loan | The contractual term of any optional extentions. | NUMBER | |||
| Vehicle Type | Raw | Loan | Type of vehicle (code) where 1 = luxury/sedan, 2 = pickup truck, 3 = SUV | TEXT | |||
| Debt to Income Ratio | Raw | Loan | The debt defined as the amount of underlying exposure outstanding as of data cut-off date. This includes any amounts that are secured by the mortgage and will be classed as principal in the securitization. | *100 | NUMBER | ||
| Vehicle Model | Raw | Loan | The name of a car product and sometimes a range of products. | TEXT | |||
| Advance Transfer Date | Raw | Loan | Date of transfer of the Advance from Lender to Borrower/Seller | DATE | |||
| Prime Flag | Calc | Loan | 0 = "No", 1 = "Yes" | TEXT | |||
| Co-Borrower FICO Score | Raw | Loan | The FICO Score of the co-borrower of a loan. | NUMBER | |||
| APR | Raw | Loan | Annual Percentage Rate | NUMBER | |||
| Days Past Due | Raw | Loan | The number of days in which a payment has not been made as of its due date. | NUMBER | |||
| Count Ratio | Calc | Loan | To be used for graphing the percentage or ratio of assets in a given category. Should be calculated as 1/(Total Count of Assets) | 1 / X | NUMBER | X: The count of all assets in the current tape This value is used to graph the % of loans in a given delinquency category | |
| Original OEM Fee | Raw | Loan | CURRENCY | ||||
| Title Verification Status | Calc | Loan | The status of the current title verification. | Mapping: 1 = "Yes, 0 = "No" | TEXT | ||
| Dealer Discount Fee | Raw | Loan | CURRENCY | ||||
| Offroad Flag | Calc | Loan | Off Road = "Yes", On Road = "No" | TEXT | |||
| Eligible Loan Flag | Calc | Loan | A flag indicating an asset meets all the of the key eligibility criteria of the facility. | If Rows 77 - 88 all = "No", "Yes", ELSE "No" | TEXT | ||
| Original Term Eligible Flag | Calc | Loan | A flag to indicate long loan terms. | If X < 2, "Yes", ELSE IF Y = "Yes" AND X => 84, "No", ELSE IF Y = "No" AND X =< 72, "No", ELSE "Yes" | TEXT | X: Loan Term Y: Prime Flag | |
| Delinquency Eligibility Flag | Calc | Loan | Mapped to Yes/No. Identifies assets that meet the delinquency criteria. | If X > 30 OR Y > 0, "Yes", Else, "No" | TEXT | X: Days Past Due Y: Days Past Due When Pledged | |
| Term Seasoning | Raw | Loan | The current number of periods from the seaonsing start date or loan start date (number of months). | NUMBER | |||
| Days Past Due When Pledged | Raw | Loan | Days past due when pledged. | NUMBER | |||
| Payment To Income Flag | Calc | Loan | If X > 21%, "Yes", ELSE "No" | TEXT | X: Payment To Income Percentage | ||
| Original OEM Fee % | Raw | Loan | NUMBER | ||||
| Current LTV | Raw | Loan | A percentage representing the current senior and sub-debt original balance over the value of the collateralized property. For non-first lien loans this should be the combined or total LTV. | NUMBER | |||
| First Payment Date | Raw | Loan | The first scheduled payment date | DATE | |||
| Relationship to Co-Borrower | Raw | Loan | The relationship of the borrower to the co-borrower. | TEXT | |||
| Origination Date | Raw | Loan | The date of original underlying exposure advance. | DATE | |||
| COVID Extensions | Raw | Loan | The number of extensions due to COVID-19. | NUMBER | |||
| Extensions Flag | Calc | Loan | A flag whether a borrower has needed extensions on payments. | If X > 2, "Yes", ELSE "No" | TEXT | X: COVID Extensions | |
| Trade in Equity | Raw | Loan | CURRENCY | ||||
| Collateral Type | Raw | Loan | The primary (in terms of value) type of asset securing the debt. | TEXT | |||
| Currently Bankrupt Flag | Calc | Loan | A flag indicating if the borrower is currently bankrupt. | If X is NOT blank and < Y, "Yes", ELSE "No" | TEXT | X: Bankruptcy Date Y: Request Date | |
| Loan Term | Raw | Loan | Original contractual term (use units to define days, months, years) | NUMBER | |||
| Credit Grade Flag | Calc | Loan | A flag indicating a below average credit grade. | If X > 8, "Yes" ELSE "No" | TEXT | X: Custom Credit Tier | |
| Vehicle Make | Raw | Loan | The brand of the the car’s manufacturer or companies who produced the car. | TEXT | |||
| Account Number | Raw | Loan | NUMBER | ||||
| Request Date | Raw | Loan | The date of a Lending Facility draw request | DATE | |||
| Monthly Payment | Raw | Loan | Current monthly payment | CURRENCY | |||
| Total Eligible Prime Balance | Calc | Pool | The total eligible prime balance. | If Y = "Yes" | Sum X | CURRENCY | X: Outstanding Balance Y: Prime Flag |
| Outstanding Balance | Calc | Pool | The unpaid, interest-bearing balance of a loan or loan portfolio. | Sum(X) for all loans | CURRENCY | X: Outstanding Balance | |
| Delinquency Ratio | Calc | Pool | As of any date of determination, a ratio (expressed as a percentage) computed by dividing (i) the aggregate amount of payments due and unpaid on a PACE Asset through such date by (ii) the PACE Asset Balance of all Eligible PACE Assets. | If X = "Yes" | Z/Y | NUMBER | X: Delinquency Eligibility Flag Y: Outstanding Balance (from Pool) Z: Outstanding Balance (from Collateral Collection |
| Total Eligible Non-Prime Balance | Calc | Pool | The total eligible sub-prime balance. | If Y = "No" | Sum X | CURRENCY | X: Outstanding Balance Y: Prime Flag |
| Total Ineligible Balance | Calc | Pool | Total principal balance minus approved ineligible loan amount | X - Y | CURRENCY | X: Oustanding Balance (from Pool) Y: Total Eigible Balance (from Pool) |