DUS Data Digitizer

Structured data sets must include any Fannie Mae Multifamily Deal Identifier from DUS Gateway or other acquisition systems. Since only Lenders have access to these Fannie Mae systems, Lenders and Third-Party Report Vendors should agree on a process to share this Deal Identifier information and include it in the structured data sets.

The Collateral Reference Number is an optional data field hence it shouldn’t need to be included in the structured data sets.

Yes, structured data sets need to adhere to a file naming convention. DUS Data Digitizer will not allow the upload of structured data sets that do not adhere to the prescribed file naming convention.

For deals with one property, use Deal Identifier_Report Type, e.g., 123456_PCA. xml or 123456_PCA. csv. For deals with multiple properties, use Deal Identifier_Report Type_Numeric Suffix, e.g., 123456_PCA_1.xml, 123456_PCA_2.xml,… 123456_PCA_n.xml or 123456_PCA_1.csv, 123456_PCA_2.csv,… 123456_PCA_n.csv. There is flexibility to add other characters Lenders deem necessary as long as “_” precedes the additional characters, e.g., 123456_PCA_XYZbuilding.xml or 123456_PCA_XYZbuilding.csv; 123456_ESA_XYZbuilding.xml or 123456_ESA_XYZbuilding.csv.

Yes, only in CSV format. Data is expected for all reports in row 11. Additional data is expected in row 21-97 for the Property Condition Assessment.

PCA structured data sets including a Capital Item Category whose Capital Items do not belong in that Category will be rejected.

Supplemental structured data sets will be required for third-party reports with a signature date of September 30, 2020 and later.  Fannie Mae released Multifamily Mortgage Business Lender Letter 20-09 highlighting information regarding this specific deadline.

No, we will not reject your deal through the acquisition certification process if your deal is missing a structured data set during the initial implementation phase.

The Fannie Mae DUS Third-Party Report Standards and Report Specifications Package are available on Fannie Mae’s website under the Multifamily Learning Center’s Learning Library. Access the report standard details using the hyperlinks above.

The Fannie Mae DUS Third-Party Report Specifications Package includes two sets of templates (XSD and Excel) and two sets of sample data files (XML and CSV) for each third-party report. Fannie Mae will, therefore, be able to accept XML data files, CSV data files or a combination of both formats.

Yes. The requirement for the narratives for third-party reports will not change. The new standard data set requirements will simply require the structured data supplements to accompany report narratives.

Yes. The requirements for the site inspection and its corresponding MBA Master Inspection Form will not change.

Yes. Structured data supplements will be required for Streamlined Property Condition Assessments. The technical specifications created for the Base Property Condition Assessment will also work for the Streamlined Property Condition Assessment.

No. However, the Multifamily Selling and Servicing Guide has been updated to require delivery of structured data and include a report narrative if the Lender orders a Zoning Report.

There are two parts to the transmission of third-party report data sets — first, from third-party report vendors to DUS Lenders; and second, from DUS Lenders to Fannie Mae. While each DUS Lender will determine the transmission method it will accept for delivery of data from its third-party report vendors, Fannie Mae has established the data transmission methods for delivery from DUS Lenders to Fannie Mae.

We understand that third-party report vendors collect data while on site, conducting the assessments. This data is utilized to create report narratives. We expect the same data to be leveraged in the creation of the structured data supplements in CSV or XML format. No data extraction from narratives is expected, although vendors are free to use this technique if they find it useful in assuring consistency between the report and the data set.

Refer to the Business Glossary on the Fannie Mae DUS Third-Party Report Standards for the data point definition. Free-form text descriptions can be leveraged to provide additional information when appropriate.

Yes, structured data supplements will be required for specialty assets such as Seniors, Students, etc. Additionally, PCA Modules corresponding to specialty assets will continue to be required.

See Years of Construction in the Business Glossary. The data point is defined as, "A free-form text to capture the years the multiple buildings of a property were constructed."

No. For any given property, structured data supplements could be submitted in XML, CSV or a combination of both formats.

For the foreseeable future, Fannie Mae will require that structured data supplements are submitted along with final versions of the third-party reports. This requirement may change in the future.

In the fall of 2019, Fannie Mae released the Multifamily Mortgage Business Lender Letter 19-09 highlighting the new standard data set requirements, scope of impacted reports, actions required, and effective date. Fannie Mae also announced information sessions for DUS Lenders which were conducted in 2019. Fannie Mae and DUS Lenders co-hosted additional information sessions in March 2020 which were open to third-party report vendors.