Ad Hoc report SQL queries written to run on the Metadb reporting database
All Reports
All Reports | |||
| CUL Report Code and Link to Query | Last Updated | Report Name | Description |
|---|---|---|---|
| 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. |
| 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. |
| 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. |