What Oracle tables are used to produce circulation statistics?

• Article Type: General
• Product: Aleph
• Product Version: 20, 21, 22, 23

Description:
What Oracle tables are used to produce circulation statistics? (We want to make sure that we don't delete any information necessary for statistics.)

Resolution:
The p_cir_30 ("General Circulation Statistics") and pc_cir_31 ("Circulation Statistics by Activity Type") both use the z35 table to produce their statistics.

Though the p_cir_32 ("Remove Patron IDs") job and the total_patron_delete program (used in the GUI and in the cir-23 and file-20 Services) change the z35_id to "SCRyyyymmdd", this does not affect the statistics since the z35_id is not used in the statistics and the other z35 fields -- including the z35_bor_status -- are unaffected by p_cir_32.

The count of the number of times a particular item has circulated (which appears in the "Loans" column in the GUI Circ Items list) comes from the z30_no_loans field.

The z36h (loan history) and z37h (request history) tables play no role in Aleph circulation statistics. p_cir_21, using the z309 (circulation log) records, can produce statistics on certain events not covered by the p_cir_30 statistics; see KB's 8192-2759 and 16384-23473.