Database Analysis

1. Database Analysis August 4, 2004

2. The MARC of Quality (TMQ) Analysis of the CCS Database July 15, 2004

4. 260 & 300 tags missing: • The entire 260 (Publisher) and 300 (Physical description) information is missing from these records. • If these records are for materials for which you will never make MARC records, then try to identify a common element in these records that we can use to pull them in the future (and not print them as we are doing here). • If there is no way to identify these records, then add something to each in a local field, e.g., 945 $bOCLC DO NOT SET, and tell us about it so we can pull them next time. Otherwise, add the missing information to these records.

5. No 049, 1xx, 260 or 300

7. No 020, 1xx, 260, 300

9. No 02X, 260, 300 Note: TAPELOAD DATA

11. No 02X, 260, 300

12. Note: Created by, Date Cataloged

13. Item has circulated 12 times

14. HUNTLEY DATA

16. What does this record need to make it “legal”?

17. 945 ‡b OCLC DO NOT SET

18. Please check all your library’s “uncataloged” records for 945 tags!

19. How do you properly remove a tag from a record?

20. Entire 260 missing • The entire 260 (Publisher) information is missing from these records. • If these records are for materials for which you will never make make MARC records, then try to identify a common element in these records that we can use to pull them in the future (and not print them as we are doing here). • If there is no way to identify these records, then add something to each in a local field, e.g., 945 $b OCLC DO NOT SET, and tell us about it so we can pull them next time. • Otherwise, add the missing information to these records.

22. Where is 260 info?

24. Either catalog in OCLC or add 945

26. Does this contain “OCLC DO NOT SET”?

28. Enter in OCLC or “DO NOT SET”

29. 260 ‡b missing • 260 $b (Publisher) is missing from this record and 000/06 (Record type) is not 'd', 'f', 'p', 'r', or 't' (Manuscript or Realia). • If this is a published work, add a 260 $b, even if you must use ':$b [s.n.]' to indicate that the publisher is unknown.

31. 260 a?

32. 260 ‡b?

33. 260 ‡a?

37. 260 ‡c missing • 260 $c (Date of publication) is missing from this record and 000/07 (Bib level) does not indicate that this record is a serial ('s' or 'b'). • Add a 260 $c, even if you must guess at the date.

38. 260 ‡c

39. Can the problems with this record be resolved by transferring the holdings to another record? Search for key elements, title words and publisher name.

40. Looks like a possible match! Get details.

43. Phys. Description vs. RecType c • 000/06 (Type of record) does not match 300 $a (or the 300 $a is entered incorrectly; AACR). • Fix the 300 $a, or change the leader RecType to 'a' for printed or 't' for manuscript language material and adjust the 008 accordingly to match the type of material described in the 300 $a, except in rare exceptions.

44. NSS

45. Phys. Desc. vs. RecType i or j • 000/06 (Type of record) does not match 300 $a (or the 300 $a is entered incorrectly; see AACR). • Fix the 300 $a, or change the leader RecType to 'i' for non-musical or 'j' for musical sound recordings and adjust the 008 accordingly to match the 300 $a, except in rare exceptions.

46. “Pseudo-MARC”

47. Pseudo-MARC

48. RecType does not agree with 300

49. Is there a better “duplicate”?

50. Search by publisher’s number (“Label no.”)