New Document

Inn-Reach Statistics

Inn-Reach Circulation Statistics

For Prospector Summary statistics, see: http://prospector.coalliance.org:4444/olinkpatrep/report2/0/

*Most files are too large to display completely in Excel. You may want to download the file into notepad and import sections into Excel spreadsheets or download the entire file into Access or another database program. If you have questions or have problems downloading the files, contact Rose Nelson at rose@coalliance.org or (303)-759-3399

For further documentation, or to download files from earlier years refer to CSDirect http://csdirect.iii.com/manual_silver/ir_central_download_stats.html

"Right-click" on the month you wish to download and save file to your local computer.

January 2006

February 2006

March 2006

April 2006

May 2006

June 2006

July 2006

February 2007

March 2007

April 2007

May 2007

The raw data files from Innovative do not contain column headings. Please refer to the Transactions Code table below to label each column with the appropriate heading

Transaction Fields

Field #
Field Name
Field Description

1
Transaction ID
Transaction number.

2
Transaction Number
Unique number assigned to all transactions associated with the request.

3
Patron Site
Site code of the patron site.

4
Owning Site
Site code of the owning site.

5
Pickup Location Info
Location code of pickup location (5 char)
Pickup location spelled out (20 char max)
Delivery stop spelled out (32 char max)

6
INN-Reach Central Server Patron Type
INN-Reach Central Server P TYPE from the patronmap table. The INN-Reach Central Server uses the P TYPE and I TYPE to determine which loan rule should be used for the checkout.

7
INN-Reach Central Server Item Type
INN-Reach Central Server I TYPE from the itemmap table. The INN-Reach Central Server uses the P TYPE and I TYPE to determine which loan rule should be used for the checkout.

8
Author
The author of the item.

9
Title
The title of the item.

10
Call #
The call number of the item.

11
Item record
Item record number.

12
Message Time
Time of message in the yymmddhhmmss format.

13
Pickup Anywhere Location Key
Unique key for the Pickup Anywhere location (Pickup Anywhere messages only).

14
Patron record
Patron record number (optional).

Transaction Fields
Field #	Field Name	Field Description
1	Transaction ID	Transaction number.
2	Transaction Number	Unique number assigned to all transactions associated with the request.
3	Patron Site	Site code of the patron site.
4	Owning Site	Site code of the owning site.
5	Pickup Location Info	Location code of pickup location (5 char) Pickup location spelled out (20 char max) Delivery stop spelled out (32 char max)
6	INN-Reach Central Server Patron Type	INN-Reach Central Server P TYPE from the patronmap table. The INN-Reach Central Server uses the P TYPE and I TYPE to determine which loan rule should be used for the checkout.
7	INN-Reach Central Server Item Type	INN-Reach Central Server I TYPE from the itemmap table. The INN-Reach Central Server uses the P TYPE and I TYPE to determine which loan rule should be used for the checkout.
8	Author	The author of the item.
9	Title	The title of the item.
10	Call #	The call number of the item.
11	Item record	Item record number.
12	Message Time	Time of message in the yymmddhhmmss format.
13	Pickup Anywhere Location Key	Unique key for the Pickup Anywhere location (Pickup Anywhere messages only).
14	Patron record	Patron record number (optional).