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

Description:
We are a multi-ADM site and are interested deleting expired Patrons using Cir-77. Before we start removing patrons we need to know exactly what else will be impacted by the removal of these records, especially in the area of loan and request statistics.

Once these records are removed how can we get statistics on the number of requests for an item ? Loan statistics ? Loans and request per borrower type ?

What data is removed along with that in the patron record? What Oracle tables are cleared ? Z309? z31? Z36H ? Z37H ? etc.

Resolution:
The p_cir_23 single-ADM and p_cir_77 multi-ADM jobs delete only the patron records (z303, z304, z305, and z308).

They do not delete the loan history (z36h), request history (z37h), Z309, z31, or z35 (circulation event) tables. (The z35 is what the p_cir_32 circulation statistics job uses.)

The p_cir_32 job can be used to scrub the patron ID from all of the above tables, but that job also does not actually delete any records.

The p_cir_78 deletes old circ logger records.

See also, these articles: 

•    Purging z31 cash transactions (KB 4097)
•    Deleting/purging patron and cash records **MASTER RECORD**  (KB 5820), and
•    Purging Cash History and return of old Lost items  (KB 16384-2274)

• Article last edited: 12-Dec-2016