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