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

    Batch jobs to clean out patron note fields


    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care



    Are there batch jobs or Services to update or clean out patron note fields?


    The patron records have the following note fields:

    Z303-FIELD-1 (Global Note 1)
    Z303-FIELD-2 (Global Note 2)
    Z303-FIELD-3 (Global Note 3)
    Z303-NOTE-1  (Additional Note 1)
    Z303-NOTE-2  (Additional Note 1)

    Z305-FIELD-1 (Local Note 1)
    Z305-FIELD-2 (Local Note 2)
    Z305-FIELD-3 (Local Note 3)

    There are no batch Services to update or remove data from these fields.  Blanking out of these fields would need to be done via SQL, such as the following:

    SQL> update z303 set z303_field_n = NULL where z303_field_n is not NULL;
    SQL> commit;

    Before running any such SQL, you should use the file-03 Service to back up the affected table (z303 and/or z305).

    Note:  There are also Z303-DELINQ-n ("Global Block n") and Z305-DELINQ-n (Local Block n") fields.  These fields can either use default text from tab31, or they can contain text specific to this particular patron's situation.



    • Article last edited: 8-Mar-2018
    • Was this article helpful?