*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
- Folio_audit.circulation_logs
- Folio_circulation.audit_loan
- Folio_circulation.check_in (can be linked by item_id and date/time to audit_loan table, which has user_id)
- Folio_circulation.patron_action_session
- Folio_circulation.loan
- Folio_circulation.request
- Folio_circulation.scheduled_notice
- Folio_email.email_statistics
- Folio_feesfines.accounts
- Folio_feesfines.feefineactions
- Folio_orders.po_line__
- Folio_patron_blocks.fee_fine_balance_changed_event
- Folio_patron_blocks.item_aged_to_lost_event
- Folio_patron_blocks.item_checked_in_event
- Folio_patron_blocks.item_checked_out_event
- Folio_patron_blocks.item_claimed_return_event
- Folio_patron_blocks.item_declared_lost_event
- Folio_patron_blocks.loan_closed_event
- Folio_patron_blocks.loan_due_date_changed_event
- Folio_patron_blocks.user_summary
Questions for Nassib
- Given increasing concerns about data privacy, is data anonymization on the roadmap and how will it work
- There is some loan anonymization functionality in FOLIO settings and there are plans to do the same for Requests
- Is metadb anonymization being developed with that interdependence in mind, or is it going to be an independent feature
- Will there be a feature to turn off the historical row creation for Metadb (as you do for LDP)
- Will there be a feature to make patron identifiers (e.g., user_id, requester_id) NULL in historical rows?
General Notes: Current Loans are already purged of patron data, but Historical Loans are not
-need to research connection between loans and fine/fee transactions
...
-loan id stays the same throughout all loan trans
-Sharon to ask Hosting Team if they can run the job to stop the server, run the purge scripts, then restart the server on the weekend
Historic Loan Rows Anonymization Process
...
-solution under consideration: script will be run manually initially, then library systems will run it as a chron job on Jenkins
-fields with patron identifiers:
request__ : requester_id has no value! for , (requester) lastname, (requester) firstname,
request__t__ :
request__t : requester_id has values, proxy_user_id?
Fines and Fees
-Sharon, Joanne, Ann, Tom, Susan Bristol, and Michelle to review what is needed for purging patron data here
...