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.

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.

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.

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.

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. 

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

HMDA/CRA

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.

Reports

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. 

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. 

Miscellaneous

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.