...
| Collection Management | ||||||
| CUL Report Code and Link to Query | Last Updated | Report Name | Description | ~Time to run | Related JIRA REP Issues | Setup |
|---|---|---|---|---|---|---|
| CR181 | 8/2/22 | circ_count_by_instanceHRID | This report returns circ counts from both Voyager and Folio for an individual instance HRID, as selected in the parameters. Title, location, and number of items are also included. | NEW | jl41, vp25 | |
| CR185 | 9/20/22 | ceased_cancelled_titles_holdings_level | This query finds ceased or cancelled titles at the holdings level for a specified owning library and LC class, and shows if there are holdings at the Annex. | NEW | jl41, vp25 | |
| CR186 | 9/20/22 | ceased_cancelled_titles_item_level | This query finds ceased or cancelled titles at the item level, for a specified owning library and LC class, and shows if there are holdings at the Annex. | NEW | jl41, vp25 | |
| CR189 | 9/20/22 | book_list | This query creates a list of books at a specified library showing title, author, call number, year of publication and number of circs (Voyager plus Folio). | NEW | jl41, vp25 | |
| CR208 | 5/5/23 | identifying_DVDs | This query identifies DVDs in the library location specified. | NEW | jl41 | |
HathiTrust
HathiTrust Reports | ||||||
| CUL Report Code and Link to Query | Last Updated | Report Name | Description | ~Time to run | Related JIRA REP Issues | Setup |
|---|---|---|---|---|---|---|
| CR143_A - BY REQUEST - please use the Request Form to get this report | 12/6/21 | hathitrust_serial_holdings Note: long-running query, results post to local schema | This set of queries creates the list of serials holdings in conforming to this specification that CUL sends to HathiTrust. The queries create 11 intermediate tables that write to the local schema before creating the final dataset. | REP-18 | np55 | |
| CR143_B - BY REQUEST - please use the Request Form to get this report | 12/13/21 | hathitrust_monograph_holdings Note: long-running query, results post to local schema | This set of queries creates the list of single volume monographic (SVM) holdings conforming to this specification that CUL sends to HathiTrust. | REP-18 | np55 | |
| CR143_C - - BY REQUEST - please use the Request Form to get this report | 12/13/21 | hathitrust_multivolume_holdings Note: long-running query, results post to local schema | This set of queries creates the list of multivolume monographic (MVM) holdings conforming to this specification that CUL sends to HathiTrust. | REP-18 | np55 | |
...