...
| 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 | 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 | 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 | 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 | 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 | 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 | 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 |
...