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 |
|---|---|---|---|---|---|---|
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 |
05-APR-2012 |
|
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 |
|
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 |
|
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 |
|
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 |
22-DEC-2021 |
|
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 |
|
Includes the classification number and a calculated classification number. Use this table to limit the query by classification. |
Dimension |
Libraries |
MIT ONLY |
Daily |
22-DEC-2021 |