Participants
Veli-Matti Häkkinen (Jyväskylän yliopisto)
Sirpa Janhonen (Varastokirjasto)
Esa-Pekka Keskitalo (Kansalliskirjasto)
Minna Kivinen (HAMK), chair
Mia Kujala (XAMK)
Joonas Kylmälä (Kansalliskirjasto)
Johanna Miettunen (Haaga-Helia)
Christian Nelson (Tritonia)
Andrii Vashchuk, development, National Library
From last meeting: Some slownes, fixed for tritonia and 3 AMK - fixed for others as well?
Update schedule is found on KIWI -page Update schedule and progress tracking
National Archives: Deployment Sept 22nd
HAMK: Deployment Sep 24th
XAMK: Deployment on Thursday Oct 1st
Diak: Deployment on Oct 7th.
Tritonia: Deployment on Thursday Oct 15th
Arcada: Deployment on Thursday Oct 29th
3AMK: Deployment on Thursday Nov 5th
MPKK: Deployment on Nov 11th
Humak: Deployment on Nov 19th
Tilastokirjasto: Deployment on Nov 26th
Varastokirjasto: Deployment on Dec 3rd
Hanken: Deployment on Dec 8th
Centria:
KK and JYU:
From last meeting:
Koha3 test environment
Update to Koha is planned for Koha3 test environment and after that for all the libraries
About upgrades:
Address to Finna view https://kohatesti.finna-test.fi
2.5. Discussion topics - items that need discussion about priority or definitions for implementing
Table | Time to keep | Description | Comment |
---|---|---|---|
action_logs | 2 years | Check in, check out, making holds, item modifications etc. Which logs are collected is depending of system settings. | Suggest development: it would be nice to be able to delete patron data without deleting everything else. |
deleted_borrowers | 1 kk | Deleted borrowers, deleting has affect to statistics as categorycode or statistical group is not saved elsewhere | Affects to statistics, action logs, old_reserves, old_issues where only borrowernumber is saved to link to additional borrower information (categorycode, statistical group) We need to list cases where it's important to keep, or important to delete this data. |
old_reserves | 3 years | Handled holds. If patron is anonymized, link to patron is deleted when item is returned. | |
old_issues | 3 years | Returned loans. If patron is anonymized, link to patron is deleted when item is returned. | |
accountlines | 3 years | Paid fees. Unpaid fees must be deleted manually | |
statistics | 2 years | Statistical information about loans, renewals, reservations, payments. Needed until all statistics has been taken out. | New fields needed in the statistics table. ANd borrowernumber deleted |
message_queue | 3 years | Sent messages. Needed to check if the message has been sent from system. Only for active borrowers, information deleted when borrower is deleted | |
deleted_biblio, deleted_items | 5 years | Deleted bibliographic records and item records | National Library will not delete these, but it's a special case (Fennica). |
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |
---|---|---|---|---|---|---|---|---|---|
datetime | DATETIME | 19 | √ | null | date and time of the transaction | ||||
branch | VARCHAR | 10 | √ | null | foreign key, branch where the transaction occurred | ||||
value | DOUBLE | 16,4 | √ | null | monetary value associated with the transaction | ||||
type | VARCHAR | 16 | √ | null |
| transaction type (localuse, issue, return, renew, writeoff, payment) | |||
other | LONGTEXT | 2147483647 | √ | null | used by SIP | ||||
itemnumber | INT | 10 | √ | null | foreign key from the items table, links transaction to a specific item | ||||
itemtype | VARCHAR | 10 | √ | null |
| foreign key from the itemtypes table, links transaction to a specific item type | |||
location | VARCHAR | 80 | √ | null | authorized value for the shelving location for this item (MARC21 952$c) | ||||
borrowernumber | INT | 10 | √ | null | kirjasto | ||||
ccode | VARCHAR | 80 | √ | null |
The goal of this new feature is to add a way to pseudonymize patron's data, in a way they could not be personally identifiable.
* 1 for transactions and patrons data (pseudonymized_transactions) * 1 for patrons' attributes (pseudonymized_borrower_attributes) Entries to pseudonymized_transactions are added when a new transaction (checkout, checkin, renew, on-site checkout) is done. Also, anonymized_borrower_attributes is populated if patron's attributes are marked as "keep for pseudonymization".
Question about component parts: no changes, the parts will come along with the replication.
Tuudo:
functionalities are ready
select * from accountlines where accounttype = "O" and amountoutstanding > 0 and itemnumber IS NULL;
(have to check this SQL query, if this a right one or not