Contact Us
Contact Us

RiskExec has recently been updated to include the following enhancements:

2024 HMDA Filing Instructions Guide and Supplemental Guide for Quarterly Filers 

The 2024 HMDA FIG has been released and is available in the Help Center by clicking here. RiskExec will be implementing all changes to the Edit Checks in future releases. There are currently no noted Geography changes, but it is anticipated that the new MSA/Counties could be implemented for 2024 submission.

RiskExec Connect 2023

Join us for the next RiskExec Connect virtual conference on November 1, 2023. Users can now register by clicking the link on the RiskExec home page. Please note that the conference is free to all attendees.

Fair Lending and Redlining Modules

Ability to Transfer Data Between Redlining and Fair Lending Modules

Users can now create datasets in the Fair Lending module from existing Redlining datasets, as well as create datasets in the Redlining Analysis module from existing Fair Lending datasets. In the Fair Lending module, click on New Dataset and select RiskExec File From Another Module as the data source. Select RiskExec Redlining Dataset as the RiskExec Module and then choose the type of data you are going to bring over such as CRA, HMDA, etc. from the options listed under the sub module tab.
 
Once you have made your selections, you will use the Dynamic Import Wizard to import the dataset. 

In Redlining, click on New Dataset. The data source will be Other RiskExec Module. The RiskExec Module will be RiskExec Fair Lending Dataset and the Sub Module will be the type of data you are going to bring over (CRA, HMDA, etc.) In the example below, the user chose a HMDA dataset to bring over from the Fair Lending module. Click Create Dataset to begin the Dynamic Import process.
 

Dynamic Import Wizard

Map a Single Source Field to Multiple RiskExec Fields

Users can now map one source field to multiple RiskExec fields in the Dynamic Import Wizard. To do so, check the box labeled Map Source Field to Multiple RiskExec Fields at the top of the Source Fields list on the Map Fields screen.  
 

For example, in the CRA module, a user may want to save the full loan amount in a user-defined field, as well as import it into the RiskExec field where it is rounded to the 1000’s. In the image below, the loanamt source field was mapped to the Loan Amount RiskExec field and the Full Loan Amount RiskExec user-defined field.

Import 11 Digit Geocodes

Users are now able to import 11 digit Geocoding/FIPS codes into RiskExec. This is made possible by the new functionality that allows users to map the same field from their source data file to multiple RiskExec fields. 

In the example below, the 11 digit FIPS code is in a field in the source data file called FIPS Code. By checking the box labeled Map Source Field to Multiple RiskExec Fields on the Map fields screen, the user is able to map that FIPS Code source field to the Geocoded State, County, and Tract fields in RiskExec.

RiskExec will then break up the field and map the data to the correct RiskExec fields.


Fair Lending Module

Decisioning Regression Summaries: Model Agreement

Users can select multiple analyses of a similar type (i.e. all Decision Regression or all Pricing Regressions) by Clicking Shift+Left Mouse. This will then allow the user to use the Summary Option and produce a downloadable report of the Regression results.

Model Agreement has now been added to the Decisioning Regression Summary report. This new column allows users to review and compare model performance across multiple analyses without accessing each individual analysis results.

CRA Module

Community Development Lending By Purpose Categories

A new report has been added to the CRA module under Executive reports called Community Development Lending By Purpose Categories. This report provides a volume breakdown by Community Development Purpose category for Community Development lending.
 

1071 SBL Module

Race and Ethnicity Codes Update


The below code changes have been made in accordance with the August 17th updates to the 2024 Filing Instructions Guide (FIG).

For race, the Native Hawaiian or Other Pacific Islander sub codes were reordered:

Previous codes: 


Current Codes:


For ethnicity, the Hispanic sub codes were reordered:


Previous codes: 

Current Codes:


Data Validation IDs

The Data Validation IDs have been incorporated into the 1071 SBL module. 

The CFPB announced that the Filing Instructions Guide (FIG) for Home Mortgage Disclosure Act (HMDA) data collected in 2024 is now available. The 2024 FIG is a technical resource to help financial institutions file HMDA data collected in 2024 and reported in 2025. 

They have also released the Supplemental Guide for Quarterly Filers for 2024, which includes 2024 calendar year quarterly deadlines. This guide will help financial institutions that are required to file HMDA data on a quarterly basis.

The 2024 FIG and the Supplemental Guide for Quarterly Filers for 2024 can be accessed at https://ffiec.cfpb.gov under Guides for HMDA Filers. 

RiskExec has recently been updated to include the following enhancements:

Redlining Module

New Analysis Measure: Ad Hoc User Filter

Users now have the ability to perform a Redlining Analysis on a measure of their own. This can be accomplished by selecting the Ad hoc user filter option in the Select Analysis Measures screen. The drop down for this feature includes all Filters created by any of the Institution’s users such that the filter can be successfully applied to the Redlining dataset and all the Peer data for the module. For example, if there are saved filters in the HMDA module, and the dataset is HMDA data, the filter list will include those filters. 
Note: The filter must be applicable for both the data in the redlining dataset and the data in peer. Hence, a filter that includes applicant name will not appear in the filter list because applicant name is not included in peer data.

Fair Lending, Fair Servicing, and Batch Geocoding Modules

Proxy Results Report 

A Proxy Results report has been added to the Fair Lending, Fair Servicing, and Batch Geocoding modules. 

HMDA, CRA, and 1071 Modules

Edit Check Summary/Validation Summary Search Bar

Users are now able to use a search bar to quickly find a specific edit check in the Edit Check Summary Report. The search bar will search the edit check descriptions and narrow the list of displayed Edits such that the Search text is included in the edit descriptions.

Miscellaneous
Record List Search Bar

Users are now able to use a search bar to quickly find a specific record in any record list in RiskExec. This feature can search for all text fields and all numeric values that are stored as text (zip codes, census tracts, etc.) that are included in the Report Format. Searches will begin after at least three characters are entered into the search bar. 

RiskExec has recently been updated to include the following enhancements:

2023 Census Flat File and FFIEC Median Family Income Updates

The updated 2023 Census Flat File has been released by the FFIEC and RiskExec's census data has been updated. None of the geographies have changed in this release. The file has updated values for MSA Median Family Income, so Borrower LMI and Income Class may have changed. Tract LMI did not change. 

Please note that the FFIEC still has NOT included data for the Island Areas (American Samoa, Commonwealth of the Northern Mariana Islands, Guam, and the U.S. Virgin Islands). This may be coming in an update later this year.

The FFIEC has also announced that the 2024 Census Flat File will incorporate the new MSA and MD definitions in OMB Bulletin 23-01, and also potentially the changes in the Connecticut counties, so next year will have extensive geographic changes.

1071 SBL Module

RiskExec 1071 SBL Data Comparison to HMDA and CRA

Our comparison of 1071 SBL to HMDA and CRA is now available in the Help Center here. This review reflects our understanding of the intersection of these rules at this time. We understand the Consumer Financial Protection Bureau (CFPB) will continue to provide guidance and further clarification related to 1071 SBL.

The file attached to the Help Center article was created using the CFPB data points file that was shared when the final rule was published in March 2023. Our team added columns describing the comparison of HMDA and CRA data, respectively, to the 81 1071 SBL data points. Additionally, the final row of the workbook provides additional comments about the comparison of HMDA and CRA to 1071 SBL. While there are similarities, 1071 SBL is more complex than the CRA data collection requirements. 1071 SBL shares similarities with HMDA requirements but there are notable differences in how some similar fields can be populated. 

Peer Analysis Module

Disparity Indices Report

The Disparity Indices report for HMDA Geographical Peer Sets has been updated to include Combined Race/Ethnicity.

Fair Lending Module

Matched Pair Analysis Results

A new tab has been added to the Matched Pair Analysis Results that lists all Comparator applications with any associated Target applications. This tab enables users to easily identify when a single Comparator file is matched to multiple Targets.

Redlining Module

Analysis Results Update

Two new columns have been added to the Peer and Market tabs in the analysis results for Analysis Measures that are tract-based. The available tract-based measures are selected below:

The results will now include a column with the total number of tracts for a geography and a column with the number of tracts in the geography for the selected measure. 

RiskExec has recently been updated to include the following enhancements:

Redlining Module

Tracts List Report: Additional Analysis Measures

If you select any of the below Analysis Measures when setting up your Advanced Redlining Analysis, they will now be included in the Tracts List report in the Analysis Results. Previously, only LMI and MMCT were included in this report.

In the below example, LMI, MMCT, MHCT, MBCT, and MBHCT were chosen as measures to be included in this analysis.

Clicking on a hyperlinked geography name under the Assessment Area column will bring up the Tracts List report for that geography.

Only Include Respondents with Branches 

The option to only include respondents with branches in the geographical area has been added to the Streamlined Analysis setup screen.  If this option is selected, the analysis results will only include respondents with physical branches in the Assessment Area Set selected in the setup screen.

NOTE: This branch data comes from the FDIC Summary of Deposits (SOD) so it only applies to institutions that report this data, which are primarily depositories. If you select this option, then by default, all non-depositories will be removed from the list of peers in the Redlining analysis. This note has been added to both the Advanced and Streamlined Analysis setup screens.

Assessment Area/ REMA and Peer Analysis Modules

Batch Processing 

Batch Processing is now available for all reports in the Assessment Areas Module and has been enabled for the Peer Analysis reports listed below. For more information on this functionality, see the Assessment Area Set and Assessment Area Reports: Batch Processing and Peer Reports: Batch Processing articles in the Help Center.

Assessment Area Module

Create Assessment Area Units 

The Create Units screen has been updated. The include/exclude options are now radio buttons instead of a drop down menu and the Include in Assessment Area option is selected by default.

Tracts Demographics Report

The Majority-Asian Census Tract (MACT) designation has been added as a column to the Tracts Demographics Report.

HMDA and CRA Modules

Branch List Report

Users can now filter this report by Location Type. This report has also been updated to include columns for the Open and Closed dates.

Fair Lending Module

Difference of Means: Test Threshold

As there is no approved amount for differences (e.g. interest rate, APR, fees) between protected and non-protected groups, the Test Threshold has been removed from the Difference of Means analysis setup and all differences will populate in the analysis results.

RiskExec has recently been updated to include the following enhancements.

Dynamic Import Wizard

Column Header Row Selection Update

The Dynamic Import Wizard has been updated. 

The File contains column names checkbox is checked by default. Checking this box means that your uploaded data file contains a row for column header names. 

If your uploaded data file does not contain a row for column names (Application Number, Loan Action, etc.), then you will want to un-check that box. 

Then, be sure the first row of data in your uploaded data file is selected in the table. This row of data and the following rows will be imported as data records. Any rows prior to this row will be skipped.


HMDA and CRA Modules

File History Tab: File Part Changes 

The File History tab will now record any changes made to the File Parts in your file.


Chart Labels Update

The chart on the File Summary screen will now display the number of loans for each category when Number of Loans is selected for the X axis.

The chart will also display the total loan amount for each category when Loan Amount is selected for the X axis.


Fair Lending Module

Ability to "Save Model" After Changing Model Name

Users are now able to save any changes they make to their model names and/or the model notes without having to click through the rest of the model setup screens. 


Pricing Regression Dependent Variables

Users are now able to select any numeric field from the Pricing Regression Dependent Variable dropdown menu, including Origination Charges, Total Loan Costs, and other fee-related fields.


Focal Point Analysis: p-Value Update for Difference of Means Tests

The Focal Point analysis results has been updated to display both the t-Stat and the p-Value results for a Difference of Means test, relying on the p-Value to identify areas of statistical significance. The Difference of Means was previously updated to utilize the p-Value as an alternative to the t-Stat when identifying statistical significance. This update aligns the Focal Point report with the latest Difference of Means testing protocols. 

Please Note: For any Focal Point analysis that was run prior to this release, the p-Values will be NA. The test will need to be rerun in order to update the p-Values and the correct statistical significance testing.


HMDA Module

SCIF Fields Update 

The YES code for the Homeownership Education and Housing Counseling fields has been removed and the remaining code descriptions have been updated. 

RiskExec has recently been updated to include the following enhancements:

2022 HMDA Peer Data and Other Updated Data in RiskExec

On June 29, 2023, the CFPB released the 2022 HMDA Peer National Snapshot. Our team has downloaded, converted, and reviewed the data.  It is now available in RiskExec for immediate use. It consists of submissions from 4,460 institutions totaling over 16 million records.

Note, that as in previous years, the data was redacted before it was made public. It is published by the CFPB and continues to evolve as institutions resubmit their data. As such, the public data is subject to change and the following items should be taken into consideration when using this data for any analysis:

Additionally, the Distressed and Underserved report and data has been updated with the 2023 designations from data provided by the FFIEC. 


RiskExec Reports

Fair Lending Module

In the Marketing Report of the Fair Lending module, users are now able to dynamically set arbitrary significance numbers to "Highlight Values Above or Equal to <enter number> or Highlight Values Below or Equal to <enter number>." To do so, the user will click on the downward arrow in the vs. Demographic column(s). From there, the user will set the values by entering the number in the blank tab. In the example below, the user wanted to “Highlight Values Above or Equal to 5.” You will see that reflected in the dropdown as well as the footnote of the report.

HMDA and CRA Reports

The Branch List report found under HMDA and CRA Executive reports has been updated so that the county, MSA, and Assessment Areas are listed out in individual columns. This allows the data to be sorted, filtered, and exported in a more efficient manner.  
 
HMDA Reports

RiskExec has updated the footnote of the HMDA Disposition Summary found under Executive Reports in the HMDA module. The footnote now clarifies that the report only uses records with loan actions 1 through 5. 

Assessment Area Module Reports

The Assessment Area Set Summary Report has been revamped to now include a breakdown of the total population and percentage of population that a group makes up. The total population has been updated for all groups provided in this report except for Sex. Because the FFIEC uses ACS as the source for the counts by sex and age, and Decennial Census for the tract population, the sex and age counts may not sum to the total population.

Miscellaneous

RiskExec’s Help Center has been updated with new articles that allow you to download an Excel spreadsheet of all RiskExec Field Calculations, Codes, and their Descriptions.  Each module is on a separate sheet. Click here to access the new articles (you will need to be logged into RiskExec):

https://riskexec.zendesk.com/hc/en-us/articles/4403493525019-RiskExec-Codes-and-their-Descriptions-All-Modules

https://riskexec.zendesk.com/hc/en-us/articles/16770501976731-RiskExec-Field-Calculations-All-Modules

RiskExec has recently been updated to include the following enhancements:

HMDA and CRA Modules

Add Comments When Deleting Records

Users now have the option to add a comment when deleting a record. To do so, click the down arrow next to the Delete button when viewing the record detail page in HMDA or CRA. Then, select Delete with Comment. The comments entered can later be reviewed in the Notes column of the Change Log report. 


Branch List Report Updates

The Branch List report has been updated to display the Address, City, State, and Zip Code fields as separate columns. Additionally, a column for Majority Black Hispanic Census Tracts (MBHCT) has been added. 


HMDA and Fair Lending Modules

CFPB Derived GMI Fields

The CFPB uses its own internal methodology for categorizing applications for Combined Race, Ethnicity and Gender. These calculations have now been added to RiskExec in the HMDA and Fair Lending Modules as CFPB Derived fields. They can be utilized in reporting and in Fair Lending Analysis. The CFPB logic can be found here.

Assessment Areas Module

Reports: Batch Processing 

Batch Processing is now available in the Assessment Areas Module for the Assessment Tract Counts By County and Families/Households Below Poverty Level By Tracts LMI reports. 

If a user runs Batch Processing on an Assessment Area Set, a report will be returned for each Assessment Area. For example, running Batch Processing on the 2023 Submission Set will return three reports, one for the Altoona MSA Area, Tennessee Counties Area, and Washington DC MSA Area. 

If a user runs Batch Processing on an Assessment Area, a report will be returned for each Assessment Area Unit. For example, running Batch Processing on the Tennessee Counties Assessment Area will return a report for each of the four counties that make up this Assessment Area. 


1071/SBL Module

Data Validation

The Data Validation section of the side menu is now available to users so that they can run data validations on their 1071/SBL files. Data Validations are a series of checks that run on the small business lending application register to ensure that the data entries are correct and ready to submit, meaning the data are both internally consistent and consistent with the syntax and logic specified by the Small Business Lending Rule Filing Instructions Guide. They are similar to Edit Checks in the HMDA/CRA modules.

RiskExec has recently been updated to include the following enhancements:

Maps

Themes: Apply Outside Assessment Areas


Users can now choose to apply map themes only outside of their Assessment Areas.


File Parts: Record Property and Filter

Users can now set the record property in their maps to File Part. 

File Part can also be used as a map filter. 


Fair Lending Module

Matched Pair Analysis Results

When running a matched pair analysis, users have the ability to limit the Targets for inclusion based on the Outliers from a corresponding regression analysis. When doing so, the Residual value from the regression is displayed for any Targets included in the matched pair analysis results. 

Going forward, if an analysis is not tied to a regression, this Residual column will no longer appear.


HMDA and CRA Modules

File Crosstab Report

The ability to remove the percentages has been added to this report. By default, percentages are enabled. 

To remove them, uncheck the box next to Include % Rows.


Peer Analysis Module

Reports: Batch Processing 

In the Peer Analysis module, a number of reports now have batch processing available. This new feature allows users to export a report for all Peer Units in a Peer Set, all at once.

HMDA Respondent Group Peer Set Reports:

HMDA Geographical Peer Set Reports:

CRA Geographical Peer Set Reports:

CRA Respondent Group Peer Set Reports:

CRA Respondent Peer Set Reports:

PPP Geographical Peer Sets:

RiskExec has recently been updated to include the following enhancements:

2022 and 2023 Zip Codes Are Now Available

The US Department of Housing and Urban Development (HUD) has released their crosswalk file and all zip code data has been updated in RiskExec for 2022 and 2023. The RiskExec Map Layers and demographic reports now include Zip Codes for 2022 onwards.

Assessment Areas Module

Rural Non-MSAs

Users are now able to create Rural Non-MSA based Assessment Area units. These Units can also now be used in Redlining Analysis.

Fair Lending Module

Coefficient Display When a Variable is Dropped

When running a regression, the statistics engine will drop certain factors due to various reasons including multicollinearity when these issues arise. The Coefficient tab has now been modified to display “NA” for all values for these variables when they are not utilized in the specific run for the regression analysis. The Analysis Notes tab also lists the factors dropped and the reason they were dropped.

Regression Analysis for Processing Days

Users can now use Processing Days as the dependent variable in a pricing (linear) regression analysis. This will allow users to conduct a processing days analysis utilizing explanatory factors to determine whether statistical differences in processing times exist.


CRA Module

Community Development Tab

A note has been added to the Community Development tab of the Loan Detail screen to explain that all of the fields on this screen are optional and not submitted.

Reports Moved and Renamed

The following reports have been moved to the Executive reports section:

The following reports were renamed:

New OCC Report

The Table A - Demographic Information report has been added to the list of OCC reports available in CRA. 

RiskExec Reports

Now Sorted Alphabetically

All report lists in RiskExec have been sorted so they are listed alphabetically. 


Manage Institution

New Location Type: LSC

Users now have the option to choose Limited Service Center, or LSC, as the location type when importing or manually adding a new location. 

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