RiskExec Release Notes - January 27, 2021

January 28, 2021
RiskExec has recently been updated to include the following enhancements.

FFIEC Geocoding

RiskExec previously released the FFIEC Geocoding option. With this new feature, users can compare any discrepancies found when examining current RiskExec geocoding to FFIEC geocoding by opening their file and clicking the “FFIEC Geocoding” button in the side menu.  As a reminder, this is a new permission and to gain access, the Primary User of an institution must request access for each individual user.

Based on user feedback, in this release, RiskExec has made some updates to this new feature.

When a user opens the FFIEC Geocoding tab, the number of records in the list will now be displayed in the upper left-hand corner.

FFIEC Geocoding tab now indicates the number of records in the list

RiskExec has also added a record’s application number and hyperlinked this to the application detail page.  A user will now be able to click on the hyperlinked application number to access the full application detail page.

The application number has been added and is hyperlinked to the application detail page

When a user reviews the RiskExec Geocode column, they will now be able to see the source that was used to geocode that record in RiskExec.  If that source is “Manual,” then the option to update the record to an FFIEC geocode has been removed.  This is because the RiskExec system will not override manually geocoded records.  However, RiskExec did want to provide a comparison of a manual geocode to the FFIEC geocode results for the user to be able to view and decide if it is necessary for them to update their manual geocode.

The option to select a manual geocode to be updated to FFIEC Geocoding results has been removed

To update the manually geocoded record, a user will be able to click through to the application detail page by clicking on the application number in the list.  There, the user will be able to manually update the geocoded information to the FFIEC results should they choose to do so.

To update a manual geocode to the FFIEC geocode results, a user will have to update the property information on the application detail page

Lastly, a user can now hide records from the FFIEC Geocoding list that a user has audited and decided to keep the RiskExec Geocode results. To do so, a user must add ‘GCFF’ to the record’s “Audited Checks” tab on the application detail page.  The code “GCFF” indicates that a user has reviewed that record and has decided to keep the existing RiskExec geocoding results. 

Add “GCFF” to the Audited Checks tab on the application detail page to audit addresses in the FFIEC Geocoding tab- this indicates that you are keeping the RiskExec Geocode

This then allows a user to hide records that have already been audited by un-checking “Include Audited Addresses” on the FFIEC Geocoding tab.

Uncheck “Include Audited Addresses” to remove audited addresses from the FFIEC Geocoding tab


RiskExec has added new details that must be confirmed when a user clicks “Submit LAR” in the HMDA module or “Submit File” in the CRA module, and begins the process of creating a submission file.  The checklist now requires a user to confirm the file that they are submitting, the institution’s respondent name, LEI or Respondent ID, and agency code prior to submitting their files.


RiskExec has standardized the way that calculations are made on the loan amounts in HMDA data for years 2018 and forward in both of the File Crosstab and File Comparison reports.  Previously, the reports were totaling and rounding the whole dollar amounts in the loan amount field differently.  One report was rounding each individual loan amount value and then providing the sum, while the other report was summing the total, then rounding and dividing by 1,000.  All values are now totaled based on the whole value of dollars and cents in the field and then rounded to either the nearest whole dollar value (File Comparison Report) or rounded to the nearest whole dollar value and then divided by 1,000 (File Crosstab Report). This will ensure that these reports and their subtotals are accurate to the dollar.

RiskExec has added a new regulatory report within the FFIEC Interagency Core Tables report.  This new report is called, “Distribution of Branch Delivery System and Branch Openings/Closings.”  It can be pulled based on the rating area: Assessment Area, State, or MSA.  The report will show the percentage of the rated area’s deposits, the number of branches per rated area, the percentage of branches per rated area, and the percent of locations of branches by low, moderate, middle, or upper incomes of geographies.  It also showcases the net change in location of branches (ie. the number of openings and closing of branches in a given area).  And lastly, it will show the percent of the population within each geographic area based on income level. This report relies on the user having accurate branch closing/opening information in RiskExec. For more information on how to maintain this branch list please contact the RiskExec support team at RiskExec.support@asurity.com

Distribution of Branch Delivery System and Branch Openings/Closings report found in the FFIEC Interagency Core Tables report in Regulatory Reports

Batch Geocoding

A user can now access a list of results that were geocoded in the Batch Geocoding module by clicking “View Results.”  When a user views the results, they also have the option to edit the report format.  This is very similar to how the application list and report formatting operates in both the HMDA and CRA modules. 

View Results in Batch Geocoding
Batch Geocoding Results
Update the Report Format in Batch Geocoding


Now when a user selects the “Single Field Update” to update a single field in either the HMDA, CRA, or Fair Lending module, they can upload a pipe-delimited .txt file to use for the Single Field Update import format. This is in addition to the current .csv option.

Sign up for news + updates

Expert insights and regulatory updates on RegTech, compliance management, and fair lending.

Questions? Comments?

Contact RiskExec customer support at riskexec.support@asurity.com.

Anurag Agarwal, PhD

President, RiskExec

Recommended Resources

Goals Module Overview

Learn more about the Goals Module and its key monitoring and reporting features.

Reg+Tech Magazine Volume 2 Issue 1

Learn about the changes of state consumer protection and the responsibility of financial services institutions to pursue operational excellence and a culture of compliance.

Reg+Tech Magazine Vol. 1 Issue 2

Regulatory and technology experts discuss innovation, CRA reforms, and how single-close construction loans are reenergizing rural America.

chevron-down linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram