Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    What Oracle Tables does the Circulation Module Use?

    1. Last updated
    2. Save as PDF
    • 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