BOARD OF GOVERNORS OF THE FEDERAL RESERVE SYSTEM

1 BOARD OF GOVERNORS OF THE FEDERAL RESERVE SYSTEM BULK DATA DOWNLOAD DATA DICTIONARY AND REFERENCE GUIDE Document Version Prepared By: National Information Center Rev. 11/16 This page was intentionally left blank. TABLE OF CONTENTS SECTION I GENERAL INFORMATION .. 1 SECTION II HOW TO USE THE DATA DICTIONARY .. 2 SECTION III TABLE 3 SECTION IV ATTRIBUTES TABLE DETAILS .. 4 SECTION V RELATIONSHIPS TABLE DETAILS .. 31 SECTION VI TRANSFORMATIONS TABLE DETAILS.

2 40 1 SECTION I GENERAL INFORMATION BULK DATA DOWNLOAD The Bulk Data Download feature was developed in response to growing demand from the public for data in bulk format. Data being provided are considered non-confidential, public data. As our first iteration of this feature, we are releasing the tables related to attributes, relationships, and transformations. Details of these tables can be found in the subsequent sections of this Data Dictionary. Future developments of this feature are planned with the intent of expanding the available data provided on the NIC public website on an individual institution basis.

3 In the interim, additional requests for data can be made via our Freedom of Information Act Office. Additionally, we welcome feedback regarding the presentation of the data via our feedback link. 2 SECTION II HOW TO USE THE DATA DICTIONARY DATA ELEMENTS The Data Dictionary consists of data elements stored in tabl es t hat de scribe a n entity, its struc tur e, its relationships with ot her entities, and its existence over time. T he tables in the Bulk Data Download are: Attributes: The data are broken down into three files based on the status of the institution or branch.

4 O Active: Provides information describing the characteristics of open and active institutions. o Closed: Provides the last instance of closed / failed institutions. o Branches: Provides the last instance of branches whose head office is listed in either the Active or Closed Attributes tables. Relationships: Provides the history of ownership between two entities. Transformations: Provides information on mergers and failures. While all entities have data in the Attributes category, records withi n other categories are initialized only when applicable.

5 LINKING TABLES When linking the tables, please note the primary keys which should be used: Attributes: ID_RSSD, D_DT_START Relationships: ID_RSSD_PARENT, ID_RSSD_OFFSPRING, D_DT_START, RELN_LVL Transformations: ID_RSSD_PREDECESSOR, ID_RSSD_SUCCESSOR, D_DT_TRANS 3 SECTION III TABLE ELEMENTS ATTRIBUTES ACT_PRIM_CD AUTH_REG_DIST_FRS BANK_CNT BHC_IND BNK_TYPE_ANALYS_CD BROAD_REG_CD CHTR_AUTH_CD CHTR_TYPE_CD CITY CNSRVTR_CD CNTRY_CD CNTRY_INC_CD CNTRY_INC_NM CNTRY_NM COUNTY_CD D_DT_END D_DT_EXIST_CMNC D_DT_EXIST_TERM D_DT_INSUR D_DT_OPEN D_DT_START DIST_FRS DOMESTIC_IND DT_END DT_EXIST_CMNC DT_EXIST_TERM DT_INSUR DT_OPEN DT_START ENTITY_TYPE EST_TYPE_CD FBO_4C9_IND FHC_IND FISC_YREND_MMDD FNCL_SUB_HOLDER FNCL_SUB_IND FUNC_REG IBA_GRNDFTHR_IND IBF_IND

6 ID_ABA_PRIM ID_CUSIP ID_FDIC_CERT ID_LEI ID_NCUA ID_OCC ID_RSSD ID_RSSD_HD_OFF ID_TAX ID_THRIFT ID_THRIFT_HC INSUR_PRI_CD MBR_FHLBS_IND MBR_FRS_IND MJR_OWN_MNRTY NM_LGL NM_SHORT NM_SRCH_CD ORG_TYPE_CD PLACE_CD PRIM_FED_FEG PROV_REGION REASON_TERM_CD SEC_RPTG_STATUS SLHC_IND SLHC_TYPE_IND STATE_ABBR_NM STATE_CD STATE_HOME_CD STATE_INC_ABBR_NM STATE_INC_CD STREET_LINE1 STREET_LINE2 URL ZIP_CD RELATIONSHIPS CTRL_IND D_DT_END D_DT_RELN_EST D_DT_START DT_END DT_RELN_EST DT_START EQUITY_IND FC_IND ID_RSSD_OFFSPRING ID_RSSD_PARENT MB_COST OTHER_BASIS_IND PCT_EQUITY PCT_EQUITY_BRACKET PCT_EQUITY_FORMAT PCT_OTHER REASON_ROW_CRTD REASON_TERM_RELN REG_IND REGK_INV RELN_LVL TRANSFORMATIONS ACCT_METHOD D_DT_TRANS DT_TRANS ID_RSSD_PRECESSOR ID_RSSD_SUCCESSOR TRNSFM_CDATTRIBUTES TABLE 4 SECTION IV ATTRIBUTES TABLE DETAILS The data element s in the Attributes Table cha racterize an ent ity.

7 Each entity has a unique ide nt ifier, the ID_RSSD. T his table contains entity de script ors that define the l egal and commonl y us ed cha racteristics of an entity, . the t ype of cha rter, the i ns ur er, location, etc. The se cha racteristics are c onsistent ly va lid for t he e ntity withi n the specified date range. Not all data items are r equired for each entity's Attributes rows. All entities must ha ve an Attributes row in order to have any ot her structur e or f ina nc ial data associated with the e nt ity stored on the databa se.

8 COLUMN: ACT_PRIM_CD DATA TYPE: CHARACTER [6] DESCRIPTION: PRIMARY ACTIVITY CODE The Primary Activity Code is a f ive or s ix-di git North American Industry Classification SYSTEM (NAICS) Code va lue that be st describes the primary activi ty conducted by an entity. A full de scription of all N AICS codes may be f ound at t he U .S. Cens us Bur eau s webs ite at If the e ntity is i nactive, thi s item should contain 0 (zero) except in the cases of Edge a nd Agr eement Corporati ons and electric power companies (including co- gene rators) that report on FR 2009a/b/c.

9 0 = Not applicable (for branches), or inac tive (with the exception of Edge a nd Agreement Corporati ons and electric power compa ni es tha t are c o- gene rators reporting on FR 2009a/b/c) COLUMN: AUTH_REG_DIST_FRS (ARDF) DATA TYPE: INTEGER DESCRIPTION: FEDERAL RESERVE REGULATORY DISTRICT CODE The FEDERAL RESERVE Regulatory District Code is a t wo- di git numeric code de signating the FEDERAL RESERVE District of regulator y aut hority for institutions. Refer to the Attributes DIST_FRS column entry for code to district translations.

10 Entity types included are: Depository Institutions ( ., Banks, Thr ifts, Credit Uni ons, etc.) Bank Hol di ng Compa ni es Savi ng s and Loan Hol di ng Compani es Foreign Banking Organizations Edge Corporati ons Agr eement Corporati ons Sole foreign owne rs of a subs idiary Edge or Agreement Corporati on Chang es in Regulations D and I, e ffective October 1, 1997, allow de pository institut ions to de note ATTRIBUTES TABLE 5 a Fede ral RESERVE office ot her than w he re the e ntity is p hysically located for purposes of Fede ral RESERVE membe rship and/or RESERVE account maint ena nce.