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. z36_letter_date not updated by Courtesy Notice job

    z36_letter_date not updated by Courtesy Notice job

    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, 21, 22, 23

    Description:
    On 09/05, we sent over 1150 courtesy notices out to faculty members on campus. However, in counting the number of z36 and/or z36h records which have a letter_date of '20070905', we only find nowhere near that number of records. Do courtesy notices not update the letter_date value? Or do we have something set improperly which results in this information not being updated?

    Is there any other table which might have information about these notices which we can use to review, through SQL, who all was sent a notice on that day?

    Resolution:
    The p_cir_10 Courtesy Notice job does not update the z36_letter_date. This field is reserved for recall, overdue, and lost notices.

    There is no indication on the z36 (or z36h) record that a courtesy notice was sent.  The only record of courtesy notices being sent is found in the z309 (Circ Logger) table:  z309_action type 15 is "Courtesy letter created".

    Also, the abc50 $data_scratch/cir_10_2.scr file has the item numbers; and the $data_scratch/cir_10_3.scr and $data_print/faccour090507 files have the complete notices (in xml).


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • z36_id2: cannot CREATE UNIQUE INDEX
      • z36_letter_date updated, but overdue notice not produced
    • 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