		Home About IS&T Contact IS&T Site Map	Search Advanced Search

	Related Links:
	Data and Reporting Services

Library Item Detail

Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.

Table Name	Description	Type	Primary Provider	Sensitivity	Load Frequency	Last Load Date
LIBRARY	Includes codes and descriptions of the MIT Libraries. This is the library that "owns" the item. (these are defined as Sub Libraries in Aleph, and include SAS, Document Services, Physics Reading Room, etc.). Use this table to limit the query by library that owns the item. Use the LIBRARY_FUND "Paying Library" field to limit the query by the library that paid for the item.	Dimension	Libraries	MIT ONLY	Daily	Unavailable
LIBRARY_CATALOG	Includes bibliographic data such as Title, Author, Imprint, Year of Publication, ISSN/ISBN, Call Number, bib record creation and update dates and the bib system number (from MIT01). Data in this table is taken from the Z13 table in Aleph. Do not use the call number for limiting queries, use the LIBRARY_CALL_NUMBER_SEARCH table to limit the query by classification.	Dimension	Libraries	MIT ONLY	Daily	01-JAN-2004
LIBRARY_COLLECTION	Includes codes and definitions of library collections as well as the type of material. Data in this table is taken from the Z30 table in Aleph. Use this table to limit the query to collection (e.g., Stacks, Electronic Journals, Basement, etc.)	Dimension	Libraries	MIT ONLY	Daily	Unavailable
LIBRARY_CALL_NUMBER_SEARCH	Includes the classification number and a calculated classification number. Use this table to limit the query by classification.	Dimension	Libraries	MIT ONLY	Daily	05-SEP-2008
LIBRARY_ITEM_STATUS	Includes descriptions of both the Item Status (e.g., 28 Day Loan, 1 Week Loan) and the Item Processing Status (e.g., On Order, Received, Claimed). Note that only the description of the codes are currently included (e.g., Received) and not the codes themselves (e.g., RD). Use this table to limit by statuses.	Dimension	Libraries	MIT ONLY	Daily	Unavailable
LIBRARY_CALL_NO_STRUCTURE	Includes codes and descriptions of Classification Schemes. Use this table to limit the query by whether there is a Call Number, Classification type and Prefix (Dewey Decimal, SCORE, etc.)	Dimension	Libraries	MIT ONLY	Daily	Unavailable
LIBRARY_ITEM_DETAIL	Includes detailed information contained in the Item Records in Aleph (e.g., Barcode, Serial Levels, Call Number, Update Date). Data in this table is taken from the Z30 table in Aleph	Fact	Libraries	MIT ONLY	Daily	05-SEP-2008


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