Canned LDP Reports | ||||||
|---|---|---|---|---|---|---|
CUL Report Code and Link to Query | Last Updated | Report Name | Description | ~Time to run | Related 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 report | in review, not currently available | circulation_chargesrenewals_adc | Circulation 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-195 | jl41, lm15 | |
| CR147_B - BY REQUEST - please use the Request Form to get this report | in review, not currently available | annual_circ_cons_pg_stats | Annual circulation statistics by consolidated patron group | REP-195 | jl41 | |
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 minutes | New | lm15 |
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 minutes | New | lm15 |
| 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 format | 9 minutes | REP-230adc1 | lm15 |
| 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 minutes | REP-230adc2 | lm15 |
| 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 minutes | REP-230adc3 | np55, 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 minutes | REP-230adc3 | np55, lm15 |
| CR168 | IN REVIEW 5/11/22 | physical_serial_titles_currently_received_adc | Count of physical serial titles currently received for the annual data collection. Blocked. | ~3 minutes | part of REP-228 | np55, lm15 |
| CR169 IN REVIEW | 6/24/33 | database_count_adc | Gets counts of databases for ACRL and NCES reporting. Note: This currently includes all CISER databases. May be revised. | ~6 minutes | part of REP-41 | np55, 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 minutes | NEW | np55, lm15 |
| CR192 | 10/25/22 | withdrawn_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. | NEW | jl41 | |
| CR193 | 10/25/22 | filled_delivery_requests | This 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. | NEW | jl41 | |