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. Where is course/item semester information stored?

    Where is course/item semester information stored?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    We recently realized since moving to Aleph 20, our courses were being flagged as "Winter" rather than our previously-used "Fall" based on pc_tab_exp_field.eng. We've since corrected this, but have records coded as Winter rather than Fall already set up.

    Is there a way to change these, perhaps via SQL? I can't seem to locate where the CNO-6 entry is stored in the database, so I don't even know where to start looking.

    Resolution:
    The CNO-6 field is a virtual field created by the expand_doc_course from the z108_period field of the xxx50 z108 course record.

    When you update the course record in GUI Circ, z07 indexing requests are created in the xxx30 library for each of the xxx30 doc records connected to the course.

    The course could be updated via SQL, but that would not result in the necessary z07 indexing requests. Update in GUI Circ is the way to go.

    The following SQL was used to locate courses with "Winter" as a period:

    SQL-abc50> select z108_rec_key from z108 where z108_period like '%Winter%';


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Where is "upgrade_oracle_table" proc?
      • Where is question/answer entered for patron in bor-update-password stored?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      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