Skip to content

Annual Reports

Jeremy Goldstein edited this page Apr 26, 2023 · 2 revisions

Collection of queries used for generating annual report and compiling statistics for ARIS.


Aris

Gathers current holdings by ARIS category for a specified library determined by Agency code.

ARIS categories are defined by itypes.

Gathers current holdings by ARIS category for a specified library determined by Agency code. Categories are defined by Mat Type and location codes.

Crosstab report of item types and location codes, with ARIS categories for each itype.

Holdings

Gathers a count of holdings in each location, subdivided by status.

Count of items held by each building location.

Count of items created in the past year, for each combination of location code and itype.

Crosstab version of Items Added Location By Itype.

Count of items added by each library in the past year, excluding specified itypes.

Patrons

Provides counts of Active, New, and total patrons associated with each library, using barcode prefix to determine the card issuing library.

Provides counts of Active, New, and total patrons for each Ptype.

Miscellaneous

Provides the current total number of records for each record type within Sierra.