CREFC IRP Standard: Commercial Mortgage-Backed Securities Data

# **Overview**

This dataset provides comprehensive, CREFC IRP-compliant data on Commercial Mortgage-Backed Securities (CMBS) conduit deals, meticulously sourced and curated from publicly available information on the EDGAR SEC.gov database. Covering CMBS conduit deals since 2017, this dataset offers standardized reporting in alignment with the Commercial Real Estate Finance Council (CREFC) Investor Reporting Package (IRP) standards. It serves as a critical tool for investors, analysts, and financial institutions seeking consistent, transparent, and detailed loan and property performance metrics across a wide range of commercial real estate assets.

# **Scope and Value**

The dataset includes detailed loan-level and property-level information such as loan modifications, property valuations, servicing actions, payment statuses, financial metrics, and more. By adhering to CREFC IRP standards, it provides consistency and comparability, ensuring that users can easily integrate this data into their existing analysis workflows. This data is valuable for assessing loan performance, predicting future risk, and making informed investment decisions.

# **Sample Tables and Schemas**

## crefc_irp_schedulealfile_paid

- asset_number_type TEXT
- prospectus_loan_id TEXT
- group_id TEXT
- reporting_period_begin_date TEXT
- reporting_period_end_date TEXT
- loan_contributor_to_securitization TEXT
- origination_date TEXT
- original_note_amount TEXT
- original_term_of_loan TEXT
- maturity_date TEXT
- original_amortization_term TEXT
- original_note_rate TEXT
- note_rate_at_contribution TEXT
- interest_accrual_method TEXT
- interest_rate_type TEXT
- original_interest_only_term TEXT
- first_loan_payment_due_date TEXT
- underwriting_indicator TEXT
- lien_position_at_contribution TEXT
- loan_structure TEXT
- payment_type TEXT
- periodic_pi_payment_at_contribution TEXT
- scheduled_principal_balance_at_contribution TEXT
- payment_frequency TEXT
- number_of_properties_at_contribution TEXT
- number_of_properties TEXT
- grace_days_allowed TEXT
- interest_only_yn TEXT
- balloon_yn TEXT
- prepayment_premium_indicator TEXT
- negative_amortization_allowed_yn TEXT

This dataset also includes views for each filing where the column names are the CREFC short codes. For example LoanPeriodic columns are L1, L2, L3, etc. These are convenience views for use in harmonizing this dataset with your own CREFC IRP tables.

# **Data Sources**

This data is derived from the EDGAR SEC.gov database, a publicly accessible source of information on CMBS conduit deals. You can purchase the raw XML filings in the [CMBS Schedule AL - XML](https://app.snowflake.com/marketplace/listing/GZT0ZYQ5625/cmd-rvl-command-reveal-cmbs-schedule-al-xml?originTab=provider&providerName=CMD%252BRVL%2520(Command%2520Reveal)&profileGlobalName=GZT0ZYQ5618) dataset on the Snowflake marketplace. The dataset includes comprehensive data on all CMBS conduit deals filed since 2017. The information has been shaped into CREFC IRP standardized files and reports, providing a valuable resource for those interested in data contracts and the practical application of standardized financial data.

By transforming the raw public data into CREFC IRP format, this dataset demonstrates an exercise in data contracts, enabling users to benefit from consistent data quality, format, and usability.

# Related Datasets

Upstream this data is sourced from [CMBS Schedule<br/>AL - XML](https://app.snowflake.com/marketplace/listing/GZT0ZYQ5625/cmd-rvl-command-reveal-cmbs-schedule-al-xml?originTab=provider&providerName=CMD%252BRVL%2520(Command%2520Reveal)&profileGlobalName=GZT0ZYQ5618). The free [CREFC IRP Legend Crosswalk Tables](https://app.snowflake.com/marketplace/listing/GZT0ZYQ5636/cmd-rvl-command-reveal-crefc-irp-legend-crosswalk-tables?originTab=provider&providerName=CMD%252BRVL%2520(Command%2520Reveal)&profileGlobalName=GZT0ZYQ5618) is a companion dataset to this one which provides crosswalk tables to lookup the various CREFC codes into friendly names and descriptions. [CMBS Tenant Normalization Training Dataset](https://app.snowflake.com/marketplace/listing/GZT0ZYQ562L/cmd-rvl-command-reveal-cmbs-tenant-normalization-training-dataset?originTab=provider&providerName=CMD%252BRVL%2520(Command%2520Reveal)&profileGlobalName=GZT0ZYQ5618) is an example downstream dataset which is curated from a subset of the data in this dataset.

# Examples

The data in this dataset is used to power some pages on [https://dealcharts.org](https://dealcharts.org), for example [BMARK 2024-V10 - Charts and Resources](https://dealcharts.org/capitalmarkets/abs/cmbs/bmark2024-v10/). Also find [a Count.co canvas that allows the user to explore the amount of multifamily collateral in a given CMBS deal](https://count.co/canvas/Df2wE081wBE).

# Metadata

Use the search bar on [https://discover.cmdrvl.com](https://discover.cmdrvl.com/) to find tables and columns in this dataset and many others along with other valuable metadata.

# Disclaimer(s)

Please note that, since this data is sourced from the EDGAR SEC.gov database and not directly from trustee sites, it does not contain every field defined in the CREFC IRP standards. The dataset is shaped in alignment with the CREFC IRP format but is limited to the fields that are publicly available from SEC filings.This dataset is not a replacement for purchasing the CREFC IRP from a certified data provider - rather it is intended as a supplement to those data feeds and a head start for integrations that rely on the CREFC IRP format.

In addition, while this dataset contains FinancialFile and BondFile tables, these tables are very sparsely populated as the ScheduleAL filing does not contain detailed line by line financials or bond information.

搜集汇总

背景与挑战

背景概述

该数据集提供2017年以来符合CREFC IRP标准的商业抵押贷款支持证券(CMBS)标准化数据，包含贷款和房产级别的详细信息，数据来源于SEC公开数据库并经过规范化处理，适用于投资分析和风险评估。