Skip to content Accesskey=4Skip to sub-navigation Accesskey=3View our Accessibility Options MIT Information Services and Technology Home About IS&T Contact IS&T Site Map Search Advanced Search
Getting StartedGetting Services by Topic or Alphabetically Getting Help

data warehouse logo

 
Related Links:
 

Data and Reporting Services


Libraries Reports

 

Instructions for downloading & processing reports

From the list of reports, find the one you want to download. Click on the appropriate version links -- PC (for PC/Windows), Mac (for Mac) underneath the report name to download the report. Citrix users should download the PC version.

Reports with the symbol (standard reports) have been tested by a group of central and departmental users who have checked that the numbers in the report reliably tie out to SAP.

Reports without a symbol (user reports) have been reviewed by the Data Warehouse team and approved for posting on the web, but have not been through a formal testing process.


Circulation Collection Management Processing Serials Control


Circulation

Information about the Circulation of Items including Events, Dates, Number of Loans, Type of Borrower and Item.

Report

Description

Created By

Last Modified

High Circulation

PC

Mac


This report generates a list of Titles for a Library and/or Collection based on the total number of times an item circulated (based on the Item Information and a count greater than 3 or what you choose), Date of Publication, a range of Class Numbers, Library Item Material and other limits. Note that: Detailed Item Loan counts begin on July 9, 2001. Total Loan counts go back to June 26, 1995. There are no statistics prior to this. One report is arranged by Call No. another by Author, and a third by No. of Times Circulated


11/01/2005

Low Circulation

PC

Mac


This report generates a list of Titles for a Library and/or Collection based on Zero (0), or any low number of times an item did or did not circulate (based on Item information), Date of Publication, a range of Class Numbers, Library Item Material and other limits. Note that: Detailed Item Loan counts begin on July 9, 2001. Total Loan counts go back to June 26, 1995. There are no statistics prior to this. One report is arranged by Call No. a second by Author.


11/01/2005


Collection Management

Information on funds for library's budgets, receipt of new materials, management of collections including circulation and missing items. Some of the data comes only from the Item Data; other from the Circulation information.

Report

Description

Created By

Last Modified

Amount to Encumber (All Libraries)

PC

Mac


This report generates a list of Fund Statuses for Monographs for all libraries for a fiscal year. It displays the Allocation Amount, Expenditures, % Spent, Actual Balance, Encumbrances, Free balance, % Free and the Capped Allocation Amounts (based on % max over commitment) with Subtotals and Totals. The report is arranged by Library and Fund. There are Pivot reports summarizing the same data. Corresponding reports are Amount to Encumber by Library and Library Fund Status (All Libraries).


02/09/2004

Amount to Encumber by Library

PC

Mac


This report generates a list of Fund Statuses for Monographs for a library for a fiscal year. It displays the Allocation Amount, Expenditures, % Spent, Actual Balance, Encumbrances, Free balance, % Free and the Capped Allocation Amounts (based on % max over commitment) with Subtotals and Totals. The report is arranged by Fund. A corresponding report is Fund Status by Library.


02/09/2004

Fund Status (All Libraries)

PC

Mac


This report generates a list of Fund Statuses for all libraries for a fiscal year. It displays the Allocation Amount, Expenditures, % Spent, Actual Balance, Encumbrances, Free balance and % Free with Subtotals and Totals. One report is arranged by Budget Group, Source and Library. Another report is arranged by Library, Budget Group and Source. There are two Pivots summarizing the same data. Corresponding reports are "Fund Status by Library" and "Amount to Encumber by Library."

Maija Ahlquist

02/09/2004

Fund Status by Library

PC

Mac


This report generates a list of Fund Statuses for a library for a fiscal year. It displays the Allocation Amount, Expenditures, % Spent, Actual Balance, Encumbrances, Free balance and % Free with Subtotals and Totals. The report is arranged by Budget Group. There is a Pivot report summarizing the same data. Corresponding reports are "Fund Status (All Libraries)" showing similar data for all libraries and "Amount to Encumber by Library."

Maija Ahlquist

02/09/2004

High Circulation

PC

Mac


This report generates a list of Titles for a Library and/or Collection based on the total number of times an item circulated (based on the Item Information and a count greater than 3 or what you choose), Date of Publication, a range of Class Numbers, Library Item Material and other limits. Note that: Detailed Item Loan counts begin on July 9, 2001. Total Loan counts go back to June 26, 1995. There are no statistics prior to this. One report is arranged by Call No. another by Author, and a third by No. of Times Circulated


11/01/2005

Low Circulation

PC

Mac


This report generates a list of Titles for a Library and/or Collection based on Zero (0), or any low number of times an item did or did not circulate (based on Item information), Date of Publication, a range of Class Numbers, Library Item Material and other limits. Note that: Detailed Item Loan counts begin on July 9, 2001. Total Loan counts go back to June 26, 1995. There are no statistics prior to this. One report is arranged by Call No. a second by Author.


11/01/2005

Missing Items

PC

Mac


This report generates a list of missing items for a library based on the missing date status. It displays item and holding library information, statuses and numbers of items missing. One report is arranged by Missing Status and Call Number, another by Collection and Call Number, and a third by Number Missing with Item Information. There is also a table that can be downloaded into Excel or other programs.


02/09/2004

New Books

PC

Mac


This report generates a list of new titles (short bibliographic record) received by a holding library. The report may be limited to collection(s), fund(s) and/or class (es) based on a range of arrival dates (it may have arrived, but may not be cataloged ? there may be a 6 weeks delay). One report is arranged by Call Number, another by Author and Title, and a third by Collection and Title. There is also a table that can be downloaded into Excel or other programs.


02/09/2004

Titles Received by Donor

PC

Mac


This report generates a list of titles received on a Donor Fund for a given Fiscal Year.


02/09/2004


Processing

Reports containing data about the processing and/or item statuses for items, call number ranges and types of materials in a library or collection.

Report

Description

Created By

Last Modified

Item Processing Status

PC

Mac


This report generates an Item Processing Status list for a library. It displays short bibliographic information, bar code, catalog system number and status. There are three reports, one arranged by Processing Status, another by Collection and one by Format of Material. There is also a table that can be downloaded to Excel or other programs.


02/09/2004

Items by Collection

PC

Mac


This report generates a list of Titles for a Library and/or Collection based on Call Number Prefix, Library Item Process Status, Library Item Material and other limits. It displays selected Item Information. One report is arranged by Call No. Prefix, another by Collection and a third by Processing Status. This report is useful in identifying how many items are in a library collection or stored off site.


11/01/2005

Missing Items

PC

Mac


This report generates a list of missing items for a library based on the missing date status. It displays item and holding library information, statuses and numbers of items missing. One report is arranged by Missing Status and Call Number, another by Collection and Call Number, and a third by Number Missing with Item Information. There is also a table that can be downloaded into Excel or other programs.


02/09/2004


Serials Control

Information about Serial Subscriptions including costs, vendors, and orders.

Report

Description

Created By

Last Modified

Item Processing Status

PC

Mac


This report generates an Item Processing Status list for a library. It displays short bibliographic information, bar code, catalog system number and status. There are three reports, one arranged by Processing Status, another by Collection and one by Format of Material. There is also a table that can be downloaded to Excel or other programs.


02/09/2004

MIT Home | Getting Started | Getting Services | Getting Help | About IS&T | Accessibility
Ask a technology question or send a comment about this web page.