Requests cube

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

Home TUG Statistics & Reports

Documents Contacts Search

PowerPlay Cube Documentation

Search Reports Status Database

*Cube File Name:*	Requests.mdc
*Revision Date:*	2002-07-02
*Cube Developer:*	Gail Sperling

Cube Description:

This cube contains statistical data on "holds and recall" transactions that have been created since the Trellis system went live.

Measure Name	Description	Drill Through Reports
Requests	This measure includes all holds, administrative holds, recalls and administrative recalls that were placed by staff or patrons on TRELLIS. Cannot be used with the Patron Statistical dimension.	requests_drill
Requests (by statistical)	This measure includes all holds, administrative holds, recalls and administrative recalls that were placed by staff or patrons on TRELLIS. Note: Counts can be inflated because patrons can have multiple statistical categories assigned to their record.

Dimension Name	Dimension Hierarchy	Description	Valid Measures	Alternate Hierarchy
All Dates	Year	The date the hold or recall was created.	Requests Requests (by statistical)
	Term
	Month
	Week
All Locations (happening)	Institution	The location where the hold or recall was placed. Holds or recalls placed through the OPAC will show under the location "Other" "annex. Circulation Desk" or under location "0".	Requests Requests (by statistical)	Alternate hierarchy to include colleges in main institutions
	Library
	Create Location
All Locations (item)	Institution	The location associated with the item record. If the request was a title level hold the location will be "Unknown".	Requests Requests (by statistical)	Alternate hierarchy to include colleges in main institutions
	Library
	Item Location
Patron/Staff	Patron or Staff	Indicates whether the request was placed by patrons through the OPAC or by staff on TRELLIS.	Requests Requests (by statistical)
Item Types	Media	The item type of the requested item. If a title level hold or recall is placed the item type will be "Unknown".	Requests Requests (by statistical)
	Item Type Name
Holds and Recalls	Request type	Indicates whether the request was a hold or a recall.	Requests Requests (by statistical)
Title and Copy	Request level	Indicates whether the request was a title level or copy level request.	Requests Requests (by statistical)
Day	Day of the Week	The day of the week that the request was created	Requests Requests (by statistical)
Hour	00... 23	The hour of the day that the request was created	Requests Requests (by statistical)
All Status	Request Status	Indicates the hold status.	Requests Requests (by statistical)	Special category for "Satisfied"
LC Class	First letter	The LC Class associated with the request. If the request is a title level hold or recall the LC Class will display as "Unknown".	Requests Requests (by statistical)
	LC Class
LC Number	Thousands range	The LC Number associated with the requested item. If a title level hold or recall is placed the LC Number will be "Unknown".	Requests Requests (by statistical)
	Hundreds range
	Tens range
	LC Number
All Locations (pickup)	Institution	The location where the patron expects to pickup the requested item.	Requests Requests (by statistical)	Alternate hierarchy to include colleges in main institutions
	Library
	Pickup Location
All Patron Statistical	Patron Library Name	The patron statistical category. Counts can be inaccurate because a patron may be assigned to multiple statistical categories.	Requests (by statistical)
	Patron Stat Code
All Patron Groups	Institution	The patron group associated with the patron placing the request. For requests placed prior to Release 99.1 (July 2000) the patron group is "Unknown".	Requests Requests (by statistical)
	Patron Group
Day (status)	Day of the week	The day of the week that the request status (at the time of the cube build) was applied	Requests Requests (by statistical)
Hour (status)	00... 23	The hour of the day that the request status (at the time of the cube build) was applied	Requests Requests (by statistical)
Status Date	Year	The date the hold or recall status was applied.	Requests Requests (by statistical)
	Term
	Month

PowerPlay Model File Name:

requests.pyi