Reporting: LDP-based Reports (UXPROD-1319)

[REP-251] Un-cataloged materials Created: 12/Jun/18  Updated: 16/Sep/20

Status: Draft
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: Unresolved Votes: 0
Labels: dwreport, inventory, metadatamanagement, reporting
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Defines
is defined by LDPQURY-12 SQL query for Uncatalogued Materials ... Open
Relates
relates to UXPROD-867 Reporting: In-App Reports Open
relates to UXPROD-2216 MM-Cataloging Status Cluster Open
Epic Link: Reporting: LDP-based Reports
Report Contact(s):
Christie Thomas
Report ID (pre-May 2019): ID313
Report Functional Area(s):
Metadata Management
Rank: Chalmers (Impl Aut 2019): R5
Rank: Chicago (MVP Sum 2020): R4
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): R4
Rank: U of AL (MVP Oct 2020): R4

 Description   

Periodically review to locate un-cataloged materials (instance status = uncataloged) that are available (item status = available); which indicate item is having bypassed cataloging workflows. Here bib status=uncatalogued, instance has a specific code, as does the item.

Parameters to the report:
FOLIO ID (HRID), Instance Status, Bib Staff Only Flag, Date created, Date updated, Created by, Updated by, MARC LDR, Instance Title (MARC 245), MARC 6xx, Holdings ID, Holdings type, Location, Call Number, Item ID, Item Staff Only flag, Material type (Item type), Item Status, Date Item Status Updated.

Notes from Reporting Master spreadsheet:
MARC fields, administrative bibliographic metadata, holdings and item data.



 Comments   
Comment by lew235 [ 02/Aug/19 ]

This can be covered by a search or (preferably) filter on Instance status

Comment by Nassib Nassar [ 04/Sep/19 ]

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

Comment by Charlotte Whitt [ 04/Sep/19 ]

Hi Nassib Nassar - this will be covered by a filter on instance status; and solved when updating the diplay of filters in Inventory.

Comment by Kevin Walker [ 23/Jan/20 ]

WOLFcon2020:

Add "request" element to this report (e.g., hold). Is there a request associated with a record?

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