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



HomeRegulation & Examinations > Resources for Bank Officers & Directors > Community Banking Initiatives > Community Banking Data





Community Banking Initiatives

Community Banking Structure Reference Data Notes to Users

Table of Contents

  1. Business Problem


  2. Solution
    1. Data Set Layout
    2. Variable Derivation

  3. Maintenance and Revision


  4. Abbreviation Dictionary


  1. Business Problem
  2. The FDIC needs to be able to account for entrances and exits in the universe of Call Report or Thrift Financial Report (TFR) reporters (those captured in the Quarterly Banking Profile) from quarter to quarter, starting with year-end 1984. Currently, it is difficult to accurately account for these changes using the Research Information System (RIS) or the Structure Information Management System (SIMS). Significant FDIC, academic, and professional research requires efficiency in this process. RIS is a series of data sets used in time series analysis of institution financial statements. SIMS is the FDIC's system for managing demographic data about the nation's banks.

  3. Solution
  4. Create and maintain a data set that records each FDIC Certificate Number (CERT) that enters or exits the universe of reporters (when comparing quarter-end to quarter-end) starting with year-end 1984. Consolidate reasons for entrance and exit to a smaller number of categories than contained in SIMS for ease of use. The name of the data set will be the "Community Banking Structure Reference Data". It will be available to the public as "Community Banking Structure Reference Data.csv".

    1. Data Set Layout
    2. This data set is designed to simply and accurately account for entrances and exits of institutions in the reporting universe. There are more source variables and interim variables used to create this data set that are not included for sake of ease of use and simplicity. The following table shows the basic structure of Community Banking Structure Reference Data.csv.

      Variable Name Source Definition
      Key System Generated The unique system generated table key.
      CERT* RIS The unique FDIC certificate number for the insured institution that either started or stopped reporting Call Reports or TFRs after 1984. Changes in QBP reporters reconcile to counts from this data set. Differences between this data set's counts of other types of events to other published counts (e.g. counts in the Historical Statistics on Banking or HSOB) includes conservatorships and institutions that opened and closed within the same year and are explained in this document. The Community Banking Structure Reference Data includes institutions that filed at least one year-end Call Report or TFR.
      PROXIMATE_CERT MERG The CERT of the acquiring institution.
      RPT_START_TYPE* CALC The reason this institution started reporting. Possible values are:
      "1" - new institution,
      "2" - institution established previously, but recently received insurance, or "3" - other.
      RPT_START_YR* CALC The year the institution started reporting a Call Report or TFR.
      RPT_START_QTR* CALC The quarter of RPT_START_YR that the institution started reporting a Call Report or TFR. This is expressed as a numeric value for the last month in the quarter. For example, Quarter 1, which ends in March, has a value of 3.
      RPT_START_CALLYM* CALC The date the institution started reporting a Call Report or TFR, expressed as yyyymm where yyyy is the year and mm is the month of designation.
      RPT_STOP_TYPE* CALC The reason this institution stopped reporting. Possible values are:
      "1" - failure,
      "2" - merger without assistance, consolidation,
      "3" - merger, acquisition (approximately 3.03% of this population received government assistance 180 days or less before the RPT_STOP_CALLYM),
      "4" - self-liquidation, or
      "5" - other.
      RPT_STOP_YR* CALC The year the institution stopped reporting a Call Report or TFR. This is the last year for which we have financial statement data.
      RPT_STOP_QTR* CALC The quarter of RPT_STOP_YR that the institution stopped reporting a Call Report or TFR. This is the last quarter for which we have financial statement data and is expressed as a numeric value for the last month in the quarter. For example, Quarter 1, which ends in March, has a value of 3.
      RPT_STOP_CALLYM* CALC The date of the latest Call Report or TFR available, expressed as yyyymm where yyyy is the year and mm is the month of designation.
      ULTIMATE_CERT MERG The CERT from the RIS Merger History File that currently "holds" the failing institution from a previous period.
      FAIL_YR FTDB Year the institution failed from the Failure Transaction Database (FTDB), a database used to populate several publications such as the HSOB. This date can be different than RPT_STOP_YR. For example, an institution can fail in the first quarter of a year, before filing the March Call Report or TFR. A count of CERTS by RPT_STOP_YR would not include that CERT because that institution stopped reporting in the previous year. This variable can be used to reconcile this data set's contents with counts in publications such as HSOB's table BF02.
      FAIL_QTR FTDB Quarter the institution failed from the FTDB.
      FAIL_DATE FTDB Date the institution failed from the FTDB, expressed as yyyymmdd, where yyyy is the year, mm is the month, and dd is the date of failure. This date can be different than RPT_STOP_YR. For example, an institution can fail in the first quarter of a year, before filing the March Call Report or TFR. A count of CERTS by RPT_STOP_YR would not include that CERT because that institution stopped reporting in the previous year. This variable can be used to reconcile this data set's contents with counts in publications such as HSOB table BF02.
      RUN_DATE CALC The date when the current Community Banking Structure Reference Data was created, expressed as yyyymmdd. This date is the same for every record.

      Sources: FTDB = Failure Transaction Database, MERG =RIS Merger History File, CALC = Calculated by the Division of Insurance and Research (Updated annually), RIS = Research Information System (Updated quarterly)

      * Variable derivation is further discussed in 2b, below.

    3. Variable Derivation
    4. This section describes how the variables were derived more specifically than described in 2a. above.

      CERT The initial list of CERTs to be included in this data set were identified by comparing the unique CERTS in RIS at year-end 1985 with those at year-end 1984. Those that existed in 1985 that didn't exist in 1984 have a RPT_START_YR of 1985, and those that existed in 1984 that didn't exist in 1985 have a RPT_STOP_YR of 1985. This logic is followed through to the current period for all RPT_START and RPT_STOP variables. This data set only includes CERTS that are included in the QBP "Number of institutions reporting" line item.

      RPT_START_TYPE SIMS Structure Distribution Center was queried to identify the closest transaction code to the RPT_START date for each of the CERTs with a RPT_START date.

      • If the SIMS event code for the CERT in question was 110, "New Additions", then a RPT_START_TYPE code of "1" was entered.
      • If the SIMS event code for the CERT in question was 410, "Change in Insurance Status", then a RPT_START_TYPE code of "2" was entered.
      • If neither of these codes existed in SIMS for the CERT in question, then a RPT_START_TYPE code of "3" was entered.

      RPT_START_YR Populated by querying RIS and identifying the earliest Call Report or TFR available, and then extracting the year of that first report from variable CALLYM in the RIS Structure Information database.

      RPT_START_QTR Populated by querying RIS and identifying the earliest Call Report or TFR available, and then extracting the quarter of that first report from variable CALLYM in the RIS Structure Information database.

      RPT_START_CALLYM Populated by querying RIS and identifying the earliest Call Report or TFR available, and then extracting the date of that first report from variable CALLYM in the RIS Structure Information database.

      RPT_STOP_TYPE Populated through sequence of analyzing the transaction codes from SIMS, failure dates and resolution types from the Failure Transaction Database, and RIS Merger History files.

      • Institutions other than assisted acquisitions with failure dates received a stop type of "1".
      • Institutions that merged out of existence who were of common ownership four quarters prior to the stopped date received a stop type of "2".
      • Institutions that merged out of existence that were not of common ownership received a stop type of "3" (approximately 3.03% of this population received government assistance 180 days or less before the RPT_STOP_CALLYM).
      • Institutions involved in other liquidations or closings received a stop type of "4."
      • Institutions that stopped reporting for any unexplained reason received stop type of "5."

      RPT_STOP_YR - Populated by querying RIS and identifying the latest Call Report or TFR available, and then extracting the year of that last report from variable CALLYM in the RIS Merger database.

      RPT_STOP_QTR - Populated by querying RIS and identifying the latest Call Report or TFR available, and then extracting the quarter of that last report from variable CALLYM in the RIS Merger database.

      RPT_STOP_CALLYM - Populated by querying RIS and identifying the latest Call Report or TFR available, and then extracting the date of that last report from variable CALLYM in the RIS Merger database.

  5. Maintenance and Revision
  6. 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.

    The Community Banking Structure Reference Data will be updated once a year by the Data Management section of the FDIC's Statistics Branch. This file will always be named "Community Banking Structure Reference Data.csv". Any changes made to the data set will be recorded in all subsequent notes to users.

  7. Abbreviation Dictionary
  8. Abbreviation Full Name
    CERT FDIC Certificate Number
    FTDB Failure Transaction Database
    HSOB Historical Statistics on Banking
    OBA Open Bank Assistance
    QBP Quarterly Banking Profile
    RIS Research Information System
    SIMS Structure Information Management System
    TFR Thrift Financial Reports



Last Updated 12/18/2012 CommunityBanking@fdic.gov