Skip to main content
Ex Libris Knowledge Center

Find Znn Tables Containing Patron ID in Order to Change an ID


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


Desired Outcome Goal:
Find all the Oracle tables where the patron ID is used so IDs can be changed
The specific goal is to change the patron ID found in z303_rec_key


Changing the z303_rec_key cannot be done via any Aleph functionality. 
If customers are doing this outside Aleph functionality they do it at their own risk without support from Ex Libris. 
Contracting with Ex Libris to have such a change done is strongly recommended.




  • Article last edited: 02-Mar-2016
  • Was this article helpful?