Reporting: LDP-based Reports (UXPROD-1319)

[REP-253] Move items to long-term storage (a pick list) Created: 11/Jun/18  Updated: 13/Jun/23  Resolved: 13/Jun/23

Status: Closed
Project: Reporting
Components: None
Affects versions: None
Fix versions: None
Parent: Reporting: LDP-based Reports

Type: New Feature Priority: P3
Reporter: Charlotte Whitt Assignee: Sharon Beltaine
Resolution: Won't Do Votes: 0
Labels: dwreport, inventory, metadatamanagement, reporting
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Relates
relates to UXPROD-867 Reporting: In-App Reports Open
relates to UXPROD-881 Move materials to long-term storage Closed
relates to UXPROD-881 Move materials to long-term storage Closed
relates to UXPROD-2242 MM-Picklist-Report Cluster Closed
Epic Link: Reporting: LDP-based Reports
Report Contact(s):
Sharon Beltaine
Report ID (pre-May 2019): ID304; ID305
Report Functional Area(s):
Metadata Management
Rank: Chalmers (Impl Aut 2019): R5
Rank: Chicago (MVP Sum 2020): R1
Rank: Cornell (Full Sum 2021): R2
Rank: Duke (Full Sum 2021): R1
Rank: 5Colleges (Full Jul 2021): R2
Rank: FLO (MVP Sum 2020): R4
Rank: GBV (MVP Sum 2020): R5
Rank: hbz (TBD): R5
Rank: Hungary (MVP End 2020): R1
Rank: Lehigh (MVP Summer 2020): R3
Rank: Leipzig (Full TBD): R4
Rank: TAMU (MVP Jan 2021): R1
Rank: U of AL (MVP Oct 2020): R4

 Description   

Purpose: An ad-hoc report. The libraries move tens of thousands of books into long-term storage every year. These reports are generated every month or two.

Parameters to the report:
LC Class; Format; Language; Pub Date; Pub Status; Receipt Status; Record Type; Location; Suppression; Call number type; Barcode status; Circ activity / number of charges
criteria can change over time.

The output:

  • Present a list to fix or clean up the data, a "pick list"
  • Diacritics MUST be rendered accurately in printed reports, e.g. 40% of Cornell's collection is in 200+ foreign languages.

For Cornell Law, report will need to show how many items were moved from campus library to annex; include date items moved and operator id for batch processing

 

Notes from Reporting Master spreadsheet:
Legacy System Data Element Sources: MARC record leader bytes 06/07 to determine format; MARC BIB 008/6 Pub Status, 008/7-10 Date of Pub, 008/35-37 Language; 008/21 Type of Continuing Resource (fmt=as);100 Author, 245 Short and Long form of Title, 260 Imprint; Access to 5xx and 6xx tags; Presence of 780/785 tags to report title changes; 880 tags for CJK character sets; MFHD: Marc Leader/06 Type of Record; Call Number in display and sort order form; Call number type (LC / Other); LC Class (class, first letter of class and first cutter); 852 |k, 852 |m, 852 |t; complete text of 866, 867 and 868 tags; MARC MFHD 008/06 Receipt Status; BIB and MFHD Suppress values; Enumeration; Chronology; Holdings location; Item location; Item temp location; Item Barcode; Item Barcode Status (active/expired); Historic and Current Circulation data (charges)

 

 

 

 



 Comments   
Comment by Kristin Martin [ 30/Apr/19 ]

This report is something that we would want to be able to do on an Ad-Hoc basis since our criteria for transferring materials vary based on the project.

Comment by lew235 [ 06/Aug/19 ]

Seems like a search/batch-editing need to me rather than a report per se?

Comment by Nassib Nassar [ 04/Sep/19 ]

Please identify an analyst or developer resource to write the SQL report query.

Comment by Vandana Shah [ 17/Sep/19 ]

Duplicate

Generated at Fri Feb 09 00:11:09 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.