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

    Graying out patron ID in GUI patron creation screen

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

    When the staff use the fast registration form, the patron ID should be filled by the system counter like "ID-" (the prefix which we specify for last-bor-id in util g/2).

    Can this field be grayed out/disabled to the staff in order not to fill it in with other data by mistake?

    When the patron ID is assigned using the util g/2 last-bor-id counter, the resulting z303_rec_key is of the form ID-nnnnnnnnn.

    The following SQL will locate cases where the patron ID was created in the past 7 days and is not of the form ID-00nnnnnnn:

    SQL> select z303_rec_key from z303 where z303_rec_key not like 'ID-00%'and Z303_OPEN_DATE > TO_CHAR (SYSDATE-7, 'YYYYYMMDD');

    You could execute this weekly. If you find that staff are filling in the Patron ID with specific values, you may want to do it more frequently.

    • Article last edited: 10/8/2013