Count by Call Number Ranges is an item count report. The program, called report-callnums in ITD, reads thru the items and their associated BIB and HOLdings records, and the associated Circulation loan records. The Call number ranges used in the initial run of the report was the default list of ranges used for the CARL CNREP report. We have not used the specialized lists that existed in CARL at this time.

Count by Call Number Ranges report program utilizes data from Aleph Z13 (short bibliographic record), Z00 (HOL), Z30 (items), Z36 (loans) and Z36H (loans history). Z13 (short bibliographic record) contains up to six fixed (system defined) fields, including year, call no., author, title (up to 100 characters), imprint and issn-isbn. Z00 (HOL) includes information of HOL system number, sublibrary, collection, and call number. Z30 item records include information of an item's sub-library, collection, temporary location, call no., material type, item processing status, enumerations/chronologies, etc. Z36 includes active loan records whereas Z36H retains completed transactions.

Call number: either the first letter or the more specific ranges. The SUDOC numbers come at the end of the alphabet in each section.

Bibs: The bibliographic counts only appear in the more specific ranges of the report. There is a "-" when we could not provide a count of unique titles on the summary lines.

Hols: The holdings counted are those associated with an item. If there are holdings without items they were not counted.

• Active/Current: items currently charged out (with the exception mentioned below of excluded loans). [Taken from the Z36 loan table: z36_status='A']
• Active/Range: items charged in Aleph during a certain period of time. We cannot include the cumulative charges from CARL. The monthly run of the reports will be in a range of 2003/01/06 - the day the report was run. Any other range, which covers the time we have been on Aleph, can be requested as an Ad Hoc running of the report. [Taken from the Z36 loan and Z36h loan history tables: (z36_status='A' and z36_loan_date in range)+(z36h_status='A' and z36h_loan_date in range)
• Claims returned: items currently charged out and marked as claims returned. These are not included in the Active/Current column. [Taken from the Z36 loan table: z36_status='C'].
• Lost: Items charged out and lost. These do not include items with an item processing status of lost. [Taken from the Z36 loan table: z36_status='L'].

Description: The last column of the report is description for the call number listed, e.g., AE = Encyclopedias, AG = General Reference Works, etc. The asterisk "*" in this column indicates no description available or an invalid range. This information comes from the default list of call number ranges.

Frequency: ITD will run the standard report monthly to provide up-to-date USMAI statistics, which can be retrieved from the Aleph report page on the Web. We will run the report on different days of the month for each institution. You can submit a request for a customized, ad hoc, report to satisfy your campus specific needs for data inclusion, exclusion, call number ranges or range of dates through the Aleph Web Request Form.

• in-transit loans
• borrower statuses (from the count of Z36/Z36H records):
• - 61 ILL
• - 71 Bindery
• - 72 Catalog Maintenance
• - 73 CPDPT
• - 91 In transit
• - 92 Tracer
• - 93 Lost
• - 79 Institutional borrowers

• EX (expected),
• NA (not arrived),
• NE (not expected),
• NP (not published),
• NR (not received),
• OI (order initiation),
• OR (on order) Optional exclusions, must explicitly request these to be excluded:
• DW (damaged withdrawn),
• LP (lost and paid),
• MI (missing),
• RM (missing, searched),
• WI (withdrawn)

• ranges.xml - Default
• ranges-art.xml
• ranges-ce.xml
• ranges-cs.xml
• ranges-fs.xml
• ranges-ml.xml
• ranges-su.xml
• ranges-tu.xml
• ranges-ub.xml

Information Technology Division College Park, MD 20742-7011
Please send comments and suggestions to ITD's Webmaster.
Content questions should be directed to USMAI Web Admin.