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

Desired Outcome Goal:
p_cir_30 and p_cir_31 give statistics by sublibrary only. We need statistics by Collection.

Procedure:
The following SQL can be used to get counts of loans (excluding in-house loans) for all Collections for a particular month: 
> s+ abc50
SQL> select z30_collection, count(*) from z30, z35 where (z35_event_type like '5%' ) and z35_event_date like 'yyyymm%' and z30_rec_key = z35_rec_key || lpad (Z35_ITEM_SEQUENCE,6,'0') group by z30_collection order by z30_collection;
where "yyyymm" is the year/month. 

The following SQL can be used to get counts of *in-house* loans for all collections for a particular month:
SQL> select z30_collection, count(*) from z30, z35 where (z35_event_type = '80' or z35_event_type = '82' ) and z35_event_date like 'yyyymm%' and z30_rec_key = z35_rec_key || lpad (Z35_ITEM_SEQUENCE,6,'0') group by z30_collection order by z30_collection;

The following example gives you the counts of in-house loans for January, 2012:
select z30_collection, count(*) from z30, z35 where (z35_event_type = '80' or z35_event_type = '82' ) and z35_event_date like '201201%' and z30_rec_key = z35_rec_key || lpad (Z35_ITEM_SEQUENCE,6,'0') group by z30_collection order by z30_collection;

Additional Information
The p_priv_21 service, available on EL Commons, developed by Al Rykhus at MN PALS, produces Circulation statistics by Collection and Call number range.

• Article last edited: 12-Mar-2016