LIBRARY CIRCULATION DETAIL Table
Includes information about the circulation transaction including dates, hours and staff checking out the item; as well as the type of material (BOOK, ISSUE, etc.). This data comes from the Aleph Z35 Events Table. Note: Do not use this table to determine the Total counts of Circulation prior to 7/9/2001; there is no detail information available in the Circulation Detail table until this date. Refer to the Item Detail table to obtain this data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LIBRARY_BORROWER_STATUS_KEY |
Key used to join to the LIBRARY_BORROWER_STATUS table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
20 |
LIBRARY_CATALOGER_NAME |
The staff user name associated with a circulation transaction. This is NOT the library patron; it is the library staff member who performed the transaction. |
VARCHAR2 |
10 |
LIBRARY_CIRCULATION_DESK_KEY |
Key used to join to the LIBRARY_CIRCULATION_DESK table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
35 |
LIBRARY_CIRCULATION_EVENT_DATE |
The date a circulation transaction was registered. |
DATE |
8 |
LIBRARY_CIRCULATION_EVENT_HOUR |
The time that a circulation transaction was registered. |
VARCHAR2 |
5 |
LIBRARY_CIRC_EVENT_TYPE_KEY |
Key used to join to the LIBRARY_CIRC_EVENT_TYPE table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
50 |
LIBRARY_CIRC_ITEM_STATUS_KEY |
Key used to join to the LIBRARY_CIRC_ITEM_STATUS table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
2 |
LIBRARY_ITEM_KEY |
XXX |
VARCHAR2 |
15 |
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_MATERIAL |
XXX |
VARCHAR2 |
5 |
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 |