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. Course Reserve documents don't show up in the Documents list

    Course Reserve documents don't show up in the Documents list

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    Certain documents appear in the Web OPAC Course Reserve database (and in the GUI), but don't appear under the course in the staff Web Course Reading/Reserve function. We get the message "There are no documents belonging to this course" (or the list displays with the title and other columns blank).

    Why?

    Resolution:
    Both the Web OPAC and the GUI base their display on the (Z01) ACC CRN index, while the staff Course Reserve uses the (Z11) Direct CNO index, plus the Z13 short doc file.

    If the document has Z01 entries but lacks the Z11 or Z13, you will see this symptom.

    You can use the following SQL to check for a particular document:

    SQL-xxx30> select * from z11 where Z11_DOC_ NUMBER = 'nnnnnnnnn';

    SQL-xxx30> select * from z13 where Z13_REC_KEY = 'nnnnnnnnn';

    <where "nnnnnnnnn" is the xxx30 doc number>.

    Or this SQL to check generally:

    SQL-xxx30> select count(*) from z00;

    SQL-xxx30> select count(*) from z11 where Z11_REC_KEY like 'CNO%';

    SQL-xxx30> select count(*) from z13;

    The number of z13's should be equal to the number of z00's. The number of CNO z11's should be at least 10% of the z00's.

    To recreate the Z11, run p_manage_05 (for the xxx30 library); to recreate the Z13 short docs, run p_manage_07.

    Additional Information

    faq, course reading, reserves, z11, z01, ACC CRN, z13, CNO, item, manage_05, faq


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Course Reserve documents all 0 even though there are documents attached
      • Course reserve hold does not block renewal
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    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