Impromptu Report Documentation

Impromptu Report Documentation

Report Title	Inventory Item Status: Lost(s), Missing, Withdrawn
Report Reference #
Revision Date	2007-01-10
Requestor	Ann Naese

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

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

Report Description:

This report is used to identify items that have the pre-existing Item Status of Lost Library Applied, Lost System Applied, Missing or Withdrawn and were Not Found in Inventory. These items need to be identified in order to be removed them from the process of assigning a new Missing Item Status. The original Missing, Lost and Withdrawn Item Status date is required for re-ordering purposes.

Prompt	Type	Description
Select library (s) to list locations	Picklist	Select the library (s) to list the item locations to include in your report
Select library item location (s) to include	Picklist	Select the item locations to include in your report
Enter start LC Class	Type in	Enter the start LC class to include in your report. Leave the appropriate spaces e.g. HA---35 or HB-1000. (4 spaces for 1 digit LC numbers, 3 spaces for 2 digit LC numbers, etc.)
Enter end LC Class	Type in	Enter the end LC class to include in your report. Leave the appropriate spaces as in above example.

Filters:

Library location is in the selected library location (s) from prompt
Item location is in the selected item location (s) from prompt
The call number is between the LC class numbers entered in the start and end LC class prompts
The item status equals Missing, Lost-Library Applied, Lost-System Applied or Withdrawn

Sort Order:

Call Number (ascending)

Data Elements:

Full Call Number
Item Barcode
Item Location Name
Item Status
Item Status Date

Important Notes:

Enter the appropriate number of spaces between the LC Class letter and number. Enter 4 spaces for 1 digit LC numbers, 3 spaces for 2 digit LC numbers, 2 spaces for 3 digit LC numbers and 1 space for 4 digit LC numbers. The dash in the prompt example is to show where the space is to be entered.

Estimated run time:

10 – 15 minutes.

Report Developer:

Susan Arruda