Each depositor insured to at least $250,000 per insured bank

Table of Contents

1. Business Problem



2. Solution
1. Table Layout
2. Derivation of Calculated Variables


3. Maintenance and Revision

1. Business Problem

The FDIC has developed a community bank definition for research purposes and this definition is being used for publically available papers (this definition can be found in "Defining the Community Bank", an FDIC Community Banking Study publication, at http://www.fdic.gov/regulations/resources/cbi/study.html). The demographic and financial data behind the FDIC's definition, sourced from the Research Information System (RIS) and Summary of Deposits (SOD), needs to be publicly accessible so that external analysts can build upon the FDIC's research. RIS is a series of data sets used in time series analysis of institution financial statements. The Summary of Deposits (SOD) is the annual survey of branch office deposits for all FDIC-insured institutions.

2. Solution

Create a data set that contains the demographic and financial information underlying the FDIC's definition of a community bank for all FDIC-insured institutions as of year-end. This data is provided to the public to supplement existing FDIC research on community banks and encourage further academic and professional research. The data set is called "Current Community Banking Reference Data.csv."

1. Table Layout

The following table outlines the basic structure of Current Community Banking Reference Data.csv:

Name	Source	Type	Definition
CERT	RIS	Num	FDIC certificate number.
ID	RIS	Num	Unique institution identification number. Designation of community bank status is at the banking organization level. Institutions in a multibank holding company take the RSSD ID (unique identifying number assigned by the Federal Reserve for all financial institutions, main offices, and branches) of the parent holding company, identified as their regulatory high holder, as their banking organization's unique identifier (ID). Institutions not in a bank holding company or in a one-bank holding company take the bank's FDIC certificate number as their organization's unique identifier. Data for each banking organization is aggregated over all the institutions in the organization.
NAMEFULL	RIS	Char	Full name of the institution.
ADDRESS	RIS	Char	Address of the headquarters of the institution.
CITY	RIS	Char	The city where the headquarters of the institution is located.
STALP	RIS	Char	The state abbreviation of the location of the institution's headquarters.
STCNTY	RIS	Num	The Federal Information Processing Standard (FIPS) code associated with the state and county of the institution's headquarters.
STATE_COUNT	SOD	Num	Number of states in which the organization has branches.
ZIP	RIS	Char	The ZIP code associated with the physical address of the institution's headquarters.
YEAR	RIS	Num	The year of community bank designation.
CALLYM	RIS	Num	Reporting quarter, expressed as yyyymm.
CB	CALC	Num	Community bank flag where a "1" designates community bank status. A "0" designates non-community bank status. See 2b for further explanation.
ASSET	RIS	Num	The total assets of the institution.
BUSINESS_LINE	CALC	Char	The lending specialization of the institution. See 2b for further explanation.
LOANTOASSET	RIS	Num	The loan to asset ratio of the organization.
CORERATIO	RIS	Num	The core deposit ratio of the organization.
EXCL_SPECIALTY	RIS	Num	Any banking organization where more than 50 percent of total assets are held in certain specialty banking charters (e.g. credit card specialists, consumer nonbank banks, industrial loan companies, trust companies, and bankers banks) have a value of "1." All others have a value of "0."
EXCL_FOREIGN	RIS	Num	Foreign assets greater than or equal to 10% flag where a "1" indicates that foreign assets are greater than or equal to 10% of total assets. A "0" indicates that foreign assets are less than 10% of total assets.
EXCL_NOCORE	RIS	Num	No core deposits flag where a "1" indicates that this organization does not have core deposits. A "0" indicates that this organization has core deposits.
EXCL_NOLOANS	RIS	Num	No loans flag where a "1" indicates that this organization does not have loans. A "0" indicates that this organization has loans.
EXCL_CREDIT	RIS	Num	Credit card flag where a "1" indicates that this organization is a credit card organization. A "0" indicates that this institution is not a credit card organization.
MAX_DEPOSITS	SOD	Num	The largest amount of deposits held at any branch of the organization.
OFFICE_COUNT	RIS, SOD	Num	Number of offices in which the organization operates.
UNIQUE_METROS	CALC	Num	The number of unique large metro areas in which the organization operates (has branches). A "large metro area" is defined as any MSA with a population of over 500,000 people.
RSSDHCR	RIS	Num	The regulatory top holder RSSD ID number.
NAMEHCR	RIS	Char	The name of the top regulatory bank holding company.
HCASSET	RIS	Num	Represents the summation of Call Reports or Thrift Financial Reports (TFR) filed by all FDIC-insured bank and thrift subsidiaries held by a bank holding company.
RUN_DATE	CALC	Num	The date when the current data set was created, expressed as yyyymmdd. This date is the same for every record.
Sources: RIS = Research Information System (updated quarterly), CALC = calculated by the Division of Insurance and Research (updated annually), SOD = Summary of Deposits (updated June 30 annually) and merger-adjusted for mergers between June 30 and December 31.

2. Derivation of Calculated Variables

CB (Community Bank Flag)

The CB flag designates community bank status based on the FDIC's definition of a community bank. This definition can be found in "Chapter 1 - Defining the Community Bank", an FDIC Community Banking Study publication, at http://www.fdic.gov/regulations/resources/cbi/study.html.

BUSINESS_LINE

BUSINESS_LINE identifies asset concentration and is calculated by comparing relative concentrations of loans to an institution's total assets at the institution-level. This variable is ultimately based on RIS data.

Every institution is in one, and only one, of the categories below (the criteria are mutually exclusive).

Reference #	BUSINESS_LINE Values	Definition
Retail Loans
1	Mortgage Lending	Residential loans are more than 30% of total assets.
2	Other Consumer Lending Specialization	Other consumer loans are more than 20% of total assets.
Commercial Loans
3	Commercial Real Estate Lending Specialization	Construction and Development (C&D) loans are more than 10% of assets or Commercial Real Estate (CRE) loans are more than 30% of total assets.
4	C&I Lending Specialization	Commercial and Industrial (C&I) loans are more than 20% of total assets.
5	Ag Lending Specialization	Agricultural loans are more than 20% of assets.
6	Multiple Specializations	Retail loans are greater than 40% of assets, or commercial loans are greater than 40% of total assets, or the institution meets any two of 1 through 5 in this table.
7	No Specialty	Total loans are less than 33% of assets or the institution meets none of 1 through 6 in this table.

3. Maintenance and Revision

Users combining this data with other FDIC maintained data such as RIS should be aware that other FDIC maintained data are refreshed according to different schedules. For instance, RIS data are updated quarterly, capturing newly filed Call Report data for the current quarter in addition to amendments and other corrections to prior quarter data. Information generated using RIS or other FDIC maintained data may not exactly correspond to analysis posted on FDIC.gov produced using prior versions of that data.

Current Community Banking Reference Data.csv will be updated annually by the FDIC's Division of Insurance and Research. This table will always be named "Current Community Banking Reference Data".

Any changes made to the data set will be recorded in all subsequent notes to users.

*******