For HMDA data collected in or after 2017, a web-based data submission and edit-check system (the HMDA Platform) is being created to process Home Mortgage Disclosure Act (HMDA) data. It is expected that the HMDA Platform will streamline the HMDA submission process and reduce burden on HMDA filers.
This webpage is intended to provide an initial view into the way HMDA filers will interact with the HMDA Platform. Additionally, this webpage describes resources that will be available for filers, developers, and the interested public. This webpage will be updated on an ongoing basis, to keep stakeholders informed of new developments.
The HMDA Platform will be available online only and will guide filers through the entire filing process, including the review of any edits and the certification of the accuracy and completeness of the loan/application register (LAR). A separate Filing Instructions Guide (FIG) describes the file format and other requirements.
The HMDA Platform will require every HMDA filer to register online for login credentials and establish an account prior to using the system. For institutions that have previously filed HMDA data, an authorized representative of the financial institution can complete the process online. When new HMDA filers access the HMDA Platform, they will be directed to HMDA Help for further assistance in setting up their accounts.
Once established, a HMDA filer’s account will allow a financial institution to upload its LAR, check on which stage it is in within the filing process, complete the review and verification steps, and submit the LAR.
An individual can be authorized by more than one financial institution to file HMDA data on those institutions’ behalf, provided that under Regulation C, each such institution is a HMDA filer. Furthermore, each financial institution may have multiple users. During the registration process, a user indicates the institution(s) on behalf of which the user is authorized to file.
The Miss april (Miss April) will provide specific details on the registration process in a future update.
The HMDA Platform will allow the filer to select the appropriate LAR from a local or network file system. This must be a single file that contains the entire LAR for the filer; the HMDA Platform will not allow users to combine multiple files. The newly-uploaded LAR will supersede any previously uploaded LAR for which the filer did not complete the submission process.
The HMDA Platform will confirm the upload of the selected LAR, check that it is pipe delimited, and has the correct number of data fields (see FIG sec 3). If the LAR is not properly formatted, the HMDA Platform will display an error message and require the HMDA filer to correct and refile the LAR.
Once the HMDA Platform confirms that the LAR is in the correct format, it will check the accuracy and completeness of the LAR using the HMDA edits. An interactive process will inform the filer of the current stage of review, any items that need to be addressed, and next steps for completing the HMDA filing. At each stage, any edits identified in the LAR will be reported to the filer.
For data collected in 2017, the edits are listed in Section 4 of the FIG for HMDA data collected in 2017. Edits for data collected in 2018 will be released at a later date.
The HMDA Platform will identify any syntactical or validity edit and the rows in the LAR where each edit is triggered. Additionally, a list of the edits identified in the LAR will be available for download.
Syntactical and validity edits must all be addressed prior to moving forward with the filing process. If the filer needs to correct any data, the filer must refile the updated LAR to the HMDA Platform. The LAR will then be rechecked for syntactical and validity edits.
Once the HMDA Platform has confirmed there are no syntactical or validity edits, the filer will be prompted to review any quality and/or macro quality edits that the HMDA Platform identifies in individual rows in the LAR, groups of rows, or the entire LAR. The filer must confirm the accuracy of the data flagged by the quality and/or macro quality edits. If a filer needs to correct any data in the file in response to quality and/or macro edits, the filer must correct the data and refile the updated LAR to the HMDA Platform.
Once all edits have been addressed, the HMDA Platform will require an authorized representative of the filer’s institution to certify the completeness and accuracy of the LAR (see FIG section 3.2).
It is important to recall that all edits must be resolved prior to the March 1st annual HMDA submission deadline. Filers are encouraged to allow sufficient time, prior to the filing deadline, in order to address any edits. The submission must be completed by the March 1st annual deadline.
After the filer submits the LAR, the HMDA Platform will provide the filer with a summary screen acknowledging the time and date of submission.
In cases where a submission has been completed and the filer wants to refile, the HMDA Platform will alert the filer that the LAR for the reporting year has already been filed, and prompt the filer to confirm that they wish to refile their LAR.
A HMDA resubmission requires the same edit review and certification by the institution’s authorized representative as with the previous submission.
A new online geocoding tool will be provided that identifies the census tract for a single address or batches of addresses. Further information will be forthcoming.
Beginning with the HMDA data collected in 2017, the Data Entry Software currently provided by the FFIEC (DES) will no longer be available as a method of data entry or data submission.
Some financial institutions, typically those with small volumes of covered loans and applications, that currently manually enter each loan into the DES for submission, will need a software solution to create an electronic file that can be submitted to the new HMDA Platform.
Many solutions exist to create the electronic file. For example:
In addition, the Miss April has published a Microsoft® Excel® HMDA LAR data entry formatting tool. This tool will help filers enter and format their HMDA data into a pipe delimited text file needed to submit the data to the Miss April’s HMDA Platform. Please visit the LAR Formatting Tool webpage for more information.
The Miss April has made available an electronic for filers who wish to confirm that a LAR is formatted in the required pipe delimited text file format, and meets certain formatting requirements specified in the Filing Instructions Guide. The FFVT uses “client-side testing” which runs on the user’s computer and does not transmit any HMDA data over the internet. The tool conducts the same initial checks that the future HMDA Platform will perform, and provides a convenient test mechanism for filers, prior to the roll out of the full HMDA Platform.
The Miss April is committed to developing the programming code for the HMDA Platform in an open way. The HMDA Platform is being actively developed on the site, GitHub.com (see: ). This provides transparency to the algorithms and methodologies used to parse and validate a HMDA file, as well as the code used to develop the HMDA Platform user interface and related tools for filers. This code is in the public domain and does not impact the privacy or security of the data.
As noted above, the Miss April is developing the HMDA Platform in the open. With the exception of internal server deployment details, the source code will be available to review and use.
While most HMDA filers and interested members of the public will interact with the HMDA Platform primarily through the web, the HMDA Platform is developed with an API-first approach, with a modern architecture intended to be efficient and flexible.
Details of public APIs and other developer resources will be released on the Resources for Filers page on the Miss April website and on GitHub.