TABLE: RCRIB COLUMNS: +---------------------------+--------------------------------------+------------------+ | Name | Label | Type | +---------------------------+--------------------------------------+------------------+ | IDRSSD | | INTEGER | | Reporting_Period_End_Date | Reporting Period End Date | DATE | | unnamed | | INTEGER | | RCFA3792 | TOTAL RISK-BASED CAPITAL | INTEGER | | RCFA5310 | ALLL INCLUDIBLE IN TIER2 CAPITAL | INTEGER | | RCFA5311 | TIER 2 (SUPPLEMENTARY) CAPITAL | INTEGER | | RCFA7204 | TIER 1 LEVERAGE CAPITAL RATIO | DOUBLE PRECISION | | RCFA7205 | TOTAL RISK-BASED CAPITAL RATIO | DOUBLE PRECISION | | RCFA7206 | TIER 1 RISK-BASED CAPITAL RATIO | DOUBLE PRECISION | | RCFA8274 | TIER 1 CPTL ALLWBL UNDR RISK-BASED | INTEGER | | RCFAA223 | RISK-WEIGHTED ASSETS | BIGINT | | RCFAA224 | AVG TOT ASSET NET DEDUCTIONS | BIGINT | | RCFAB530 | ACCUMULATED OTH COMPREHENSIVE INCOME | INTEGER | | RCFAB596 | OTHR DEDUCT FR ASSETS FOR LEVRGE CAP | INTEGER | | RCFAP742 | COMMON EQUITY TIER 1 CAPITAL | INTEGER | | RCFAP793 | CAP RATIO COM EQTY TIER1 CAP RATIO | DOUBLE PRECISION | | RCFAP839 | COM EQTY TIER 1 MINORTY INTERST | INTEGER | | RCFAP840 | COM EQTY TIER 1 CAP BEFORE REG ADJ | INTEGER | | RCFAP841 | COM EQTY TIER 1 CAP ADJS AND DEDUDS | INTEGER | | RCFAP842 | LESS INTANG ASSTS NET OF ASSCTD DTLS | INTEGER | | RCFAP843 | DFRD TX ASSTS OPRTING LOSS TX CRDT | INTEGER | | RCFAP849 | NET GNS (LSSES) HTM SEC AOCI | INTEGER | | RCFAP850 | OTH THRSHLD DEDS COMEQTY TIER1 CAP | INTEGER | | RCFAP851 | NNSG INVCP UNCNS COMSTK 10 PCT THRSH | BOOLEAN | | RCFAP852 | SUBTOT COMEQTY TIER1 CAP ADJ AN DEDS | INTEGER | | RCFAP853 | COMSTK 10PCT EQTY TIER1 CAP THRSHLD | BOOLEAN | | RCFAP854 | MSA DTL 10PCT EQTY TIER1 CAP THRS | BOOLEAN | | RCFAP855 | DTAS CAP CMSTK 15PCT TIER1 CAP THRSH | INTEGER | | RCFAP856 | MSA DTA 15PCT COMEQTY TIER1 CAPTHRES | BOOLEAN | | RCFAP857 | INSF TIER1 TIER2 CAP CVR DED | INTEGER | | RCFAP858 | ADJSTMNT DEDT COM EQTY TIER1 CAP | INTEGER | | RCFAP859 | COM EQTY TIER 1 CAPITAL | INTEGER | | RCFAP860 | ADDITIONAL TIER 1 CAPITAL | INTEGER | | RCFAP861 | NNQFY CAP INSTR PHSOUT ADD TIER1 CAP | INTEGER | | RCFAP862 | TIER1 MNRTY INTR NOT EQTY TIER1 CAP | INTEGER | | RCFAP863 | ADD TIER 1 CAPITAL BEFORE DEDUCTIONS | INTEGER | | RCFAP864 | TOT ADDTNL TIER 1 CAP DEDUCTIONS | INTEGER | | RCFAP865 | ADDTNL TIER 1 CAPITAL | INTEGER | | RCFAP866 | TIER 2 CAP INSTRMNTS PLUS RLTD SRPLS | INTEGER | | RCFAP867 | NNQLIFY CAP INSTR PHSOUT TIER2 CAP | INTEGER | | RCFAP868 | CAP MNRTY INTRST NOT INCL TIER 1 CAP | INTEGER | | RCFAP870 | TIER 2 CAPITAL BEFORE DEDUCTIONS | INTEGER | | RCFAP872 | TOTAL TIER 2 CAPITAL DEDUCTIONS | INTEGER | | RCFAP875 | DEDS COMEQTY TIER1 CAP ADD TIER1 CAP | INTEGER | | RCFAQ257 | UNREALIZED GAINS ON A-F-S EQUITY SEC | INTEGER | | RCFAQ258 | CUMULATIVE CHANGE IN FAIR VALUE | INTEGER | | RCFD3368 | QTLY AVG OF TOTAL ASSETS | BIGINT | | RCFD3632 | UNDIVIDED PROFITS & CAPITAL RESERVES | INTEGER | | RCFW3792 | TOTAL RISK-BASED CAPITAL | INTEGER | | RCFW5310 | ALLL INCLUDIBLE IN TIER2 CAPITAL | INTEGER | | RCFW5311 | TIER 2 (SUPPLEMENTARY) CAPITAL | INTEGER | | RCFW7205 | TOTAL RISK-BASED CAPITAL RATIO | DOUBLE PRECISION | | RCFW7206 | TIER 1 RISK-BASED CAPITAL RATIO | DOUBLE PRECISION | | RCFWA223 | RISK-WEIGHTED ASSETS | BIGINT | | RCFWP793 | CAP RATIO COM EQTY TIER1 CAP RATIO | DOUBLE PRECISION | | RCFWP870 | TIER 2 CAPITAL BEFORE DEDUCTIONS | INTEGER | | RCOA3792 | TOTAL RISK-BASED CAPITAL | INTEGER | | RCOA5310 | ALLL INCLUDIBLE IN TIER2 CAPITAL | INTEGER | | RCOA5311 | TIER 2 (SUPPLEMENTARY) CAPITAL | INTEGER | | RCOA7204 | TIER 1 LEVERAGE CAPITAL RATIO | DOUBLE PRECISION | | RCOA7205 | TOTAL RISK-BASED CAPITAL RATIO | DOUBLE PRECISION | | RCOA7206 | TIER 1 RISK-BASED CAPITAL RATIO | DOUBLE PRECISION | | RCOA8274 | TIER 1 CPTL ALLWBL UNDR RISK-BASED | INTEGER | | RCOAA223 | RISK-WEIGHTED ASSETS | INTEGER | | RCOAA224 | AVG TOT ASSET NET DEDUCTIONS | INTEGER | | RCOAB530 | ACCUMULATED OTH COMPREHENSIVE INCOME | INTEGER | | RCOAB596 | OTHR DEDUCT FR ASSETS FOR LEVRGE CAP | INTEGER | | RCOAP742 | COMMON EQUITY TIER 1 CAPITAL | INTEGER | | RCOAP793 | CAP RATIO COM EQTY TIER1 CAP RATIO | DOUBLE PRECISION | | RCOAP838 | AOCI OPT-OUT ELECTION | BOOLEAN | | RCOAP839 | COM EQTY TIER 1 MINORTY INTERST | BOOLEAN | | RCOAP840 | COM EQTY TIER 1 CAP BEFORE REG ADJ | INTEGER | | RCOAP841 | COM EQTY TIER 1 CAP ADJS AND DEDUDS | INTEGER | | RCOAP842 | LESS INTANG ASSTS NET OF ASSCTD DTLS | INTEGER | | RCOAP843 | DFRD TX ASSTS OPRTING LOSS TX CRDT | INTEGER | | RCOAP849 | NET GNS (LSSES) HTM SEC AOCI | INTEGER | | RCOAP850 | OTH THRSHLD DEDS COMEQTY TIER1 CAP | INTEGER | | RCOAP851 | NNSG INVCP UNCNS COMSTK 10 PCT THRSH | BOOLEAN | | RCOAP852 | SUBTOT COMEQTY TIER1 CAP ADJ AN DEDS | INTEGER | | RCOAP853 | COMSTK 10PCT EQTY TIER1 CAP THRSHLD | BOOLEAN | | RCOAP854 | MSA DTL 10PCT EQTY TIER1 CAP THRS | BOOLEAN | | RCOAP855 | DTAS CAP CMSTK 15PCT TIER1 CAP THRSH | BOOLEAN | | RCOAP856 | MSA DTA 15PCT COMEQTY TIER1 CAPTHRES | BOOLEAN | | RCOAP857 | INSF TIER1 TIER2 CAP CVR DED | INTEGER | | RCOAP858 | ADJSTMNT DEDT COM EQTY TIER1 CAP | INTEGER | | RCOAP859 | COM EQTY TIER 1 CAPITAL | INTEGER | | RCOAP860 | ADDITIONAL TIER 1 CAPITAL | BOOLEAN | | RCOAP861 | NNQFY CAP INSTR PHSOUT ADD TIER1 CAP | BOOLEAN | | RCOAP862 | TIER1 MNRTY INTR NOT EQTY TIER1 CAP | BOOLEAN | | RCOAP863 | ADD TIER 1 CAPITAL BEFORE DEDUCTIONS | BOOLEAN | | RCOAP864 | TOT ADDTNL TIER 1 CAP DEDUCTIONS | INTEGER | | RCOAP865 | ADDTNL TIER 1 CAPITAL | BOOLEAN | | RCOAP866 | TIER 2 CAP INSTRMNTS PLUS RLTD SRPLS | INTEGER | | RCOAP867 | NNQLIFY CAP INSTR PHSOUT TIER2 CAP | BOOLEAN | | RCOAP868 | CAP MNRTY INTRST NOT INCL TIER 1 CAP | BOOLEAN | | RCOAP870 | TIER 2 CAPITAL BEFORE DEDUCTIONS | INTEGER | | RCOAP872 | TOTAL TIER 2 CAPITAL DEDUCTIONS | BOOLEAN | | RCOAP875 | DEDS COMEQTY TIER1 CAP ADD TIER1 CAP | INTEGER | | RCOAQ257 | UNREALIZED GAINS ON A-F-S EQUITY SEC | INTEGER | | RCOAQ258 | CUMULATIVE CHANGE IN FAIR VALUE | BOOLEAN | | RCON3368 | QTLY AVG OF TOTAL ASSETS | INTEGER | | RCON3632 | UNDIVIDED PROFITS & CAPITAL RESERVES | INTEGER | | RCOW3792 | TOTAL RISK-BASED CAPITAL | INTEGER | | RCOW5310 | ALLL INCLUDIBLE IN TIER2 CAPITAL | INTEGER | | RCOW5311 | TIER 2 (SUPPLEMENTARY) CAPITAL | INTEGER | | RCOW7205 | TOTAL RISK-BASED CAPITAL RATIO | DOUBLE PRECISION | | RCOW7206 | TIER 1 RISK-BASED CAPITAL RATIO | DOUBLE PRECISION | | RCOWA223 | RISK-WEIGHTED ASSETS | INTEGER | | RCOWP793 | CAP RATIO COM EQTY TIER1 CAP RATIO | DOUBLE PRECISION | | RCOWP870 | TIER 2 CAPITAL BEFORE DEDUCTIONS | 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 09302014/FFIEC CDR Call Schedule RCRIB 09302014.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 06302014/FFIEC CDR Call Schedule RCRIB 06302014.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 03312014/FFIEC CDR Call Schedule RCRIB 03312014.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 12312014/FFIEC CDR Call Schedule RCRIB 12312014.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.