LIBRARY CIRCULATION DETAIL Table
View exposing library circulation transaction records including item identifiers, borrower attributes, desk identifiers, event types, and transaction dates used for circulation reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LIBRARY_BORROWER_STATUS_KEY |
Surrogate key identifying the library borrower status. |
VARCHAR2 |
20 |
LIBRARY_CATALOGER_NAME |
Library cataloger name associated with the record. |
VARCHAR2 |
10 |
LIBRARY_CIRCULATION_DESK_KEY |
Surrogate key identifying the library circulation desk. |
VARCHAR2 |
50 |
LIBRARY_CIRCULATION_EVENT_DATE |
Date associated with library circulation event. |
DATE |
|
LIBRARY_CIRCULATION_EVENT_HOUR |
Library circulation event hour associated with the record. |
VARCHAR2 |
5 |
LIBRARY_CIRC_EVENT_TYPE_KEY |
Surrogate key identifying the library circ event type. |
VARCHAR2 |
50 |
LIBRARY_CIRC_ITEM_STATUS_KEY |
Surrogate key identifying the library circ item status. |
VARCHAR2 |
2 |
LIBRARY_ITEM_KEY |
Surrogate key identifying the library item. |
VARCHAR2 |
15 |
LIBRARY_KEY |
Surrogate key identifying the library. |
VARCHAR2 |
5 |
LIBRARY_MATERIAL |
Library material associated with the record. |
VARCHAR2 |
5 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |