List view
The files published (quarterly) by FCA appear to be exported from a relational database. We would like to re-create this database and insert the data published each quarter into our database, then license access to the database to Ketchbrook's clients. The difficult part of this effort will be dealing with schema mismatches in the historical data published by FCA. This effort will involve published files from a particular quarter as the "starting point" for the schema of our database. Then, we will have to work backwards to back-fill additional historical quarters of published data and address backwards schema changes as they arise.
No due dateThe number of files that FCA [publishes](https://www.fca.gov/bank-oversight/call-report-data-for-download) changes from quarter to quarter. For example, in December 2022, FCA published **70** files; the next quarter (March 2022), FCA published **72** files. The addition/deletion of a file published by FCA would equate to adding/removing a database table. Additionally, the content of the schema/metadata files (the files that begin with a *"D_"* may change from quarter to quarter; these changes would represent alterations to existing database tables; e.g., changes to column names, column definitions, or allowable "codes" in the column; the addition/removal of new columns; etc. We will need to detect these changes each quarter and apply them in order to insert new data into the database shortly after the files are published.
No due date•2/2 issues closed