TABLE: RICI COLUMNS: +---------------------------+--------------------------------------+---------+ | Name | Label | Type | +---------------------------+--------------------------------------+---------+ | IDRSSD | | INTEGER | | Reporting_Period_End_Date | Reporting Period End Date | DATE | | unnamed | | INTEGER | | RCFDM708 | RE CNSTR LN RECD INVST:INDV IMPARMNT | INTEGER | | RCFDM709 | RE CNSTR LN ALLW BAL: INDV IMPAIRMNT | INTEGER | | RCFDM710 | RE CNSTR LN RECD INVST:COLL IMPARMNT | INTEGER | | RCFDM711 | RE CNSTR LN ALLW BAL: COLL IMPAIRMNT | INTEGER | | RCFDM712 | RE CNSTR LN REC INVST PUR CR IMPRMNT | INTEGER | | RCFDM713 | RE CNSTR LN ALLW BAL PUR CR IMPARMNT | INTEGER | | RCFDM714 | RE CMRL LN RECD INVST INDV IMPAIRMNT | INTEGER | | RCFDM715 | RE CMRL LN ALLW BAL: INDV IMPAIRMNT | INTEGER | | RCFDM716 | RE CMRL LN RECD INVST COLL IMPAIRMNT | INTEGER | | RCFDM717 | RE CMRL LN ALLW BAL: COLL IMPAIRMNT | INTEGER | | RCFDM719 | RE CMRL LN REC INVST PUR CR IMPARMNT | INTEGER | | RCFDM720 | RE CMRL LN ALLW BAL PUR CR IMPAIRMNT | INTEGER | | RCFDM721 | RE RESD LN RECD INVST INDV IMPAIRMNT | INTEGER | | RCFDM722 | RE RESD LN ALLW BAL: INDV IMPAIRMNT | INTEGER | | RCFDM723 | RE RESD LN RECD INVST:COLL IMPAIRMNT | INTEGER | | RCFDM724 | RE RESD LN ALLW BAL: COLL IMPAIRMNT | INTEGER | | RCFDM725 | RE RESD LN REC INVST PUR CR IMPARMNT | INTEGER | | RCFDM726 | RE RESD LN ALLW BAL:PUR CR IMPAIRMNT | INTEGER | | RCFDM727 | CMRL LN RECD INVST: INDV IMPAIRMNT | INTEGER | | RCFDM728 | CMRL LN ALLW BAL: INDV IMPAIRMNT | INTEGER | | RCFDM729 | CMRL LN RECD INVST: COLL IMPAIRMNT | INTEGER | | RCFDM730 | CMRL LN ALLW BAL: COLL IMPAIRMNT | INTEGER | | RCFDM731 | CMRL LN RECD INVST: PUR CR IMPAIRMNT | INTEGER | | RCFDM732 | CMRL LN ALLW BAL: PUR CR IMPAIRMNT | INTEGER | | RCFDM733 | CC LNS RECD INVST: INDV IMPAIRMNT | INTEGER | | RCFDM734 | CC LNS ALLW BAL: INDV IMPAIRMNT | INTEGER | | RCFDM735 | CC LNS RECD INVST: COL IMPAIRMNT | INTEGER | | RCFDM736 | CC LNS ALLW BAL: COL IMPAIRMNT | INTEGER | | RCFDM737 | CC LNS RECD INVST: PUR CC IMPAIRMNT | INTEGER | | RCFDM738 | CC LNS ALLW BAL: PUR COL IMPAIRMNT | BOOLEAN | | RCFDM739 | OTHR CONS LN RECD INVST IND IMPAIRMT | INTEGER | | RCFDM740 | OTHR CONS LN ALLW BAL:INDV IMPAIRMNT | INTEGER | | RCFDM741 | OTHR CONS LN RECD INVST COL IMPARMT | INTEGER | | RCFDM742 | OTHR CONS LN ALLW BAL: COL IMPAIRMNT | INTEGER | | RCFDM743 | OTR CONS LN REC INVST PUR CR IMPRMNT | INTEGER | | RCFDM744 | OTR CONS LN ALW BAL PUR CR IMPAIRMNT | INTEGER | | RCFDM745 | UNALLOCATED ALLW BAL: COL IMPAIRMNT | INTEGER | | RCFDM746 | TOTAL RECORDED INVST: INDV IMPAIRMNT | INTEGER | | RCFDM747 | TOTAL ALLOWANCE BAL: INDV IMPAIRMNT | INTEGER | | RCFDM748 | TOTAL RECORDED INVST: COL IMPAIRMNT | INTEGER | | RCFDM749 | TOTAL ALLOWANCE BAL: COL IMPAIRMNT | INTEGER | | RCFDM750 | TOTAL RECORDED INVST PUR CR IMPARMNT | INTEGER | | RCFDM751 | TOTAL ALLOWANCE BAL:PUR CR IMPAIRMNT | INTEGER | | RCONM708 | RE CNSTR LN RECD INVST:INDV IMPARMNT | INTEGER | | RCONM709 | RE CNSTR LN ALLW BAL: INDV IMPAIRMNT | INTEGER | | RCONM710 | RE CNSTR LN RECD INVST:COLL IMPARMNT | INTEGER | | RCONM711 | RE CNSTR LN ALLW BAL: COLL IMPAIRMNT | INTEGER | | RCONM712 | RE CNSTR LN REC INVST PUR CR IMPRMNT | INTEGER | | RCONM713 | RE CNSTR LN ALLW BAL PUR CR IMPARMNT | INTEGER | | RCONM714 | RE CMRL LN RECD INVST INDV IMPAIRMNT | INTEGER | | RCONM715 | RE CMRL LN ALLW BAL: INDV IMPAIRMNT | INTEGER | | RCONM716 | RE CMRL LN RECD INVST COLL IMPAIRMNT | INTEGER | | RCONM717 | RE CMRL LN ALLW BAL: COLL IMPAIRMNT | INTEGER | | RCONM719 | RE CMRL LN REC INVST PUR CR IMPARMNT | INTEGER | | RCONM720 | RE CMRL LN ALLW BAL PUR CR IMPAIRMNT | INTEGER | | RCONM721 | RE RESD LN RECD INVST INDV IMPAIRMNT | INTEGER | | RCONM722 | RE RESD LN ALLW BAL: INDV IMPAIRMNT | INTEGER | | RCONM723 | RE RESD LN RECD INVST:COLL IMPAIRMNT | INTEGER | | RCONM724 | RE RESD LN ALLW BAL: COLL IMPAIRMNT | INTEGER | | RCONM725 | RE RESD LN REC INVST PUR CR IMPARMNT | INTEGER | | RCONM726 | RE RESD LN ALLW BAL:PUR CR IMPAIRMNT | INTEGER | | RCONM727 | CMRL LN RECD INVST: INDV IMPAIRMNT | INTEGER | | RCONM728 | CMRL LN ALLW BAL: INDV IMPAIRMNT | INTEGER | | RCONM729 | CMRL LN RECD INVST: COLL IMPAIRMNT | INTEGER | | RCONM730 | CMRL LN ALLW BAL: COLL IMPAIRMNT | INTEGER | | RCONM731 | CMRL LN RECD INVST: PUR CR IMPAIRMNT | INTEGER | | RCONM732 | CMRL LN ALLW BAL: PUR CR IMPAIRMNT | INTEGER | | RCONM733 | CC LNS RECD INVST: INDV IMPAIRMNT | INTEGER | | RCONM734 | CC LNS ALLW BAL: INDV IMPAIRMNT | INTEGER | | RCONM735 | CC LNS RECD INVST: COL IMPAIRMNT | INTEGER | | RCONM736 | CC LNS ALLW BAL: COL IMPAIRMNT | INTEGER | | RCONM737 | CC LNS RECD INVST: PUR CC IMPAIRMNT | INTEGER | | RCONM738 | CC LNS ALLW BAL: PUR COL IMPAIRMNT | INTEGER | | RCONM739 | OTHR CONS LN RECD INVST IND IMPAIRMT | INTEGER | | RCONM740 | OTHR CONS LN ALLW BAL:INDV IMPAIRMNT | INTEGER | | RCONM741 | OTHR CONS LN RECD INVST COL IMPARMT | INTEGER | | RCONM742 | OTHR CONS LN ALLW BAL: COL IMPAIRMNT | INTEGER | | RCONM743 | OTR CONS LN REC INVST PUR CR IMPRMNT | INTEGER | | RCONM744 | OTR CONS LN ALW BAL PUR CR IMPAIRMNT | INTEGER | | RCONM745 | UNALLOCATED ALLW BAL: COL IMPAIRMNT | INTEGER | | RCONM746 | TOTAL RECORDED INVST: INDV IMPAIRMNT | INTEGER | | RCONM747 | TOTAL ALLOWANCE BAL: INDV IMPAIRMNT | INTEGER | | RCONM748 | TOTAL RECORDED INVST: COL IMPAIRMNT | INTEGER | | RCONM749 | TOTAL ALLOWANCE BAL: COL IMPAIRMNT | INTEGER | | RCONM750 | TOTAL RECORDED INVST PUR CR IMPARMNT | INTEGER | | RCONM751 | TOTAL ALLOWANCE BAL:PUR CR IMPAIRMNT | 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 06302020/FFIEC CDR Call Schedule RICI 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 06302019/FFIEC CDR Call Schedule RICI 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 12312021/FFIEC CDR Call Schedule RICI 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 03312019/FFIEC CDR Call Schedule RICI 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 12312020/FFIEC CDR Call Schedule RICI 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 09302020/FFIEC CDR Call Schedule RICI 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 09302021/FFIEC CDR Call Schedule RICI 09302021.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 RICI 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 03312022/FFIEC CDR Call Schedule RICI 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 06302022/FFIEC CDR Call Schedule RICI 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 03312021/FFIEC CDR Call Schedule RICI 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 03312020/FFIEC CDR Call Schedule RICI 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 RICI 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 06302021/FFIEC CDR Call Schedule RICI 06302021.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.