Course Data Reports

Course reserve specific data fields.

Course	Term	Reserve Item
Name	Name	Several inventory fields
Description	startDate	startDate
Department	endDate	endDate
Registrar ID		temporaryLoanType
external ID		CopyrightTracking
location ID		copyrightStatus
course code		totalPagesused
section		percentOfPagesUsed
course type		paymentBasis
instructor		Processing status

Based on Reporting SIG master spreadsheet

Course data only vs circulation or item only reports

Institution(s)	Report title	Parameters	Real time	Description / Purpose
	Active Courses	course name, term, status	yes	Provides a list of all courses listed as active during a set date range
Wentworth	Course Reserves by Department/Discipline	Course Name, Term, Status	Yes	Pulls a report that sorts all Course Reserves by Department/Discipline (e.g. HUMN, ENGR, etc.). Ability to pull report based on active or non-active would be helpful.

Reports that are item + course data + User

Report title	Repeated	Parameters	Output (parameter column +)	LDP or In app	Description / Purpose
Items on reserve - Current		Course name, professor name, term, dates, items		In App
Items on reserve - Historical		Course name, professor name, term, dates, items	Circulation count	LDP
	on demand	User, course name, course number, link to course		Not	Need clarification - Pulls a report that contains professor name that taught a particular course at any time. and return date. (and link to course)
Permanent Reserves		Permanent Reserves items + number of historical charges		Yes	Wentworth. Pulls a report of each item on Permanent Reserve (or any specific course) and historical charges and date of last charge for each item for weeding purposes (is it possible to do this?).
		Items, course, historical charges, time stamp, term		LDP	Pulls a report of each item on Permanent Reserve (or any specific course) and historical charges and date of last charge for each item for weeding purposes (is it possible to do this?).
Reserve statistics by semester		course, item, instructor, semester, reserve format, reserve library, owning library, item barcode, title/author, call number, number of views, date range, number of circ transactions within a date range.		Probably not?	REP-106 - Getting issue details... STATUS
List of e-items and print items on reserve, with processing status and reserve usage to date		Voyager: Bib_ID, MFHD_ID, ITEM_ID, Title, Author, Call Number, Item_enum, CHRON, Copy #, Item Barcode, Owning Library, Circ_transaction_id, Charge_date, loan_interval, loan_period. Ares: Ares Item ID, Course ID, Course Name, Course number, Instructor Name, Semester, Reserve Location, Processing Location, Course start date, Course end date, Item Title, Item start date, Item end date, ItemBarcode, Item processing status, Item processing status date, Document Type, Item Format, Article Title, Pagination, UserID, Publisher, Class enrollment, Item history ID, item history date, item history type. Print usage is obtained by exporting all selected Ares data to a Voyager Access database and then linking to Voyager tables. E-usage is recorded in Ares itself (in the Item History table) but exported to the Voyager Access database so it can be combined with print usage data and included on the reports for distribution to reserve desks and faculty.			This came from Cornell. REP-213 - Getting issue details... STATUS "View items on reserve, their status and usage. At minimum I use ths report to capture usage at the end of the semester and distribute it to reserve desks and archive the report on a wiki. Unit libraries use the reports to evaluate how many items are used."