Understanding the circ_longterm_history table
The circ_longterm_history table has been updated with merged information from the former circ_longterm_history, circ_tran, and circ_ancient_history tables. The new circ_longterm_history table contains columns from circ_tran and circ_ancient_history with a few modifications.
The circ_longterm_history table is populated with the following information:
The software updates the data in this table at both checkout and check in. When the item is first checked out, an entry will be added to the table with the basic data that can be populated at the time of checkout (cko_location, cko_date, etc.). Data that is unknown and cannot be known until check in is left null. When the item is returned, the record will be updated with the data that can only be populated at time of check in (cki_location, cki_time, etc.).
Sites with existing history information will have that history moved to the new table when they upgrade to 7.5.4.1. They will still be able to pull history data as they have in the past. That data will be accessed in an SQL view that mimics the existing history tables.
For sites that are already set up to keep a circulation history, the tables will be turned on automatically in the upgrade process.
© 1998-2017 Sirsi Corporation