LIBRARY ITEM DETAIL Table
View exposing detailed library item records including identifiers, status attributes, locations, and circulation-related information.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CALL_NUMBER |
Call number associated with the record. |
VARCHAR2 |
100 |
CALL_NUMBER_CLASS |
Call number class associated with the record. |
VARCHAR2 |
50 |
CALL_NUMBER_PREFIX |
Call number prefix associated with the record. |
VARCHAR2 |
50 |
CALL_NUMBER_SEARCH_KEY |
Surrogate key identifying the call number search. |
VARCHAR2 |
50 |
CALL_NUMBER_SORT |
Call number sort associated with the record. |
VARCHAR2 |
80 |
CALL_NUMBER_SOURCE |
Call number source associated with the record. |
VARCHAR2 |
50 |
CALL_NUMBER_SUFFIX |
Call number suffix associated with the record. |
VARCHAR2 |
50 |
CHRONOLOGICAL_I |
Chronological i associated with the record. |
VARCHAR2 |
20 |
CHRONOLOGICAL_J |
Chronological j associated with the record. |
VARCHAR2 |
20 |
CHRONOLOGICAL_K |
Chronological k associated with the record. |
VARCHAR2 |
20 |
CHRONOLOGICAL_L |
Chronological l associated with the record. |
VARCHAR2 |
20 |
ENUMERATION_A |
Enumeration a associated with the record. |
VARCHAR2 |
20 |
ENUMERATION_B |
Enumeration b associated with the record. |
VARCHAR2 |
20 |
ENUMERATION_C |
Enumeration c associated with the record. |
VARCHAR2 |
20 |
ENUMERATION_D |
Enumeration d associated with the record. |
VARCHAR2 |
20 |
ENUMERATION_E |
Enumeration e associated with the record. |
VARCHAR2 |
20 |
ENUMERATION_F |
Enumeration f associated with the record. |
VARCHAR2 |
20 |
ENUMERATION_G |
Enumeration g associated with the record. |
VARCHAR2 |
20 |
ENUMERATION_H |
Enumeration h associated with the record. |
VARCHAR2 |
20 |
IS_ITEM_LOCATION_TEMPORARY |
Indicator identifying whether item location temporary (Y/N). |
VARCHAR2 |
1 |
ITEM_PROCESS_STATUS_DATE |
Date associated with item process status. |
DATE |
|
LIBRARY_ADM_KEY |
Surrogate key identifying the library adm. |
VARCHAR2 |
20 |
LIBRARY_CALL_NO_STRUCTURE_KEY |
Surrogate key identifying the library call no structure. |
VARCHAR2 |
20 |
LIBRARY_CALL_NUMBER_ALEPH |
Library call number aleph associated with the record. |
VARCHAR2 |
200 |
LIBRARY_CATALOGER_ID |
Business identifier for the library cataloger. |
VARCHAR2 |
10 |
LIBRARY_CATALOG_KEY |
Surrogate key identifying the library catalog. |
VARCHAR2 |
20 |
LIBRARY_COLLECTION_KEY |
Surrogate key identifying the library collection. |
VARCHAR2 |
20 |
LIBRARY_HOLDINGS_KEY |
Surrogate key identifying the library holdings. |
VARCHAR2 |
9 |
LIBRARY_HOL_DOC_NUMBER_X |
Library hol doc number x associated with the record. |
VARCHAR2 |
9 |
LIBRARY_ISSUE_ARRIVAL_DATE |
Date associated with library issue arrival. |
DATE |
|
LIBRARY_ISSUE_EXPEC_ARRVL_DATE |
Date associated with library issue expec arrvl. |
DATE |
|
LIBRARY_ITEM_BARCODE |
Library item barcode associated with the record. |
VARCHAR2 |
30 |
LIBRARY_ITEM_DESCRIPTION |
Description of library item. |
VARCHAR2 |
200 |
LIBRARY_ITEM_ISSUE_DATE |
Date associated with library item issue. |
DATE |
|
LIBRARY_ITEM_KEY |
Surrogate key identifying the library item. |
VARCHAR2 |
15 |
LIBRARY_ITEM_LAST_RETURN_DATE |
Date associated with library item last return. |
DATE |
|
LIBRARY_ITEM_LOANS_NUMBER |
Library item loans number associated with the record. |
NUMBER |
3 |
LIBRARY_ITEM_OPEN_DATE |
Date associated with library item open. |
DATE |
|
LIBRARY_ITEM_STATUS_KEY |
Surrogate key identifying the library item status. |
VARCHAR2 |
20 |
LIBRARY_ITEM_UPDATE_DATE |
Date associated with library item update. |
DATE |
|
LIBRARY_KEY |
Surrogate key identifying the library. |
VARCHAR2 |
3 |
LIBRARY_ORDER_KEY |
Surrogate key identifying the library order. |
VARCHAR2 |
14 |
LIBRARY_ORDER_STATUS_KEY |
Surrogate key identifying the library order status. |
VARCHAR2 |
20 |
LIBRARY_ORDER_TYPE_KEY |
Surrogate key identifying the library order type. |
VARCHAR2 |
20 |
LIBRARY_VENDOR_KEY |
Surrogate key identifying the library vendor. |
VARCHAR2 |
20 |
ORDER_NUMBER |
Order number associated with the record. |
VARCHAR2 |
30 |
PUBLIC_NOTE |
Public note associated with the record. |
VARCHAR2 |
50 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |