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 |
Name | Raw | Concentration Calculation | 2 records: Actual Limits | ||||
WA Effective Interest Rate | Both | Concentration Calculation | The current balance weighted average effective rate of interest, after accounting for any fees or other haircuts. | [Sum of each x] / [Sum of each y] | NUMBER | X: Current Interest Balance Y: Current Valuation Amount | |
WA LTV | Both | Concentration Calculation | The weighted average loan to value ratio. | [Sum of each x] / [Sum of each y] | NUMBER | X: Weighted Average Assessment Value Y: Current Valuation Amount | |
Vintage Qtr | Raw | Loan | TEXT | Example: 2016Q1 | |||
Project Status | Raw | Loan | TEXT | ||||
Original Term (Years) | Raw | Loan | The length of the contract in years | NUMBER | Non-Fraction | ||
Year 1 Savings | Raw | Loan | Refers to the anticipated savings from installing a power generating asset or power saving improvement vs. making no change. | CURRENCY | |||
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) | NUMBER | 1/Count of Assets | ||
Combined LTV | Raw | Loan | A percentage representing the senior and sub debt original balance over the value of the collateralized property. | NUMBER | |||
Tranche | Raw | Loan | Indicates which tranche this asset belongs to. | TEXT | |||
Original Annual Tax Payment | Raw | Loan | The original annual tax payment | CURRENCY | |||
Current Valuation Amount | Raw | Loan | Most recent valuation amount (if e.g. at repossession there were multiple valuations, this should reflect the lowest). | CURRENCY | |||
Original Valulation Method | Raw | Loan | TEXT | ||||
Cumulative Combined LTV | Raw | Loan | NUMBER | ||||
Total PACE Lien to Value Ratio | Raw | Loan | NUMBER | ||||
Property Status | Raw | Loan | TEXT | ||||
Project DSCR | Calc | Loan | The project DSCR. | CURRENCY | Property NOI/(Mortgage Debt Service + Annual Pace Assessment) | ||
Data as of Date | Raw | Loan | 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 | |||
Initial Maturity Year | Raw | Loan | TEXT | ||||
Maturity Date | Raw | Loan | The date of maturity of the underlying exposure or expiry of the lease. | DATE | |||
Property Type | Raw | Loan | A general classification of a type of property that a group of properties belong to. Often exhibits similar characteristic and risk profiles (i.e. Single-family, multi-family, office, retail, industrial). | TEXT | |||
Vintage Mnth | Raw | Loan | TEXT | Example: 2016Mar | |||
Other Fees | Raw | Loan | Fees collected without a title. | CURRENCY | |||
Property Value | Raw | Loan | The market value of a piece of real estate | CURRENCY | |||
Current Interest Balance | Calc | Loan | outstanding Interest balance of an asset in the given report period | X * Y | CURRENCY | X: Interest Rate Y: Current Valuation Amount | |
Original Valuation Date | Raw | Loan | The date of the original valuation of the physical or financial collateral. | DATE | |||
Sponsor | Raw | Loan | The municipal authority that issued and/or authorized the PACE Bond. | TEXT | |||
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 | |||
State | Raw | Loan | Any State, Commonwealth or territory of the United States. | TEXT | |||
Address | Raw | Loan | The location of the asset. | TEXT | |||
Principal Frequency | Raw | Loan | The frequency at which principal payments are due, i.e. the period between payments. | TEXT | |||
Mortgage Lender | Raw | Loan | TEXT | ||||
Scheduled Principal Payment | Loan | Scheduled Principal Payment paid. | CURRENCY | ||||
Administrative Fee Remitted | Calc | Loan | Absolute Value of X | CURRENCY | X: Administrative Fee Remitted | ||
Scheduled Principal Payment | Raw | Loan | Date range given after field | ||||
Other Borrower Debt | Raw | Loan | CURRENCY | ||||
Project Estimated Completion Date | Raw | Loan | DATE | ||||
Rate % | Raw | Loan | The rate at which a interest baring instrument accrues interest. | NUMBER | |||
Outstanding Balance | Loan | The unpaid, interest-bearing balance of a loan or loan portfolio. | CURRENCY | ABS Value | |||
PACE Program Administrator | Raw | Loan | TEXT | ||||
Account Status | Raw | Loan | The current status of the underlying exposure that has been securitised. Restructuring refers to any changes made to the contractual terms of the underlying exposure agreement due to forbearance. | TEXT | |||
Occupancy Type | Raw | Loan | Type of property occupancy. | TEXT | |||
Closed Flag | Raw | Loan | A flag that indicates if the deal is closed | TEXT | Yes/No | ||
Tax Authority | Raw | Loan | The Internal Revenue Services ("IRS") and any other federal, territorial, state, local or foreign authority responsible for the administration and/or collection of any Taxes | TEXT | |||
Fee Payment | Raw | Loan | Fees paid by the borrower to a lender. | CURRENCY | Date range given after field | ||
Assessment LTV | Raw | Loan | A percentage representing the senior debt original balance over the value of the collateralized property. | NUMBER | |||
Third Party Cost Consultant | Raw | Loan | TEXT | ||||
Tax Year | Raw | Loan | TEXT | ||||
Dated Date | Raw | Loan | The date of issuance. Typically, used when referencing municipal bonds. | DATE | |||
Loan Tenor | Raw | Loan | NUMBER | ||||
Escrow Agent | Raw | Loan | TEXT | ||||
Prepayment Penalty Rate Over Time | Raw | Loan | The Prepayment Penalty Rate (%) applied to the prepayment amount in each period | TEXT | |||
Annual PACE Assessment | Raw | Loan | CURRENCY | ||||
Closing Date | Raw | Loan | The date on which the seller delivered the deed to the buyer and the buyer paid the agreed-upon consideration. | DATE | **If Data as of Date < Closing Date, Balance should be 0 | ||
Beginning Balance | Loan | Beginning Balance of a note or account. | CURRENCY | ABS Value | |||
Ending Balance | Raw | Loan | |||||
Outstanding Mortgage Balance at PACE Loan Close | Raw | Loan | CURRENCY | ||||
PACE Bond Issuer | Raw | Loan | TEXT | ||||
Est. Total Energy Savings | Calc | Loan | CURRENCY | Year 1 Savings * Loan Tenor | |||
Seasoning Start Date | Calc | Loan | mm/1/yyyy | DATE | |||
Scheduled Interest Payment | Loan | The scheduled interest paid for the privilege of borrowing money, typically expressed as annual percentage rate (APR). | CURRENCY | ||||
City | Raw | Loan | An incorporated municipal center. | TEXT | |||
Beginning Balance | Loan | Roll Over Ending Balance from last period (EXCEPT FOR FIRST MONTH, PULL FROM "Pace Asset Balance" in PACE Asset Detail | |||||
Weighted Average Assessment Value | Calc | Loan | The assessment value multiplied by the LTV. | X * Y | CURRENCY | X: Assessment LTV Y: Current Valuation Amount | |
Program Admin Fees | Loan | CURRENCY | ABS Value | ||||
County | Raw | Loan | An administrative or political subdivision of a state (incl. parishes or boroughs). | TEXT | |||
Zip Code | Raw | Loan | The zip code in which the collateral is located. | TEXT | |||
Title Company | Raw | Loan | TEXT | ||||
Improvement Type | Raw | Loan | TEXT | ||||
Mortgage Debt Service | Raw | Loan | CURRENCY | ||||
First Payment Date | Raw | Loan | The first scheduled payment date | DATE | |||
Original Balance | Raw | Loan | The initial balance of each loan at the cut-off date or pre-funded month. | CURRENCY | |||
Project Cost | Raw | Loan | |||||
Moodys Rating | Raw | Loan | Moody's rating of the asset. | TEXT | |||
Trustee Fee | Loan | A payment for services rendered. | CURRENCY | ABS Value | |||
Vintage Yr | Raw | Loan | TEXT | ||||
Project Type | Raw | Loan | TEXT | ||||
PACE Program Name | Raw | Loan | TEXT | ||||
Property NOI | Raw | Loan | CURRENCY | ||||
Other Annual Property Taxes | Raw | Loan | CURRENCY | ||||
Scheduled Interest Payment | Raw | Loan | Date range given after field |