TABLE: BalanceSheetIncomeStatementPastDue3 COLUMNS: +--------------------------------------+--------------------------------------+-------------+ | Name | Label | Type | +--------------------------------------+--------------------------------------+-------------+ | IDRSSD | | INTEGER | | Reporting_Period_End_Date | | DATE | | unnamed | | INTEGER | | FDIC_Certificate_Number | | INTEGER | | Financial_Institution_Address | | VARCHAR(55) | | Financial_Institution_City | | VARCHAR(24) | | Financial_Institution_Filing_Type | | CHAR(3) | | Financial_Institution_Name | | VARCHAR(91) | | Financial_Institution_State | | CHAR(2) | | Financial_Institution_Zip_Code | | VARCHAR(9) | | Last_Date_Time_Submission_Updated_On | | TIMESTAMP | | OCC_Charter_Number | | INTEGER | | OTS_Docket_Number | | INTEGER | | Primary_ABA_Routing_Number | | INTEGER | | RIAD5415 | NET GAINS(LOSSES)ON OTHER RE OWNED | INTEGER | | RIAD5416 | NET GAINS(LOSSES)ON SALES OF LOANS | INTEGER | | RIAD8431 | FEE INCM FRM SLE&SERVCG OF MUTL FNDS | INTEGER | | RIAD8757 | TRDG REVNU FROM INT RATE EXPOSURES | INTEGER | | RIAD8758 | TRDG REVNU FROM FGN EXCH EXPOSURES | INTEGER | | RIAD8759 | TRDG REVNU FROM EQTY SEC EXPOSURES | INTEGER | | RIAD8760 | TRDG REVNU FROM COMMODITY&OTHER | INTEGER | | RIAD9106 | ACQUISITION DATE | INTEGER | | RIADA220 | TRADING REVENUE | INTEGER | | RIADA251 | CR LOSSES ON OFF-BALC SHEET DERIVTVS | INTEGER | | RIADA517 | TIME DEPOSITS OF $100,000 OR MORE | INTEGER | | RIADA518 | TIME DEPOSITS OF LESS THAN $100,000 | INTEGER | | RIADA530 | DOES THE RPRTNG BK HAV A SUBCHPTR S? | BOOLEAN | | RIADB485 | INTEREST INCOME: CREDIT CARDS | INTEGER | | RIADB486 | INTEREST INCOME: OTHER INDIVIDUAL | INTEGER | | RIADB487 | INTEREST INC: OTHER LOANS-DOMESTIC | INTEGER | | RIADB488 | INT&DIV INCOME: U.S.TREA SEC,ETC | INTEGER | | RIADB489 | INT&DIV INCOME: MORTGAGE-BACK SECUR | INTEGER | | RIADB491 | NONINT INC: VENTURE CAPITAL REVENUE | INTEGER | | RIADB492 | NONINT INC: NET SERVICING FEES | INTEGER | | RIADB493 | NONINT INC: NET SECURITIZATION INCOM | INTEGER | | RIADB496 | NET GAINS(LOSS): SALES OF OTHR ASSET | INTEGER | | RIADB497 | OTHER NONINTEREST INCOME | INTEGER | | RIADC216 | GOODWILL IMPAIRMENT LOSSES | INTEGER | | RIADC232 | AMORTIZATION EXPNSE&IMPAIRMNT LOSSES | INTEGER | | RIADC386 | INSURANCE&REINSURANCE UNDRWRTNG INC | INTEGER | | RIADC387 | INCOME FROM OTH INS&REINSUR ACTVTES | INTEGER | | RIADC886 | FEES & COMMISSIONS FRM SECURS BROKE | INTEGER | | RIADC887 | FEES & COMMISSIONS FROM ANNUITY SALE | INTEGER | | RIADC888 | INV BKG, ADVIS & UNDR FEES & CMSNS | INTEGER | | RIADC889 | GAIN/LOSS ON CR DERIVATIVES HLD FOR | INTEGER | | RIADC890 | GAIN/LOSS ON CR DERIVATIVES HLD FOR | INTEGER | | RIADF186 | TRDG REVENUE CR EXP | INTEGER | | RIADF228 | NONCASH INCOME NEG AMRTZ 1-4 RES PRO | INTEGER | | RIADF551 | NET GAINS(LOSS) ERN RPT AT FV | INTEGER | | RIADF552 | EST GN LS RPT FV OPTION | INTEGER | | RIADF553 | NET GN LS ERN ON LIABILITY RPT AT FV | INTEGER | | RIADF554 | EST GN LS LIABILITY RTP AT FV | INTEGER | | RIADFT28 | DISCONTINUED OPERATIONS, NET OF APPL | INTEGER | | RIADG103 | LESS NET INC LOSS ATTRTBL TO NONCTRL | INTEGER | | RIADG104 | NET INC LOSS ATTRTBL TO BANK BHC | INTEGER | | RIADH032 | SEV CHAR DEP DOM OFF OVER IND | INTEGER | | RIADH033 | SEV CHAR DEP DOM OFF MAIN IND | INTEGER | | RIADH034 | SEV CHAR DEP DOM OFF ATM IND | INTEGER | | RIADH035 | SEV CHAR DEP DOM OFF ALL IND | INTEGER | | RIADJ319 | TOTAL OTTI LOSSES | INTEGER | | RIADJ320 | LESS OTTI LS OTHR COMP INC | INTEGER | | RIADJ321 | OTTI LOSS RECOGNIZED EARNING | INTEGER | | RIADK090 | TRDG RVNU CHG BK DRVT CNTRPRTY | INTEGER | | RIADK094 | TRDG RVNU CHG BK DRVT LAIB | INTEGER | +--------------------------------------+--------------------------------------+-------------+ DATA SOURCES: /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk Subset of Schedules/FFIEC CDR Call Bulk Subset of Schedules 2016/FFIEC CDR Call Subset of Schedules 2016(3 of 3).txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk Subset of Schedules/FFIEC CDR Call Bulk Subset of Schedules 2011/FFIEC CDR Call Subset of Schedules 2011(3 of 3).txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk Subset of Schedules/FFIEC CDR Call Bulk Subset of Schedules 2015/FFIEC CDR Call Subset of Schedules 2015(3 of 3).txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk Subset of Schedules/FFIEC CDR Call Bulk Subset of Schedules 2013/FFIEC CDR Call Subset of Schedules 2013(3 of 3).txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk Subset of Schedules/FFIEC CDR Call Bulk Subset of Schedules 2012/FFIEC CDR Call Subset of Schedules 2012(3 of 3).txt /Users/swaldman/Dropbox/BaseFolders/development-why/gitproj/callrep-archiver/datafiles/2022-10-29/FFIEC CDR Call/FFIEC CDR Call Bulk Subset of Schedules/FFIEC CDR Call Bulk Subset of Schedules 2014/FFIEC CDR Call Subset of Schedules 2014(3 of 3).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.