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
...
| Report title | Repeated | Parameters | Real time | Description / Purpose | MVP | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| on demand | User, course name, course number, link to course | Not | 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?). | ||||||||||
| 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? |
| ||||||||||
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.
"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." | |||||||||||
...