Item Status 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	Item Status Report
Report Reference #	opac-200409-117
Revision Date	2004-09-23
Requestor	Alex McCulloch

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

Web File Name ( login)	Web News Box
item_status_list2 (see sample)	TUG Reports and Cubes/Circulation/Item Reports

Report Description:

Report will list items in TRELLIS with the specified item status for the specified location(s) where the item status was applied in the date range specified and the item also has a second item status applied to it. For example a list of items that are marked missing and also charged out could be created with this report.

The following is a partial list of item statuses that can be chosen:

At bindery
Cataloguing Review
Charged
Circulation Review
Claims Returned
Damaged
Discharged
Hold Request
In Transit, In Transit Discharged, or In Transit On Hold
Lost-- Library Applied or Lost--System Applied
Missing
Not Charged
On Hold
Overdue
Recall Request
Renewed
Withdrawn

Prompt (Please note that the order of prompts in this documentation applies to the Cognos Web Server only)	Type	Description
Choose location codes that start with:	Type in	Enter the start characters of the location codes you want to select from
Select status to use to preselect records	Picklist	Select the status that should be used to identify records to be preselected for the report (this should be the status that would select the fewest records)
Enter start date (yyyy-mm-dd)	Type in	Enter the start of the preselect item status date range for the report
Enter end date (yyyy-mm-dd)	Type in	Enter the end of the preselect item status date range for the report
Select location(s) for report:	Picklist	Select the item location(s) to include in the report
Select item status for report	Picklist	Select a status to include in the report
Enter start date (yyyy-mm-dd)	Type in	Enter the start of the item status date range for the report
Enter end date (yyyy-mm-dd)	Type in	Enter the end of the item status date range for the report

Filters:

Item Status Date

(date for the first status specified) between the specified dates (first set of prompts) or there is no date for the status

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

Item has one Item Status equal to the first status specified and one Item Status equal to the second status specified

Item Status Date

(date for the second status specified) between the specified dates (second set of prompts) or there is no date for the status

Sort Order:

Location name

Call number

Data Elements:

Call number (or storage number if one exists)
Title
Item Status Date (of the second status specified)
Item barcode
Item Type name
Location Name

Important Notes:

If you are running the report in the Windows client the order of the prompts will be different than shown above. The preselect item status and date range prompts will be the last prompts to be entered.

Items will be included in the report if either status has no status date associated with it. The item status specified for the preselect should be the one that is the most restrictive for selecting records. For example if the report was to include items that have the "Lost-Library Applied" status and the "Not Charged" status the "Lost-Library Applied" status should be the one specified in the preselect prompts and the "Not Charged" status should be the second status specified.

Estimated run time:

10 minutes

Report Developer:

Gail Sperling