LIBRARY CATALOG Table
View exposing library catalog bibliographic records including titles, identifiers, formats, subjects, and related catalog attributes used for discovery and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CATALOG_AUTHOR_NAME |
Catalog author name associated with the record. |
VARCHAR2 |
750 |
CATALOG_CALL_NUMBER |
Catalog call number associated with the record. |
VARCHAR2 |
100 |
CATALOG_ISBN |
Catalog isbn associated with the record. |
VARCHAR2 |
110 |
CATALOG_PUBLISHER |
Catalog publisher associated with the record. |
VARCHAR2 |
1000 |
CATALOG_RECORD_CREATE_DATE |
Date associated with catalog record create. |
DATE |
|
CATALOG_RECORD_UPDATE_DATE |
Date associated with catalog record update. |
DATE |
|
CATALOG_SYSTEM_NUMBER |
Catalog system number associated with the record. |
VARCHAR2 |
20 |
CATALOG_TITLE |
Catalog title associated with the record. |
VARCHAR2 |
1000 |
CATALOG_YEAR |
Catalog year associated with the record. |
VARCHAR2 |
4 |
LIBRARY_CATALOG_KEY |
Surrogate key identifying the library catalog. |
VARCHAR2 |
20 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |