Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Using the Principal Cataloger's and Director of Cataloging and Metadata Special Reports

Compiling Database Quality Unit Statistics


...

 

Anchor
intro
intro
A. Introduction

...

Additional specialized reports have been written in a separate database to gather information regarding batch processing production in LTS. These statistics are compiled by the Batch Processing Supervisor for each fiscal year.

...

Anchor
connect
connect
B. Connecting to the Technical Services Statistics Database

...

vii. The program has saved your report as a .pdf file in your chosen folder and has opened it in Adobe Acrobat for you to review. (If you wish to print it at this time, click the "Print" button on the toolbar and remember to go to "Print Properties and deselect "print on both sides".) Now that you have saved the report as a .pdf, you may retrieve and print it at any time. 

...

Anchor
dbq
dbq
I. Compiling Database Quality Unit Statistics

The fiscal year end spreadsheet, L://tsstats/LTS_Stats_2005-[current year].xlsx, requires information for the Database Quality Unit that require the use of more than one report in the Technical Services Statistics Database. (See screenshot, below.)

Image Added

The Record maintenance and Withdrawals statistics can be gathered simply by running the Unit Summary Report for Database Quality,  and retrieving the two figures highlighted in the screenshot below:

Image Added

To gather the information for "Transfers," you will need to run the "Transfers Summary Report" for the FY in question. This query will return an .xlsx spreadsheet with a list of BIB ids that were transferred. Simply enter the total number of records in the spreadsheet to get the number of transfers executed by Database Quality staff members.


Save

Save

Save

Save

Save

Save

Save

Save

Save

Save