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

Description:
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?

Resolution:
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