Follett VERSION 6.00, User Manual

Page: 589 / 730

04/04 Chapter 40 Extracting data 589
The following table contains the names of the fields in the four extraction files:
Copies/Titles Copy Transactions Category Transactions Patrons
(Copy) Barcode
Call Number
Title
Author
LCCN
ISBN
ISSN
Material Type
Publication Date
Copy Status
Inventory Status
Sub location
Acquisition Date
Price
Description 1
Enumeration 1
Description 2
Enumeration 2
Description 3
Enumeration 3
Copy Number
Funding Source
Vendor
Circulation Type Code
Circulation Type Description
Circulation Total
Yeartodate Statistics
Last Year's Statistics
Monthtodate statistics
Today's Statistics
Member (MOC)
Last Name**
First Name**
Middle Name**
Patron Barcode**
(Patron) ID**
Location 1**
Location 2**
User Field 1**
User Field 2**
Graduation Year**
Patron Type Code
Patron Type Description
Due Date
Date Checked Out (Transaction) Type
Modifier*
Date
Time
Title
LCCN
ISBN
ISSN
Material Type
Material Age (pub. date)
Barcode
Call Number
Circulation Type Code
Circulation Type Description
Transaction Circulation Type
Code
Transaction Circulation Type
Description
Transaction Call Number
Last Name**
First Name**
Middle Name**
Patron Barcode**
(Patron) ID**
Patron Type Code
Patron Type Description
Transaction Patron Type Code
Transaction Patron Type
Description
Transaction Amount
Transaction Balance
(Transaction) Type
Modifier*
Date
Time
Category Number
Category Description
Last Name**
First Name**
Middle Name**
Patron Barcode**
(patron) ID**
Patron Type Code
Patron Type Description
Transaction Patron
Type Code
Transaction Patron Type
Description
Status
Barcode
ID
Last Name
First Name
Middle Name
Address Line 1
Address Line 2
City (address line 3)
State (address line 4)
Zip/Postal Code
Phone Number
Gender
Graduation Year
Birth Date
Card Expiration Date
Location 1
Location 2
User Field 1
User Field 2
Patron Type Code
Patron Type Description
(current) Checkouts
(current) Overdues
(current) Fine Amount
(current) Refund
Amount
*
The Modifier field lists any additional information about the transaction: Renewal, Reshelf, Refund Deleted, Fine
Deleted, Pending Hold, Pending Reserve, Ready Hold, Ready Reserve, or Reserved.
** These fields are included only if you select the Extract Patron Data option in System Setup | Circulation | Misc.