Count by Sublibrary/Collection/Material/Item Status (SCMI) is an item count report. The program, called report-itemlocs in ITD, reads through the items and their associated BIB and HOLdings records, and the associated Circulation loan records. This report is similar to the CARL BLMREP.

The Count by SCMI program utilizes data from Z00 (HOL), Z30 (items), Z36 (loans) and Z36H (loans history). 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.

Sublib: The Aleph 6 letter code for sublibrary in the Z30 record.

Coll: The Aleph 6 letter code for collection in the Z30 record.

Matrl: The material type code from the Z30 record.

IS: Item status number in the Z30 record. You can refer to tab15 for a general description of the item statuses. (tab15 is password protected)

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

Hols: The holdings counts also only appear in the most specific SCMI combinations. 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'].

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. 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)

• DW (damaged withdrawn),
• LP (lost and paid),
• MI (missing),
• RM (missing, searched),
• WI (withdrawn)

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.