Versions Compared

Old Version 5

changes.mady.by.user Sharon Helen Markus

Saved on

compared with

New Version 6

changes.mady.by.user Sharon Helen Markus

Saved on

Key

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

...

Canned report SQL queries written to run on the Metadb reporting database


All Reports


All Reports

CUL
Report
Code
Code 
and Link to Query		Functional AreaPriorityLast
Updated or Target Date		Report NameDescriptionAssignment
AuthorCR143_A - BY REQUEST - please use the Request Form to get this report12/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 report12/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 report12/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.
MCR101Collection DevelopmentMedium

fund_expenditures_by_po_line_invoice_payments

shows fund expenditures by purchase order line within a given invoice payment date rangeslm5
MCR106Access ServicesHigh

missing_or_lost_items

creates a list of missing or lost items at a given libraryjl41
MCR107Access ServicesHigh6/24/24

patron_requests_by_type_and_status

list of patron requests within a specified date range by request type and statusjl41