Ytdcirc

Department: 

Circulation (as of 2018, Sam Simpson is responsible for running this annually)

Purpose:

At the end of the fiscal year, the item record values in the YTDCIRC field need to be transferred to the 2YDCIRC field. The YTDCIRC field is zeroed out so that data for the new fiscal year can be reflected.

Overview:

The YTDCIRC field is a running count of how many times the item has circulated in the current fiscal year. The 2YRCIRC field represents how many times the item has circulated the previous fiscal year. At the beginning of each fiscal year the YTDCIRC data must be transferred to the 2YRCIRC field. Note: We rely on the TOT CHKOUT field to tell us the total number of checkouts since the field was added to our system (about 1993).

The procedure involves making a list of item records, making a subset of the list for each library, running statistical reports against the list, and saving the reports to an Excel spreadsheet on the S drive.

The statistical reports are run against the SCAT table for collection development purposes. The results show how many unique items have circulated at least once in each call number range. Note: this is not the same as our total checkout count.**

Required Knowledge/Skills:

Equipment/Supplies:

PC with access to  access to S drive

Procedure

IMPORTANT: This procedure must be done toward the end of the day on June 30 or early in the day on July 1, or on the nearest working day to either of those days.

1. Perform this function at the end of the day on the last day we are open for the fiscal year, or early in the day on the first day we are open for the new fiscal year.

Do the roll-over.

Completion

8. Send an email to collection development, circulation and technical services staff, so they will know why so many item records have the same updated date.

drr Updated 7/17/2015