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. Report of new patrons and who added them?

    Report of new patrons and who added them?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    • Article Type: Q&A
    • Product: Aleph
    • Product Version: 20

    Question

    Is there a report that lists new patrons who have been added to ALEPH circulation and the name of the person who added the new patron?

    Answer

    In version 21, there's a new service, cir-27 (Patron Record Log Changes Report), which reads a new table (z307) (the patron logger table), which can produce a report of new patrons with the updater's name.

    In version 20, this would need to be done by SQL :

    SQL> select z303_rec_key, z303_name from z303 where z303_update_date > 'yyyymmdd';

    But it is *not* possible in version 20 to get the name of the "cataloger" who created either the global patron record or the local because the z303 (Global patron) and z305 (Local Patron) records do not contain this information.

    Category: Circulation


    • Article last edited: 1/16/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Report of New and Updated Catalog Records - by Cataloger (com-03) is empty
      • Report of Number of circulations, Title, and Fund code.
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. Circulation
      3. contype:kba
      4. Prod:Aleph
      5. Type:Q&A
    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