Global Navigation


 

What's New for SDI and Data Availability
   Notes on Statistical Capability and Averages

 
Updated:

With September 2020 data:

  • Added Pledged loans (LNPLEDGE) on the Net Loans and Leases report memoranda section.

  • The following institution did not file a report this quarter: Prime Bank (FDIC # 58804).

  • The financial predefined data .zip files were updated back thru December 2010. The organization of that data matches the most current quarter attributes, except for the new PPP and MMLF report that started June 2020.

With June 2020 data:

  • (New) PPP Loans, PPLF Borrowings, and MMLF Assets Report for June 2020 data only. Added RIS variables: PPPLNNUM, PPPLNBAL, PPPLNPLG, PPPLF1LS, PPPLFOV1, AVPPPPLG, MMLFBAL, AVMMLF.

  • The following institutions did not file a report this quarter as they sold a majority of their assets to credit unions, but their charters remain active: West End Bank SB (#28807), New Buffalo Savings Bank (#31257), Ben Franklin Bank of IL (#28384).

  • The Financial data predefined .zip files were updated back thru December 2009.  The organization of that data matches the most current quarter attributes, except for the new PPP and MMLF report that started June 2020. 

With March 2020 data:

  • Changes made for both the Current Expected Credit Losses (CECL) accounting standard and the Community Bank Leverage Ratio (CBLR) regulatory framework.  Please see the definitions and footnotes on the reports and items affected.

  • Securities report: Exchanged IDSCCMMB, Other commercial mortgage-backed securities, for SCCMB to clarify difference between the actual FDIC RIS variable.  Added SCHTMRES, Allowance for credit losses on held to maturity debt securities, for CECL reporters.

  • Performance and Condition Ratios report: Added CBLRIND, elected community bank leverage ratio framework (1 is Yes).  Removed RBC1RWAJ and RBCT1CER, Tier 1 ratios, because they are not available for institutions that have elected the Community Bank Leverage Ratio (CBLR). Replaced them with IDT1CER, Common equity tier 1 capital ratio, and IDT1RWAJR, Tier 1 risk-based capital ratio, which are only calculated for those that have not elected the CBLR framework. Standard peer data is not available for those ratios.  Custom peer data includes only those that have not elected the CBLR framework.

  • The predefined datasets (.zip files) for all FDIC-insured institutions were updated back through December 2014.

With December 2019 data:

  • No data additions, deletions, or modifications.

With September 2019 data:

  • There were more rule changes to reduce reporting burden. Please see footnotes on the reports affected.

  • The Total Assets limit for FFIEC Call Form 51 filers increased to $5 Billion from $1 Billion. The FFIEC Call form 51 began in March 2017 for institutions with domestic offices.

  • In the predefined quarterly .zip files INST.WEBADDR and WEBADDR reflect the September 2019 data. FFIEC Call Form 51 filers now only report their main website address, and applicable trade names or website addresses semiannually in  June and December.

  • The FFIEC Call Form 51 filers only report Loans restructured in troubled debt restructurings semiannually each June and December.   

  • FFIEC Call form 51 filers report Fiduciary and Related Assets quarterly, semi-annually or yearly based on the amount of their fiduciary assets and fiduciary income as of the preceding December 31st. They file quarterly if fiduciary assets are over $1 billion or fiduciary income is over 10% of revenue.  They file in June and December if fiduciary assets are over $250 million to $1 billion or fiduciary income is over 10% revenue. Else, they file yearly in December.

  • No data additions, deletions, or modifications.

With June 2019 data:

  • No data additions, deletions or modifications

With March 2019 data:

  • Removed Securitization items that ended in June 2018. On the Bank Assets Sold and Securitized report, deleted ASDRHEL, ASDRCRCD, ASDRAUTO, ASDRCONS, and ASDRCI. On the Maximum Amount of Credit Exposure Retained report, deleted SZIORES, SZIOHEL, SZIOCRCD, SZIOAUTO, SZIOCON, SZIOCI, SZIOOTH, SZSSCRES, SZSSCHEL, SZSSCCRD, SZSSCAUT, SZSSCCON, SZSSCCI, SZSSCOTH, IDSLCRES, IDSLCHEL, IDSLCCCD, IDSLCAUT, IDSLCCON, IDSLCCCI, IDSLCOTH, ENCEHEL, ENCECRCD, ASCEHEL, ASCECRCD, ASCEAUTO, ASCECONS, ASCECI.

  • The predefined datasets (.zip files ) for all FDIC-insured institutions were updated back through March 2013

With December 2018 data:

  • No data additions, deletions or modifications

  • December data does not include FDIC Certs #58005 Georgia Heritage Bank, #58262 Preferred Community Bank and #58466 Millennium Bank.

  • The predefined datasets (.zip files ) for all FDIC-insured institutions were updated back through December 2000

With September 2018 data:

  • No data additions, deletions or modifications

  • September data does not include FDIC Certs #58005 Georgia Heritage Bank and #58262 Preferred Community Bank.

With June 2018 data:

  • There were significant rule changes to reduce reporting burden. Please see new footnotes on the reports affected

  • The line items that end before June 2018 are indicated in the label. They will be available through December 2018 data. After that, the reports will reflect the current format only.

  • US Government Obligations Report, added Non-mortgage backed total, IDSCAS.

  • Goodwill and Other Intangibles Report, removed INTANGAO and replaced it with INTANOTH.

  • Maximum Amount of Credit Exposure Retained Report, added Total securitization sponsored by reporting institution by each loan category, SZISLRES, SZISLHEL ,SZISLCCD, SZISLAUT, SZISLCON, SZISLCI, SZISLOTH.

  • The predefined datasets for all FDIC-insured institutions were updated back through March 2014.

With March 2018 data:

  • Securities Report - added Equity securities with readily determinable fair values(SCEQFV) and the sum of equity securities available-for-sale and equity securities with determinable fair value as Equity Securities not held for trading (IDSCEQ). The equity securities with readily determinable fair values data begins in March 2018 and is reported by institutions that have adopted FASB Accounting Standards ASU 2016-01.

  • March data does not include FDIC Cert # 11133 Farmers State Bank of Canton

With December 2017 data:

  • No data additions, deletions or modifications.

With September 2017 data:

  • The September 2017 data does not include Scotiabank de Puerto Rico (FDIC Cert #22946). They were given more time to file because of the hurricane.

  • No data additions or deletions. Yet, the P3ASSET and P3LNLS source formulas for 51 CALL reporters were repaired.

Mid October 2017:

  • Expanded the Institutions based Custom Peer Group limit from 100 to 200.

With June 2017 data:

  • No data additions, deletions or modifications.

With March 2017 data:

  • Significant reporting requirement changes for banks filing the new FFIEC Call Report 51, banks with domestic offices only and Total Assets < $1 billion.

    • The FFIEC Call Report number is listed on each bank’s Demographic report or download.
    • Data that previously was reported as zeros may now be null because it is not required.
    • Some reports are now only filed semi-annually.
    • Please review each report’s footnotes for more detail. Overall report requirements may not yet be in each line item definition

  • The remaining maturity or re-pricing frequency for time deposits is now reported at the $250,000 threshold and not at the $100,000 threshold. So changes were made to the 4 reports related deposit thresholds. New variables include NTRTMMED, IDcd3less, IDcd3t12s, IDcd1t3s,IDcdov3s, NTRTMLGJ,IDcd3les, IDcd3t12, Idcd1t3, IDcdov3.

  • Total Interest Expense report - added Other interest expense, IDEOTHINT and IDEOTHINTQ, for Call Report 51 filers.

  • Memoranda (servicing) - added 1-4 family residential mortgages serviced in foreclosure, MSRESFCL.

  • Net Charge-offs to loan % - removed All other loans & leases (including farm) IDNTOTHR and IDNTOTQR.

  • Non-Current loans to loans % - removed All other loans & leases (including farm) IDNCOTHR.

Mid May2017:

  • Added quarterly Other Trade Name and Website information, if applicable, to the Demographic Report and download. The use of trade names and other websites is an optional business practice, not used by all banks. The information is reported quarterly on the FFIEC Call report, Schedule RC-M starting in March of 2014. It is provided electronically by the bank to the FDIC on the required FFIEC CALL reports (RC-M). The information is not edited by the FDIC. TE01N529, TE02N529, TE03N529, TE04N529, TE05N529, TE06N529, TE01N528, TE02N528, TE03N528, TE04N528, TE05N528, TE06N528, TE07N528, TE08N528, TE09N528, TE10N528.

With December 2016 data:

  • No data additions, deletions or modifications.

With September 2016 data:

  • No data additions, deletions or modifications.

With June 2016 data:

  • No data additions, deletions or modifications.

  • See Update Schedule, all quarters updated.

  • All Financial Data .zip files for Data Download updated.

With March 2016 data:

  • On the percent Net Charge-offs to Loans report and the percent Non-current Loans to Loans report additional break outs of Other loans to Individuals for Automobile loans and Other consumer loans were added. The percent of Net Charge-offs to Loans variables are: YTD – IDNTATOR and IDNTCOTR, QTR – NTAUTOQR and NTCONTQR. The percent of Non-current Loans to Loans variables are: IDNCATOR and IDNCCOTR.

With December 2015 data:

  • No data additions, deletions or modifications.

With September 2015 data:

  • Six new variables were added to the Past Due and Nonaccrual Assets Report related to owner-occupied and other nonfarm nonresidential properties (P3RENROW, P3RENROT, P9RENROW, P9RENROT, NARENROW,NARENROT).

  • Twenty-four new variables were added to the Loan Charge-Offs and Recoveries Report related to 1-4 family residential construction loans, other construction loans, owner-occupied nonfarm nonresidential property loans, and other nonfarm nonresidential property loans. (Year-to-date and quarterly variables: DRRECNFM, DRRECNOT, DRRECNFQ, DRRECNOQ, DRRENROW DRRENROT, DRRENOWQ, DRRENOTQ, CRRECNFM, CRRECNOT, CRRECNFQ, CRRECNOQ, CRRENROW, CRRENROT, CRRENOWQ, CRRENOTQ, NTRECNFM, NTRECNOT, NTRECNFQ, NTRECNOQ, NTRENROW, NTRENROT, NTRENOWQ, NTRENOTQ).

Mid-September 2015:

  • Changed the search criteria Specialized Categories (FAQ’s) to Common Searches and added FDIC Community Banks as a search/select option allowing lists in ID and custom peers in SDI to be created.

  • Updated and expanded tutorials in new.pdf format.

  • In SDI, modified the single institution search and custom peers create to use/translate Federal Reserve RSSD ID numbers.

  • Added the FDIC Community Bank indicator and number of insured offices in others areas in the ID demographic report and the SDI custom download. (Demographic items can only be downloading in SDI not viewed.)  

With June 2015 data:

  • Two demographic variables were added to the ID download, CB and OFFOA. CB is the FDIC Community Bank flag, 1=yes. OFFOA is number of offices in other insured areas. We plan for both variables to be available for use within SDI and ID later this fall.

With March 2015 Data:

  • Performance and Condition Ratio Report – the Earning assets to total assets ratio (ERNASTR) and Common equity tier 1 capital ratio (RBCT1CER) were added.

  • Multiple definition updates to reflect that beginning March 2015 all institutions now report according to the amended Market Risk Capital Rule, see: FDIC Financial Institutions Letter FIL-24-1012 and CALL schedule RC-R part 1B.

With December 2014 Data:

  • No data additions, deletions or modifications

With September 2014 Data:

  • No data additions, deletions or modifications

With June 2014 Data:

  • Asset & Liability Report - Total risk-weighted assets adjusted as of March 2014, according to the amended Market Risk Capital Rule, see: FDIC Financial Institutions Letter FIL-24-1012 and CALL schedule RC-R part 1B. (Variable changed from RWAJ to RWAJT.). 

  • Performance and Condition Ratio Report - Net loans and leases to total assets ratio (LNLSNTV) and Total domestic deposits to total assets (DEPDASTR) were added in an ongoing effort to sync with the Quarterly Banking Profile.

With March 2014 Data:

  • No data additions, deletions or modifications

 With December 2013 Data:

  • No data additions, deletions or modifications

With September 2013 Data:

  • The year-to-date and quarterly loan and lease provision to average asset ratios were added to the Performance and Condition ratio report back through December 2008 (ELNATRY, ELNATRYQ).

With June 2013 Data:

  • No data additions, deletions or modifications

With March 2013 Data:

  • The Financial Assets Transferred Report, variables, and associated links were removed. Most of the data had not been collected for ten years or can be found on the Servicing, Securitization, and Asset Sales Report. 

  • In an effort to re-sync with the Quarterly Banking Profile, Noninterest income to earning assets (noniiy & noniiyq) were replaced by  Noninterest income to average assets (NONIIAY & noniiaqy). Also Noninterest expense to earning assets (nonixy & nonixyq) were replaced with Noninterest expense to average assets (NONIXAY & nonixayq) on the Performance & Condition Ratios Report. The quarterly Percentage of institutions with earning gains was also repaired for summary data on that report.

  • On the Net-Charge Offs to Loans Report and the Noncurrent Loans to Loans Report both Other loans to individuals (idntcoor, IDNTCOQR& idnccoor) were updated to include Auto loans that were separated in 2011.  

  • Download All .zip files were updated back to March 2003. 

With December 2012 Data:

  • No data additions, deletions or modifications

With September 2012 Data:

  • No data additions, deletions or modifications

With June 2012 Data:

  • No data additions, deletions or modifications

With March 2012 Data:

  • OTS-regulated savings institutions converted from filing the Thrift Financial Report (TFR) to filing the Consolidated Reports of Condition and Income (Call Report) beginning with the reporting period ending March 31, 2012.
  • No data additions, deletions or modifications.

With December 2011 data:

  • Estimated assessable deposits (DEPCSBQ) on the Total Deposits Report was removed because it was based on the pre-Dodd-Frank definition. No data additions. Minor clarification and expansion of some definitions.
  • SDI Download All data in (.ZIP) bulk files updated thru June 2007.

 
 

 

Update Schedule:

All data presented reflect the highest level of consolidation (e.g., domestic and foreign operations) unless otherwise indicated. This information is stored on and retrieved from the FDIC Research Information System (RIS) database.  

 
 

Quarter

Year

 Date of RIS Update
1 September 2020  as of   11/14/2020
2 June 2020  as of 11/14/2020
3 March 2020  as of 11/14/2020
4
December
2019
  as of 11/14/2020
5
September
2019
 as of
 11/14/2020
6
June
2019
 as of
 11/14/2020
7
March
2019
 as of
 11/14/2020
8
December
2018
 as of
 11/14/2020
9
September
2018
 as of
 11/3/2020
10
June
2018
 as of
 11/3/2020
11
March
2018
 as of
10/29/2020
12
December
2017
 as of
 10/29/2020
13
September
2017
 as of
 10/29/2020
14
June
2017
 as of
 10/29/2020
15
March
2017
 as of
 10/29/2020
16
December
2016
 as of
 10/29/2020
17
September
2016
 as of
 10/29/2020
18
June
2016
 as of
 10/29/2020
19
March
2016
 as of
 10/29/2020
20
December
2015
 as of
 10/29/2020
21
September
2015
 as of
 10/29/2020
22
June
2015
 as of
 10/29/2020
23
March
2015
 as of
 10/29/2020
24
December
2014
 as of
 10/29/2020
25
September 
2014
 as of
 10/29/2020
26
June
2014
 as of
 10/29/2020
27
March
2014
 as of
 10/29/2020
28
December
2013
 as of
 10/29/2020
29
September 
2013
 as of
 10/29/2020
30
June
2013
 as of
 10/29/2020
31
March
2013
 as of
 10/29/2020
32
December
2012
 as of
 10/29/2020
33
September 
2012
 as of
 10/29/2020
34
June
2012
 as of
 10/29/2020
35
March
2012
 as of
 10/29/2020
36
December
2011
 as of
 10/29/2020
37
September
2011
 as of
 10/29/2020
38
June
2011
 as of
 10/29/2020
39
March
2011
 as of
 10/29/2020
40
December
2010
 as of
 10/29/2020
41
September
2010
 as of
 7/20/2020
42
June
2010
 as of
 7/20/2020
43
March
2010
 as of
 7/20/2020
44
December
2009
 as of
 7/20/2020
45
September
2009
 as of
12/16/2018
46
June
2009
 as of
12/16/2018
47
March
2009
 as of
12/16/2018
48
December
2008
 as of
12/15/2018
49
September
2008
 as of
12/15/2018
50
June
2008
 as of
12/15/2018
51
March
2008
 as of
12/15/2018
52
December
2007
 as of
12/14/2018
53
September
2007
 as of
12/14/2018
54
June
2007
 as of
12/14/2018
55
March
2007
 as of
12/14/2018
56
December
2006
 as of
12/14/2018
57
September
2006
 as of
12/14/2018
58
June
2006
 as of
12/14/2018
59
March
2006
 as of
12/14/2018
60
December
2005
 as of
12/13/2018
61
September
2005
 as of
12/13/2018
62
June
2005
 as of
12/13/2018
63
March
2005
 as of
12/13/2018
64
December
2004
 as of
12/13/2018
65
September
2004
 as of
12/13/2018
66
June
2004
 as of
12/12/2018
67
March
2004
 as of
12/12/2018
68
December
2003
 as of
12/12/2018
69
September
2003
 as of
12/12/2018
70
June
2003
 as of
12/12/2018
71
March
2003
 as of
12/12/2018
72
December
2002
 as of
12/12/2018
73
September
2002
 as of
12/12/2018
74
June
2002
 as of
12/12/2018
75
March
2002
 as of
12/12/2018
76
December
2001
 as of
12/11/2018
77 September 2001  as of 12/11/2018
78 June 2001  as of 12/11/2018
79 March 2001  as of 12/11/2018
80
December
2000
 as of
12/11/2018
81
December
1999
 as of
12/10/2018
82
December
1998
 as of
12/9/2018
83
December
1997
 as of
12/8/2018
84
December
1996
 as of
12/7/2018
85
December
1995
 as of
12/7/2018
86
December
1994
 as of
12/6/2018
87
December
1993
 as of
12/6/2018
88
December
1992
 as of
12/5/2018