PowerPlay Cube Documentation

TUG TRELLIS Reports Home
Search Reports Status Database

 

Cube File Name

refstats.mdc

Revision Date

2004-02-05

Cube Developer

Gail Sperling

Cube Description:

This cube contains statistics on information services resources transactions at UW. This includes types of questions, consultations and AskLib questions for Davis Reference, Porter Reference, Porter Gov Pubs, UMD and Special Collections. It also contains manual circulation statistics for Special Collections. Source data is maintained in the excel file refstats.xls found in R:\UW Statistics and Reports\Departmental Statistics\ISR and in circstats.xls in R:\UW Statistics and Reports\Departmental Statistics\Special Collections

 

Measure Name

Description

Total

A total of all time periods in the day

Daytime

A total of daytime activity (up to 5:00 PM)

Evening

A total of evening activity (after 6:00 PM)

hh:mm am

A count of activity for the hour beginning with the time period specified

Accessibility Measures

A folder containing measures used by the Accessibility Centre

Activity count

A count of activity in the Accessibility Centre (this number comes from the "9:00 am" column in the refstats.xls ExtraRef worksheet)

Time (in minutes)

A count of the number of minutes spent on various Accessibility Centre activities

Time (hours)

A count of the number of hours spent on various Accessibility Centre activities

Special Collections Manual Charges

A folder containing measures used for Special Collections Manual Circulation counts

Patron Group Counts

A folder containing Patron related manual circulation counts for Special Collections

Faculty/Staff

A count of the manual circulations for Faculty and Staff in Special Collections

Undergrad

A count of the manual circulations for Undergraduates in Special Collections

Grad

A count of the manual circulations for Graduates in Special Collections

Other-Patron

A count of the manual circulations for Other Patrons in Special Collections

Patron Total

A total of the manual circulations for all Patrons in Special Collections

Item Type Counts

A folder containing Item related manual circulation counts for Special Collections

Book

A count of the manual circulations for Book items in Special Collections

Periodical

A count of the manual circulations for Periodical items in Special Collections

Archive

A count of the manual circulations for Archive items in Special Collections

UW Archive

A count of the manual circulations for UW Archive items in Special Collections

KW Record Negative

A count of the manual circulations for KW Record Negatives in Special Collections

Other-Type

A count of the manual circulations for Other items in Special Collections

Item Total

A total of the manual circulations for all Items in Special Collections

Research Purpose Counts

A folder containing Research Purpose related manual circulation counts for Special Collections

Book

A count of the manual circulations for Book purposes in Special Collections

Paper(Essay)

A count of the manual circulations for Paper/Essay purposes in Special Collections

Article

A count of the manual circulations for Article purposes in Special Collections

Dissertation

A count of the manual circulations for Dissertation purposes in Special Collections

Geneaology

A count of the manual circulations for Geneaology purposes in Special Collections

Personal

A count of the manual circulations for Personal purposes in Special Collections

Other-Purpose

A count of the manual circulations for Other purposes in Special Collections

Research Purpose Total

A total of the manual circulations for Research Purposes in Special Collections

 

Dimension Name

Dimension Hierarchy

Description and Notes

Valid Measures

Alternate Hierarchy

Date

Year

Year is fiscal year starting May 1 and indicates the year at the end of the fiscal year (e.g. 1999 = 1998/1999)

  • Total
  • Daytime
  • Evening
  • 9:00 AM
  • ...
  • 8:00 PM
  • Activity count
  • Time (in minutes)
  • Time (hours)
  • Special Collections Manual Circulations (all counts in the folders)
 

Month

Week (weeks split between months will be split between the months by date)

All types

Reference/accessibility activity type

The type of reference question or reference/accessiblity activity

  • Total
  • Daytime
  • Evening
  • 9:00 AM
  • ...
  • 8:00 PM
  • Activity count
  • Time (in minutes)
  • Time (hours)

  A special category "ARL" combines "consultations" and specific reference question types together

All locations

Location

The location where the activity occurred

  • Total
  • Daytime
  • Evening
  • 9:00 AM
  • ...
  • 8:00 PM
  • Activity count
  • Time (in minutes)
  • Time (hours)
  • Special Collections Manual Circulations (all counts in the folders)

Days

Day of week name

Day of week name

  • Total
  • Daytime
  • Evening
  • 9:00 AM
  • ...
  • 8:00 PM
  • Activity count
  • Time (in minutes)
  • Time (hours)
  • Special Collections Manual Circulations (all counts in the folders)

Session Length

A range of lengths that each session could fall under

Session length may be one of;

  • 0 to 30 minutes
  • 31 to 60 minutes
  • 61 to 90 minutes
  • 90+ minutes

 

  • Activity count
  • Time (in minutes)
  • Time (hours)
  • Total
  • Daytime
  • Evening
  • 9:00 AM
  • ...
  • 8:00 PM

Subtype

A secondary way to categorize activity counts (used mainly for Accessibility Centre statistics)

Day of week name

  • Activity count
  • Time (in minutes)
  • Time (hours)
  • Total
  • Daytime
  • Evening
  • 9:00 AM
  • ...
  • 8:00 PM

Department

Department Name

The department and course information for Special Collections manual circulation counts

  • Special Collections Manual Circulations (all counts in the folders)

Course Number

 

PowerPlay Model File Name:

refstats.pyi