- 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