LIBRARY CATALOG Table
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.
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
CATALOG_AUTHOR_NAME |
Author including all subfields based on MARC tag 1XX. (Z13-AUTHOR) |
VARCHAR2 |
500 |
CATALOG_CALL_NUMBER |
First call number the system encounters when creating the brief bib information. (Z13 $$h only). Use the LIBRARY_ITEM_DETAIL table to display Call No. info in a report. |
VARCHAR2 |
100 |
CATALOG_ISBN |
ISBN, ISSN, or ISMN (Z13-ISBN-ISSN). Includes the MARC tags for International Book Number, Serials Number and Music number: 020, 022, or 024, including all subfields. Note: If none of these MARC tags is present, the System Number will be used instead. |
VARCHAR2 |
100 |
CATALOG_PUBLISHER |
Imprint of the bibliographic record. Includes all of MARC field tag for the imprint (e.g., 260) (Z13-IMPRINT) |
VARCHAR2 |
500 |
CATALOG_RECORD_CREATE_DATE |
Date the record was created. (Z13-OPEN-DATE) |
DATE |
8 |
CATALOG_RECORD_UPDATE_DATE |
Date record was last updated. (Z13-UPDATE-DATE) |
DATE |
8 |
CATALOG_SYSTEM_NUMBER |
Contains same value as the Aleph System Number- Library Catalog Key (Z13-DOC-NUMBER) |
VARCHAR2 |
20 |
CATALOG_TITLE |
Title (Z13; MARC tag 245, including all subfields) |
VARCHAR2 |
100 |
CATALOG_YEAR |
Year of publication, distribution. (Z13-YEAR) |
VARCHAR2 |
4 |
LIBRARY_CATALOG_KEY |
Key used to join to the LIBRARY_CATALOG table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |