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

Question
What Oracle tables need to be in the pw_library, usr_library, and z105_library?

Answer

pw_library:.
. *needs* to have these tables: z52, z66, z67.
. *can* have these optional tables: z34 (OPAC statistics); z107 (course enrollments table); z700 (ILL Partner); z1004 (MAB-only)
See also, the $aleph_root/tab/file_list.PW in your version.

usr_library:.
. *needs* to have these tables: z52; z61 (profiles); Z100; z303, z304, z308 (patron tables); z123 (OPAC saved-search-sets table -see PRB 10009); z325 (SDI patron profile); z353 (patron list table)
. *can* have these tables: z115 (MAB-only -see PRB 10005); z119 (e-shelf); z1005 (MAB-only -see PRB 10006).
. Note: The usr00 file list also contains z00, z13, and z103 tables. These may also be necessary..
See also, the $aleph_root/tab/file_list.USR in your version.

z105_library:.
. *needs* the z105 (messages-between-libraries table) and probably the z52.

[See also, the article "How to know what library a particular Oracle table is found in" (KB 16384-4757).]

• Article last edited: 12-Mar-2016