CREFC IRP Legend Crosswalk Tables

**Description:**

The "CREFC IRP Legend Crosswalk Tables" dataset provides a detailed mapping of codes and their corresponding descriptions from the legend of version 8.4 of the CREFC Investor Reporting Package (IRP). These tables serve as a critical reference for professionals who need to interpret and understand the standardized codes used in CREFC IRP data, enabling seamless integration, analysis, and reporting across multiple datasets.

**Scope, Scale, and Value:**

This dataset includes all codes and descriptions from the IRP version 8.4 legend, providing users with a comprehensive crosswalk that translates codes into full names or detailed descriptions. It is designed to be used in conjunction with other CREFC IRP data, allowing for straightforward joining and mapping processes. By incorporating this dataset, users can enhance data accuracy, streamline data processing, and ensure consistent reporting standards across their organization.

**Sample Tables and Schemas:**

- **Table 1: crefc_irp_codes_masterservicers**
- **Sample Fields:**
- Code (e.g., "ARB")
- Full_Name (e.g., "Arbor Commercial Mortgage")
- **Table 2: crefc_irp_codes_interestratetype**
- **Sample Fields:**
- Code (e.g., "1")
- Description (e.g., "Fixed")
- **Table 3: crefc_irp_codes_propertystatus**
- **Sample Fields:**
- Code (e.g., "2")
- Description (e.g., "REO")

**Data Sources:**

The dataset is based on the official CREFC Investor Reporting Package (IRP) version 8.4 legend, which is a trusted industry standard for reporting in the commercial real estate finance sector. This dataset will empower users to correctly interpret and utilize CREFC IRP data by providing a reliable crosswalk between codes and their corresponding full names or descriptions.