Fine Fee Cube Documentation

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:*	Fine_fee.mdc
*Revision Date:*	2004-03-25
*Cube Developer:*	Gail Sperling

Cube Description:

This cube contains information on fines and fees that have been assessed, paid, forgiven, or refunded through TRELLIS.

Measure Name	Description	Drill Through Reports
Transaction Amount	The amount of the fine or fee transaction that was paid, forgiven or marked as an error.	fine_drill
Amount Assessed	The original amount assessed when the fine or fee was created.	assessed_drill
Balance Owing	The amount of fines and fees that are still outstanding (at the time the cube was built).	assessed_drill
Transaction amount (patron group	The amount of the fine or fee transaction that was paid, forgiven or marked as an error. This measure can be used with the patron group dimension but inaccuracies will be caused by patrons with multiple barcodes.	fine_drill(patron_group)

Dimension Name	Dimension Hierarchy	Description and Notes	Valid Measures	Alternate Hierarchy
Date	Year	The date the fine fee or fine transaction was created. Years are fiscal years from May 1 to April 30. The year indicates the last year in the fiscal period. e.g. 2001 covers May 1, 2000 to April 30, 2001.	Transaction Amount Amount Assessed Balance Owing Transaction amount (patron group
	Term
	Month
Locations (happening)	Institution	The location where the fine fee or fine transaction was created. If the record was created during the conversion to TRELLIS the location may be unknown.	Transaction Amount Amount Assessed Balance Owing Transaction amount (patron group	Alternate drill path which includes colleges with the institution at the top level Special categories for Fines reconciliation location groupings
	Library
	Happening location name
All Patron Groups	Institution	The patron group associated with the fine fee or fine transaction..	Transaction amount (patron group
All Patron Groups	Patron group code		Transaction amount (patron group
Locations (item)	Institution	The location associated with the item record. Some fine fees are not associated with item records so they will display as "Blank".	Transaction Amount Amount Assessed Balance Owing Transaction amount (patron group	Alternate drill path which includes colleges with the institution at the top level Special categories for Fines reconciliation location groupings
	Library
	Item location name
Item Types	Media	The item type associated with the item record. If a fine fee is not associated with an item record it will show as "Blank".	Transaction Amount Amount Assessed Balance Owing Transaction amount (patron group
Item Types	Item Type Name
Fine Fee Type	Fine Fee Type	This dimension indicates the reason the fine fee was assessed. E.G. overdue, replacement, processing charge.	Transaction Amount Amount Assessed Balance Owing Transaction amount (patron group	Alternate drill path by Fine Type Group. Alternate drill path by Fine Type Institution
Payment Method	Fine Fee Transaction Method	The method used to pay the fine fee transaction amount. E.G. cash, cheque, credit card	Transaction Amount Transaction amount (patron group	Special category for "Fines Reconciliation" to exclude "Under Appeal - WLU"
Fine Transaction Type	Fine Transaction Type	This dimension defines whether the fine transaction was a payment, error, refund or forgiven.	Transaction Amount Transaction amount (patron group	Special category to group "Payments and Refunds" together.

PowerPlay Model File Name:

Patrons2.pyi