Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. What Oracle Tables does the Circulation Module Use?

    What Oracle Tables does the Circulation Module Use?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Article Type: Q&A
    • Product: Aleph
    • Product Version: 21

    Question

    What Oracle tables does the Circulation module use?

    Answer

    Z30 - Items
    Z31 - Cash
    Z35 - Events (for Circ Statistics)
    Z36 - Loans
    Z36H - Loan History
    Z37 - Hold Requests
    Z37H - Hold Requests History
    Z38 - Photocopy Requests
    Z40 - Z46 - Interlibrary Loan
    Z107 - e-Reserves Course Enrollments
    Z108 - Course Reserves Courses
    Z111 - ADM keywords
    Z301 - Circulation dates (built from tab17, tab16, etc.)
    Z303 - Global patron information
    Z304 - Patron addresses
    Z305 - Local patron information
    Z308 - Patron ID's
    Z309 - Circ Logger
    Z310/Z320/Z322 - Reading Room
    Z353 - Patron Index
    Z370 - Title Hold Requests

    The Circulation module uses various tables (z00 doc record; z13 Brief doc record; z95/z97/z98 Word indexes; etc.), which are not specific to Circulation.

    Note: The above list should not be considered definitive; there may be others not included there.

    Additional Information

    See also, the "ALEPH File Relationship Diagrams" on the Documentation Center.

    Category: Circulation (500)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • What Oracle Tables does the Acquisitions Module Use?
      • What Oracle tables need to be in the pw_library, usr_library?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 21
      2. Circulation (500)
      3. contype:kba
      4. Prod:Aleph
      5. Type:Q&A
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved