Scope: This procedure explains the process LTS managers and the LTS Administrative Support Specialist must follow to gain access to the database, and gives guidelines for its use. Step-by-step explanations for the use of specific reports is included.
Contact: Nancy Solla
Date last updated:
Date of next review:
Introduction
Connecting to the TS Stats Database
Using the TS Stats Database (General guide)
Brief Description of Each Report
Using the “Unit” reports in the TS Stats Database
Using the Batch Processing Stats Database
How to Compile Batch Processing Statistics for the Fiscal Year End
__________________________________________________________________________________________
A. Introduction
Library Technical Services tracks and compiles production statistics at the department, unit, and individual levels. This information is important for individual employee performance evaluation and management, and for short and long term planning at both the unit and department levels. Information from 948 fields is harvested and processed to determine what type of work was done to a record, on what day, and by whom. An Access database was built to query this data and create reports for individuals, units, and the entire department.
Managers may retrieve statistics for each of their reports, and may also retrieve statistics for their units, for any desired date range. They may run these queries at any time they desire. Monthly retrieval of statistics for the entire department is executed by the LTS Administrative Support Specialist, who compiles this information into a spreadsheet for each fiscal year. This spreadsheet is distributed throughout LTS management and shared with Library Administration.
Additional, specialized reports have been written in a separate database [link to F] to gather information regarding batch processing production in LTS. These statistics are compiled by the Batch Processing Supervisor for each fiscal year. [link to G]
B. Connecting to the Technical Services Statistics Database
- Download and install the MySQL ODBC 5.1 driver. The installer is available on the LTS share, in "netadmins\Software\MySQL." Also, either create a desktop shortcut to the database, or map drive to it. The database is found at \\files.cornell.edu\lib\ds-deptshares\LTS\tsstats\1New_culv2-2012-2013.accdb.
- Ask Amy Blumenthal or Chris Manly for the database password.
- Configure the driver, using the 32-bit ODBC Administrator, here: c:\windows\syswow64\odbcad32.exe. (Note: Do not use the ODBC Administrator in Control Panel/Administrative Tools.)
