KU ScholarWorks >
Information Services (Libraries and Information Technology) >
Information Services Working Papers and Technical Reports  >

Please use this identifier to cite or link to this item: http://hdl.handle.net/1808/1685
View usage statistics

Title: Creating an ILLiad Transaction Archive
Authors: Waterhouse, Janetta
Keywords: ILLiad
interlibrary loan
transaction archive
Issue Date: 31-Aug-2007
Type: Technical Report
Abstract: The University of Kansas (KU) uses OCLC ILLiad software for managing interlibrary loan borrowing, lending and document delivery operations. In 2007, KU created a transaction archive to save dated transactions for reporting purposes, allowing them to be removed them from the main ILLiad database. This technical paper describes the process used to design and create the transaction archive, populate it with data, and remove the data from the primary database. This process can be used to remove patron data from interlibrary loan transactions while leaving enough data intact for copyright and bibliographic reports and workflow analysis. Sample SQL code is included in the appendices and as a separate text document.
URI: http://hdl.handle.net/1808/1685
Appears in Collections:Information Services Working Papers and Technical Reports

Files in this Item:

File Description SizeFormat
Creating_Illiad_Transaction_Archive.pdfTechnical report to support presentation given March 15, 2007 at the 2007 OCLC ILLiad International Conference, Virginia Beach, VA143.09 kBAdobe PDFView/Open
Creating_ILLiad_TransArchive_Code.sqlText file with SQL Code from technical report appendices13.12 kBTextView/Open