Community Reinvestment Act
FFIEC INTERAGENCY CRA RATING FILE SPECIFICATIONS

This process lets you download a file containing all of the information available through the CRA Ratings Search screen. The file has CRA ratings for all examinations conducted by the four bank and thrift regulators--the Office of the Comptroller of the Currency (OCC), Federal Reserve (FRB), Federal Deposit Insurance Corporation (FDIC), and Office of Thrift Supervision (OTS)--since the CRA Ratings became public in July 1990.

Information in this file and on the Web site is updated by the regulators four times a year, and will contain information about all examinations whose ratings have been made public to that point.

In order to understand the layout of the file you are downloading, we recommend that you print this Web page. This page describes the order of the data fields in the file and what the data in the fields means. If you have any questions about this data, please send an e-mail to 'crahelp@frb.gov'. We will e-mail a response to your question within two days of receiving the question.

Click here to download the CRA Ratings Database

Information in this file and on the Web site is updated by the regulators four times a year, and will contain information about all examinations whose ratings have been made public to that point.

The data file is in an ASCII, tab-delimited format. You must decompress it before use. Information about WinZip® is available at  www.winzip.com

The fields in the file, and their possible values, are listed below.

File Specifications for CRA Ratings Database

Field Name   Max. Length   Description
ID   10   Depository Institution's Identifier. OCC uses Charter number, FRB uses RSSD ID, FDIC uses Certificate number, OTS uses docket number. These numbers should correspond to identifiers used to report HMDA or CRA data.
Regulator   1   OCC = 1, FRB = 2, FDIC = 3, OTS = 4
Exam Date   8   Listed as ccyymmdd
Bank Name   72   Name of Institution
City   30   City where head office is located
State   2   Postal abbreviation of state where head office is located
Asset Size   10   Assets at time of exam. Reported in thousands ($000s).
Exam Method   2   1 = Large Bank Exam, 2 = Small Bank,
3 = Strategic Plan, 4 = Limited Purpose,
5 = Wholesale, 6 = Wholesale/Limited Purpose,
7 = Intermediate Small Bank*, 8 = Assessment
Factor, 9 = Not Reported**, 10 = Hybrid
Rating   1   Rating assigned at the exam.
1 = Outstanding, 2 = Satisfactory, 3 = Needs
to Improve, 4 = Substantial Noncompliance
*Applies only to OCC, FRS, and FDIC- regulated institutions
**For some agencies, data about the exam method was not always collected.

 

red arrow CRA Home Page image of red arrow FRB Ratings Page image of red arrow OCC Ratings Page red arrow FDIC Ratings Page image of red arrow OTS Ratings Page