TUG-Libraries 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

circ activity.mdc

Revision Date

2010-10-20

Cube Developer

Gail Sperling

Cube Description:

This cube contains statistical data on circulation desk interactions and transactions from both the TRELLIS database and the LibQuest database. The first table indicates what statistical measures are in the cube. The second table indicates the dimensions which can be used to analyze the statistical measures and which measures apply to each dimension.

Measure Name

Description

Drill Through Reports

Interactions

A count of circulation desk interactions from TRELLIS and Libquest data. An interaction may include multiple transactions occuring in the same half hour period.

NOTE: If a patron had different interaction types in the same half hour period each type counts as a separate interaction.

 

Transactions

A count of TRELLIS and LibQuest transactions.

 

Dimension Name

Dimension Hierarchy

Description

Valid Measures

Alternate Hierarchy

Date

Year

 

The date the interaction or transaction happened.

Year is fiscal year starting May 1 and indicates the year at the end of the fiscal year

Only data from September 1, 2010 on is included.

  • Interactions
  • Transactions

Special categories for

  • Current Month
  • Previous Month
  • Year to date
  • Previous Year
Term

Month  

Week

All Locations (happening)

Library

 

The location where the interaction or transaction occurred

  • Interactions
  • Transactions
 

Special category for Main UW locations

Desk Location

Interaction Type

 

Interaction Group

The type of interaction that occurred at the circulation desk. The interaction groups and types for LibQuest counts comes from the LibQuest Categories and SubCategories.

All TRELLIS interaction types have the group "TRELLIS". TRELLIS interaction types include:

  • Circulation
  • Discharge
  • Fine - other
  • Fine Paid
  • Request

"Circulation" interactions include regular and reserve charges and renewals.

  • Interactions
  • Transactions

Interaction Type

Hour

Hour of the day

 

The hour in which the interaction or transaction was recorded

  • Interactions
  • Transactions
 

Special categories for

  • Morning
  • Afternoon
  • Evening
  • Extended Hours

halfHour

half hour segment

The half hour segment in which the interaction or transaction was recorded

  • Interactions
  • Transactions

Operator Id

Operator Id

 

The operator who completed the interaction or transaction

  • Interactions
  • Transactions

Day

Day of week  

 

The day of the week the interaction occurred.

  • Interactions
  • Transactions

Special categories for

  • Weekdays
  • Weekend

PowerPlay Model File Name:

circ activity.pyi