KUKU

KU ScholarWorks

  • myKU
  • Email
  • Enroll & Pay
  • KU Directory
    • Login
    View Item 
    •   KU ScholarWorks
    • Libraries
    • Libraries Scholarly Works
    • View Item
    •   KU ScholarWorks
    • Libraries
    • Libraries Scholarly Works
    • View Item
    JavaScript is disabled for your browser. Some features of this site may not work without it.

    Creating an ILLiad Transaction Archive

    Thumbnail
    View/Open
    Technical report to support presentation given March 15, 2007 at the 2007 OCLC ILLiad International Conference, Virginia Beach, VA (143.0Kb)
    Text file with SQL Code from technical report appendices (13.11Kb)
    Issue Date
    2007-08-31
    Author
    Waterhouse, Janetta
    Type
    Technical Report
    Metadata
    Show full item record
    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
    Collections
    • Libraries Scholarly Works [512]

    Items in KU ScholarWorks are protected by copyright, with all rights reserved, unless otherwise indicated.


    We want to hear from you! Please share your stories about how Open Access to this item benefits YOU.


    Contact KU ScholarWorks
    785-864-8983
    KU Libraries
    1425 Jayhawk Blvd
    Lawrence, KS 66045
    785-864-8983

    KU Libraries
    1425 Jayhawk Blvd
    Lawrence, KS 66045
    Image Credits
     

     

    Browse

    All of KU ScholarWorksCommunities & CollectionsThis Collection

    My Account

    LoginRegister

    Statistics

    View Usage Statistics

    Contact KU ScholarWorks
    785-864-8983
    KU Libraries
    1425 Jayhawk Blvd
    Lawrence, KS 66045
    785-864-8983

    KU Libraries
    1425 Jayhawk Blvd
    Lawrence, KS 66045
    Image Credits
     

     

    The University of Kansas
      Contact KU ScholarWorks
    Lawrence, KS | Maps
     
    • Academics
    • Admission
    • Alumni
    • Athletics
    • Campuses
    • Giving
    • Jobs

    The University of Kansas prohibits discrimination on the basis of race, color, ethnicity, religion, sex, national origin, age, ancestry, disability, status as a veteran, sexual orientation, marital status, parental status, gender identity, gender expression and genetic information in the University’s programs and activities. The following person has been designated to handle inquiries regarding the non-discrimination policies: Director of the Office of Institutional Opportunity and Access, IOA@ku.edu, 1246 W. Campus Road, Room 153A, Lawrence, KS, 66045, (785)864-6414, 711 TTY.

     Contact KU
    Lawrence, KS | Maps