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

    Where is course/item semester information stored?

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    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.

    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