TABLE: RICII COLUMNS: +---------------------------+--------------------------------------+---------+ | Name | Label | Type | +---------------------------+--------------------------------------+---------+ | IDRSSD | | INTEGER | | Reporting_Period_End_Date | Reporting Period End Date | DATE | | unnamed | | INTEGER | | RCFDJJ04 | Loans and Leases, Held for Investmen | INTEGER | | RCFDJJ05 | Loans and Leases, Held for Investmen | INTEGER | | RCFDJJ06 | Loans and Leases, Held for Investmen | INTEGER | | RCFDJJ07 | Loans and Leases, Held for Investmen | INTEGER | | RCFDJJ08 | Loans and Leases, Held for Investmen | INTEGER | | RCFDJJ09 | Loans and Leases, Held for Investmen | INTEGER | | RCFDJJ11 | Loans and Leases, Held for Investmen | BIGINT | | RCFDJJ12 | Loans and Leases, Held for Investmen | INTEGER | | RCFDJJ13 | Loans and Leases, Held for Investmen | INTEGER | | RCFDJJ14 | Loans and Leases, Held for Investmen | INTEGER | | RCFDJJ15 | Loans and Leases, Held for Investmen | INTEGER | | RCFDJJ16 | Loans and Leases, Held for Investmen | INTEGER | | RCFDJJ17 | Loans and Leases, Held for Investmen | INTEGER | | RCFDJJ18 | Loans and Leases, Held for Investmen | INTEGER | | RCFDJJ19 | Loans and Leases, Held for Investmen | INTEGER | | RCFDJJ20 | Held to Maturity Securities, Securit | INTEGER | | RCFDJJ21 | Held to Maturity Securities, Mortgag | INTEGER | | RCFDJJ23 | Held to Maturity Securities, Asset b | INTEGER | | RCFDJJ24 | Held to Maturity Securities, Other d | INTEGER | | RCFDJJ25 | Held to Maturity Securities, Total | INTEGER | | RCONJJ04 | Loans and Leases, Held for Investmen | INTEGER | | RCONJJ05 | Loans and Leases, Held for Investmen | INTEGER | | RCONJJ06 | Loans and Leases, Held for Investmen | INTEGER | | RCONJJ07 | Loans and Leases, Held for Investmen | INTEGER | | RCONJJ08 | Loans and Leases, Held for Investmen | INTEGER | | RCONJJ09 | Loans and Leases, Held for Investmen | INTEGER | | RCONJJ11 | Loans and Leases, Held for Investmen | INTEGER | | RCONJJ12 | Loans and Leases, Held for Investmen | INTEGER | | RCONJJ13 | Loans and Leases, Held for Investmen | INTEGER | | RCONJJ14 | Loans and Leases, Held for Investmen | INTEGER | | RCONJJ15 | Loans and Leases, Held for Investmen | INTEGER | | RCONJJ16 | Loans and Leases, Held for Investmen | INTEGER | | RCONJJ17 | Loans and Leases, Held for Investmen | INTEGER | | RCONJJ18 | Loans and Leases, Held for Investmen | INTEGER | | RCONJJ19 | Loans and Leases, Held for Investmen | INTEGER | | RCONJJ20 | Held to Maturity Securities, Securit | INTEGER | | RCONJJ21 | Held to Maturity Securities, Mortgag | INTEGER | | RCONJJ23 | Held to Maturity Securities, Asset b | INTEGER | | RCONJJ24 | Held to Maturity Securities, Other d | INTEGER | | RCONJJ25 | Held to Maturity Securities, Total | INTEGER | +---------------------------+--------------------------------------+---------+ DATA SOURCES: /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk All Schedules/FFIEC CDR Call Bulk All Schedules 06302021/FFIEC CDR Call Schedule RICII 06302021.txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk All Schedules/FFIEC CDR Call Bulk All Schedules 03312019/FFIEC CDR Call Schedule RICII 03312019.txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk All Schedules/FFIEC CDR Call Bulk All Schedules 06302019/FFIEC CDR Call Schedule RICII 06302019.txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk All Schedules/FFIEC CDR Call Bulk All Schedules 12312020/FFIEC CDR Call Schedule RICII 12312020.txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk All Schedules/FFIEC CDR Call Bulk All Schedules 09302019/FFIEC CDR Call Schedule RICII 09302019.txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk All Schedules/FFIEC CDR Call Bulk All Schedules 09302020/FFIEC CDR Call Schedule RICII 09302020.txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk All Schedules/FFIEC CDR Call Bulk All Schedules 03312021/FFIEC CDR Call Schedule RICII 03312021.txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk All Schedules/FFIEC CDR Call Bulk All Schedules 06302020/FFIEC CDR Call Schedule RICII 06302020.txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk All Schedules/FFIEC CDR Call Bulk All Schedules 03312022/FFIEC CDR Call Schedule RICII 03312022.txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk All Schedules/FFIEC CDR Call Bulk All Schedules 03312020/FFIEC CDR Call Schedule RICII 03312020.txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk All Schedules/FFIEC CDR Call Bulk All Schedules 12312019/FFIEC CDR Call Schedule RICII 12312019.txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk All Schedules/FFIEC CDR Call Bulk All Schedules 06302022/FFIEC CDR Call Schedule RICII 06302022.txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk All Schedules/FFIEC CDR Call Bulk All Schedules 12312021/FFIEC CDR Call Schedule RICII 12312021.txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk All Schedules/FFIEC CDR Call Bulk All Schedules 09302021/FFIEC CDR Call Schedule RICII 09302021.txt PARSE ERRORS: SOURCE: Financial Institutions Examination Council -- https://cdr.ffiec.gov/public/ Data downloaded 2022-10-29, indexed and report generated 2022-10-31.