Versions Compared

Old Version 2

changes.mady.by.user Sharon Helen Markus

Saved on

compared with

New Version 3

changes.mady.by.user Sharon Helen Markus

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Collection Management Excel Downloads


Index NumberNameDescriptionExcel File Download
Documentation
SQL Query Code
CRXXX
CR219

Olin Library

Provides fiscal year counts of physical collections use (loans and renewals) with filters for owning library, patron group, material type, and collection type (regular, equipment, etc.). Also provides counts of patron filled requests.

CR184A loans and renewals Excel download

CR193 filled delivery requests Excel download

Shelf List Inventory

This query finds shelf list inventory information for Olin Library. The most_recent_patron_group field determines what patron group an item was assigned to most recently, which is important for assignments to the Borrow Direct and Inter Library Loan patron groups, which change frequently.

CR219_Olin_3rd_A-DC

CR219_Olin_4th_DD-GV

CR219_Olin_5th_H-JF

CR219_Olin_6th_JK-PN

CR219_Olin_7th_PQ-PZ

Filtering data to obtain specific counts


CR184A SQL Query

CR193 SQL Query

CR219

Uris Library

Provides counts of circulation desk transactions by month, day, date, and time of day, with filters for material type, request type, and action type (checkin or checkout). Kroch Asia CollectionsProvides a list of all items that have an item status of 'missing', including item details, with filters including Library, permanent location, missing status date, call number and LC class. Also contains a separate view for list of items where item status is 'in transit', along with  item details and a filter for number of days in transit. If items haven't been checked in at the home location (permanent location) after a specified time period, the items might have been lost or misplaced on their way back to their home location

Shelf List Inventory

This query finds shelf list inventory information for Uris Library. The most_recent_patron_group field determines what patron group an item was assigned to most recently, which is important for assignments to the Borrow Direct and Inter Library Loan patron groups, which change frequently.

CR219

Kroch Asia Collections

Shelf List Inventory

This query finds shelf list inventory information for Kroch Asia Collections. The most_recent_patron_group field determines what patron group an item was assigned to most recently, which is important for assignments to the Borrow Direct and Inter Library Loan patron groups, which change frequently.

CR204Missing, Lost, Claimed, Returned ItemsThis query creates a list of missing, lost, and claimed returned items (including equipment) at a given library, and includes item status date, last date and location of check in, and size/pagination. Sorts in call number order. To view results for a particular library, sort your Excel file on the library_name column. To view results for a particular item status (e.g., Missing, Aged to Lost, Lost and Paid), sort your Excel file on the status_name column. Missing Lost Claimed Returned Excel DownloadCR204