Contact Us

RiskExec has recently been updated to include the following enhancements:

HMDA, CRA, and 1071 SBL Modules

Update All File Parts

Users now have the ability to update all File Parts within a file at once when using the Dynamic Import Wizard’s Partial Update import option. 

If All File Parts is selected on the Import Data screen, the only available import option on the following screen will be the Partial Update.

Note: The Update All File Parts option will update ALL matching records. For example, if the file that is being imported has the loan number ABCD and the existing uploaded data in RiskExec already has 2 records with ABCD in 2 different file parts, then this option will update both of the existing records in those different file parts.

Change Log Report Update

Users can now select multiple fields when reviewing the Change Log report. For example, changes to three selected geocoding fields can be reviewed at once:

HMDA Module

New Export Format: RiskExec Regulatory Edits Full

A new export format has been added to allow users to download a list of the regulatory edit checks that are triggered on their HMDA file. To access this format, click on the Export tab and then click Export Data. Then, choose RiskExec Regulatory Edits Full from the Export Format drop down menu. When downloaded, this format will display the ULI, Application Number, Edit Check, and Edit Check Description.

Assessment Area Module

Assessment Area Type

A new option has been added to the Create Assessment Area/REMA screen that allows a user to choose an Area Type, if applicable.

The Area Type allows users to identify an assessment area using the terminology in the CRA Final Rule. According to the CRA Final Rule, performance for banks will be evaluated in facility-based assessment areas and, as applicable, retail lending assessment areas, and outside retail lending areas. For assistance in determining the appropriate assignment for an assessment area, financial institutions should refer to the regulation or their regulator.

Trade Area Tract Information Report

Only MMCT Tracts and LMI or MMCT Tracts have been added as additional categories to the Trade Area Tract Information report. 

Redlining Module

LEI Added to Peer and Market Results 

LEI has been added as a column to the Total Count stack rankings report in the Peer and Market tabs in the Redlining Analysis Results. To access this report, navigate to the Peer or Market tab in your analysis results. Then, click on the hyperlinked Total Count.

Fair Servicing Module

Update Datasets

Users can now update the data in existing Fair Servicing datasets. To update a dataset, select it from the list and click on Update Dataset. The Dynamic Import Wizard will now contain all update options. 

CRA Module

FDIC Tables: Batch Processing

Batch Processing has been enabled for the FDIC Performance Evaluation Tables in RiskExec. To utilize this feature, select an FDIC report from the drop down and click View Report. The Batch Processing button will be available in the top right of the report. Click Batch Processing and choose the file type you would like your FDIC reports to be exported as. Click Process and all FDIC PE Tables will be exported and will download into a zip file. 

RiskExec has recently been updated to include the following enhancements:

HMDA and CRA Modules

2023 Submission Videos

2023 Submission walkthrough videos have been published to the Help Center for HMDA and CRA.

Redlining Module

Advanced Redlining Analysis Update

The RiskExec Redlining module had previously been updated to allow users to elect to have RiskExec automatically select respondents to be used as peers for Assessment Area geography peer analysis.  An additional filtering option has been added to the Advanced Analysis setup for cases where an institution wants to identify peers using a different criteria than the analysis filters.   

Dynamic Import Module

New Date Conversion

DD-MM-YYYY has been added as an additional date conversion in the Dynamic Import Wizard. To utilize this option, click on the Transform button on the Review and Edit Mapping screen. Then, choose the DD-MM-YYYY translation and click Accept. 


Maps

Banking Markets Layer

The Banking Markets Layer has been updated. The updates include some banking market definitions and their corresponding shapefiles in the 1st and 11th District of the Federal Reserve System.

Peer Analysis Module
Rankings by Respondent Report

Combined Race and Combined Ethnicity have been added as categories to the Rankings by Respondent Report.

Fair Lending Module
Focal Point Model Parameters

The Model Parameters report for a Focal Point model will now display the sub-models that are included in it. To review the Model Parameters, click on a model and choose Model Parameters in the side menu and the Included sub-models will be listed at the bottom of the report. 

RiskExec has recently been updated to include the following enhancements:

FFIEC MSA, CBSA, and County Updates for 2024

RiskExec has been updated to reflect the new MSAs, CBSAs, and Counties, as designated by the FFIEC, beginning in 2024. Of particular note are the changes to MSAs and CBSAs and the new Connecticut counties.


Redlining Module

Analysis Results Summary Update

The coloring of the Analysis Results Summary tab has been updated to indicate when the p-Value is NA. If the p-Value is NA, the cell will now be colored gray. 

The p-Value will display as NA when it is unable to be calculated. Examples of when a p-Value cannot be calculated include when a specified measure is not located in a particular geography and/or there is no performance of the peer/market for a specified measure. 


CRA Module

New OCC PE Tables

Two new OCC PE tables have been added. They are the Lending Activity (Number of Loans and Dollar Volume of Loans) report and the Table D - Lending Inside and Outside Assessment Area report. 


Peer Analysis Module

View Parameters Update

The View Parameters screen will now include the Respondent Type of each Respondent. The Peer Finder Criteria will also reflect the Respondent Types that were selected. 

RiskExec has recently been updated to include the following enhancements:

Dynamic Import Wizard

Select Additional Match Criteria

Users are now able to set additional match criteria when running an Append - Use New Data for Existing Records, Append - Use Old Data for Existing Records, or a Partial Update - Update Selected Fields for Existing Records import.

The user still must use Application Number or ULI as a record identifier. However, they may now also choose to add additional fields to be used as match criteria.

HMDA and CRA Modules

Branch and ATM Distribution Report Update

The Branch and ATM Distribution report can now be organized by Assessment Area. 

Redlining Module

Peer Filter Screen

The Peer Data Filter screen in the Advanced Analysis setup will now come after the Peer Geography screen when you are selecting your own peers for analysis. 

CRA Module

CRA Field Names Update

The table below has the original RiskExec display field name and what the display field names have been changed to in order to match the FFIEC CRA File Specifications. The internal SQL field name used in an import or export has not changed.

Miscellaneous 

Census Data Added to RiskExec

The following tract demographics have been added to all core data modules in RiskExec. They will be added as Redlining factors in a future release. 

RiskExec has recently been updated to include the following enhancements:

Maps

New Layers: Bank Branches and Credit Union Branches

Two new layers have been added to RiskExec’s maps: Bank Branches and Credit Union Branches.

Bank Branches are added from the Annual FDIC Summary of Deposits file and Credit Union Branches are from the NCUA call reports.

Radius Tool Enhancements
The radius tool in RiskExec Maps has been updated and enhanced. Users can now have multiple radii area(s) drawn on a map. The radius popup can be changed to show Records instead of Census Tracts.

Drop a Pin
A new marker tool has been added to the maps. Users can use this tool to drop a pin and get the geocoding and some demographic data for that location. The Place that is returned is a reverse geocode for the latitude and longitude of the marker.  The Accuracy is how close the reverse geocode is to the marker.  If there is not an address close enough, the Accuracy will be left blank and only a zip code will be returned instead of an address. The pin, its geocoding information, and its demographic information will be exported if a user exports the map.

Redlining Module

Advanced Analysis Peer Selection

The Advanced Redlining Analysis has been enhanced to allow users to choose to have RiskExec select their peers for their analysis.

Note: This option is only available if all of the geographies selected for analysis are Assessment Areas.

If you choose to have RiskExec select your peer respondents, a screen very similar to the Peer Finder screen in the Peer Analysis module will appear.

CRA Module

OCC PE Tables: Batch Processing

Batch Processing has been enabled for the OCC PE Tables in RiskExec.

HMDA and CRA Modules

Branch List Report

The Branch List has been updated to include the Saturday and Sunday branch hours to the Open Branch Hours report type.

RiskExec has recently been updated to include the following enhancements:

Redlining Analysis Module

Streamlined Analysis Set Up

The Streamlined Analysis set up screen has been updated. If a user chooses to include only respondents with branches in the Assessment Area Set selected for this analysis, a new drop down menu will appear. 

Users will then be able to choose whether they want to only include respondents with branches that are Banks (based upon the FDIC Summary of Deposits), only include respondents with branches that are Credit Unions (based upon the NCUA Call Report), or include respondents with branches that are either Banks or Credit Unions. 

Advanced Analysis Set Up

The Advanced Analysis set up has been updated. On the first screen, the option to exclude the target institution from the Market analysis results and the option to only include respondents with branches in the geographies selected for analysis have been removed.

Those options have been moved to a later screen in the analysis setup. They will only be available if a peer or market factor is selected for inclusion in the analysis. 

After you select your in-scope geographies and click Next, you will be able to make those selections.

If a user chooses to include only respondents in the Assessment Area Set selected for this analysis, a new drop down menu will appear. 

Users will then be able to choose whether they want to only include respondents with branches that are Banks (based upon the FDIC Summary of Deposits), only include respondents with branches that are Credit Unions (based on the NCUA Call Report), or include respondents with branches that are either Banks or Credit Unions. 

Dataset History

Users can now view the history of their Redlining datasets. To do so, select a dataset and then click on the Dataset History option in the side menu. 

Then you will be able to review the history of the selected dataset. 

CRA Module

Dynamic Import Wizard: Translation for Revenue Code

Users are now able to import revenue dollar amounts and convert them to the corresponding Revenues code in RiskExec using a transform in our Dynamic Import Wizard.

1071 SBL Module

New Submission Value Fields

Read-only semicolon-delimited fields have been added to the 1071 SBL module. These fields allow users to see what the actual submission values will look like for owner race and ethnicity fields, credit purpose, business ownership status, type of guarantee, and denial reasons. 

For example, the Race of principal owner 1 (aggregated) field takes Race 1-5 of the principal owner and the Additional Race of principal owner 1 field and compiles them into a semicolon-delimited list. 

Regulatory Export Format

The Regulatory SBL export format has been added to RiskExec according to the Filing instructions guide for small business lending data collected in 2024

To access this export format, navigate to the Export tab of your 1071 SBL file and choose Regulatory SBL Export from the list of export formats. 

RiskExec has recently been updated to include the following enhancements:

2023 FFIEC Census Flat File Update

An updated 2023 Census Flat File has been released by the FFIEC and RiskExec's census data has been updated to include the Island Areas: American Samoa, Commonwealth of the Northern Mariana Islands, Guam, and the U.S. Virgin Islands. This is potentially the last update for the 2023 file.

HMDA, CRA, and 1071 SBL Modules

Field-Level Edit Checks Link to the Corresponding Field

Field-level edit checks listed in the Edit Check Summary report will now link directly to the field triggering the edit check. RiskExec will take you to the Application Detail tab that the field is on by scrolling to the field and highlighting the field with a border outline.

Manage Institution

UDF Default Value

Users can now set a default value for Datetime, Integer, and Numeric User-Defined Fields.

If a field is blank in a source data file upon import, and a Default Value is set for that field in Manage Institution, that field will be populated with the Default Value.

Note: The Default Value must be the same data type as the UDF. For example, the Default Value for an integer UDF must also be an integer. 

If the Default Value field is blank in Manage Institution, then the field will remain empty upon import.

Analysis Variable Direction

Users can now set the Analysis Variable Direction for Fair Lending and Fair Servicing Numeric and Integer User-Defined Fields to Positive or Negative. This setting affects which direction will be highlighted as favorable or unfavorable when statistical significance is identified in an analysis. If a field is marked Positive, a significant value smaller than the Control class value will be indicated as favorable. If a field is marked Negative, a significant value smaller than the Control class will be indicated as unfavorable.

For example, if a UDF is created for Fees such that higher value of Fees is considered unfavorable, the analysis variable should be set to positive.  A Difference of Means analysis of this field will show an unfavorable statistical significance when a Target class average fee is higher than the Control class average fee.  Conversely, if a UDF is created for Credits such that higher value of Credits is considered favorable, the analysis variable should be set to negative.  A Difference of Means analysis of this field will show an unfavorable statistical significance when a Target class average credit is less than the Control class average credit.

Redlining and Fair Lending Module

Creating a Dataset

We have improved the process when creating datasets in the Redlining Analysis module from existing Fair Lending datasets, and creating datasets in the Fair Lending module from existing Redlining datasets. 

The Automatch feature will now work seamlessly on the Map Fields screen of the Dynamic Import Wizard. 

Additionally, if the data you are bringing over has been geocoded already, the geocoding will be preserved during dataset creation. For example, if you are creating a Redlining dataset from an existing Fair Lending dataset, and the Fair Lending dataset has been geocoded, that geocoding will be imported into Redlining when you create your new dataset.

CRA Module

New OCC Reports

Two new OCC reports have been added under Regulatory reports: Branch Network in the Rated Region by Assessment Area and Branch Opening/Closing in the Rated Region by Assessment Area.

New FDIC Reports

Two new FDIC reports have been added under Regulatory reports: Geographic Distribution of Home Mortgage Loans and Distribution of Home Mortgage Loans by Borrower Income Level.

Redlining Module

Combined Minority and Combined Race/Ethnicity Fields

Combined Minority and Combined Race/Ethnicity have been added as fields to the Redlining module for HMDA datasets.


Fair Lending Module

Minimum Count of Records per Segment for Regression

The minimum count of records per segment in a Regression analysis has been hardcoded to be greater than or equal to 10. If a value less than 10 is entered, the value will be changed to 10 and the user will get a notification explaining that the minimum cannot be less than 10.

Records Output in Regression Analyses

A feature has been added to regression models so that advanced users can control how many records are displayed on the Records tab of a regression analysis in the analysis results screens. This setting is controlled in the Advanced menu of the model setup screens. Here users can set a maximum record output that will limit the records displayed.  All existing models have been set to the default maximum of 10,000.

The full download of records can still be accessed utilizing the Download Analysis option from the main Analysis menu.

RiskExec has recently been updated to include the following enhancements:

2023 FDIC Summary of Deposits Data

On Friday, September 22, 2023, the FDIC released the annual Summary of Deposits data for all FDIC-insured institutions. Please note that this data is as of June 30, 2023. Click here to learn more about the release.

The data is ready for immediate use and you are able to access it through the Peer Analysis module as well as when importing locations in the Manage Institutions tab.

Redlining Module

Ability to Transfer Data to Redlining Module

We have improved the process when creating datasets in the Redlining Analysis module from existing Fair Lending datasets. Now a user can select the option Other for Data Type when importing Fair Lending data into the Redlining module.  This Data Type should be used for analysis of datasets that do not have peer data available.

HMDA Module

RiskExec has incorporated the changes from the 2024 HMDA Filing Instructions Guide (FIG) for following Validity Edit Checks:


Assessment Areas Module

Rating Areas and Scope Type

One essential component of a CRA Examination is the ability to aggregate and report by Rating Areas and also whether an Area is Full-Scope or Limited-Scope. Users are now able to assign optional Rating Areas and Scope when creating Assessment Areas within a Submission set. The option to include Rating Area and Scope Types is available on the Create Assessment/REMA Set screen.

Users will assign the rating areas and scope types when creating each assessment area. In general, a Rating Area is either one State or a Multi-State MSA. RiskExec also allows users to create a Custom Rating Area by providing a name for it. This functionality allows assessment areas to be grouped in the same way they are grouped in CRA Performance Evaluations.


Tracts by Geography Report

The Tracts by Geography report now includes a grouping by Assessment Area. 
 

Peer Analysis Module

Respondent Group Peer Set Parameters Report

A new report has been added to the Peer Analysis module called the Respondent Group Peer Set Parameters report. This report will identify any parameters that were set when creating a Respondent Group peer set. Users will be able to download this report in various formats.

Miscellaneous

The Branch List report has been updated to allow users to select more than one location group and type at a time to review.

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. 

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