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 |
Tranche Name | Calc | Bond | The tranche name of a bond (i.e. A, A1, B, C, etc.) | TEXT | A-1 A-2-A A-2-B A-3 B C D | ||
Report Date | Raw | Bond | The date of the servicer report/cashflow report | DATE | |||
Tranche Size | Raw | Bond | The total value in the tranche that contains this asset. | CURRENCY | |||
Beginning Balance | Raw | Bond | Beginning Balance of a note or account. | CURRENCY | |||
Current Interest Rate | Raw | Bond | Current interest rate (%). | NUMBER | |||
Residual Payment | Raw | Bond | A payment paid into a residual tranche. | CURRENCY | |||
Principal Payment | Calc | Bond | Principal payment made to a ABS Tranche. | Sum {12}:{17} | CURRENCY | Sum {12}:{17} to get an aggregate principal payment for the period | |
Original Note Balance | Raw | Bond | CURRENCY | ||||
Interest Rate Type | Calc | Bond | The interest rate type that the loan uses. | For all X, Y = FIXED | TEXT | X = Tranche Name Y = Interest Rate Type | |
Current Interest Balance | Raw | Bond | outstanding Interest balance of an asset in the given report period | CURRENCY | |||
Bond Factor | Raw | Bond | The ratio of the current bond balances to the original bond balance | NUMBER | |||
Reserve Initial Balance | Raw | Deal | The initial amount of proceeds deposited in the reserve account. | CURRENCY | |||
Name | Deal | SDART 2020-4 | |||||
Current Period Net Loss | Raw | Deal | The current period's net loss | CURRENCY | |||
Reserve Account Balance | Raw | Deal | CURRENCY | ||||
Overcollateralization Percentage | Raw | Deal | 1 - (Class A Note and Class B Note balance) / (Pool Balance) | NUMBER | |||
Overcollateralization Amount | Raw | Deal | The positive difference of (a) the sum of, without duplication (i)the Aggregate PACE Asset Balance minus the Excess Concentration Amount, (ii) amounts on deposit in the Liquidity Reserve Account (iii) the amount on deposit in the Collection Account. | CURRENCY | |||
Reserve Withdrawal | Raw | Deal | Amounts withdrawn from a reserve account. | CURRENCY | |||
Target Overcollateralization Amount | Raw | Deal | As of any date of determination, five (5) percent of the Aggregate PACE Asset Balance | CURRENCY | |||
Current Period Average Portfolio Balance | Raw | Deal | The current period's average portfolio balance. | CURRENCY | |||
Reserve Account Required Amount | Raw | Deal | reserve account requirement | CURRENCY | |||
Reserve Deposit | Raw | Deal | The amount deposited into a reserve account in this period. | CURRENCY | |||
Vehicle Type | Calc | Loan | Type of vehicle (code) where 1 = luxury/sedan, 2 = pickup truck, 3 = SUV | when X = 1 = Luxury/Sedan, when X = 2, Pickup Truck, when X = 3, SUV | TEXT | X = vehicleTypeCode | |
Next Interest Rate | Calc | Loan | The next period's interest rate (%). | X*100 | NUMBER | X = nextInterestRatePercentage | |
Actual Interest Collected Amount | Raw | Loan | The reported net interest paid to the collection account. | CURRENCY | |||
Paid-off Flag | Calc | Loan | Identifies loans that have been paid off. | X = 1: "Not delinquent when paid off" X = 3: "Delinquent when paid off" X = 4: "Unknown" | TEXT | X: zeroBalanceCode | |
Vehicle Year | Raw | Loan | Describes approximately when a product was produced, and usually indicates the coinciding base specification (design revision number) of that product. | TEXT | |||
Charged-Off Principal Amount | Raw | Loan | The amount of the principal balance which was charged-off. | CURRENCY | |||
Payment To Income Percentage | Calc | Loan | The payment due to income percentage. | X*100 | NUMBER | X = paymentToIncomePercentage | |
Repaid Date | Raw | Loan | DATE | if there is a date, the ending balance is $0 | |||
Repossessed Asset Flag | Calc | Loan | A flag indicating if the asset has been repossessed. | True = "Yes" and False = "No" | TEXT | FALSE = no, not repossessed TRUE = yes, repossessed | |
Model Type (New/Used) | Raw | Loan | Indicates if the underlying asset is new or used. | NUMBER | new = 1, used = 2 Map field twice. First to Model Type (New/Used) as a number | ||
Origination Date | Raw | Loan | The date of original underlying exposure advance. | DATE | |||
Maturity Date | Raw | Loan | The date of maturity of the underlying exposure or expiry of the lease. | DATE | |||
Scheduled Principal Payment | Raw | Loan | Scheduled Principal Payment paid. | CURRENCY | |||
Vehicle Model Name | Raw | Loan | The name of manufacturers model. | TEXT | |||
Total Actual Amount Paid | Raw | Loan | The reported amount paid. | CURRENCY | |||
Remaining Term | Raw | Loan | Remaining months of a contract. | NUMBER | |||
New/Used | Calc | Loan | When Model Type (New/Used) = 1, New/Used = New When Model Type (New/Used) = 2, New/Used = Used | new = 1, used = 2 *see condition Second, using Model Type (New/Used) map to meaning of 1, 2 in the field New/Used | |||
Income Verification for Primary Income | Calc | Loan | Type of verification for primary income. | 1 = Not Stated/Not Verified 2 = Stated/Not Verified 3 = Stated/Partially Verified 4 = Stated, Level 4 Verified 5 = Stated, Level 5 Verified | TEXT | ||
Days Past Due | Raw | Loan | The number of days in which a payment has not been made as of its due date. | NUMBER | |||
Co-Obligor Indicator | Calc | Loan | Indicates if there is a co-obligor on the financial obligation. | when X = True, 'Yes' X = False, 'No' | TEXT | ||
Obligor Employment Verification | Calc | Loan | Obligor employment verification type (1 = not stated/not verified, 2 = stated/not verified, 3 = stated/level 3 verified (level 3 verification = direct independent verification with a third party of the obligor's current employment)) | 1 = Not Stated/Not Verified 2 = Stated/Not Verified 3 = Stated/Level 3 Verified | TEXT | ||
Reporting Period Actual End Balance Amount | Raw | Loan | The reported ending balance. | CURRENCY | |||
Interest Paid Through Date | Raw | Loan | The last date interest was due and paid. | DATE | |||
Repossessed Proceeds Amount | Raw | Loan | The amount of the Repossessed proceeds. | CURRENCY | |||
Servicer | Raw | Loan | The entity that collects principal and interest payments from obligors and administers the portfolio after transaction closing. | TEXT | |||
Asset Value | Raw | Loan | The monetary worth of an asset. | CURRENCY | |||
Rate % | Calc | Loan | The rate at which a interest baring instrument accrues interest. | X*100 | NUMBER | X = originalInterestRatePercentage | |
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 | True = "Yes" and False = "No" | TEXT | TRUE = modification, FALSE = no modification | |
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 | |||
Recovered Amount | Raw | Loan | The total recoveries (regardless of their source) on the (defaulted/charged-off/etc.) debt, net of costs. It should include all sources of recoveries, not just proceeds from the disposal of any collateral. | CURRENCY | |||
Principal Adjustment | Raw | Loan | Other Principal Adjustments. | CURRENCY | |||
Actual Principal Collected Amount | Raw | Loan | The reported net principal paid to the collection account. | CURRENCY | |||
Originator | Raw | Loan | Lender that advanced the original loan. | TEXT | |||
Original Term | Raw | Loan | The length of the contract. | NUMBER | |||
Vehicle Manufacturer Name | Raw | Loan | The name of the vehicle manufacturer. | TEXT | |||
Original Loan Amount | Raw | Loan | The original total amount of the loan | CURRENCY | |||
Delinquency Category | Calc | Loan | Defined categories, based on source data, for delinquency | When X < 31 then Current When X >= 31 and < 61 then "31 - 60 Days Delinquent" When X >= 61 and < 91 then "61 - 90 Days Delinquent" When X >= 91 and < 121 then "91 - 120 Days Delinquent" when X >= 121 then "121+ Days Delinquent" | TEXT | X: Days Past Due | |
Bureau Score Provider | Raw | Loan | Who has provided the score. For continental Europe give name of provider. | TEXT | |||
Servicing Fee Percentage | Calc | Loan | The annual percentage due to the loan servicer | X*100 | NUMBER | X = servicingFeePercentage | |
Other Fees | Raw | Loan | Fees collected without a title. | CURRENCY | |||
Reporting Period Scheduled Payment Amount | Raw | Loan | The reported scheduled payments. | CURRENCY | |||
Actual Other Collected Amount | Raw | Loan | The reported additional amounts paid to the collection account. | CURRENCY | |||
Unscheduled Principal Payment | Calc | Loan | The principal payments that were made in excess of any scheduled principal due. | if X - Y >= 0, X - Y if X - Y < 0, 0 | CURRENCY | X = Actual Principal Collected Amount Y = Scheduled Principal Payment | |
First Payment Date | Raw | Loan | The first scheduled payment date | DATE | |||
Next Payment Amount | Raw | Loan | The amount due to be paid in the next period. | CURRENCY | |||
State | Raw | Loan | Any State, Commonwealth or territory of the United States. | TEXT | |||
Grace Period | Raw | Loan | Indicates the number of months during which interest accrues but no payments are due from the obligor | NUMBER | |||
Scheduled Interest | Raw | Loan | The scheduled interest due for the privilege of borrowing money, typically expressed as annual percentage rate (APR). | CURRENCY | |||
61-90 Balance | Raw | Pool | 61-90 day (2 month) delinquency Balance | CURRENCY | |||
Ending Balance | Raw | Pool | The balance from the beginning of the period adjusted for any principal distribution or adjustment made over the period. | CURRENCY | |||
Collection Period End Date | Raw | Pool | The end date for current period collection | DATE | |||
Previous Payment Date | Raw | Pool | This is the last date for which a payment has been made for a deal. | DATE | |||
31-60 Count | Raw | Pool | 31-60 Count | NUMBER | |||
Collection Period Begin Date | Raw | Pool | The beginning date for current period collection | DATE | |||
91-120 Count | Raw | Pool | 91-120 Count | NUMBER | |||
Total Delinquencies | Raw | Pool | Total value of delinquencies. | CURRENCY | |||
Number of Loans | Raw | Pool | The aggregated number of loans represented in the aggregated balance. | NUMBER | |||
61-90 Count | Raw | Pool | 61-90 Count | NUMBER | |||
Principal Distributable Amount | Raw | Pool | principal distributable amount | CURRENCY | |||
Cumulative Net Loss Ratio | Raw | Pool | The Cumulative Net Loss Ratio (Net losses since the Cut-off Date / Pool Balance as of the Cut-off Date) | NUMBER | |||
121+ Count | Raw | Pool | 121+ Count | NUMBER | |||
WAC | Raw | Pool | Weighted Average Coupon | NUMBER | |||
Servicer Fee | Raw | Pool | Fee paid to the servicer | CURRENCY | |||
Current Period Net Loss Ratio | Calc | Pool | The current period's net loss ratio (typically current period net loss/current period avg portfolio balance) | (X / Y)*100 | NUMBER | X = Current Period Net Loss, Y = Current Period Average Porfolio Balance | |
Pool Cut-off Date | Raw | Pool | Pool or Portfolio cut-off date. All dates take DD-MM-YYYY format. | DATE | column header is diagonal to the data we want to pull | ||
Interest Day Count | Raw | Pool | The interest day count determines how the loan accrues interest. | TEXT | |||
Servicer Fee MOVE TO DEAL? | Raw | Pool | |||||
WA Remaining to Maturity Term | Raw | Pool | weighted average time remaining to maturity of pool of loans | NUMBER | |||
121+ Balance | Raw | Pool | 121+ day delinquency Balance | CURRENCY | |||
Pool Factor | Raw | Pool | A measure of how much of the original loan principal remains in an asset-backed security | NUMBER | |||
31-60 Balance | Raw | Pool | 31-60 day (1 month) delinquency Balance | CURRENCY | |||
Payment Date | Raw | Pool | payment date | DATE | |||
Available Funds | Raw | Pool | funds available for cash flow | CURRENCY | |||
Original Collateral Balance | Raw | Pool | The original underlying exposure principal balance (inclusive of capitalized fees) at origination. | CURRENCY | column header is diagonal to the data we want to pull | ||
Repossessed Inventory Amount | Raw | Pool | The number of repossessed assets. | NUMBER | |||
Static | Pool | Pool | |||||
Number of Loans - Beginning | Raw | Pool | The beginning number of loans in a pool or deal | NUMBER | column header is diagonal to the data we want to pull | ||
Total Delinquencies Count | Raw | Pool | Total Delinquencies Count | NUMBER | |||
91-120 Balance | Raw | Pool | Balance of loans 91-120 (3 months) delinquent | CURRENCY | |||
Days in Collection Period | Raw | Pool | The number of days in the current collection period | NUMBER | |||
Deal Closing Date | Raw | Pool | DATE | column header is diagonal to the data we want to pull | |||
WA Original Term | Raw | Pool | NUMBER |