Reporting: LDP-based Reports (UXPROD-1319)

[UXPROD-881] Move materials to long-term storage Created: 11/Jun/18  Updated: 16/Sep/20  Resolved: 17/Sep/19

Status: Closed
Project: UX Product
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: Duplicate Votes: 0
Labels: dwreport, inventory, metadatamanagement, reporting
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Cloners
clones UXPROD-880 Shelf list by location (item level) Closed
Relates
relates to REP-253 Move items to long-term storage (a pi... Closed
relates to REP-253 Move items to long-term storage (a pi... Closed
Epic Link: Reporting: LDP-based Reports
Analysis Estimate: Large < 10 days
Analysis Estimator: Charlotte Whitt
Front End Estimate: XL < 15 days
Front End Estimator: Charlotte Whitt
Front-End Confidence factor: Low
Back End Estimate: Medium < 5 days
Back End Estimator: Charlotte Whitt
Estimation Notes and Assumptions: We haven't done any canned reports yet so I have no idea what will be involved.
Development Team: Reporting
Report ID (pre-May 2019): ID303
Report Contact(s):
Sharon Beltaine
Report Functional Area(s):
Metadata Management
PO Rank: 33
Rank: Chalmers (Impl Aut 2019): R5
Rank: Chicago (MVP Sum 2020): R5
Rank: Cornell (Full Sum 2021): R4
Rank: Duke (Full Sum 2021): R2
Rank: 5Colleges (Full Jul 2021): R4
Rank: FLO (MVP Sum 2020): R4
Rank: GBV (MVP Sum 2020): R4
Rank: hbz (TBD): R4
Rank: Hungary (MVP End 2020): R2
Rank: Lehigh (MVP Summer 2020): R3
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:

  • This report present a compilation of records, a shelf-list of what to be pulled to send to the remote storage.
  • Diacritics MUST be rendered accurately in printed reports, e.g. 40% of Cornell's collection is in 200+ foreign languages.

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)

Definition of Inventory In-app reports:
A report which is available from within the Inventory application itself. The in-app report are using the live data being created and stored in the Inventory module.

Document on Wiki: https://folio-org.atlassian.net/wiki/display/RPT/In-App+vs.+Data+Warehouse+Reports



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

This feature is not actually about serials and should be renamed.

Comment by lew235 [ 06/Aug/19 ]

Agree with Kristin – I changed the name from "serial cleanup". Also, could be addressed by LDP?
Sharon Beltaine

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 ]

UXPROD-881 Closed will be closed as it is a duplicate of REP-253 Closed .

Comment by Vandana Shah [ 17/Sep/19 ]

This item is a duplicate of REP-253 Closed .

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