Ralf Habacker
-
2024-01-06
- labels: --> 1.57
- Version: 1.50 --> 1.58
The bank details downloaded from https://www.bundesbank.de/de/aufgaben/unbarer-zahlungsverkehr/serviceangebot/bankleitzahlen/download-bankleitzahlen-602592 are each valid for 3 months, from 4.12.y, 4.3.y+1, 4.6.y+1, 4.9.y+1 to 3.6.y, 3.9.y, 3.12.y, 3.3.y+1 (in German date format, y = year)
These date ranges are not added to the generated bankdata databases.
$ sqlite3 bankdata_de.db
sqlite>.schema institutions
CREATE TABLE institutions ( country CHAR(2) DEFAULT 'DE' CONSTRAINT germanCountryCode NOT NULL CHECK(country == 'DE'), bankcode CHAR(8) NOT NULL PRIMARY KEY CHECK(length(bankcode) = 8), bic CHAR(11), method CHAR(2), name VARCHAR(60), location VARCHAR(40), valid_upto real );
CREATE INDEX bic_index ON institutions (bic);
which shows that there is a database column valid_upto
.
sqlite> select count(*) from institutions where valid_upto is not null;
0
but it is empty and should be filled with the associated end date.