LIBRARY Table
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.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LIBRARY_CODE |
Three-letter code for the Sub-Library (e.g., ENG, HUM) owning the item. Use the Paying_Library_Code for the library purchasing the item. |
VARCHAR2 |
3 |
LIBRARY_KEY |
Key used to join to the LIBRARY table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
3 |
LIBRARY_NAME |
The description of the Library (Sub-Library) code. (e.g., Barker Library, Humanities Library) |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |