TABLE: RCRIA COLUMNS: +---------------------------+--------------------------------------+------------------+ | Name | Label | Type | +---------------------------+--------------------------------------+------------------+ | IDRSSD | | INTEGER | | Reporting_Period_End_Date | Reporting Period End Date | DATE | | unnamed | | INTEGER | | RCFD2221 | UNREALIZED GAINS ON A-F-S EQUITY SEC | INTEGER | | RCFD3210 | TOTAL EQUITY CAPITAL | INTEGER | | RCFD3792 | TOTAL RISK-BASED CAPITAL | INTEGER | | RCFD4336 | ACCMLTD NT GN(LOSS) ON CSH FLW HDGS | INTEGER | | RCFD5306 | QUALIFYING SUBORDINATED DEBT | INTEGER | | RCFD5310 | ALLL INCLUDIBLE IN TIER2 CAPITAL | INTEGER | | RCFD5311 | TIER 2 (SUPPLEMENTARY) CAPITAL | INTEGER | | RCFD5610 | DEFRD TAX ASSETS DISALWD FOR REGLTRY | INTEGER | | RCFD7204 | TIER 1 LEVERAGE CAPITAL RATIO | DOUBLE PRECISION | | RCFD7205 | TOTAL RISK-BASED CAPITAL RATIO | DOUBLE PRECISION | | RCFD7206 | TIER 1 RISK-BASED CAPITAL RATIO | DOUBLE PRECISION | | RCFD7273 | TIER 1 LEVERAGE RATIO | DOUBLE PRECISION | | RCFD7274 | TIER 1 RISK-BASED CAPITAL RATIO | DOUBLE PRECISION | | RCFD7275 | TOTAL RISK-BASED CAPITAL RATIO | DOUBLE PRECISION | | RCFD8274 | TIER 1 CPTL ALLWBL UNDR RISK-BASED | INTEGER | | RCFD8275 | TIER 2 CPTL ALLWBL UNDR RISK-BASED | INTEGER | | RCFD8434 | NET UNRELZD HLDG GAINS(LOSS) ON AVL | INTEGER | | RCFDA221 | NET UNREAL LOSS ON AFS EQTY SEC | INTEGER | | RCFDB503 | ADJSTMNT TO TOTL RSK-BASED CPTL | INTEGER | | RCFDB504 | ADJUSTMENT TO RWA | INTEGER | | RCFDB505 | ADJUSTMENT TO AVERAGE TOTAL ASSETS | INTEGER | | RCFDB588 | NONQUALIFYING PERPETUAL PREFER STOCK | BOOLEAN | | RCFDB589 | QUALIFYING MINORITY INT CONSOL SUBS | INTEGER | | RCFDB590 | DISALLOWD GOODWILL&OTH INTANG ASSETS | INTEGER | | RCFDB591 | DISALLOWD SERVICING ASSETS & PCCR'S | INTEGER | | RCFDB592 | OTHER ADDITIONS(DEDUCT) FROM TIER1 | INTEGER | | RCFDB593 | CUMULATIVE PERPETUAL PREFERRED STOCK | INTEGER | | RCFDB594 | OTHER TIER 2 CAPITAL COMPONENTS | INTEGER | | RCFDB595 | DEDUCTIONS FOR TOTL RISK-BASED CAPTL | BOOLEAN | | RCFDC227 | SUBTOTAL | INTEGER | | RCFDC228 | ADJMNT TO TIER 1 CPTL | INTEGER | | RCFDF264 | CUMULATIVE CHANGE IN FAIR VALUE | INTEGER | | RCFDL136 | TOTAL ASSETS FOR LEVERAGE RATIO | INTEGER | | RCFDL137 | OTHR ADD DED FOR LEVERAGE CAP PURP | INTEGER | | RCFDL138 | TOTAL ASSETS LEVERAGE CAPITAL PURPOS | INTEGER | | RCON2221 | UNREALIZED GAINS ON A-F-S EQUITY SEC | INTEGER | | RCON3210 | TOTAL EQUITY CAPITAL | INTEGER | | RCON3792 | TOTAL RISK-BASED CAPITAL | INTEGER | | RCON4336 | ACCMLTD NT GN(LOSS) ON CSH FLW HDGS | INTEGER | | RCON5306 | QUALIFYING SUBORDINATED DEBT | INTEGER | | RCON5310 | ALLL INCLUDIBLE IN TIER2 CAPITAL | INTEGER | | RCON5311 | TIER 2 (SUPPLEMENTARY) CAPITAL | INTEGER | | RCON5610 | DEFRD TAX ASSETS DISALWD FOR REGLTRY | INTEGER | | RCON7204 | TIER 1 LEVERAGE CAPITAL RATIO | DOUBLE PRECISION | | RCON7205 | TOTAL RISK-BASED CAPITAL RATIO | DOUBLE PRECISION | | RCON7206 | TIER 1 RISK-BASED CAPITAL RATIO | DOUBLE PRECISION | | RCON7273 | TIER 1 LEVERAGE RATIO | DOUBLE PRECISION | | RCON7274 | TIER 1 RISK-BASED CAPITAL RATIO | DOUBLE PRECISION | | RCON7275 | TOTAL RISK-BASED CAPITAL RATIO | DOUBLE PRECISION | | RCON8274 | TIER 1 CPTL ALLWBL UNDR RISK-BASED | INTEGER | | RCON8275 | TIER 2 CPTL ALLWBL UNDR RISK-BASED | INTEGER | | RCON8434 | NET UNRELZD HLDG GAINS(LOSS) ON AVL | INTEGER | | RCONA221 | NET UNREAL LOSS ON AFS EQTY SEC | INTEGER | | RCONB503 | ADJSTMNT TO TOTL RSK-BASED CPTL | INTEGER | | RCONB504 | ADJUSTMENT TO RWA | INTEGER | | RCONB505 | ADJUSTMENT TO AVERAGE TOTAL ASSETS | INTEGER | | RCONB588 | NONQUALIFYING PERPETUAL PREFER STOCK | INTEGER | | RCONB589 | QUALIFYING MINORITY INT CONSOL SUBS | INTEGER | | RCONB590 | DISALLOWD GOODWILL&OTH INTANG ASSETS | INTEGER | | RCONB591 | DISALLOWD SERVICING ASSETS & PCCR'S | INTEGER | | RCONB592 | OTHER ADDITIONS(DEDUCT) FROM TIER1 | INTEGER | | RCONB593 | CUMULATIVE PERPETUAL PREFERRED STOCK | INTEGER | | RCONB594 | OTHER TIER 2 CAPITAL COMPONENTS | INTEGER | | RCONB595 | DEDUCTIONS FOR TOTL RISK-BASED CAPTL | INTEGER | | RCONC227 | SUBTOTAL | INTEGER | | RCONC228 | ADJMNT TO TIER 1 CPTL | INTEGER | | RCONF264 | CUMULATIVE CHANGE IN FAIR VALUE | INTEGER | | RCONL136 | TOTAL ASSETS FOR LEVERAGE RATIO | INTEGER | | RCONL137 | OTHR ADD DED FOR LEVERAGE CAP PURP | INTEGER | | RCONL138 | TOTAL ASSETS LEVERAGE CAPITAL PURPOS | 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 RCRIA 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 RCRIA 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 RCRIA 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 RCRIA 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.