Understanding the Item Delete Discard Tables
If you choose to save deleted item data, Horizon stores the information in these tables:
|
•
|
discard_item_additional |
Horizon writes item and bib record information to these tables depending on your specifications in the Batch Item Delete Options process. Horizon records information such as whether this is the last item to be deleted for this location or for the system. It also records whether the associated bib has been deleted. You can review and purge the saved information using standard Table Editor functionality.
You can give staff members the rights to override your Batch Item Delete Options for each discard session. You can also give them the rights to review and purge the saved information.
These options apply to item records deleted in Cataloging. They do not apply to the deletion of a fast-added item at Circulation checkin or to the deletion of an item when it is withdrawn from Reserve Bookroom.
The discard_item table includes all the information from the item table.
The discard_item_additional table includes this information:
|
•
|
The source catalog code from the item_activity table. |
|
•
|
Whether the item is the last copy for the location. |
|
•
|
Whether the item is the last copy for the system. |
|
•
|
Whether the bib record was also deleted. |
|
•
|
The user ID of the library staff member who discarded the item and deleted the item record. |
|
•
|
The date the items were deleted. |
If you specify MARC maps from which Horizon should extract information in Item Delete Options, Horizon can also include this information in the discarded items tables:
|
•
|
The author of the item. |
|
•
|
The item’s publication date. |
|
•
|
The item’s LCCN, if appropriate. |
|
•
|
The item’s ISBN, if appropriate. |
|
•
|
A library-designated control number. |
© 1998-2017 Sirsi Corporation