Data Exchange Application (DEXA)

Data Exchange Application logo

Information

DEXA is the NCUA’s new web-based data ingest tool used primarily by credit unions and examiners to import credit union member loan and share data provided in compliance with Letter to Credit Unions 03-CU-05 - Expanded AIRES Loan and Share Record Layout.

Some of DEXA’s key features include the ability to easily:

  • Import loan and share data files
  • Upload a data mapping schema for credit union loan and share type codes 
  • Validate the data prior to submitting the file
  • View the status of submitted files

Credit unions can Log into NCUA Connect to access DEXA. The following templates and FAQs are available to assist with uploading files.

DEXA: Loan Type Map Template
DEXA: Share Type Map Template
DEXA: Frequently Asked Questions

Vendor File Testing

The NCUA provides DEXA file compatibility testing for credit union data processing vendors by submitting test loan and share download files to the NCUA’s Office of Business Innovation. The NCUA will test the file(s) received from data processors and provide confirmation of success or feedback to resolve any issues. Prior to submitting any test files to the NCUA, please review and consider the following DEXA resource information:

DEXA: Quick Reference Troubleshooting Guide

If you wish to submit a loan and/or share file to the NCUA for testing, please contact us at BIMail@ncua.gov.

We highly encourage vendor participation as some files accepted by the NCUA’s legacy examination program, AIRES, have been rejected by DEXA. In addition, examiners still receive loan and share files that require manual corrections to conform to our 2003 specifications. Refer to the Troubleshooting Guide for common errors seen with these files.

DEXA Quick Reference Troubleshooting Guide

The following are common errors seen with the loan and share files.

Data File Issue Resolution
Missing Data Fields At a minimum, files must contain all of the critical and optional data fields in the order listed in the NCUA Letter to Credit Unions 03-CU-05 (even if the field is blank). Missing data fields will cause a schema validation error when imported into DEXA. If there is a header row, the system will start validating the data fields on the second row of the download file.
Invalid File Types Files must be in a tab delimited file format. The system will not accept other file types such as .csv or .xlsx.
Invalid Character Types Files cannot have invalid character types such as alpha characters when numbers are required and vice versa (e.g., alpha characters in payment frequency or delinquency counter fields).
Header Rows A header row is not required, but DEXA will accept files with a single-row header. It will not accept multi-row headers.
Footer Rows A footer row is not required, but DEXA will accept files with footer rows, regardless of whether they are single or multi-row.
Incorrect Effective Dates All files should be as of the same effective date with correct balances and accrued interest (e.g., credit cards, mortgages).
Extra Columns Between Data Columns Files cannot contain any extra columns in between the critical and optional data columns.
Extra Spaces Before or After Text If the download file contains blank text spaces in the Loan or Share Type Code fields, this can cause errors importing the data. For example, a loan type code of UV with spaces after the ‘V’ are not easily identifiable and will cause a mapping validation error.

 

Last modified on
04/09/21