Versions Compared

Key

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




Canned LDP Reports

CUL Report Code

and Link to Query

Last UpdatedReport NameDescription~Time to runRelated JIRA
REP Issues
Setup
CR144 - BY REQUEST - please use the Request Form to get this report

7/1/22

in review; not currently available

volume_count_stats

Note: long-running query, results post to local schema

newly created and total existing volume count statistics for Cornell annual statistics reports by unit and on campus versus the annex



np55

CR147_A  - BY REQUEST - please use the Request Form to get this reportin review, not currently availablecirculation_chargesrenewals_adcCirculation statistics (charges and renewals) by library, patron group and collection type (regular, reserve, laptop, equipment) used for the annual data collection. Excludes SPEC and ILL/BD owned by other institutions.
REP-195jl41, lm15
CR147_B  - BY REQUEST - please use the Request Form to get this reportin review, not currently availableannual_circ_cons_pg_statsAnnual circulation statistics by consolidated patron group
REP-195jl41

CR160 - BY REQUEST - please use the Request Form to get this report

Warning - currently requires manual processing of results

7/1/22

in review; not currently available


soundrec_piece_ct_adc

Note: long-running query, some results post to local schema

*adc = Annual Data Collection

This set of queries provides soundrecording piece count statistics for Cornell annual statistics reports,  by unit "on campus," and by unit at the Annex.14 minutesNewlm15

CR161 - BY REQUEST - please use the Request Form to get this report

Warning - currently requires manual processing of results

7/1/22

in review; not currently available


vidrec_piece_ct_adc

Note: long-running query, some results post to local schema

*adc = Annual Data Collection

This set of queries provides videorecording piece count statistics for Cornell annual statistics reports,  by unit "on campus," and by unit at the Annex.8 minutesNewlm15
CR162  - BY REQUEST - please use the Request Form to get this report

6/27/22

in review; not currently available

title_count_non-micr-physical_adc_stats

Note: long-running queries; some results post to local schema

Count of all physical titles except those in microform format, by bib format9 minutesREP-230adc1lm15
CR163  - BY REQUEST - please use the Request Form to get this report

5/10/22

in review; not currently available


title_count_micro_adc_stats

Note: long-running queries; some results post to local schema

Count of microform titles, by bib format.7 minutesREP-230adc2lm15
CR164   - BY REQUEST - please use the Request Form to get this report

8/11/22

in review; not currently available


title_count_servremo_viaculcodes_adc

Note: long-running queries; some results post to local schema

Count of serv,remo titles, by bib format, through CUL-applied codes (in previous version, leader format used). PLEASE NOTE: this query does not yet exclude unpurchased PDA.10 minutesREP-230adc3np55, lm15
CR164alt   - BY REQUEST - please use the Request Form to get this report

8/5/22

in review; not currently available

title_count_servremo_adc

Note: long-running queries; some results post to local schema

Count of serv,remo titles, by bib format, through leader coding.  An alt query for limited use. Contact Linda Miller for more info.10 minutesREP-230adc3np55, lm15
CR168IN REVIEW
5/11/22
physical_serial_titles_currently_received_adcCount of physical serial titles currently received for the annual data collection. Blocked.~3 minutespart of REP-228np55, lm15
CR169 IN REVIEW

6/24/33


database_count_adcGets counts of databases for ACRL and NCES reporting. Note: This currently includes all CISER databases. May be revised.~6 minutespart of REP-41np55, lm15
CR180 - BY REQUEST - please use the Request Form to get this report

6/24/22

in review; not currently available

773_and_899_aggr_counts_adc

Note: long-running query

Gets counts of aggregators and other collections coded in 773 and 899 fields. Used to help track changes in e-counts from year to year. First version.~24 minutesNEWnp55, lm15
CR19210/25/22withdrawn_items

This query finds the number of items withdrawn in the date range specified, as of 7-1-21 and going forward. From 7-1-21 through 8-14-22, the withdrawn information comes from the holdings note on specific holdings records. 

NOTE: As of 8-15-22, the count of withdrawn items comes from the administrative note on the instance record and is not linked to specific holdings records. In this case, the the query lists all the holdings locations, and the total number of pieces withdrawn, without being able to specify from which locations the withdrawals took place. 

The query lists title, holdings hrid, library name, location name, call number, holdings type, withdrawal date, and number of pieces withdrawn. 



NEWjl41
CR19310/25/22filled_delivery_requestsThis query provides a count of all contactless delivery and circulation desk pickup requests, by fiscal year. Patron group, material type, request type, and location details are included. 
NEWjl41

...