Ceased Titles Report Documentation

Staff Web StaffWeb: UG | UW | WLU
Libraries: UG | UW | WLU
Campus: UG | UW | WLU

Home TUG Statistics & Reports

Documents Contacts Search

Impromptu Report Documentation

Search Reports Status Database

Report Title	Ceased Titles List
Report Reference #	cat-200504-99
Revision Date	2004-03-17
Requestor	Betty Graf

Impromptu File Name	Directory	Catalogue
ceased_titles.imr	C:\Impromptu Web Reports\Acquisitions	C:\Impromptu Web Reports\Acquisitions\acquisitions-serials.cat

Web File Name (login)	Web News Box
ceased_titles (see sample)	TUG Reports and Cubes/Acquisitions/Serial Reports

Report Description:

This report will list titles that have a value of "d" in character position 7 of the MARC 008 tag if the mfhd location of the holdings record is one of the locations specified and there is no 785 tag in the bibliographic MARC record.

Prompt	Type	Description
Choose location codes that start with:	Type-in	The start characters of the location code to choose from
Select mfhd location(s):	Picklist	Select the location(s) to include in the report

Data Elements:

MFHD Location Name (in header)

Call Number

Bibid

Title

Filters:

Bibliographic record MARC 008 offset 7 equals "d"
Bibliographic record does not have a 785 tag
MFHD Location equals one of the locations selected

Sort Order:

Mfhd Location Name

Call Number

Important Notes:

Estimated run time:

15-30 minutes

Report Developer:

Gail Sperling