Circulation Report   |   HISTORICAL        
DATA FARM
< back to circ reports>
Summary - Items Charged
All Active
Current Year to Date
5-Year Aver.
FY2008
FY2007
FY2006
FY2005
FY2004
Circulation Locs - Books 147402 266084 363499 362680 372165 364642 352096 365912
Circulation Locs - Videos 1084 37005 55652 60262 66987 66292 52717 31999
Laptops [ All Locs ]N/A 28890 26747 24172 27623 31730 27516 22694
Reserve Locs - Books 56 8693 11189 8795 9273 12762 13392 11722
Reserve Locs - Videos 8 545 13753 436 727 66773 268 560
Audio [ All Locs ] 896 9537 16241 13909 15230 18834 17568 15662
Total Charges - All Item Types 152178 375409 514004 509551 534914 542115 504565 478872
Renewal Count - Booksselect sum(renewal_count) from circ_trans1 where discharge_date is null and location_name not like '%Reserve%' and (item_type_code like '%book/seria%' or item_type_code like 'reserve%' or item_type_code like 'reference%' or item_type_code like 'non-circ%' or item_type_code like 'special%' or item_type_code like 'twoweek%' or item_type_code like 'bound jrnl%' or item_type_code like 'bestseller%') * ERROR at line 1: ORA-00904: "RENEWAL_COUNT": invalid identifier select sum(renewal_count) from circ_trans1 where charge_date >= '01-Jul-2008' and location_name not like '%Reserve%' and (item_type_code like '%book/seria%' or item_type_code like 'reserve%' or item_type_code like 'reference%' or item_type_code like 'non-circ%' or item_type_code like 'special%' or item_type_code like 'twoweek%' or item_type_code like 'bound jrnl%' or item_type_code like 'bestseller%') * ERROR at line 1: ORA-00904: "RENEWAL_COUNT": invalid identifier 0select sum(renewal_count) from circ_trans1 where charge_date >= '01-Jul-2007' and charge_date < '30-Jun-2008' and location_name not like '%Reserve%' and (item_type_code like '%book/seria%' or item_type_code like 'reserve%' or item_type_code like 'reference%' or item_type_code like 'non-circ%' or item_type_code like 'special%' or item_type_code like 'twoweek%' or item_type_code like 'bound jrnl%' or item_type_code like 'bestseller%') * ERROR at line 1: ORA-00904: "RENEWAL_COUNT": invalid identifier select sum(renewal_count) from circ_trans1 where charge_date >= '01-Jul-2006' and charge_date < '30-Jun-2007' and location_name not like '%Reserve%' and (item_type_code like '%book/seria%' or item_type_code like 'reserve%' or item_type_code like 'reference%' or item_type_code like 'non-circ%' or item_type_code like 'special%' or item_type_code like 'twoweek%' or item_type_code like 'bound jrnl%' or item_type_code like 'bestseller%') * ERROR at line 1: ORA-00904: "RENEWAL_COUNT": invalid identifier select sum(renewal_count) from circ_trans1 where charge_date >= '01-Jul-2005' and charge_date < '30-Jun-2006' and location_name not like '%Reserve%' and (item_type_code like '%book/seria%' or item_type_code like 'reserve%' or item_type_code like 'reference%' or item_type_code like 'non-circ%' or item_type_code like 'special%' or item_type_code like 'twoweek%' or item_type_code like 'bound jrnl%' or item_type_code like 'bestseller%') * ERROR at line 1: ORA-00904: "RENEWAL_COUNT": invalid identifier select sum(renewal_count) from circ_trans1 where charge_date >= '01-Jul-2004' and charge_date < '30-Jun-2005' and location_name not like '%Reserve%' and (item_type_code like '%book/seria%' or item_type_code like 'reserve%' or item_type_code like 'reference%' or item_type_code like 'non-circ%' or item_type_code like 'special%' or item_type_code like 'twoweek%' or item_type_code like 'bound jrnl%' or item_type_code like 'bestseller%') * ERROR at line 1: ORA-00904: "RENEWAL_COUNT": invalid identifier select sum(renewal_count) from circ_trans1 where charge_date >= '01-Jul-2003' and charge_date < '30-Jun-2004' and location_name not like '%Reserve%' and (item_type_code like '%book/seria%' or item_type_code like 'reserve%' or item_type_code like 'reference%' or item_type_code like 'non-circ%' or item_type_code like 'special%' or item_type_code like 'twoweek%' or item_type_code like 'bound jrnl%' or item_type_code like 'bestseller%') * ERROR at line 1: ORA-00904: "RENEWAL_COUNT": invalid identifier
 
 
Charges by Location [All Item Type]
All Active
Current Year to Date
5-Year Aver.
FY2008
FY2007
FY2006
FY2005
FY2004
*Van Pelt Circulation106732175842248510245575250373247601243836255164
Annenberg Reserve276927905667116729431054
Biomedical Circulation08971127871051411232133141490413967
Biomedical Circulation30774833514952183800614662664313
Biomedical Reserve141640216621061849219122422441
CAJS Circulation0393413166
Chemistry Circulation8402033462432774709465648575620
Circ training12737182724452000174415771367
Dental Circulation75995612041324185715931095147
Dental Reserve620698312792730729936350793196232111
Engineering Circulation 02302549833446653957854132500
Engineering Circulation224247567055395324559956216267
Fine Arts Circulation961178809476102109864914187449417
Fine Arts Reserve7143671389912232125853221315
Lippincott Reserve Circ010189112053817513223601106
Math Circulation035641841231153
Math Circulation2879191858821898652658
Museum Circulation53282469155751219821962585752
New Bolton Circulation010421458265511047068951929
Ormandy Center94312842730133811661185
PA Hosp Circulation0141704
Serials Circulation00
Storage Circulation00
VP Ref230
Van Pelt Lib Circ Desk BD00
Van Pelt Lib Circ Desk EZ4
System Totals130715252766356750344293355649367469355864361137
back to circ reports   |   Circ Dashboard   |   back to DataFarm home