Batch deletion of old/paid cash records

• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
Is there a batch job which deletes old/paid cash records? We have accumulated millions of such records.

Resolution:
There used to be a p_cash_04 service to delete old/paid cash records, but it was removed by version 16 rep_ver 7253. {"Removing p-cash-04 from ALEPH - the program is now integrated part of p-cir-32 (scrubbing utilities)."}

In v16-up the z31s have been included in the p_cir_32 Patron Link Removal ("Scrub patron IDs"). This job will remove the user ID from paid or waived cash records older than xxx days. It does not let you differentiate cash record types (such as Lost). It does not actually *delete* cash records, it just changes the user ID.

If privacy is the main concern, p_cir_32 addresses that; but, if space is the main concern, old/paid cash records will need to be deleted with SQL.

• Article last edited: 10/8/2013