...
| Annual Statistics 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 | 4/26/22 | 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 | 1/14/22 | annual_circ_non_cons_pg_stats | Annual circulation statistics (charges and renewals) by library, patron group and collection type (regular, reserve, laptop, equipment) | REP-195 | jl41 | |
| CR147_B - BY REQUEST - please use the Request Form to get this report | 01/14/22 | 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 | updated 6/24/22 3/28/22 | 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 | updated 6/24/22 3/28/22 | 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 | updated 6/27/22 updated 5/10/22 posted 3/3/22 | 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 | updated 5/10/22 posted 3/3/22 | 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 | updated 6/23/22 posted 3/3/22 | title_count_servremo_adc_stats Note: long-running queries; some results post to local schema | Count of serv,remo titles, by bib format. | 7 minutes | REP-230adc3 | 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. | ~3 minutes | part of REP-228 | np55, lm15 |
| CR169 IN REVIEW | updated 6/24/33 5/11/22 | database_count_adc | Gets counts of databases for ACRL and NCES reporting. | ~6 minutes | part of REP-41 | np55, lm15 |
| CR180 - BY REQUEST - please use the Request Form to get this report | IN REVIEW 6/24/22 | 773_and_899_aggr_counts_adc Note: long-running queries; | 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. | ~24 minutes | NEW | np55, lm15 |
...