This cube holds details about the library items, including summary information about loans. Use cube_library_loan for a more detailed breakdown of the loans taken out.
|Shared Dimension||Name in Cube||Notes|
Item Bibliographic Info
|The dimension has been split up into other dimensions on the cube, for ease of use.|
Cube Specific Dimensions
This holds additional columns used for analysis and reporting purposes.
|Column Name||Data Type||Description||Derivation|
|Item Loan Number Src||integer||The total number of loans recorded for the item||Based upon z30_no_loans|
|Loan Count On Aleph||varchar||Total number of loans recorded on Aleph||Number of records for item in z36 & z36h tables.|
|Max Loan Date Sk||integer||Latest date item was loaned out||Latest loan date based upon z36_loan_date & z36h_loan_date|
|Max Loan Returned Date Sk||integer||Latest date item was returned||Latest item return date based upon z36_returned_date and z36h_returned_date|
|Loan Total Count||The total number of loans recorded against the item.|
|Loan Aleph Count||Number of loans in the selection|
|Loan Date Max||The latest (max) loan date. Note: Displayed currently in YYYYMMDD format, which matches Aleph formatting.|
|Loan Returned Date Max||The latest date the item has been returned|