Inventory Missing Search List 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	Inventory Missing Search List
Report Reference #
Revision Date	2003-08-19
Requestor	Alex McCulloch

Impromptu File Name	Directory	Catalogue Name
Inventory_missing_search_list.imr	C:\Impromptu Web Reports\circ_transactions	C:\Impromptu Web Reports\circ_transactions\circ_transactions.cat

Web File Name ( login)	Web News Box
Inventory_missing_search_list (see sample)	UW Reports and Cubes/Circulation Services/Inventory Reports

Report Description:

This list may be used as part of the inventory process to see what items may be considered missing. This report will list all items that do not have the item statistical category "Inventory" applied if the location and item type that matches those selected in the prompts and the call number is between the call numbers specified and the item status is either "Not Charged" or "Hold Request". Any item that has a temporary location is excluded from the report. See Important Notes below.

Prompt	Type	Description
Choose location codes that start with:	Type in	Enter the start characters of the location codes you want to select from
Select inventory location(s):	Picklist	Select the item location(s) of the items that were inventoried
Select item types for inventory:	Picklist	Select the item type(s) included in the location of the inventory
Enter start call number LC class and number (e.g. AB 1234):	Type in	The start call number of the call number range for the inventory. The call number must be entered with proper spacing after the LC class.
Enter End Call Number	Type in	The end call number of the call number range for the inventory. The call number must be entered with proper spacing after the LC class.

Filters:

Item Statistical Category does not exist

Item location equals the one of the locations selected in the location prompt

Item type equals one of the item types selected in the item type prompt

Call number is between the start and end call numbers entered in the prompts

Item Status equals "Not Charged" or "Hold Request"

Item temporary location does not exist

Sort Order:

Call number

Data Elements:

Location Name (in page header)
Call Number
Item Type Name
Title
Item Status

Important Notes:

The call numbers entered should only include the LC Class and whole LC number. It is advisable to stop inventory for a call number range at the end/beginning of a whole number. Items will appear on this list if they have multiple statuses that include either "Not Charged" or "Hold Request". See examples below for proper call number spacing. The "-" is used as a place holder for spaces that should be entered.

A----1
A---12
A--123
A-1234
AB----1
AB---12
AB--123
AB-1234

Estimated run time:

15 minutes

Report Developer:

Gail Sperling